June 19, 2013

Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

May 21, 2013 By 8 Comments

… features regarding replication in MySQL 5.6. They open up a…However you should keep in mind some limitations of the current …mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a new table on the master: mysql> create table… servers have gtid_mode set to ON. Could it…

Filed Under: MySQL Tagged With: , ,

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

June 10, 2013 By 3 Comments

…tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter values being limited to 32-bit signed integers. Fixed so that these values can be 64-bit unsigned integers now. Bug fixed #714925. mysql_set…

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

May 22, 2013 By Leave a Comment

…In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings… be good for raw performance, but there are limitations which MyISAM imposes that are difficult to work …logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=…

Filed Under: Benchmarks, MySQL Tagged With: , , , , , , ,

Post: Percona Server 5.6.11-60.3 first Release Candidate now available

June 3, 2013 By 3 Comments

…in the Percona Server 5.6 series. All of Percona’s software is open…tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter values being limited…MySQL 5.6.11-60.3 are available in…

Filed Under: MySQL, Percona Server, Percona Software Tagged With: ,

Post: Is Synchronous Replication right for your app?

May 14, 2013 By 18 Comments

…MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much worse than Galera.  As I illustrated in….  This really will open a large window … this table with a statement like this: UPDATE achievements SET count = count… waiting, and after the limit is exceeded you will…

Filed Under: MySQL, Percona Software, XtraDB Cluster Tagged With: , , , , , ,

Post: MySQL opening .frm even when table is in table definition cache

November 21, 2011 By 8 Comments

…In MySQL 5.5 you can find in sql/datadict.cc a function named dd_frm_type(). In MySQL…in the server: DROP TABLE RENAME TABLE DROP VIEW open table filling INFORMATION_SCHEMA tables (I think it is actually the TABLES table…

Filed Under: MySQL

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

…Open_filesblogpercona.commanual open_files_limitblogpercona.commanual Open_streamsblogpercona.commanual Open_table_definitionsblogpercona.commanual Open_tablesblogpercona.commanual Opened_filesblogpercona.commanual Opened_table_definitionsblogpercona.commanual Opened…

Filed Under: Insight for DBAs, MySQL

Post: MySQL 5.5 and MySQL 5.6 default variable values differences

February 21, 2013 By 8 Comments

…tables in this system. innodb_stats_on_metadata is disabled by default in MySQL…open_files_limit was also raised. Unlikely to cause significant gains unless opening and closing files is expensive operation (such as using MySQL…pushdown=on 1 row in set (0.00 sec) mysql [localhost] {msandbox} (test) > …

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…in MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a 3 part series. In…table for InnoDB FTS, at least for the moment, this table must use the latin1 character set. mysql: CREATE TABLE…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Distributed Set Processing with Shard-Query

May 14, 2011 By 27 Comments

… I maintain another open source tool called…in parallel and there is very little data shipping because of the distributed reduction discussed above. If you have any limitation in resources in…but right now only MySQL storage nodes are … base table: `origin_airport_id` * storage node result set …

Filed Under: MySQL
« Older Posts