Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Technical

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 25th June 2007, 03:27
Beastcave Beastcave is offline
Junior Member
 
Join Date: Jun 2007
Location: Chatham, Ontario, Canada
Posts: 15
Thanks: 3
Thanked 0 Times in 0 Posts
Default

Quote:
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?
Code:
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:
Code:
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
Reply With Quote
Sponsored Links
  #12  
Old 25th June 2007, 03:32
Beastcave Beastcave is offline
Junior Member
 
Join Date: Jun 2007
Location: Chatham, Ontario, Canada
Posts: 15
Thanks: 3
Thanked 0 Times in 0 Posts
Default

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

here what it says:
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
# 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
Reply With Quote
  #13  
Old 26th June 2007, 22:43
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

Quote:
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
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #14  
Old 28th June 2007, 04: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
  #15  
Old 29th June 2007, 17:56
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
 
Default

Quote:
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.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 17:58
Getting e-mail working hansoffate Installation/Configuration 29 13th August 2008 16:33
postfix - MySQL connection problem epo Installation/Configuration 7 4th August 2006 20:49
Perfect Xen 3.0 setup for Debian gurneyzap HOWTO-Related Questions 4 26th March 2006 11:30
MySQL connection problem cartdev Installation/Configuration 17 17th November 2005 22:30


All times are GMT +2. The time now is 07:51.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.