… as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight examines different time periods or …/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_…_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended to prevent assorted…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…logs which are no longer complete or useful for point-in-time recovery. Generally if you’re considering the binary log…disabled; on the relay master you add binary log filters; this ensures that the top-level master and its binary logs…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the current GA (Generally… are caused by the log records in the transactional log being overwritten before they … didn’t have an option to disable DTrace like innodb55 has. Fixed by adding…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
…need from logs. General Query Log The first option is the General Query Log. Let’s see an example: Enable the log: general_log_file = /var/log/mysql/mysql.log general_log = 1 …. general_log variable is dynamic so a solution could be enabling and disabling the log just when it’s needed. Error log If …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…/nfs/dist/5.6.10/lib/plugin/ | | SYNC_RELAY_LOG | 0 | 10000 | | GENERAL_LOG_FILE | /mnt/data/sandboxes/msb_5_5_30/data…_stats_on_metadata is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_size – default… because Innodb was disabled for some reason was very error prone gotcha. Note this is as far as MySQL 5.6 goes…
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
General query logging can be very handy in MySQL on profuction server for various debugging needs. Unfortunately you can’… on and off without restarting server until MySQL 5.0. What can you do in MySQL 5.0 and below ? Use Our… you can effectively enable and disable debug logging live. Note however this is not 100% equivalent for general query log – for example connects or…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… Server prepared statements were disabled for the run (same as we had few years ago). Prepared statements generally should have helped this… which makes it better to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc…_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql/var innodb…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
… is called general log activated with –log (or –general-log in MySQL 5.1+) start-up parameter. The log writes any query being executed by MySQL to a… restart to disable it when no longer necessary (though actually slow log can be disabled by simply setting long_query_time MySQL variable vale…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… see for simple queries due to generally fatter code. The problem in both cases was MySQL 5.0 broken group commit bug… old working code path if XA is disabled ? Many customers do not flush binary log anyway and use single transactional storage engine… so you may not get same performance as with MySQL 4.1 Disable Binary Logging This allows to get group commit back but…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
…summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot…mean limit disabled. Very few users actually need DOS prevention this variable strives to provide as MySQL is…left alone. Same applies to sync_relay_log and sync_relay_log_info settings. James also promises …
