Approach number 1 is correct. There was no truncation: MEDIUMTEXT is bigger …
Comment: Be careful when joining on CONCAT
May 24, 2013 By 16 Comments
… not necessary. I need to calculate IBAN from bank number+acc.number+sufix country number (3 separate columns that by design can only… cast or convert isn’t doing proper job with a number with 23 digits.
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… a “flight”. I have labeled each query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight examines different time periods or… data. It seems that InnoDB performs better when a larger number of rows must be joined together (Q4.1, Q4.2…
Comment: How to calculate a good InnoDB log file size
May 22, 2013 By 38 Comments
… Wed May 22 13:34:00 CDT 2013 Log sequence number 18342929533 Wed May 22 13:35:00 CDT 2013 Log sequence number 18343465682 -rw-rw—- 1 mysql mysql 536870912 May 22 13…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
… Tue May 21 22:23:15 CDT 2013 Log sequence number 17750417191 Tue May 21 22:24:15 CDT 2013 Log sequence number 17750981011 -rw-rw—- 1 mysql mysql 536870912 May 21 22…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… bug #69379 which caused MySQL clients to return bogus error number for host-not-found errors on Ubuntu 13.04. Bug…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… before it occurs. For example, if you see a large number of long-running queries in the output of SHOW PROCESSLIST…
Comment: Implementing SchemaSpy in your MySQL environment
June 5, 2013 By 2 Comments
… the tool, or certain features don’t work past N number of tables? In my experience, the schemas I have under…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… component of the tool. There are additional tabs: Tables – Names, number of children, parents, count of columns, row counts, and comments…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… between 47000 and 50000 with no movies, but your random number generator picks values in that range with equal frequency as…
