Optimize MySQL for large site replication

bisana — Thu, 30 May 2013 07:35:27 GMT

Hi All My replication of large site were failing, after trouble shooting, I came to know that I have to optimize MySQL. I have to change(increase)DB connection timeout and transactional cache sizes for the MySQL I am not expert in MySQL DB tuning,I would like to get guidance on the ideal parameters

Re: Optimize MySQL for large site replication

bisana — Sun, 02 Jun 2013 10:04:00 GMT

Hi All
I want to update the status, I have change the parameters by adding


binlog_cache_size = 600M
query_cache_size = 100M
thread_cache_size = 100M
‍‍‍‍‍

to the my.cnf
Now I have


mysql> show global variables like '%cache_size%';
+—————————-+———————-+
| Variable_name              | Value                |
+—————————-+———————-+
| binlog_cache_size          | 629145600            |
| binlog_stmt_cache_size     | 32768                |
| max_binlog_cache_size      | 18446744073709547520 |
| max_binlog_stmt_cache_size | 18446744073709547520 |
| metadata_locks_cache_size  | 1024                 |
| query_cache_size           | 104857600            |
| thread_cache_size          | 16384                |
+—————————-+———————-+
7 rows in set (0.01 sec)

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

topic Re: Optimize MySQL for large site replication in Alfresco Archive

Optimize MySQL for large site replication

Re: Optimize MySQL for large site replication