1
vote
1answer
268 views

What conditions trigger a table level lock

Working on some vBulletin performance issues, I ran into this situation, where everything is stuck waiting on a table-level lock: Id Command Time State Info 83 Query 47 ...
12
votes
3answers
3k views

MySQL Replication Performance

I'm having a serious issue with MySQL 5.5 replication performance between two machines, mostly myISAM tables with statement based replication. The binary logs and mysql data directory are both located ...
1
vote
3answers
10k views

Best my.cnf configuration for a 8GB MySQL server with MyISAM use only

I am preparing a large Drupal 6.x based installation and have setup a dedicated MySQL server with 8GB of RAM. Drupal 6.x uses only MyISAM engine and there will be around 500 concurrent users using the ...
1
vote
1answer
241 views

Can I change a MySQL table back and forth between InnoDB and MyISAM without any problems?

I have a site with a decently big database, 3Gb in size, a couple of tables with a dozen million records. It's currently 100% on MyISAM, and I have the feeling that the server is going slower than it ...
2
votes
1answer
924 views

Join performance on MyISAM and InnoDB tables

I am thinking about converting some tables from MyISAM to InnoDB in my mysql server. The tables will certainly benefit from the change because a lot of write requests come to these tables, while there ...
1
vote
1answer
918 views

How to use most of memory available on MySQL

I've got a MySQL server which has both InnoDB and MyISAM tables. InnoDB tablespace is quite small under 4 GB. MyISAM is big ~250 GB in total of which 50 GB is for indexes. Our server has 32 GB of RAM ...
1
vote
2answers
291 views

Will deleting old MySQL data improve performance?

Would deleting old data from my tables improve MySQL query performance? When my queries use indexes? When my queries don't use indexes? When I use InnoDB? When I use MyISAM?