Can't change mysql memory after editing etc/my.cnf

[GigaBlast]

Hello, i can't get the changes to take effect after editing super-spurious numerous php.ini files in plesk.

nothing works. all my setting keep getting overridden on this soding plesk vps.

I was told to use this guide for mylsq editing.
http://kb.parallels.com/en/111283


i edited /etc/my.cnf added this

innodb_buffer_pool_size = 384M
key_buffer = 256M
query_cache_size = 128M
query_cache_limit = 128M
thread_cache_size = 8
max_connections = 400
innodb_lock_wait_timeout = 100

restarted apache and mysql but never changes the database still has 8m mysql when the server has 2gb of ram

When i run show variables like 'innodb_buffer%'; it shows 8388608

I've spent all day on this and now given up. any help appreciated thanks

 

[IgorG]

Make sure that you have not custom MySQL settings in /root/.my.cnf config file.

 

[GigaBlast]

Hello IgorG, still not fixed.

[root@vps35856886 ~]# more /root/.my.cnf
/root/.my.cnf: No such file or directory

 

[Faris Raouf]

Can you post your entire my.cnf please? I'm just wondering if the addition you made might be in some section that is not read by default or something unusual like that. I doubt this is what's happening, but just in case.......

 

[inado1]

Perhaps you should first use the official cnf files for mysql at

/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-huge.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-small.cnf

Go to /etc/
rename my.cnf in my.cnf.bak

you just need to rename one of the files from /usr/share/mysql to my.cnf and copy it to /etc/

 

[GigaBlast]

Thanks for answers guys. I forgot about this post. As i just posted the fix which according to my host was doing a servers myslqd restart wasn't enough? could that be
Link