View Single Post
  #14  
Old 28th June 2007, 05:07
Beastcave Beastcave is offline
Junior Member
 
Join Date: Jun 2007
Location: Chatham, Ontario, Canada
Posts: 15
Thanks: 3
Thanked 0 Times in 0 Posts
Lightbulb

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.
Code:
/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
Reply With Quote