…the procedure get logged and not the 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> create procedure…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…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…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…the stored procedures to modify the dictionary. Do not modify it directly. convert.php You are probably unfamiliar with the SQL_API. In order to make working with the…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…to other things; for example, when I’m examining the status values for Created_tmp_tables and Created_disk_tmp_tables, I’ll paste in mysql…stored procedures, which are more difficult to analyze because you have to pull out the statements and analyze them individually. The goal is always to…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…procedure: Infobright: the loader that comes with ICE version is very limited and I had to transform files to…to find how to execute command from command line using included sqlline utility, and I did not understand how to…in InfoBright. MySQL is really stupid here, and EXPLAIN for this query took 6…
