… early example of this is classic MySQL replication, which was implemented by Sasha Pachev at MySQL AB around 1999, paid for by… a borked sales driven development process. Another example could be stored procedures. They were put in as “tick box requirement” again driven… out that entire chunk of code when working on Drizzle. Stored Procedures have their use today, but it’s not difficult to…
Post: MySQL Stored Procedures problems and use practices
June 12, 2007 By 21 Comments
… stored procedure calls. On the other hand Stored Procedures Indeed can help to Improve MySQL Performance. For DBT2 benchmarks we’ve tried a while back MySQL 5.0 was about 10% slower than 4.1 without stored procedures but was 20% faster if Stored Procedures are used…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… the procedure itself. So in this case you don’t need to replicate 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…
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 Flexviews data… joins, is the value proposition for Flexviews. The flexviews.refresh() stored procedure The first parameter to flexviews.refresh() is the materialized view…
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… row in set (0.00 sec) host # tail /var/log/mysql/mysql-slow.log # Time: 090115 2:25:28 # User@Host: me… that MySQL spends most of the time on, but I don’t want to go over the complicated logic of stored procedure just…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… about what some migration strategies might look like. Using MySQL Performance Schema to debug performance issues - (Zburivsky Danil, Pythian) – …improvements in 5.6! Perl Stored Procedures for MariaDB - (Antony Curtis, LinkedIn Corp) – I generally don’t recommend stored procedures, but I need …
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… addition to monitoring it which I’m sure hosting providers, MySQL as a Service vendors will especially appreciate as currently they…
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… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… been normally treated very quickly by MySQL. The moment you give someone access to MySQL Server, all MySQL Security guarantees is you can… 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 binary log. Let’s create a stored procedure to hold the transaction, which…) What you see depends on your version of MySQL, because the logging of stored procedures has changed over time. If just the CALL…
