…stored procedures, triggers and events. Operating and Troubleshooting for MySQL on Wednesday & Thursday, April 10 & 11 This MySQL workshop will cover: Understand MySQL…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…. I’m saying about Prepared Statements in MySQL 4.1 which came without query cache support but even worse not all of… we do not get major regressions. I’m saying about Stored Procedures which were released without proper development and debugging support. These… very long time. For example Query Cache support for Prepared Statements is only fixed in MySQL 5.1 and Most of other…
Post: Wanted: Better memory profiling for MySQL
May 18, 2008 By 4 Comments
…) substract memory used by other global buffers such as query_cache_size and key_buffer and will in many cases see… connection settings ? It also could be memory leak in MySQL or runaway stored procedure consuming too much memory, but there is no way… for current thread in addition to global memory allocation. As MySQL is progressing the problem of memory allocation transparency is becoming…
Comment: A micro-benchmark of stored routines in MySQL
August 17, 2009 By 7 Comments
Well, let’s try a proper stored procedure.. 
I’ll actually mimic what the statement was trying to …) | +——————–+ | 237134840 | +——————–+ 1 row in set (0.06 sec) mysql> SELECT sql_no_cache sum(ci.Population) FROM City AS ci WHERE CountryCode…
Post: A micro-benchmark of stored routines in MySQL
August 16, 2009 By 7 Comments
… — is to see how fast the SQL procedure code is at doing basically the same… and basically rewrote it as a stored function. mysql> delimiter // mysql> create function speaks_english(c char(… return res; > end// mysql> delimiter ; Now the query can be rewritten as this: mysql> select sql_no_cache sum(…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… skip-bdb skip-innodb skip-locking query_cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=1500 interactive_timeout… set-variable=max_connections=1500 log_slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority… needed referential integrity and such, MySQL was a pathetic “option”. Yes 5.x has included triggers, stored procedures, and such, but they’re…
Comment: MySQL Query Cache
July 8, 2009 By 70 Comments
… for caching queries is configurable. The MySQL query cache cannot cache stored procedures, so this solution only works for SELECT queries. Since the query cache only caches queries and often you need more caching…
Comment: What's up with HandlerSocket?
March 28, 2011 By 43 Comments
…MySQL security/ACL scheme you may have setup for corporate applications. 2.) Storing any passwords in clear text is not an option in a Sarbanes/Oxley compliant environment. 3.) Disabling query cache…where the developers prefer to utilize stored procedures whenever possible and changes have an …
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
August 29, 2007 By 57 Comments
… is not true, in “EXPLAIN SELECT SQL_NO_CACHE count(*) FROM count_test WHERE b = 666;”, count …test WHERE b = 999 ORDER BY c LIMIT 5;”, mysql uses index to determine number of rows to examine… much faster than sending two queries. I use a stored procedure that accept a dynamic sql query, an offset and…
Comment: MySQL wins C'T Database Contest
August 31, 2006 By 27 Comments
… these tests is fundamentally wrong. Cache or no cache – there is something in this tests that is MySQL-specific. For instance, 3664 op… on the execution method. At least, it should be a stored procedure, otherwise we just compare drivers and essentials of Java vs…
