… is kind of expected. What was unexpected however is how MySQL executed select queries if key value would be out of… values which can possibly be in the database we have MySQL truncating this value to 2^32-1, then performing index ref… them before no values matched supplied key value. So beware, data truncation can backfire in a ways you might not ever expect 
Post: MySQL automatic data truncation can backfire
January 9, 2007 By 10 Comments
Post: Beware of MySQL Data Truncation
February 7, 2009 By 4 Comments
…just get a warning: mysql> show warnings; +———+——+————————————————————–+ | Level | Code | Message | +———+——+————————————————————–+ | …in the column) it truncates the value, performs index lookup…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
…/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… tables from different Server instance, when table was altered or truncated in the meanwhile. Though this only works if table was…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially …data_pending_readsblogpercona.commanual Innodb_data_pending_writesblogpercona.commanual Innodb_data_readblogpercona.commanual Innodb_data_readsblogpercona.commanual Innodb_data_writesblogpercona.commanual Innodb_data….commanual Innodb_truncated_status_writesblogpercona….
Post: MySQL Slow query log in the table
May 31, 2007 By Leave a Comment
… MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you… is pretty nice to be able to work with data in SQL as it easy to filter all queries… queries) only read access is possible, with exception of TRUNCATE query. Which just recreates table which should be fast….
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… with all the data points you need to attack the right query in the right way. But vanilla MySQL does have its….0767 0.9% 4 0.0192 1.00 0.00 TRUNCATE TABLE poller_time # 14 0x3E84BF7C0C2A3005 0.0624 0.8% 272… use to gather more data about the underlying tables involved and the query execution plan used by MySQL. The end result might…
Post: Converting Character Sets
March 17, 2009 By 16 Comments
… (0.02 sec) Records: 0Â Duplicates: 0Â Warnings: 0 mysql> SHOW CREATE TABLE `t1`\G *************************** 1. row *************************** Table: t1 …text to mediumtext. This approach can result in modified data types and silent data truncation, which makes it unacceptable for our purposes. …
Post: Resyncing table on MySQL Slave
June 29, 2008 By 10 Comments
… active transaction) – this is also I used DELETE instead of TRUNCATE to clean out the table. In the applications which are… having table locked causes connections to pile up and either MySQL runs out of connections or Apache out of children allowed….01 sec) mysql> create table rep_new like rep_maint; Query OK, 0 rows affected (0.00 sec) mysql> load data infile ‘/tmp…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’, ’410680831′ ‘Com_stmt_reset’, ’0′ ‘Com_stmt_send_long_data‘, ’0′ ‘Com_truncate‘, ’0′ ‘Com_unlock_tables’, ’102′ ‘Com_update’, ’15146253′ ‘Com… 10 mysql conf: [mysqld] server-id=5908 port=3309 socket=/tmp/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: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… you have a large spike in number of connections to MySQL, which often happens when several transactions kill the database performance… large deadlock dump may easily exhaust the limit. MySQL in such situation truncates the output so it fits the required size and… full status output into innodb_status.
