… MySQL to do so. What is really bad is Parallel query. Reporting with group by over 10.000.000 of rows in real… Queries on MySQL because subqueries optimizer weakness. I’m saying about XA which were released in MySQL 5.0 without consistent work with MySQL… we do not get major regressions. I’m saying about Stored Procedures which were released without proper development and debugging support. These…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
…stored procedures, triggers and events. Operating and Troubleshooting for MySQL on Wednesday & Thursday, April 10 & 11 This MySQL workshop will cover: Understand MySQL…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… of swap space) like crazy. Why ? Because by default mysql_query uses mysql_store_result C library call and buffers all result set in… checking If you use buffered query the only real call you can get errors is when you run mysql_query , mysql_fetch_row simply reads… much more efficient. Another alternative is of course to use MySQL Stored Procedures which can be fit to do this simple job. The…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…does not handle views/triggers/procedures etc. Run with –no-…: run with –kill-long-queries to avoid nasty problems … pull binary logs in real time to another server using…you to cost effectively store long term backups with little… Decompressing Percona XtraBackup for MySQL in parallel using all…
