Moltes, moltes, moltes gràcies Markus_petrux!!! ets un crac....

I have been using Drupal for quite some time and recently we went live. The performance scalability has been some issue of late. I have been looking into monitoring my MySQL parameters for quite sometime. Currently I'm using mysql tuner perl script to monitor what variables need change.

Some observations that need help:
1> Total fragmented tables 60: The database size is quite big around 250 tables, but even then I am using "mysqlcheck -ao -auto-repair -u[username] -p[password] [database-name] with all my databases on my site to optimize and repair all my tables. Am I doing something wrong? Or do I need to optimize all my tables often? Currently I run the above command as cron for every 15 mins. How often should I repair and optimize all my tables?

2> Query cache: 66% - Is this efficient?? How to improve on this?? I already have a 32M query_cache_size

3> Temporary tables created on disk: This is somewhere I definitely need a help. Its a high 37% How to decrease the microsoft braindumps temporary tables on disk and have most of my temporary tables created in the memory?

4> Table cache hit: Not pretty good. 45%, I have set the table_cache=2048, Should I increase the value?

Any insights on any of the above would be a great help.

Thanks!!!