…, Functions, Stored Procedures, Local Variables, etc. We’ll learn what problems can we have and how to avoid them. TRIGGERS When a statement activates a Trigger… call to the procedure itself. So in this case you don’t need to replicate all your stored procedures in your slaves servers. Example: mysql…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…a MySQL stored procedure API, called the SQL_API which is used to define the view. These stored…function call. This function reads the meta-data stored in the Flexviews data dictionary. It returns the SQL which represents the data stored…
Post: UDF -vs- MySQL Stored Function
September 6, 2010 By 6 Comments
…to modify a lot of data before pushing it to sphinx – MySQL did not have a function to do the thing so I thought I’ll write MySQL Stored Function…, here’s how long it took to process 100k rows: mysql> select ltrim_junk_mysql(author), ltrim_junk_mysql(title) … confident writing C, you know who to call…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
…called. But back to what the above strace shows. In MySQL 5.5 you can find in sql/datadict.cc a function…a string compare for “TYPE=VIEW\n” being the first bytes of the FRM file. This is due to VIEWs being stored…
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 12 Comments
…to name just a few. The tcprstat tool itself is a means of gathering raw statistics, which are suitable for storing…to tune this exchange, so if you have suggestions on how to…a first prototype release, and we want much more testing. We might also change the functionality…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…to do special-purpose tasks on it. Storing a little meta-data about each file can help a lot. Store…to think about how to avoid enormous tables that are hard to maintain, back up, and restore. And the partitioning functionality…MySQL doesn’t tend to perform well on a…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…Stored Procedures Recursion – It does not have to be recursion per say – just different stored procedures calling each other. Calls…functional. General Overload As MySQL does not have much of resource utilization control you can simply run heavy queries to get MySQL Server barely functional…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
…MySQL Performance optimization. If you’ve been using this tool a…to tell at which stage MySQL actually perform the sort or creates temporary table and so how much rows will be stored to… MySQL always calls…functions is also not used in optimization which may produce suboptimal plans if stored functions…
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 2 Comments
…stored in a table. Storing the results of a SQL statement into a table (even a temporary table) is called materializing the results. Views are similar to…a slave dedicated to such work. And some drawbacks: Not all SQL syntax supported (no outer join), no non-deterministic functions…
Post: When should you store serialized objects in the database?
January 21, 2010 By 42 Comments
A while back Friendfeed posted a blog post explaining how they changed from storing data in MySQL columns to serializing data and just storing…functions on the data (MIN, MAX, AVG). You are storing the data in a way that is very specific to…
