…=America/Caracas log-slow-queries=/var/log/mysql-slow-queries.log long_query_time=15 log-queries-not-using-indexes query_cache_type=1 query…=6M key_buffer_size=12M server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket…
Comment: Can MySQL temporary tables be made safe for statement-based replication?
May 27, 2008 By 8 Comments
… binlog events IN ‘bin-logs.000440′\G *************************** 1. row *************************** Log_name: bin-logs.000440 Pos: 4 Event_type: Format_desc Server_id: 1 End_log_pos: 98… *************************** Log_name: bin-logs.000440 Pos: 224 Event_type: Query Server_id: 1 End_log_pos: 300 Info: use `test`; BEGIN *************************** 4. row *************************** Log_name: bin-logs.000440…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…mysql.pid log-error = /db/mysql.err log-slow-queries = /db/slow-queries.log log-bin = /db-logs/bin-logs/mysql-logs/mysql-bin expire_logs_days = 30 # Expire logs after in…heap_table_size = 100M query_cache_size = 100M default_table_type = MYISAM log_long_format # Innodb innodb_status_file = 1 innodb_…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…mysql.pid log-error = /db/mysql.err log-slow-queries = /db/slow-queries.log log-bin = /db-logs/bin-logs/mysql-logs/mysql-bin expire_logs_days = 30 # Expire logs after in…heap_table_size = 100M query_cache_size = 100M default_table_type = MYISAM log_long_format # Innodb innodb_status_file = 1 innodb_…
Comment: MySQL random freezes could be the query cache
March 29, 2009 By 23 Comments
…: skip-name-resolve max_connections = 2000 skip-innodb log-bin = /usr/mysql/logs/mysql-bin.log binlog-do-db=tp server-id=1 wait_timeout…_cache_size = 64M query_cache_size = 0 query_cache_type = 0 join_buffer_size = 512K log_slow_queries = /usr/mysql/logs/mysql-slow.log
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… *************************** Log_name: mysql-bin.000007 Pos: 207 Event_type: Query Server_id: 1 End_log_pos: 271 Info: BEGIN *************************** 4. row *************************** Log_name: mysql-bin.000007… the binary log: master > show binlog events in ‘mysql-bin.000011′\G *************************** 1. row *************************** Log_name: mysql-bin.000011 Pos: 4 Event_type: Format_desc…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…log_binblogpercona.commanual log_binblogpercona.commanual log_bin_indexblogpercona.commanual log_bin_trust_function_creatorsblogpercona.commanual log_errorblogpercona.commanual log_isamblogpercona.commanual log_outputblogpercona.commanual log…
Comment: No more MySQL Crash Safe Replication in 5.0 ?
August 10, 2010 By 7 Comments
…_DB | +——————+———-+————–+——————+ | mysql-bin.000001 | 1631 | | | +——————+———-+————–+——————+ error log (snipped):…TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 517 #100810 18:54:31 server id 1 end_log…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… queries, or whatnot? Sometimes there are rigid constraints on what types of solutions we can propose, and we need to know… /bin/sh /usr/bin/mysqld_safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql… off the table. Queries can be rewritten. Indexes and data types and table structures can be changed. Queries can be broken…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… At Percona we have become skilled at diagnosing these types of problems, and we can solve many of them…how to do it: cd /root mkdir -p bin cd bin wget http://aspersa.googlecode.com/svn/trunk/{stalk,…you need. Finally, make sure that the script can log into MySQL (if necessary, put a password into ….
