Cpanel + MySQL 4.0.13 = Corrupted databases?

[GFED]

Is this a bug with mySQL or Cpanel?

I had problems a few weeks ago with mySQL databases getting corrupted on my new server at XXX...

Someone helped my diagnose and fix it by adjusting a higher setting for my mySQL connections... from 500 to 5000...

it helped... and the databases quit corrupting as much... a couple have a few days ago and yesterday... so I upped my max connections to 10000 to see if it helps...

I haven't seen any other posts about this... am I the only one having problems with them?

+++

Several people have told me that this is a problem with the new version of mySQL + Cpanel

cPanel.net Support Ticket Number:

 

[casey]

What version of cPanel are you using?

cPanel.net Support Ticket Number:

 

[GFED]

WHM 6.4.2
Cpanel 6.4.2-S75
RedHat 7.3

cPanel.net Support Ticket Number:

 

[carlgm]

hi,

do this in root SSH and copy and paste what it outputs.

cat /etc/my.cnf

cPanel.net Support Ticket Number:

 

[ciphervendor]

Are the databases that are being corrupted always the same? Are the databases being manipulated with PHP?

cPanel.net Support Ticket Number:

 

[GFED]

Originally posted by ciphervendor
Are the databases that are being corrupted always the same? Are the databases being manipulated with PHP?

cPanel.net Support Ticket Number:

No, and yes.




carlgm, what does cat /etc/my.cnf do?

cPanel.net Support Ticket Number:

 

[GFED]

oh, my.cnf file contains this...


[mysqld]
set-variable = max_connections=10000

cPanel.net Support Ticket Number:

 

[carlgm]

okay then, this is min requirement for mysql 4:

Firstly delete it:

rm /etc/my.cnf

then reopen it in pico:

pico -w /etc/my.cnf

copy and paste:

[mysqld]
set-variable = max_connections=500
skip-innodb
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1

then save:

ctrl + x
y
enter

cPanel.net Support Ticket Number:

 

[GFED]

Thank you carlgm! I will see if this stops all the corruptions of my DBs!

cPanel.net Support Ticket Number:

 

[GFED]

nope... I just had to repair another database...

cPanel.net Support Ticket Number:

 

[NeutralGold]

stop - start mysql?

cPanel.net Support Ticket Number:

 

[carlgm]

Originally posted by NeutralGold
stop - start mysql?

cPanel.net Support Ticket Number:

I knew I forgot something.

After you have changed it do this

service mysql restart

Now, that config is bare min and I would suggest having more options defined withih your /etc/my.cnf config file.

cPanel.net Support Ticket Number:

 

[GFED]

I'll see if this helps... thanks again!

cPanel.net Support Ticket Number:

 

[GFED]

this is still happening, does anyone know how to fix it?

cPanel.net Support Ticket Number:

 

[ciphervendor]

Originally posted by GFED
this is still happening, does anyone know how to fix it?

cPanel.net Support Ticket Number:

Hire a system admin.

cPanel.net Support Ticket Number:

 

[advisor]

to solve your problem downgrade mysql to version 3 from whm>tweack settings

that's it

cPanel.net Support Ticket Number:

 

[GFED]

I downgraded to v3... thanks for your help, but seems to be a bug with mySQL or Cpanel from what I'm told...

cPanel.net Support Ticket Number: