1

I have a dedicated server Linux Cenots 6 with 16GB RAM - Apache + Nginx MYSQL 5.6 please can someone let me know if my etc/my.cnf MYSQL configuration is ok or can it be improved

I am getting Reocurring error! the server quit without updating pid file - not sure if this is related to these settings or not

Secondly if i upgrade to MariaDb 10.3 would these same settings be ok or would changes be needed

[mysqld]

tmpdir = /tmp

innodb_file_per_table=1 default-storage-engine=MyISAM performance-schema=0 max_allowed_packet=500M open_files_limit=22000

tmp_table_size = 64M max_heap_table_size = 64M query_cache_type = 0 query_cache_size = 32M query_cache_limit = 10M max_connections = 28 max_user_connections = 28

table_open_cache = 650 thread_cache_size = 400

join_buffer_size = 20M read_buffer_size = 60M sort_buffer_size = 60M wait_timeout = 6580 connect_timeout = 6100 bulk_insert_buffer_size = 64M key_buffer_size = 32M

#log_slow_queries=mysql-slow.log long_query_time=4 log-queries-not-using-indexes=1

performance schema

performance_schema=on innodb_file_per_table=1 slow_query_log_file = host_name-slow.log

log_error = /var/log/mysql/error.log

lower_case_table_names = 2

Improve this question
4
  • Don't repost the same question. Instead, add the additional information into your existing question.
    – Michael Hampton
    Aug 25, 2020 at 19:25
  • @MichaelHampton Not sure what you are talking about - the supposed duplicate has virtually 0 overlap with this question.
    – Gordan Bobić
    Aug 25, 2020 at 19:50
  • @GordanBobic If you take it as a MySQL tuning question, perhaps. But tuning isn't going to help with the problem the user is having, MySQL crashing, which he actually went into in detail in the other post. This isn't going to be useful unless that problem is solved.
    – Michael Hampton
    Aug 25, 2020 at 19:57
  • See this for analysis: mysql.rjweb.org/doc.php/mysql_analysis#tuning
    – Rick James
    Aug 25, 2020 at 23:51

1 Answer 1

Reset to default
0

Set query_cache_size=0 since you have it disabled anyway. You almost certainly shouldn't be changing sort_buffer_size as join_buffer_size, you are probably crippling the performance by setting them so absurdly high. The rest you may or may not need depending on your very specific workload.

You probably shouldn't be using MyISAM in 2020.

All of it should work with MariaDB 10.3.

Improve this answer
3
  • Thank you should i remove or keep same "shouldn't be changing sort_buffer_size as join_buffer_size"
    – jt9489
    Aug 25, 2020 at 19:43
  • Those should be removed.
    – Gordan Bobić
    Aug 25, 2020 at 19:48
  • Thank you i will try it and monitor it and update here
    – jt9489
    Aug 25, 2020 at 19:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.