…30/orig) Get the table structures: mysqldump –no-data orig > /tmp/orig.schema.sql Create the new target …server. As noted by one of my colleagues (thanks Bill Karwin!), the cumbersome part of this process is the …versions I was using on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some other …
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…structure of the tables involved in the benchmark tests. CREATE TABLE `supplier` ( `s_suppkey` int(11) NOT NULL DEFAULT ‘0…SQL used for this test together with its EXPLAIN output as returned by MySQL 5.5…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… so ETL jobs written to rely on SQL tend to get really bogged down. …the wrong thing. Be Creative With Table Structures Suppose you have some yes/no …data archiving on my own blog a while back. The benefits of purging and …either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…values in the /etc/my.cnf file if…64 Percona Server 5.5.11 with XtraDB. … of the flight. Some data hand updated.’; — – Table structure for…0.084244966506958s, 0.078309059143066s, 0.0059359073638916s) Execute the test: As seen above, the run_query script will run one more more semicolon terminated SQL…
Post: When is MIN(DATE) != MIN(DATE) ?
September 4, 2012 By 5 Comments
… that the MIN() function was doing some sort of internal conversion to a unix_timestamp/integer …What, then, can we learn from this? Unfortunately, setting sql_mode does not help you here. Although …5.5.25a, but in my case, the behavior was even stranger. I created a table with a similar structure:…
