… 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… if you close connection. In Percona Server you can do better as you can query temporary tables too: mysql> select sum(data_length…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… WITH READ LOCK to temporary make MySQL read only. In many cases the period for which server has to be made read only… resolving server gridlock one way or another. If you’re just using Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway) you can consider using –no…
Comment: mysql-proxy, urgh performance and scalability ?
February 27, 2012 By 27 Comments
… pool. – Failed Over. – Sharding. – Query Router. In addition it is better support stored-procedure and transparent between Mysql Server and application client. SQL Relay looks…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
… 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 this_pyear() BEGIN INSERT INTO t VALUES(YEAR(CURDATE())); END;// mysql> CALL this_pyear…
Post: MySQL Stored Procedures problems and use practices
June 12, 2007 By 21 Comments
… 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… client as in this case server may need to do more work to send it back than Stored Procedure to process it. Stored Procedures also have…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…me the question how should they estimate memory consumption by MySQL Server in given configuration. What is the formula they could use. …memory requrement for this step, especially specially crafted ones. Stored Procedures. Compex stored procedures may require a lot of memory Prepared statements and …
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… MySQL account and they have been normally treated very quickly by MySQL. The moment you give someone access to MySQL Server, all MySQL …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 …
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…> show binlog events in ‘mysql-bin.000007′\G *************************** 1. row *************************** Log_name: mysql-bin.000007 Pos: 4 Event_type: Format_desc Server_id: …*/ 7 rows in set (0.00 sec) What you see depends on your version of MySQL, because the logging of stored procedures has …
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… not work well for a lot of installations, especially as MySQL Server do not offer any enforcements – ie there is no way… is using. This works in much larger amount of cases, but not all 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 Query Cache
July 27, 2006 By 69 Comments
… Cache” which is quite helpful for MySQL Performance optimization tasks but there are… they sent from client to the server, which means it can serve responses…stored procedure calls are not, even if stored procedure would simply preform select to retrieve data from table. Avoid comment (and space) in…
