… writing Dynamic SQL in your Stored Procedures you have other issues 
I consulted for a customer who uses dynamic SQL in stored procedures extensively. They found that it was awkward because of the limits of the procedure language MySQL offers, and also…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
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’s going to be a piece of cake. In… that MySQL spends most of the time on, but I don’t want to go over the complicated logic of stored procedure just…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication… is using. This works in much larger amount of cases, but not all of them. For example stored procedures are handled (because binary logging is done on statements as executed inside stored procedures), however Stored Functions are not – so…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous… queries in the end similar to tail command. If you’re lazy typing it over and over again you can create stored procedure… stored procedure to “normalize” query by removing comments and replacing constants with some placeholders as this would allow to aggregate log entirely in…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…me the question how should they estimate memory consumption by MySQL Server in given configuration. What is the formula they could …memory requrement for this step, especially specially crafted ones. Stored Procedures. Compex stored procedures may require a lot of memory Prepared statements and …
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… great feature called “Query Cache” which is quite helpful for MySQL Performance optimization tasks but there are number of things you… or stored procedure calls are not, even if stored procedure would simply preform select to retrieve data from table. Avoid comment (and space) in the…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… the Percona Software Repositories). Based on MySQL 5.1.66, including all the bug fixes in it, Percona Server 5.1.66… respect to AUTO_INCREMENT columns. Bug fixed #1039536 (Alexey Kopytov). In cases where indexes with AUTO_INCREMENT columns where correctly detected… the case of individual statements in stored procedures correctly, this caused Query_time to increase for every query stored procedure logged to the slow query…
Comment: MySQL Stored Procedures problems and use practices
June 13, 2007 By 21 Comments
… completely agree. We are developing some complex game logics using stored procedures – in order to avoid non-useful data roundtrips between server application… there is no way to trace down MySQL logfile every SQL statement executed in a stored procedure/function… Therefore we can’t use any…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… in set (1.49 sec) To check completely in-cache scenario I created a table with just 10000 rows and wrote little stored procedure to make timing easier: mysql> DELIMITER // mysql> CREATE PROCEDURE…
Post: Stored Function to generate Sequences
April 2, 2008 By 17 Comments
… help them to convert their sequence generation process to the stored procedure and even though I have already seen it somewhere I… sequences instead of MySQL auto_increment columns ? Leaving aside more exotic ways of sequences even pure sequential value as in the case above can be quite helpful – in MySQL 5.0 you may with to…
