… everyone who has access to the database always keeps this in mind. In quite a lot of cases I’ve seen such… 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: Profiling MySQL stored routines
January 19, 2009 By 4 Comments
… an application based entirely on stored routines on MySQL side. Even though I haven’t worked much with stored procedures, I though it… have created a function “whatstheweatherlike”. Let’s call it and see what shows up in the slow query log: mysql> SELECT whatstheweatherlike(5… that MySQL spends most of the time on, but I don’t want to go over the complicated logic of stored procedure…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…with MySQL is Scale Out, but to say the truth MySQL does not provide much of the functionality for…released in MySQL 5.0 without consistent work with MySQL close Partner – Innobase to ensure Group Commit still works in 5.0 and so we do not get major regressions. I’m saying about Stored …
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_log table instead of the file as you had in…type which is used to store query execution time and lock time does not store fractions of the second. …the most. The other handly feature would be the function which returns as as SET list of tables …
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
… is quite common in MySQL world and in fact I already wrote about it. There are many aspects of managing mysql replication lag such… write the function which will take SELECT query and the table to which store its result set and use in your application in all cases when you need this functionality. Finally you should…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… become partially functional as soon as possible. This hack is needed only in some cases – in most…-binlog option in MySQL 4.1 so your Innodb log and binary log are synchronized. In MySQL 5…Innodb statistics – Unlike MyISAM Innodb does not store index cardinality in tables, instead it computes them on…
Post: Sharing an auto_increment value across multiple MySQL tables (revisited)
October 26, 2010 By 7 Comments
… benchmarking those alternatives today across two large EC2 machines: (Measured in transactions/second – higher is better) What is the conclusion?Â… 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
… list of tables used by the above view, as stored in the data dictionary: mysql> select * from flexviews.mview_table where mview_id…_sql() function call. This function reads the meta-data stored in the Flexviews data dictionary. It returns the SQL which represents the data stored in the…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… not > expect it to beat MySQLi in speed. It is however bad idea to use > mysql_ functions directly as well – I would go… hand in MySQL you might be > better of using several queries than doing complicated ones. Of > course you would rather use IN() than… amounts of memory and disk. Because indexes are fast by storing them as fixed-width data (think of converting your varchars…
Post: Countless storage engines
May 3, 2007 By 6 Comments
… is developed in MySQL. The performance we see in our previous benchmarks was not good enough, but there was some fixes in 5.2… to handle in very fast way aggregative functions on massive data sets. As I understood they use special index to store pre-calculated values for limited number of functions…
