… part of Stored Procedure execution – running of SQL queries – you do not get these logged, instead slow query log will contain full stored procedure calls. On the other hand Stored Procedures Indeed can help to Improve…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
…())’ STORED PROCEDURES The behaviour of stored procedures and functions are completely different. If our stored procedure write data to our tables the queries inside the procedure get logged and not the call to the procedure itself. So…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
… lazy typing it over and over again you can create stored procedure, something like LAST_SLOW_QUERIES and use it instead, just… slow log queries which is used if log table is locked. One thing which would be rather handy is UDF or stored procedure to “normalize” query by removing comments and replacing constants with some placeholders as this would allow to aggregate log entirely…
Post: Profiling MySQL stored routines
January 19, 2009 By 4 Comments
… application based entirely on stored routines on MySQL side. Even though I haven’t worked much with stored procedures, I though it’s… it? Well, I can still aggregate the slow query log with mk-log-parser and find routines that MySQL spends most of… don’t want to go over the complicated logic of stored procedure just to figure out what queries are being executed. This…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… Log code did not handle 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 log. Bug fixed #719386…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… 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… 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: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… that have happened in the database, instead of replaying binary logs directly. Selecting a refresh method The refresh method you select… 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: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… 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 if you have updates done by stored functions…
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
… release contains long waited features from 5.0: extended slow.log USER/TABLE/INDEX/CLIENT_STATISTICS + THREAD_STATISTICS ( coming in release-10) Extended slow.log is now even more extended, there is additional information for… profile each individual query from stored procedures, so now you should not guess what took so long in stored procedure. What we are working…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… locks Diagnostic patches. – We provide much more statistics in slow.log, i.e. execution plan, InnoDB timing, profiling info – Userstat patch… 5.0: In slow.log for Stored Procedure call you can see profiling for each individial query from this procedure, not just call storproc…_pool, so disk does not really matter, but data was stored on FusionIO 320GB MLC card. On chart with results I…
