…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 4 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 20 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: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…to dump schema’s. It does not handle views/triggers/procedures etc. Run with –no-schemas, instead use mysqldump for the…in the current charset mysqldump … -d -R –skip-triggers, out to the schema file create a schema-post file that has the triggers # mysqldump … -d -t How 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…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…the global setting on the master is to write binary logs in statement mode. The row-based format does offer advantages particularly if triggers or stored procedures…
