… while back MySQL 5.0 was about 10% slower than 4.1 without stored procedures but was 20% faster if Stored Procedures are used. And this is of course not the limit. You may also have other reasons to use Stored Procedures besides performance…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
…all your stored procedures in your slaves servers. Example: mysql> create procedure this_pyear() BEGIN INSERT INTO t VALUES(YEAR(CURDATE())); END;// mysql> CALL this…actual used auto incremental value is logged as an extra event just before the statement. MySQL uses the INSERT_ID variable to store …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… views which use the complete refresh method, incrementally refreshable views are not built directly from SQL. Instead, Flexviews includes a MySQL stored procedure API, called the SQL_API which is used to define the view. These stored procedures maintain the Flexviews data…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… instruction about what some migration strategies might look like. Using MySQL Performance Schema to debug performance issues - (Zburivsky Danil, Pythian) – … in 5.6! Perl Stored Procedures for MariaDB - (Antony Curtis, LinkedIn Corp) – I generally don’t recommend stored procedures, but I need …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… it is a lot larger problems with MySQL 5.5 with addition of user variables, stored procedures, prepared statements etc which can be a memory hog. My intent with this post is dual. I would encourage MySQL Team… might look at how it uses MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ? memory…
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
… needs leaving me puzzled whenever it is user variables, complex stored procedures temporary tables or something else. Not only such connection related… can be used to help restricting memory usage in addition to monitoring it which I’m sure hosting providers, MySQL as a… limit memory usage by individual MySQL users or even track how much these users are using. Now as MySQL 5.6 is getting…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… in MySQL 5.1 Disk Space For MyISAM tables hosting providers used to use disk quotas for MyISAM tables. You can also use similar… to run their queries. Stored Procedures – How much memory can stored procedure allocate ? say can you create 1000 variables in stored procedure and set 1M result…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… whole transaction is inside a stored procedure? Whether this works or not depends, again, on how the stored procedure call is logged to the…) What you see depends on your version of MySQL, because the logging of stored procedures has changed over time. If just the CALL statement had been logged, I think we might have been safe using a stored procedure…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… 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…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… shared here mainly applies to logical level replication. MySQL 5.1 can use row level replication which alleviates some of these issues… this query 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…
