New Server my.cnf
Normally the techs at the hosting company sort out the setup up but it is time I learnt to do more myself and understand things better.
I have a:-
E3-1230v3 Quad Core with HT (8 logical cores)
32GB RAM
2x250GB SSD in RAID1
CENTOS 6.5 x86_64 standard
Apache 2.2.27
PHP 5.4.29
My current etc/my.cnf is
[mysqld]
innodb_file_per_table=1
open_files_limit=33562
After running pltuner I see
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
Adjust your join queries to always utilize indexes
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Set thread_cache_size to 4 as a starting value
Increase table_open_cache gradually to avoid file descriptor limits
Read this before increasing table_open_cache over 64: /http://www.mysqlperformanceblog.com/2009/11/16/table_cache-negative-scalability/
Variables to adjust:
query_cache_size (>= 8M)
join_buffer_size (> 128.0K, or always use indexes with joins)
tmp_table_size (> 16M)
max_heap_table_size (> 16M)
thread_cache_size (start at 4)
table_open_cache (> 400)
innodb_buffer_pool_size (>= 1G)
Do I add the above "Variables to adjust" lines but without the brackets? or as it is is above
Is there any other tools I should run to optimise?
Many thanks
-
Hello :) The following thread is a good place to start: mysqlmymonlite.sh server stats gathering tool for cPanel Server It's important to let MySQL run for at least 24 hours before running a tuner to ensure accurate results. Thank you. 0 -
Thanks I will work with that and see what I can break... 0
Please sign in to leave a comment.
Comments
2 comments