… it is a lot larger problems with MySQL 5.5 with addition of user variables, stored procedures, prepared statements etc which can be a memory hog. My intent with this post is dual. I would encourage MySQL Team… >> ps.log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL will…
Post: MySQL Stored Procedures problems and use practices
June 12, 2007 By 21 Comments
… get these logged, instead slow query log will contain full 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…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
… is the behavior of the MySQL when it needs to log “not usual” queries like Events, Functions, Stored Procedures, Local Variables, etc. We’ll… stored procedures in your slaves servers. Example: mysql> create procedure this_pyear() BEGIN INSERT INTO t VALUES(YEAR(CURDATE())); END;// mysql> CALL this_pyear(); Binary Log…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…. The incremental method is somewhat conceptually similar to using mysql binary logs for point-in-time recovery after a restoring a backup…, Flexviews includes a MySQL stored procedure API, called the SQL_API which is used to define the view. These stored procedures maintain the Flexviews data…
Post: MySQL Slow query log in the table
May 31, 2007 By Leave a Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous … slow log queries which is used if log table is locked. One thing which would be rather handy is UDF or stored procedure to “normalize” query by removing comments and replacing constants with some placeholders as this would allow to aggregate log entirely…
Post: Profiling MySQL stored routines
January 19, 2009 By 3 Comments
… application based entirely on stored routines on MySQL side. Even though I haven’t worked much with stored procedures, I though it’…| +———————————————————-+ 1 row in set (0.00 sec) host # tail /var/log/mysql/mysql-slow.log # Time: 090115 2:25:28 # User@Host: me[…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… a 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… your version of MySQL, because the logging of stored procedures has changed over time. If just the CALL statement had been logged, I think we…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication… of them. For example stored procedures are handled (because binary logging is done on statements as executed inside stored procedures), however Stored Functions are not – so…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size. If … Here is why: List of rarely considered MySQL Server Memory Requirements Thread buffers can …this step, especially specially crafted ones. Stored Procedures. Compex stored procedures may require a lot of memory …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11:17:30… the Percona patches for microsecond logging and additional information in the slow query log output. The stock MySQL server’s limitation of one… really complex applications, or apps that have a lot of stored procedures, which are more difficult to analyze because you have to…
