…to dump schema’s. It does not handle views/triggers/procedures etc. Run with –no-schemas, instead use…to cost effectively store long term backups with little additional work Tips/Tricks: –add-header=x-amz-server-side-encryption:AES256 to use…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…MySQL 5.1 get MySQL slow query log logged in mysql.slow_…not trivial while staying 100% compatible to standard format as TIME type which is used to store query execution time and lock time does not store…used if log table is locked. One thing which would be rather handy is UDF or stored procedure to…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…or use different case – these would be different queries for query cache. Only SELECT queries are cached SHOW commands or stored procedure calls are not…to use query cache ? Third party application – You can’t change how it works with MySQL to…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to…or apps that have a lot of stored procedures, which are more difficult to analyze because you have to…
Post: Stored Function to generate Sequences
April 2, 2008 By 17 Comments
…to help them to convert their sequence generation process to the stored procedure and even though I have already seen it somewhere I did not…here for public benefit or my later use 
delimiter // create function seq(…MySQL 5.0 you may with to use them instead of auto_increment with Innodb tables to…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… take to complete this statement. Lets look at what the problem is. As of MySQL 5.5 FLUSH TABLES WITH READ LOCK does not work… to proceed, but resolving server gridlock one way or another. If you’re just using Innodb tables and you’re not actively changing users, stored procedures…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…use when such need arises but we still can’t deny – MySQL does not handle complex queries well, being able to use…to ensure Group Commit still works in 5.0 and so we do not get major regressions. I’m saying about Stored Procedures…
Post: xtrabackup-0.5, bugfixes, incremental backup introduction
April 7, 2009 By 6 Comments
…procedure you can see output: The latest check point (for incremental): ’1319:813219999′ >> log scanned up to…to change it in next release. Beside putting last checkpoint LSN to output we also store it in xtrabackup_checkpoint file to use…mysql/xtrabackup/0.5…
Comment: Upgrading MySQL
January 17, 2010 By 24 Comments
… to the newer binaries and run mysql_check followed by mysql_upgrade. That works pretty well as long as you don’t have stored procedures or triggers which the 5.1 upgrade may not cope… to be taken into account when the server size gets too large for dump/load to be used, or what extra steps or things need to…
Comment: Filtered MySQL Replication
November 9, 2007 By 8 Comments
…features as stored procedures and triggers, as well as with high concurrency transactional engines – I’m not sure Falcon or PBXT could use logical …features planned for MySQL 5.0 like Stored Procedures and Triggers can be hard to get with statement based replication. There were discussions to get row…
