…MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on variables…truncated…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
… must not drop, truncate or alter the schema of the table after the backup has been taken. The variable innodb_file_per…/mysql/data/employees/ Import the new tablespace: mysql> set FOREIGN_KEY_CHECKS=0; mysql> ALTER TABLE salaries IMPORT TABLESPACE; mysql> set FOREIGN_KEY_CHECKS=1; mysql…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… normally do is set the variable log_slow_verbosity to ‘full’, this variable is available in Percona Server ….9% 4 0.0192 1.00 0.00 TRUNCATE TABLE poller_time # 14 0x3E84BF7C0C2A3005 0.0624 0.8… gather more data about the underlying tables involved and the query execution plan used by MySQL. The end …
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…Com_show_tables’, ’2842′ ‘Com_show_variables‘, ’176825′ ‘Com_show_warnings’, ’8′ ‘Com… ’0′ ‘Com_stmt_send_long_data‘, ’0′ ‘Com_truncate‘, ’0′ ‘Com_unlock_tables’, ’102′ …mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
… logging format in GA versions of MySQL 5.1 is ‘MIXED’ STATEMENT*;  The binlog_format variable can still be changed per… a MySQL slave. After the above setup completes, I am going to change data on the slave by truncating t1. After truncation… read_only = true on your MySQL slaves to prevent accidental changes in data from happening! *edit* The MySQL 5.1 default binary logging…
Comment: MySQL automatic data truncation can backfire
January 10, 2007 By 10 Comments
… require variables to be declared neither has exact types which cause numerous security and reliability problems. Same applies to MySQL most of MySQL user base loading some dirty data to MySQL would rather like it to be truncated int the case when unexpected data…
