Group items tagged

Filter: All | Bookmarks | Topics Simple Middle

shared by Alex Street on 14 Aug 12 - No Cached

default configuration supplied on many installations is very poor
...

Cancel
Configuration File
...

Cancel
configuration settings are stored in a plain text file
...

Cancel
...16 more annotations...
my.cnf on Linux and MacOS-X.
...

Cancel
errors in my.ini, MySQL will refuse to start
...

Cancel
MySQL daemon process, mysqld.
...

Cancel
configuration lines take the format setting-name=value.
...

Cancel
find out the version of your MySQL server (
...

Cancel
max-allowed-packet=32M
...

Cancel
wait-timeout=60
...

Cancel
slow query log (as the name suggests)
...

Cancel
MySQL for query processing.
...

Cancel
Caching
...

Cancel
saves the result of each query you run
...

Cancel
Setting this too high can be counter-productive.
...

Cancel
table-cache=1024
...

Cancel
key-buffer-size=64M sort-buffer-size=16M
...

Cancel
MySQL has a large number of configuration options. Adjusting these can make an enormous difference to the performance of your database
...

Cancel
my.ini
...

Cancel

shared by Alex Street on 17 Jul 12 - No Cached

shared by Alex Street on 14 Aug 12 - No Cached

50 concurrent/interactive users - frustratingly slow
...

Cancel
1GB of RAM to MySQL sounds about right for your size of database
...

Cancel
configure webtrees and MySQL
...

Cancel
...8 more annotations...
RAM, RAM and more RAM
...

Cancel
webtrees will take advantage of MySQL's query cache and PHP/APC if they are enabled.
...

Cancel
article on the WIKI with some suggestions regarding MySQL tuning.
...

Cancel
capabilities of your server: software, memory, hardware (drives) and bandwidth
...

Cancel
mediocre server can never be made to perform well,
...

Cancel
good experiences with Amazon's servers and heavily uses their CDN as well.
...

Cancel
I too use a CDN service, Cloudflare,
...

Cancel
has substantially lightened the load on my server
...

Cancel