… unknown needs leaving me puzzled whenever it is user variables, complex stored procedures temporary tables or something else. Not only such connection related… the memory consumption by various database operations is reasonable. For example if some INFORMATION_SCHEMA query were to take couple of…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…same amount of memory and by preparing complex prepared statements you can eat a lot…not the case with Merge tables for example – creating and accessing few merge tables …queries. Stored Procedures – How much memory can stored procedure allocate ? say can you create 1000 variables in stored procedure …
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… The reasons are – this formula is very complex nowadays and what is even more important …this step, especially specially crafted ones. Stored Procedures. Compex stored procedures may require a lot of memory … reacts to changing various variables. For example you may find out increasing sort_…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… applications dealing with small data sets. For example I’m using Query Cache on server … cached SHOW commands or stored procedure calls are not, even if stored procedure would simply preform select to …, obviously there is no upper boundary – Very complex queries producing small result set will be …
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…this Commodity Space in terms of overall feature complexity. MySQL 5.2 will give you many …an some with clustering) with support of partitioning stored procedures views and a lot of stuff. Think … for many of data store applications, especially for specific needs when for example large amounts of …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…. Schema and query optimization can give much greater improvements, for example. If you’re familiar with Malcolm Gladwell’s excellent book…-hour cases are usually for really complex applications, or apps that have a lot of stored procedures, which are more difficult to analyze…
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
May 30, 2006 By 48 Comments
… using performance. Many of new features are complex – for example Stored Procedures. If you start using stored procedures in your code you might need to ensure…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… in real time is one painful thing to do requiring complex application programming to do efficiently in distributed manner. Of course…. I’m saying about Stored Procedures which were released without proper development and debugging support. These are just few examples. Of course you…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
August 29, 2007 By 57 Comments
… use SQL_CALC_FOUND_ROWS in queries that use complex where (for example search queries with many parameters and paging result set) is much faster than sending two queries. I use a stored procedure that… same thing but one with SQL_CALC_FOUND_ROWS just stores number of records before restricting rows. If I am wrong…
