… correct. There was no truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For… why TEXT coverts to MEDIUMTEXT] Maybe something changed since this article was originally written, but right now it seems downright misleading…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…. This is the second post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here… slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…. This post is the first one of a series of articles focused on the implications of enabling GTIDs on a production… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a… slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion…
Comment: How to change innodb_log_file_size safely
June 6, 2013 By 17 Comments
I followed the article, mysql is working fine now, but i dont see any innodb tables in phpmyadmin, when “check table” it says table does not exist
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… truth in the article “Dead database walking: MySQL‘s creator on why the future belongs to MariaDB.” To quote that article: “In principle, anyone who has an interest in MySQL… Tokutek). To summarize my thoughts: If you are in the MySQL market and your product is under proprietary license (not an…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… locks and how they may affect you, see Ovais’s article. In short: pt-online-schema-change 2.2 is far… a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options No more “pt-stalk — -h db1 -u me”. pt-stalk 2.2 and pt-mysql-summary 2.2 have all the standard MySQL options built-in, like other tools…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… recent blog posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6 DBA… as an important baseline that offers the best response times (MySQL server does not use multiple threads to execute query in… jobs are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5.6 brings some abilities of parallel…
Comment: Should you move from MyISAM to Innodb ?
March 27, 2013 By 59 Comments
Excellent article and discussion! Thank you very much Peter. Even though an … the incredible power of using databases! Thanks to this specific article by Peter Zaitsev my general understanding of DB engines and… ‘choice’ in using MyISAM was because it was the default MySQL engine. So far my databases have been basic and small…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… article. Recently we shifted on following new dedicated server. From first day onwards, we were facing the performance issue. Still MYSQL load… going down. Then we did some R&D on Percona MYSQL server and found that Percona need some configuration setting regarding… again performance degradation started and now it is slow again. MySQL load is not going very high. We have also noticed…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… — so generally the solution I presented to clients was a MySQL connection pool handling system for the application level via a… aim to show just how far things have come with MySQL clustering performance: http://themattreid.com/wordpress/2013/03/01/building….com pre-built as a package once I finish the articles explaining how it all works) As an aside, setting the…
