… all your stored procedures in your slaves servers. Example: mysql> create procedure this_pyear() BEGIN INSERT INTO t VALUES(YEAR(CURDATE())); END;// mysql> CALL this… inside the procedure that modifies data are logged. So in this case you need to manually create the trigger and procedure on the…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
Post: Profiling MySQL stored routines
January 19, 2009 By 3 Comments
… an application based entirely on stored routines on MySQL side. Even though I haven’t worked much with stored procedures, I though it’s… that MySQL spends most of the time on, but I don’t want to go over the complicated logic of stored procedure just… start digging deeper. On the other hand, this way of manual profiling you can’t really see real time stats, for…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… true with CREATE TEMPORARY TABLE. I tested this (sometimes the manual is wrong!) and found that indeed, you can open a… whole transaction is inside a stored procedure? Whether this works or not depends, again, on how the stored procedure call is logged to the…) What you see depends on your version of MySQL, because the logging of stored procedures has changed over time. If just the CALL…
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 …writes on the Master is of course manual filtering – using SET SQL_LOG_BIN=… stored procedures are handled (because binary logging is done on statements as executed inside stored procedures), however Stored Functions …
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… SELECT queries are cached SHOW commands or stored procedure calls are not, even if stored procedure would simply preform select to retrieve data from… lets speak a bit about Query Cache configuration and mainance. MySQL Manual is pretty good on this: Query Cache Query Cache Status…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… of swap space) like crazy. Why ? Because by default mysql_query uses mysql_store_result C library call and buffers all result set…’t use mysql_num_rows() and mysql_data_seek() if you use this method but this is told in PHP manual and so… much more efficient. Another alternative is of course to use MySQL Stored Procedures which can be fit to do this simple job. The…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… stale data from the slave or memcached manually relaxing data consistence requirements. But honestly most…get major regressions. I’m saying about Stored Procedures which were released without proper development and …figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise …
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…doing this the manual way.) The result looks like this: … a lot of stored procedures, which are more…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…. Now from queries design MySQL would support a lot of functions (which you can always lookup in the manual) but it did… the team. In many MySQL Projects there are not even dedicated MySQL people and Web developers simply use MySQL as they fit suitable… with transactions an some with clustering) with support of partitioning stored procedures views and a lot of stuff. Think how much freedom…
