… some hints what you can try for JDBC configuration. Some caching options are must (otherwise JDBC will have a lot of extra calls…_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql/var innodb_data_file_path…
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
… Statements with emulated prepared statements which JDBC, ODBC and some other drivers had forever. Now query passed to the server contained placeholders… great future ahead for MySQL Prepared statements – many of the problems such as extra round trip, non working query cache or non working…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
… itself, similar as JDBC driver does. Client size caching Would be very helpful for simple applications which may run query several times per… cache things but it would be very easy for many applications. Query Timeouts Make it easy to specify timeouts for connects and query… in many cases. Multiple concurrent queries I would like to be able to run multiple queries for multiple MySQL connections at once. For…
Comment: MySQL Query Cache
May 10, 2008 By 70 Comments
… is some transparent query cache available for mysql that is not ACID safe. something to work with high update scenario, the cache is NOT… as a wrapper over JDBC classes with local in-memory caching. or a set of APIs that first query the memcached/JCS/EHCache and if nothing is found, query the MySQL database…
