… simply responding with empty set MySQL truncates the constant, performs the lookup and only when discards results: CREATE TABLE `trunc` ( `i` int(11… application which would use multiple table and the column type was inconsistent between them… so inserts into one table would happen with correct…
Post: Concatenating MyISAM files
November 19, 2012 By 5 Comments
… sec) So, yes, you can concatenate MyISAM files, even when multiple keys are defined. Not for everyday use but still pretty… deleted rows to the mix: mysql> truncate table test_concat; Query OK, 0 rows affected (0.00 sec) mysql> truncate table test_concat_part; Query OK, 0 rows affected (0.01 sec) mysql> alter table test_concat add data…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
…and from the Percona Software Repositories). Based on MySQL 5.1.66, including all the bug …a table (any non-temporary table) can inject arbitrary SQL into the binary log and that could cause multiple…were not purged after transaction commit. Fixed by truncating the temporary file, if used for a binary…
Post: Converting Character Sets
March 17, 2009 By 22 Comments
… 0Â Warnings: 0 mysql> SHOW CREATE TABLE `t1`\G *************************** 1. row *************************** Table: t1 Create Table: CREATE TABLE `t1` (… data types and silent data truncation, which makes it unacceptable for our … it requires multiple alter statements to be run on each table: 1) …
Comment: High-Performance Click Analysis with MySQL
December 24, 2008 By 13 Comments
…clustering but if finally ends in one or multiple MySQL servers used for end user reporting. Works …it. Raw data required for aggregates processing is truncated daily. – we do not use a lot …but keep aggregate tables compact. After all, MySQL is not column oriented storage, so big tables should have …
Post: Announcing Percona Server 5.5.28-29.3
January 8, 2013 By 2 Comments
…and from the Percona Software Repositories). Based on MySQL 5.5.28, including all the bug …a table (any non-temporary table) can inject arbitrary SQL into the binary log and that could cause multiple…were not purged after transaction commit. Fixed by truncating the temporary file, if used for a binary…
