Excessive database errors with beta2, suggestions?"

[theprof]

MY webhost at rackspace said:

I am not showing that 3.23.32 is available at ftp.mysql.com. The is 3.23.33-1 available. Please let me know if you would like this installed.

eva2000, was this the one you were referring to?

[Chris Schreiber]

Actually 3.23.35 is now available, that's the one you should use now.

[George L]

Originally posted by Chris Schreiber
Actually 3.23.35 is now available, that's the one you should use now.

wow we can never keep up with this hehe

[grumpy]

Originally posted by grumpy

We've been error free for over 36 hours now.

Forget all I suggested, it's all started again

[George L]

okay seeing as you upgraded MySQL and it has dropped your load i think the ram upgrade can wait until we monitot those mysql extended status stats some more to get an idea of how mysql is running

try putting in your /etc/my.cnf file

set-variable = max_connections=150
set-variable = join_buffer=3M
set-variable = key_buffer=16M
set-variable = record_buffer=4M
set-variable = sort_buffer=5M
set-variable = table_cache=256

then restart mysql and monitor those extended status variables - http://www.adolescentadulthood.com/status.php especially, your open_tables, opened_tables, max_used_connections, and your slow_queries

more important check your load averages and your memory usage over the next couple of days - watch for any amounts of excessive hard drive swapping or slowing down of the forum (indicator that either your my.cnf settings are too high due to lack of memory or that your vB load requires the settings even higher hence more memory)

[theprof]

I have done as you have suggested, but cannot see the results because at http://adolescentadulthood.com/status.php, the table below on teh extended status script has dissapeared. I will check in telnet though.

[theprof]

I get this error message when trying to use the variables command in mysqladmin

error: Found option without preceding group in config file: /etc/my.cnf at line:
1
Program aborted

My my.cnf is the same one that you sugegsted.

[George L]

add [mysqld] before it like

[mysqld]
set-variable = max_connections=150
set-variable = join_buffer=3M
set-variable = key_buffer=16M
set-variable = record_buffer=4M
set-variable = sort_buffer=5M
set-variable = table_cache=256

[George L]

and remove the auto refresh line in the status.php script

[theprof]

I rad in the manual at mysql.com that I shoudl have a my.cnf fiel looking like this:

[client]
port=3306
socket=/tmp/mysql.sock

[mysqld]
port=3306
socket=/tmp/mysql.sock
set-variable = key_buffer_size=16M
set-variable = max_allowed_packet=1M

If so, how do I know what my port and sockets are?

[George L]

yes you can do it that way too - my server doesn't need it thought

the port would be the same to find the path to your mysql.sock

in telnet root issue

mysqladmin -u user -p version

and it will prompt you for the mysql password for user

[George L]

try this

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking

set-variable = max_connections=150
set-variable = join_buffer=3M
set-variable = key_buffer=16M
set-variable = record_buffer=4M
set-variable = sort_buffer=5M
set-variable = table_cache=256

this is how i put it in on my old rackspace server

[theprof]

yeah it worked

more important check your load averages and your memory usage over the next couple of days

What do you think of them now?

[George L]

Originally posted by theprof
yeah it worked



What do you think of them now?

you haven't restarted mysql yet so can't say

[theprof]

how do I restart mysql?