… stored procedure calls. On the other hand Stored Procedures Indeed can help to Improve MySQL Performance. For DBT2 benchmarks we’ve tried a while back MySQL… one more thing you should beware with Stored Procedures is to put a lot of computational load in them. Not only the language…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… great feature called “Query Cache” which is quite helpful for MySQL Performance optimization tasks but there are number of things you… SELECT queries are cached SHOW commands or stored procedure calls are not, even if stored procedure would simply preform select to retrieve data from… it works with MySQL to add caching but you can enable query cache so it works faster. Low load applications – If you…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
…fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough… stored procedures are handled (because binary logging is done on statements as executed inside stored procedures), however Stored Functions are…to save on traffic or if write load is high and it would be waste…
Post: MySQL Slow query log in the table
May 31, 2007 By Leave a Comment
…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file … which would be rather handy is UDF or stored procedure to “normalize” query by removing comments and replacing…most frequent slow query types or queries which load server the most. The other handly feature would…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… both the queries which cause the greatest load on the server (in aggregate) and which…, or apps that have a lot of stored procedures, which are more difficult to analyze because…
Comment: Upgrading MySQL
January 17, 2010 By 23 Comments
… are using MySQL. MySQL often recommends (if possible) doing an upgrade by doing a MySQL dump of the databases and then loading them clean… binaries and run mysql_check followed by mysql_upgrade. That works pretty well as long as you don’t have stored procedures or triggers… by the mysql_upgrade binary is to dump the tables and then load them back. Of course to run mysql_upgrade you are…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… day usage of MySQL ® Two new features which not available for 5.0: In slow.log for Stored Procedure call you can see profiling for each individial query from this procedure, not just call storproc… comes from. As I mentioned in tpce workload details the load is very SELECT intensive and these SELECTS are mainly scans…
Post: A micro-benchmark of stored routines in MySQL
August 16, 2009 By 7 Comments
… welcome — is to see how fast the SQL procedure code is at doing basically the same thing…do, at least not in MySQL 5.1 and earlier. I loaded the World sample database and …subquery and basically rewrote it as a stored function. mysql> delimiter // mysql> create function speaks_english(c char(3))…
Comment: When should you store serialized objects in the database?
January 22, 2010 By 42 Comments
… tempered by the use case of the data, typical query loads, etc. Sometimes production systems have characteristics that require non-intuitive… could do it if the client version was old. Unfortunately, MySQL‘s compress/uncompress puts a length header in front of… a stored procedure to tease the data out, but it is a pain when using a cli. If getting data from the mysql…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… starting with “Div*” are not really used. Load procedure: Infobright: the loader that comes with ICE…each field. After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA INFILE ‘/data… query Q8 (1year range) traditional transactional oriented stored engine took 30min to get result. I…
