Question : I’m little newbie in configuring mysql and I need some advices. Few days ago I made little home […]
Tag: my.cnf
What is wrong with table_cache hit rate?
Question : In my.cnf I have: table_cache = 524288 open_files_limit = 65535 Both are at max allowed value for mysql […]
What is the difference between setting the directive default-character-set under [client] as opposed to [mysqld]?
Question : Reference: https://stackoverflow.com/a/8690422/784637 Correct me if I’m wrong, but the best answer suggests a way to force everything being […]
How to optimize the my.cnf of a MySQL server that mixes InnoDB and MyISAM tablespaces?
Question : I have a database that, because of some issues, I needed to convert some tables from MyISAM to […]
What is the recommended my.cnf settings for 32 GB Server
Question : I am just moving my website to a new server and ı want to know what is the […]
Why “.my.cnf” file is empty?
Question : I want to edit some of InnoDB variables ,I go to the .my.cnf which is located in home/.my.cnf […]
Galera: any drawback of enabling wsrep_log_conflicts and cert.log_conflicts?
Question : We have a HAProxy which balances reads and writes to only one (of three) Galera nodes. If this […]
MATCH AGAINST one character words returns empty rows with ft_min_word_len = 1
Question : I’ve set ft_min_word_len = 1 to my.cnf file, also SHOW VARIABLES LIKE ‘ft_min_word%’ displays ft_min_word_len as 1. Then […]
How do I make binlog-format=ROW the start up default in the /etc/my.cnf file?
Question : I can run the query SET GLOBAL binlog_format = ‘ROW’ and it works for that session. How do […]
What is wrong with table_cache hit rate?
Question : In my.cnf I have: table_cache = 524288 open_files_limit = 65535 Both are at max allowed value for mysql […]