0
votes
1answer
30 views

Check if MySQL configuration was applied

I'm performing some heavy MySQL operations at my VM and constantly getting the following error: SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size I ...
0
votes
1answer
812 views

Safe conversion from one InnoDB(ibdata) file to innodb file per table

I have MySQL database with tables on InnoDB engine. But server is configured to use only one file ibdata0 without parameter innodb_file_per_table. I want to change this without making dump and restore ...
5
votes
1answer
1k views

16 Cores 12 GB RAM Dedicated MySql Configuration

I have a dedicated 16 Cores 12 GB RAM Mysql server which is performing quite badly since I configure it for a 16 GB server and I guess that explains why in the world the site now takes more than 500 ...
4
votes
1answer
292 views

Mysql InnoDB table size performance

I have a table that is closely approaching 2 million records. This table stores a history of transactions. This is on a high traffic website but also the table is not accessed regularly. We ...