…table and types which can be presented both in MEMORY and MyISAM storage engine. The benchmarks are done with MySQL…tables are moderately sized). Unfortunately I ran into another bug which means I will have to postpone this part of test to another…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…Another table remained though. We used mk-table-sync –print as a diff tool for MySQL to see what is different in the tables. It turned out one of the float columns stored “-0″ in MySQL 5.0 but it was displayed as “0″ when data loaded to…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
…table it often makes sense to keep it compressed. Unfortunately MySQL does not provide compressed BLOB/TEXT columns (I would really love to… box and move it to the Web box which is typically easier to scale, …another case when compression may not give any gains and sometimes even increase the data…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…mysql> drop table salaries; — Ooops! Query OK, 0 rows affected (0.49 sec) mysql> alter table employees add column…data is back. But, we still have to apply the data after the snapshot, skipping the DROP statement. You should take another…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
… and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another…mysql test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…to both MySQL 5.5 and MySQL 5.6. Another interesting thing to note is that for both Test B and…column such that both tables are read in PK order. One use case that I can think of for hash joins is data…
Comment: Air traffic queries in InfiniDB: early alpha
November 3, 2009 By 19 Comments
…to LOAD DATA INFILE. cpimport separators: I wanted to let you know that you can specify another separator value to…and 8 bytes on disk, for an 8x expansion. Moving such strings out of the fact table and into a dimension table…
Post: Small things are better
October 8, 2006 By 15 Comments
…to recover, smaller tables allow per table backup and recovery to happen faster. With MySQL and blocking ALTER TABLE there is yet another reason to keep tables…to add extra column to 500GB Innodb table. It will probably take long hours or even days for ALTER TABLE to complete and…
Comment: How to find wrong indexing with glance view
August 22, 2008 By 27 Comments
…columns that you recommend that I remove and that had performance consequences. I join 2 tables to…Another tip, turn off caching on your testing environment MySQL…
