…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… to the error log. We just need to enable log_warnings with a value greater than 1: log_warnings = 2 Then check the error log: 121227 8…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the …enable_lockingblogpercona.commanual enable_named_pipeblogpercona.commanual enable_pstackblogpercona.commanual engine_condition_pushdownblogpercona.commanual error_countblogpercona.commanual event_schedulerblogpercona.commanual exit_infoblogpercona.commanual expire_logs…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | 64 | | MAX_CONNECT_ERRORS | 10 | 100 | | SORT_BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2…_MODE | | NO_ENGINE_SUBSTITUTION | | INNODB_OLD_BLOCKS_TIME | 0 | 1000 | | LOG_ERROR | /mnt/data/sandboxes/msb_5_5_30/data/msan | /mnt… very error prone gotcha. Note this is as far as MySQL 5.6 goes – STRICT_MODE and other safer behaviors are not enabled…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… is that if you want GTID support log_slave_updates will need to be enabled in slave server and the performance impact… with GTID enabled. Instead we need to know in which GTID is the master and set it on the slave. MySQL keeps…_SQL_Running: Yes Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘The slave is connecting using…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
… XtraDB (if enabled) could sometimes cause the server to crash. Bug fixed #871722 (Stewart Smith). Fixed server assertion error related to buffer…. Bug fixed #686534 (George Ormond Lorch III). Removed error log warnings that occured after enabling innodb_use_sys_stats_table and before ANALYZE… with MySQL 5.0 or older, importing that table could crash Percona Server in some cases. Bug fixed #1000221 (Alexey Kopytov). Error log…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? …error log. The error log shows all sorts of interesting things. Basically, anything but silence in the error log…log, is one of the more fruitful ways to analyze the system. What I usually do is ask the client to enable…
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
… on and off without restarting server until MySQL 5.0. What can you do in MySQL 5.0 and below ? Use Our… log – for example connects or queries with syntax errors will not be logged. Enable logging to /dev/null You can enable queries to say “all_queries” log… you will need to enable queries you can symlink it to something else and run “flush logs” so logs are reopened and written…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… an important question. If Query Cache is enabled and the SELECT can be serviced …000005 | | sending cached result to clien | 0.000011 | | logging slow query | 0.000002 | | cleaning up | 0.000002 …; When using MySQL 5.1 the second CREATE would just fail immediately with the error “ERROR 1050 (42S01…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 2 Comments
… seconds to wait for more Binary Logs events from the master before abort … CHANGE MASTER TO command. After you enable it, the MASTER starts to send “beat”…error: mysql_slave > show slave status\G [...] Slave_IO_Running: Connecting Slave_SQL_Running: Yes [...] Last_IO_Errno: 2003 Last_IO_Error: error…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…packet = 1M max_connections=300 max_connect_errors=100 table_cache = 6000 read_rnd_buffer_…log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql…options. It is interesting though slow query log remained enabled – probably it caused so little …
