Question : I can run the query SET GLOBAL binlog_format = ‘ROW’ and it works for that session. How do […]
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 […]
Mysql Optimization suggessions
Question : I have an InnoDB database table with more than 2 million rows. I am running efficienty indexed queries […]
MariaDB is ignoring /etc/my.cnf
Question : The variable I am trying to change is innodb_buffer_pool_size. As you can see below the settings is 512M. […]
Mariadb default logs location & –log-error
Question : I am using mariadb and I to investigate some issue I wanted to check the logs. To my […]
How to configure my.cnf in 5.6.17?
Question : On production server(linux machine mysql 5.6.17), I tried to find my.cnf to change the system variables, but my.cnf […]
Need help with my.cnf: 32GB RAM and 3GB of InnoDB tables
Question : I have a Joomla app that takes my MySQL instance down all the time. It uses too much […]
How to update mysql my.cnf without getting error?
Question : I updated the MySQL my.conf file and and restarted my server without a problem. As soon as I […]
Made changes to my.cnf and mysqld wont restart – no backup
Question : I thought I’d be clever and update my.cnf file to add ft_min_word_len=2 and didn’t back it up first. […]
What settings should I use in my.cnf
Question : We have about 5-6 different internal webapps (staff use only) that we will be transferring across to a […]