…MySQL side. Even though I haven’t worked much with stored procedures, I though it’s going to be a piece of cake. In…in the slow query log generated by our mysql build running…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…in mind. In quite a lot of cases I’ve seen such filtering being broken by developer forgetting this restriction and running…This works in much larger amount of cases, but not all of them. For example stored procedures are … you. P.S It is in my todo to see how well MySQL 5.1 row based replication…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…in MySQL is well though of in regards to avoiding trouble. For example you can’t ALTER log table while query is running…stored procedure to “normalize” query by removing comments and replacing constants with some placeholders as this would allow to aggregate log entirely in…
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 2nd Edition (it’s not in…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: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
…we take the in memory table with very narrow row and run simple query which needs to do simple filtering – how many rows … To check completely in-cache scenario I created a table with just 10000 rows and wrote little stored procedure to make timing easier: mysql> DELIMITER // mysql> CREATE PROCEDURE…
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…how this table was originally defined: mysql> desc node; …in more cases than ENUM data type – maximum length of data actually stored…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…everyone in the team understand and is able to support if needed. What scares me in MySQL Development… partitioning stored procedures views and a lot of stuff. Think how much freedom evil smarty has to design…need MySQL to run ? At this point all Open Source storage engines out where are for MySQL but…
Comment: Upgrading MySQL
January 17, 2010 By 24 Comments
…to the newer binaries and run mysql_check followed by mysql_upgrade. That works pretty well as long as you don’t have stored procedures…running. This type of thing is typical in Oracle or Sybase so should not be so hard to implement in MySQL…
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…
Comment: What to tune in MySQL Server after installation
January 8, 2008 By 118 Comments
If I have an insert/update and a delete statement in a mysql stored procedure,does it mean that the second statement(delete) is executed only after the inserts/updates are completed ? Or do they all run concurrently.If yes,how to make them run one after another?
