Re: [Wikitech-l] Re: Giving Jan access

After looking at Sheldon's website, it's a good thing I didn't claim to have appeared as an expert on the radio! Anyway, I've had a look at the my.cnf file, and the settings mostly look fine. A couple of things... set-variable = innodb_buffer_pool_size=384M #set-variable = innodb_buffer_pool_size=512M I see you've reduced this, probably because it was too high with the dual db/web server. This can be upped to at most 80% of available memory when you move to the dedicated server running InnoDB tables (you'd need to make sure any MyISAM tables don't steal memory too - it's more complicated running both table types - I haven't had a real look at the db structure yet to say). This sets the cache size for innodb indexes etc, so upping it can help quite a bit if this is the bottleneck. Also: set-variable = innodb_log_file_size=5M This can go up to around 25% of the innodb_buffer_pool_size. Saves a bit of disk I/O (at the cost of recovery speed after a crash) The main speed increase I think will come from looking at individual queries, and making sure the indexes are optimized. There was mention of one query taking 37 seconds which should never happen! If you have any really problematic queries, feel free to post them and I'll see if I can take a look. I've downloaded the db from the site (hopefully the structures etc are up to date), so I can see if there's anything I can do to speed them up. ian gilfillan ----- Original Message ----- From: "Sheldon Rampton" <sheldon.rampton(a)verizon.net> To: <wikitech-l(a)wikipedia.org> Sent: Friday, February 07, 2003 3:36 PM Subject: [Wikitech-l] Re: Giving Jan access