--------------------
General recommendations:
Control warning line(s) into /var/lib/mysql/mysql-error.log file
Control error line(s) into /var/lib/mysql/mysql-error.log file
Run OPTIMIZE TABLE to defragment tables for better performance
OPTIMIZE TABLE rakao.products; -- can free 1379 MB
Total freed space after theses OPTIMIZE TABLE : 1379 Mb
MySQL started within last 24 hours - recommendations may be inaccurate
Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries which have no LIMIT clause
Variables to adjust:
sort_buffer_size (> 256K)
read_rnd_buffer_size (> 256K)
tmp_table_size (> 16M)
max_heap_table_size (> 16M)
innodb_buffer_pool_size (>= 6G) if possible.
innodb_log_file_size should be equals to 1/4 of buffer pool size (=32M) if possible.
innodb_buffer_pool_instances (=1)
innodb_log_buffer_size (>= 8M)
[root@vmi98897 ~]#
ลองปรับละครับ