How to optimize the MySQL ???

[chiaravel]

Hi,

I'm running the Plesk CP in a Dedicated Server with 2 gbs RAM.

BUT, my processor is a CELERON...

I have almost 1 gbs of free RAM and I just to install another site that use JOOMLA CMS

www.mediacenter.vb-mundo.com

This site is too slow, and when I go to the server task manager, the process that have delays is the MYSQL-NT.EXE.

Joomla perform too much querys to the MySQL Database and perhaps this querys may be Cached..

I see that MySQL 5.00 allow set the variable "query_cache_size" and the querys be allowed in the RAM.

As I have 1 GB Free ram in the server, I need to give almost 200 mb for caching querys.

HOW CAN I SET THIS VALUE WITH PLESK ?

I wen to the folder "C:\Program Files\SWSoft\MySQL\bin" and I tried to enter to the MySQLADmin... but I don't know what I need to set this variable.

Can you help me ?

Are another way to make the performance up ?

Best Regards

 

[avsokolov]

You need to edit the "my.cnf" file. It is located by default at:
"C:\Program Files\SWsoft\Plesk\Databases\MySQL\Data" folder