help with mysql connection problem please...

[Beastcave]

Originally Posted by falko

I see some Slow queries in your output. Usually this is a sign that MySQL needs to be optimized. Do you have a high server load?

Optimize: ispconfigdb.login	 status: Table is already up to date
Optimize: ispconfigdb.multidoc_dep	status: Table is already up to date
Optimize: ispconfigdb.multidoc_nodes	status: Table is already up to date
Optimize: ispconfigdb.session	status: OK
Optimize: ispconfigdb.sys_config	status: Table is already up to date
Optimize: ispconfigdb.sys_dep	status: Table is already up to date
Optimize: ispconfigdb.sys_modules	status: Table is already up to date
Optimize: ispconfigdb.sys_news	status: Table is already up to date
Optimize: ispconfigdb.sys_nodes	status: OK
Optimize: ispconfigdb.sys_user	status: Table is already up to date
Optimize: ispconfigdb.user_groups	status: Table is already up to date

I did optimize my database and it is still the same. I just started this domain/server and I don't think it's being used by public yet.

Posted what my ispconfig status says:

Server Online since:  	
6d, 4:51h
Users Online: 	
1 user (That's me :cool: )
System Load 1 Minute: 	
0.05
System Load 5 Minutes: 	
0.03
System Load 15 Minutes: 	
0.00
Filesystem	Size	Used	Avail	Use%	Mounted
/dev/hda1	7.4G	1.1G	6.1G	15%	/
varrun	125M	88K	125M	1%	/var/run
varlock	125M	0	125M	0%	/var/lock
procbususb	10M	52K	10M	1%	/proc/bus/usb
udev	10M	52K	10M	1%	/dev
devshm	125M	0	125M	0%	/dev/shm

Anything else ya wanna to know or something I should check?

B

[Beastcave]

Not sure if it helps.I did enable the log for mysql_slow.log

here what it says:

/usr/sbin/mysqld, Version: 5.0.24a-Debian_9ubuntu2-log. started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
# Time: 070624  6:25:26
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Query_time: 4294967287  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SET timestamp=1182680726;
# administrator command: Refresh;

B

[falko]

Originally Posted by Beastcave

I did optimize my database and it is still the same.

You optimized the tables, but I'm referring to MySQL server optimization: http://dev.mysql.com/doc/refman/5.1/...he-server.html

[Beastcave]

Wow lots of information to absorb and I'm not sure where to start. I'll put in the slow queries log in this and maybe you'll be able to identify which path I should take to optimize my server. There are many ways to optimize server and I'm not sure which one I should do.

/usr/sbin/mysqld, Version: 5.0.24a-Debian_9ubuntu2-log. started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
/usr/sbin/mysqld, Version: 5.0.24a-Debian_9ubuntu2-log. started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
# Time: 070627 21:26:03
# User@Host: root[root] @ servername.mydomain.com [192.168.0.100]
# Query_time: 4294967295  Lock_time: 0  Rows_sent: 1  Rows_examined: 3
use ispconfigdb;
SELECT * from user_groups where groupid = '1' and userid = '1' and userstatus = '1';
# Time: 070627 21:26:04
# User@Host: root[root] @ servername.mydomain.com [192.168.0.100]
# Query_time: 4294967295  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
SELECT * from doctype where doctype_id = '1021';
# Time: 070627 21:26:13
# User@Host: root[root] @ servername.mydomain.com [192.168.0.100]
# Query_time: 4294967288  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
SELECT * from doctype where doctype_id = '1013';
# Time: 070627 21:26:16
# User@Host: root[root] @ servername.mydomain.com [192.168.0.100]
# Query_time: 4294967290  Lock_time: 0  Rows_sent: 1  Rows_examined: 6
SELECT * from isp_nodes , isp_dep , isp_isp_user where isp_isp_user.doc_id = isp_nodes.doc_id and isp_isp_user.doctype_id = isp_nodes.doctype_id and isp_isp_user.doc_id = isp_dep.child_doc_id and isp_dep.child_doctype_id = 1014 and isp_nodes.status = '1' and isp_dep.parent_tree_id = 8;

So what should I do? Change the key_buffer_size or anything like this?
My server's PII 333MHz Dual with 256MB Ram... Not sure if helps with this

(Just tell me that my server's too friggin' slow and I'll convince my wife to get me a faster one )

B

[falko]

Originally Posted by Beastcave

My server's PII 333MHz Dual with 256MB Ram... Not sure if helps with this

(Just tell me that my server's too friggin' slow and I'll convince my wife to get me a faster one )

It's not the fastest one...
You can try to change the buffer and cache settings for MySQL, like key_buffer, sort_buffer_size, read_buffer_size, read_rnd_buffer_size, myisam_sort_buffer_size, query_cache_limit, query_cache_size, etc.