Re: Table Locking Memory Engine
Ive changed innodb_flush_log_at_trx_commit to 2.
innodb_buffer_pool_size is set to 2gb I have a total of 16gb ram.
I have added Index timeout.
The db engine is set back to innodb. I still see the hard drive active unlike memory it would hardly blink like when it was idle. I do notice the light dosnt light up solid like it used to since I switched innodb_flush_log_at_trx_commit to 2. The server load used to be around 2.0 now it's sits around .30 using innodb big improvment.
If I did the math correct Selects per hour 533.583 > per second 148
MySQL 5.1.54
I really do appreciate the help rick.
Edited 1 time(s). Last edit at 08/10/2011 01:07PM by Daniel Oneil.
Subject
Written By
Posted
Re: Table Locking Memory Engine
August 10, 2011 01:06PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.