OS: RHEL5
DB: MySQL 5.1.73 community edition
DB size: ~1GB
I have setup a testing environment and turned off all logging - general logs, binary logs, slow query logs etc.
I am using Oracle application testing suite (OATS) to run the load test. I am getting poor load test result (higher timing and less passed transactions) after logging off. Ideally I should get better result.
- Is it correct or I am missing something?
- What is the affect of getting log off?
Below is the result of
SELECT * FROM information_schema.global_variables WHERE VARIABLE_Name like 'log\_%' OR variable_name like '%\_log'
gives me:
+---------------------------------+----------------------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+---------------------------------+----------------------------+
| BACK_LOG | 50 |
| LOG_BIN_TRUST_ROUTINE_CREATORS | OFF |
| LOG_WARNINGS | 1 |
| LOG_OUTPUT | FILE |
| LOG_QUERIES_NOT_USING_INDEXES | OFF |
| LOG_ERROR | /var/lib/mysql/rpc4939.err |
| GENERAL_LOG | OFF |
| LOG_BIN | OFF |
| RELAY_LOG | |
| LOG_SLOW_QUERIES | ON |
| SLOW_QUERY_LOG | ON |
| LOG_BIN_TRUST_FUNCTION_CREATORS | OFF |
| LOG_SLAVE_UPDATES | OFF |
+---------------------------------+----------------------------+
SELECT * FROM information_schema.global_variables WHERE VARIABLE_Ne 'log\_%' OR variable_name like '%\_log';
. Just to be sure. – jynus Jul 30 '14 at 14:44