…truncated SHA1 (GUIDs) you can do some cool stuff. 1. If you’re using client side sharding of data…IO since you’re now using a smaller column. You also get to potentially drop another index…build larger clustered databases. I just with MySQL had support for showing varbinary values on the console …
Comment: High-Performance Click Analysis with MySQL
December 24, 2008 By 13 Comments
… another or switch. – we aggregate some data directly on runtime servers, then in intermediate MySQL nodes and finally when building reporting-ready… gets too big, we just delete it. Raw data required for aggregates processing is truncated daily. – we do not use a lot of… compact. After all, MySQL is not column oriented storage, so big tables should have the smallest row length possible for faster access. It…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
…MySQL, when writing slow query information to the log table, query times and lock times are truncated…mysql –raw –skip-column…Data,Close stmt,Reset stmt,Set option,Fetch,Daemon,Error’), CONCAT(‘# administrator command: ‘, sql_text), sql_text), ‘;’ ) AS `# slow-log` FROM `mysql…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… not only fetch the data but also update the view counter. For smaller single system web …, having say “id” and “counter” columns. Using separate table for updates already solves the problem in … tables insert into one and process and truncate another. MySQL offers atomic RENAME TABLE call which can …
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…MySQL slave. After the above setup completes, I am going to change data on the slave by truncating t1. After truncation… options are “–base64-output” and “-v”. For debugging row based logs, I suggest … does not carry column names, so each column is represented by the column position prefixed with…
Post: AUTO_INCREMENT and MERGE TABLES
September 11, 2008 By Leave a Comment
…auto_increment values are by truncating the table we just inserted data to: mysql> truncate table a2; ERROR 1105 (HY000):…(0.00 sec) So for bad or for good you should remember auto_increment for Merge Tables works …of this – if you’re using auto_increment columns inserting into Merge Table and in the …
