…what is the behavior of the MySQL when it needs to log “not usual” queries like Events, Functions, Stored…is fixed only in Percona server 5.5.17-22.1. AUTO INCREMENTAL VALUES In…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…stored in. That lets you choose which rows are stored close to each other, which is very beneficial in… of your application in advance. What about partitioning in MySQL 5.1? …restore. And the partitioning functionality is not done yet …using MySQL 5.1′s row-based replication, or in MySQL 5.0 and …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…MySQL to do so. What is really bad is Parallel query. Reporting with group by over 10.000.000 of rows in real time is…in MySQL 5.0 without consistent work with MySQL close Partner – Innobase to ensure Group Commit still works in 5.0…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… spotted and in the meanwhile we go over binary logs for the last month to see how frequently this functionality is used. Happily… for MySQL to see what is different in the tables. It turned out one of the float columns stored “-0” in MySQL 5.0 but it was displayed as “0” when…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
…(32, “”…, 10) = 10 <0.000011> [pid 19876] close(32) = 0 <0.000012> [pid 19876] open(“./db/…is called. But back to what the above strace shows. In MySQL 5.5 you can find in sql/datadict.cc a function named dd_frm_type(). In MySQL 5… the FRM file. This is due to VIEWs being stored as the plain text…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
…This query will perform full table scan in MySQL 5.0 (even if there are no spam … next common mistake is using INSERT … SELECT – which is in similar to what I just …in many cases and is quite easy – it is trivial to write the function which will take SELECT query and the table to which store…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
…MySQL 5.0) – there is enough gotchas with replication itself and getting things right with filtering can get quite bumpy road. In…stored functions the tables are not taken into account. The traditional pre MySQL 5.0 way to break such replication is…such slave is very fast) and what is more important …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…functions like NOW(). In fact any valid SELECT statement can be materialized. The definition of the MV is stored…is ‘enabled’, the contents are created: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_top_customers’)); Query OK, 0 rows affected (5…
Post: Profiling MySQL stored routines
January 19, 2009 By 3 Comments
…is included in all Community tree based Percona MySQL builds since it is part of MySQL community version ever since 5.0…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
…stored procedures are used, or if non deterministic functions like RAND() are used in…MySQL slaves to prevent accidental changes in data from happening! *edit* The MySQL 5.1 default binary logging format changed back to STATEMENT in MySQL 5…
