…to log “not usual” queries like Events, Functions, Stored Procedures, Local Variables, etc. We’ll learn what problems can we have and how to…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: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…MySQL stored procedure API, called the SQL_API which is used to define the view. These stored procedures… | 1 | 689 | 770793 | 3811 | | 2 | 6543 | 754138 | 3740 | | 3 | 5337 | 742034 | 3674 | | 4 …how you can combine both types of views together. The complete method examples show how to create…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…MySQL server to run out of file descriptors. The same is true for Partitioned tables in MySQL 5.1…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 set to…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…how to make MySQL replication reliable, part of which is to…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…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
…has 4 cores should be able to do up to 4 …stored procedure to make timing easier: mysql> DELIMITER // mysql> CREATE PROCEDURE test_read(pl INT) -> BEGIN -> DECLARE t INT; -> SET @x = 0; -> REPEAT SET @x = @x + 1…to see how longer rows affect performance and created the following table: CREATE TABLE …
Comment: MySQL - to use or not to use
May 29, 2007 By 10 Comments
…how to do proper joins 
Mostly, the new features in MySQL 5.0 seem to…to MySQL 4.1 or even 4.0, especially open source applications. Also I think many of those who say that MySQL lacked triggers, stored procedures…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…how to read these, there’s a full explanation in our book, High Performance MySQL…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: PROCEDURE ANALYSE
March 23, 2009 By 9 Comments
…MySQL has a native feature to perform this task – PROCEDURE ANALYSE Here is sample run of PROCEDURE…4…how this table was originally defined: mysql… | int(11) | NO | MUL | 1 | | | created | int(11) | NO | MUL…stored often can tell us if we defined varchar field too wide. Comparing maximum field length 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…1.6G which is impressive and give 1:34 compress ratio. MonetDB: It took some time to figure out how to…
