… on statements as executed inside stored procedures), however Stored Functions are not – so if you have updates done by stored functions the tables are not taken into account. The traditional pre MySQL 5…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
…any significant development since MySQL 4.1, so in-place upgrade of MySQL 5.0 to MySQL 5.5 should …you should only use it in case you’re storing multi language data. Q: What to do if … In small environments when we often care more about functionality than performance this can be great way to validate…
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
…me puzzled whenever it is user variables, complex stored procedures temporary tables or something else. Not … which can be reset as needed. If such functionality is implemented not only it can help …monitoring it which I’m sure hosting providers, MySQL as a Service vendors will especially appreciate …
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… key significantly fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal with primary… at least good to convert it in binary form and store as VARBINARY(16) for performance reasons. In any case you… index order MySQL gets data in already sorted order and looks at “one group at the time”, computing aggregate functions as needed…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
… shows. In MySQL 5.5 you can find in sql/datadict.cc a function named dd_frm_type(). In MySQL 5.1, for… of the FRM file. This is due to VIEWs being stored as the plain text of the SQL query inside the… InnoDB itself and in the table_definition_cache). Further reading: MySQL Forge Internals document on the FRM file format Stewart’s…
Post: Sharing an auto_increment value across multiple MySQL tables (revisited)
October 26, 2010 By 7 Comments
… I blogged about Sharing an auto_increment value across multiple MySQL tables. In the comments, a few people wrote in to… not too dissimilar from the Flickr solution, but uses a MySQL stored function. Full Disclosure.
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…, Flexviews includes a MySQL stored procedure API, called the SQL_API which is used to define the view. These stored procedures maintain the…() function call. This function reads the meta-data stored in the Flexviews data dictionary. It returns the SQL which represents the data stored in…
Post: Handling big result sets
June 26, 2006 By 13 Comments
… be improved. How? Let’s look mysql_query function: http://www.php.net/manual/en/function.mysql-query.php. Unfortunately there is nothing interesting… mysql_real_query / mysql_use_result or mysql_store_result, which are the same). mysqli_query with MYSQLI_STORE_RESULT (used by default) is equal mysql…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… decide yet, then don’t store everything in the database. Instead, store the source data in some fashion …, back up, and restore. And the partitioning functionality is not done yet and not fully integrated … work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, …
Post: Bug#12704861
November 20, 2011 By 1 Comment
… potentially be a very serious problem that is fixed in MySQL 5.1.60. I’ll repeat here the full documentation…_start(): Remove this faulty function that was introduced in the Bug#12612184 fix. The problem that this function was trying to address…) before storing the BLOBs, or freed (nonfree=FALSE) before committing the mini-transaction. btr_freed_leaves_validate(): A debug function for checking…
