(888) 685-3101 ext. 2
MySQL Query Cache – Use it or Disable it?

MySQL Query Cache – Use it or Disable it?

Having frequently repeated SELECT queries and their results stored in memory can significantly optimize performance on your MySQL database. The query cache will perform such a task however, you must analyze whether your query cache is effective for your workload or if...
Three reasons to not use binlog_ignore_db in MySQL

Three reasons to not use binlog_ignore_db in MySQL

The option binlog_ignore_db can be used to exclude certain information from the binary log by setting the option equal to a given database name. However, we advise our clients to not use this option. Why? The binary log is a valuable resource for point in time...
MySQL Cascading Configuration Files

MySQL Cascading Configuration Files

MySQL creates a default configuration file named my.cnf (or my.ini in Windows), that can be edited to include and fine tune the startup options to meet the needs of your environment. This is often more convenient than entering these values every time you start the...