…can cause rather hard to catch errors. Connection can timeout If you do not fetch data for long…. Another alternative is of course to use MySQL Stored Procedures which can be fit to do this simple …. Using FEDERATED Tables can work for some cases in others script can be more efficient especially when…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… or stored procedure calls are not, even if stored procedure would simply preform select to retrieve data from table. Avoid comment (and space) in the…_limit was implemented which limits result set which can be stored in query cache. If you need larger queries to be cached… bad. With other caches you may implement version based or timeout based invalidation which can offer much better hit ratio for…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
…_type=1 max_connections=1500 interactive_timeout=25 wait_timeout=10 connect_timeout=5 thread_cache_size=60 key… pathetic “option”. Yes 5.x has included triggers, stored procedures, and such, but they’re a joke. A… NULL). We will have to do this check in the application. Just my experience. I know some…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… thing to do requiring complex application programming to do efficiently in distributed manner. Of course there are summary tables and other… Commit still works in 5.0 and so we do not get major regressions. I’m saying about Stored Procedures which were released… created by other guys. These would include support for query timeouts, parallel query execution, CONNECT BY support and various performance related…
