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 <jv(a)xwiki.com>
On Fri, Feb 8, 2013 at 1:15 AM, Ludovic Dubost
<ludovic(a)xwiki.com> 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
devs(a)xwiki.org
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