… truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For a column that has a data type of VARCHAR or one of the TEXT types, CONVERT TO CHARACTER SET will change the data…
Post: Beware of MySQL Data Truncation
February 7, 2009 By 4 Comments
…range value adjusted for column ‘article_id’ at row 1 | +———+——+————————————————————–+ 1 row in set (0.00 sec) MySQL optimizer behaves …out of range what could be stored in the column) it truncates the value, performs index lookup, scanning all rows…
Post: Wow. My 6 year old MySQL Bug is finally fixed in MySQL 5.6
August 30, 2012 By 2 Comments
… constant which is too large to the column instead of simply responding with empty set MySQL truncates the constant, performs the lookup and… sql_mode=strict_all_tables which will report error when data is truncated, together with using transactional tables for any data you value.
Post: MySQL automatic data truncation can backfire
January 9, 2007 By 10 Comments
… unsigned 32bit values which did not fit in this column any more so MySQL was silently converting them to 2^32-1… values which can possibly be in the database we have MySQL truncating this value to 2^32-1, then performing index ref… cardinality for this constant is low) and discarding all of them before no values matched supplied key value. So beware, data truncation can…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…show_column_typesblogpercona…data_pending_readsblogpercona.commanual Innodb_data_pending_writesblogpercona.commanual Innodb_data_readblogpercona.commanual Innodb_data_readsblogpercona.commanual Innodb_data_writesblogpercona.commanual Innodb_data…unsafe_for_binlogblogpercona…Innodb_truncated_status…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… the limit. MySQL in such situation truncates the output so….
Post: Converting Character Sets
March 17, 2009 By 22 Comments
…mediumtext. This approach can result in modified data types and silent data truncation, which makes it unacceptable for our purposes. Approach #2 (outlined …for a target column Comma-separated. NO SPACES. table.column –ignore-tables A comma-separated list of tables to ignore –password|p The MySQL…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… logging atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise we…9% 4 0.0192 1.00 0.00 TRUNCATE TABLE poller_time # 14 0x3E84BF7C0C2A3005 0.0624 0…._name column, or you might even compress the values stored in the option_value column so that less data…
Post: Concatenating MyISAM files
November 19, 2012 By 5 Comments
… for everyday use but still pretty cool. Addendum Following Peter’s comment, I added varchar and deleted rows to the mix: mysql> truncate… sec) mysql> truncate table test_concat_part; Query OK, 0 rows affected (0.01 sec) mysql> alter table test_concat add data varchar(10….00 sec) So varchar columns are supported without any issue but, deleted rows prevent the use of the quick option for myisamchk.
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…_show_collations’, ’176788′ ‘Com_show_column_types’, ’0′ ‘Com_show…’ ‘Com_stmt_send_long_data‘, ’0′ ‘Com_truncate‘, ’0′ ‘Com_unlock_tables’, …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…32M # Only for MyISAM which …
