mysql question need help

[xanx]

i can't figure out why this is happening..

Processes are being created on the mysql machine, over 167, so it must be recognizing the connections... just no data is being transferred. WTF

[tical]

restart the server

[lib]

What do you mean no data is being transferred? You can't run any queries?

If the processes are sleeping, that's just because they're idle. Fine tune your settings and kill off some of your persistent connections.

[tical]

format the machine

[xanx]

Originally posted by lib
What do you mean no data is being transferred? You can't run any queries?

If the processes are sleeping, that's just because they're idle. Fine tune your settings and kill off some of your persistent connections.

it is a duel server setup..i remember reading somewhere that either persistant connections or fuck...something like that may cause trouble.. hmmm

[tical]

put a new fan in the machine

[darksoul]

well
it doesn't matter if its a "duel" or not
with a bad query and a bad table
structure you can kill all the duels in the world.

[lib]

So what is actually happening? Using the shell on one machine, can you connect to the other's SQL?

server# mysql -u USER -h OTHERSERVER -p DATABASE

If you don't know your password and get an error, at least it's connecting. If it's not connecting, make sure your bind address is not 127.0.0.1 in my.cnf.

[lib]

Originally posted by tical
put a new fan in the machine

Defrag!

[tical]

It could be the color of your cat5 cable

try a red one

then try a blue one

[xanx]

Originally posted by lib
So what is actually happening? Using the shell on one machine, can you connect to the other's SQL?

server# mysql -u USER -h OTHERSERVER -p DATABASE

If you don't know your password and get an error, at least it's connecting. If it's not connecting, make sure your bind address is not 127.0.0.1 in my.cnf.

[root@hosted-by root]# mysql -u root -h 192.168.1.2 -p ****_phpbb
Enter password:

above seems to hang forever.

[lib]

Running iptables on the other box?

If you do a 'netstat -l' do you see it listening (LISTEN) on the 3306/mysql port? You'll see something like a *:3306 in there.

You try restarting mysql or rebooting like tical said?

Did this ever work?

You did a show processes on the other box? Can you connect locally?

[xanx]

Originally posted by lib
Running iptables on the other box?

If you do a 'netstat -l' do you see it listening (LISTEN) on the 3306/mysql port? You'll see something like a *:3306 in there.

You try restarting mysql or rebooting like tical said?

Did this ever work?

You did a show processes on the other box? Can you connect locally?

I disabled persistent connections but still no-go. Also mysql is listening on port 3306, just checked that. I restarted it many times,

[lib]

You able to connect to it at all from any place at all?

Did this ever work?

[xanx]

Originally posted by lib
You able to connect to it at all from any place at all?

Did this ever work?

I am able to connect from mysql server:
mysql -u root -h localhost -p *****_phpbb


and this is a brand new server setup so no it has never worked before

[lib]

To test, try stopping iptables completely.

Maybe paste your my.cnf too.