Some bigger settings for a few things. The test is on innodb and I believe this setting is the most important: innodb_buffer_pool_size=512M But the cache size also might have an effect. I think it was either low or turned off before. key_buffer = 32M query_cache_limit = 1M query_cache_size = 32M query_cache_type = 1 innodb_buffer_pool_size=512M innodb_additional_mem_pool_size = 2M We plan to do more testing to know exactly what is important. Ludovic 2013/2/8 Jean-Vincent Drean <[email protected]>
On Fri, Feb 8, 2013 at 1:15 AM, Ludovic Dubost <[email protected]> wrote:
In my previous test, the database was not very optimized. Here is the result with a more optimized mysql 5.1:
Could you elaborate on what you do to optimize the databse ?
JV. _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Ludovic Dubost Founder and CEO Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost