Mysql 5 with my.cnf (http://help.directadmin.com/item.php?id=44) fails

P

PauGasol

Verified User
Joined
Feb 3, 2004
Messages
125
Hi,

I use in all the boxes the my.cnf recommended by DA : http://help.directadmin.com/item.php?id=44

But not works well with MySQL 5.x , the databases works but in the phpmyadmin all the db shows empty, and in MySQL Control in DA the size of databases are 0....

What lines should i remove ? thanks
 
If you delete the my.cnf file and restart MySQL everything starts working properly again?

Can you manage databases through DirectAdmin (create etc.)
 
Yes, deleting the my.cnf no problems.. but i want optimize the MySQL . I have around 500 clients in that box now .

PD, in other box with mysql 5 same problem... both servers Centos 4.2 64 bit edition.

Thanks
 
Since those optimizations were not made for MySQL5 I would suggest finding an uptodate one.
Or if you were me, I would go through adding one line at a time until I found the problem line then leave that out or make any adjustments necassary.
 
The problem is there are at least 50 lines or more (i cant make 50 restart of mysql with 500 clients in the servers). by that im asking if anyone solved the quiz. Thanks
 
Then add one section at a time. Most likely it has to do with settings for mysqld or client.
 
Today i put the same my.cnf . Without modifications and works.. i think the last time i cut some line and that was the problem. The my.cnf is 100% compatible with MySQL 5.x , sorry .
 
If this file does not exist in /etc you will have to create it, my.cnf is not installed by default. Use your favorite editor (such as vi, pico or joe) to start the file, then copy and paste the information from:
Code: 
http://help.directadmin.com/item.php?id=44
into the file and save it. Then restart mysqld.
 
rocketcity said:
If this file does not exist in /etc you will have to create it, my.cnf is not installed by default. Use your favorite editor (such as vi, pico or joe) to start the file, then copy and paste the information from:
Code: 
http://help.directadmin.com/item.php?id=44
into the file and save it. Then restart mysqld.
Click to expand...

Yes, but this my.cnf NOT WORKS with MySQL 5.x . Its not compatible, the databases ok but the phpmyadmin for example show 0 tables in all databases, the "mysql control" in DA all the size to 0kb etc etc

Thanks
 
Try this:
Code: 
locate my-huge.cnf
(This file should be part of your MySql 5 install). If this file exist, then copy it to /etc/my.cnf

You may have to edit it some to enhance the performance of mysql to your liking.
 
Yes , I refer only the my.cnf of DA Help. Thanks, a didnt remember the official my.cnf of mysql i will try soon.
 
There are some tips for optimizing the my-large.cnf file for MySql5 here.

I haven't tried them myself yet.
 
Last edited:
You must log in or register to reply here.
Back
Top