mysql question need help - GoFuckYourself.com

xanx · 11-03-2004, 11:12 PM

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 · 11-03-2004, 11:14 PM

restart the server

lib · 11-03-2004, 11:16 PM

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 · 11-03-2004, 11:17 PM

format the machine

xanx · 11-03-2004, 11:20 PM

Quote:

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 · 11-03-2004, 11:20 PM

put a new fan in the machine

darksoul · 11-03-2004, 11:23 PM

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 · 11-03-2004, 11:23 PM

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 · 11-03-2004, 11:24 PM

Quote:

Originally posted by tical
put a new fan in the machine

Defrag!

tical · 11-03-2004, 11:26 PM

It could be the color of your cat5 cable

try a red one

then try a blue one

xanx · 11-03-2004, 11:34 PM

Quote:

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 · 11-03-2004, 11:37 PM

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 · 11-03-2004, 11:45 PM

Quote:

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 · 11-03-2004, 11:54 PM

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

Did this ever work?

xanx · 11-04-2004, 12:06 AM

Quote:

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 · 11-04-2004, 12:22 AM

To test, try stopping iptables completely.

Maybe paste your my.cnf too.

11-03-2004, 11:12 PM	#1
xanx Confirmed User Join Date: Apr 2002 Location: Orlando, FL Posts: 3,711	mysql question need help 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

11-03-2004, 11:14 PM	#2
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	restart the server __________________ 112.020.756

11-03-2004, 11:17 PM	#4
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	format the machine __________________ 112.020.756

11-03-2004, 11:20 PM	#6
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	put a new fan in the machine __________________ 112.020.756

11-03-2004, 11:23 PM	#7
darksoul Confirmed User Join Date: Apr 2002 Location: /root/ Posts: 4,997	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. __________________ 1337 5y54\|)m1n: 157717888 BM-2cUBw4B2fgiYAfjkE7JvWaJMiUXD96n9tN Cambooth

11-03-2004, 11:16 PM	#3
lib Registered User Join Date: Sep 2003 Location: Hollywood, CA Posts: 53	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.

11-03-2004, 11:26 PM	#10
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	It could be the color of your cat5 cable try a red one then try a blue one __________________ 112.020.756

11-03-2004, 11:37 PM	#12
lib Registered User Join Date: Sep 2003 Location: Hollywood, CA Posts: 53	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?

11-03-2004, 11:54 PM	#14
lib Registered User Join Date: Sep 2003 Location: Hollywood, CA Posts: 53	You able to connect to it at all from any place at all? Did this ever work?

11-04-2004, 12:22 AM	#16
lib Registered User Join Date: Sep 2003 Location: Hollywood, CA Posts: 53	To test, try stopping iptables completely. Maybe paste your my.cnf too.