#1  
Old 5th December 2007, 19:06
mesti mesti is offline
Junior Member
 
Join Date: Dec 2007
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
Default cpu load 100% mysql

I have a debian server with mysql 4.1
1 gb ddr2 ram, intel 3.200 cpu
cpu load always 100%

please help..

sorry for bad english.....

Last edited by mesti; 5th December 2007 at 20:12.
Reply With Quote
Sponsored Links
  #2  
Old 5th December 2007, 19:07
mesti mesti is offline
Junior Member
 
Join Date: Dec 2007
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
Default hmm

my.cnf:
Code:
# * Basic Settings
#
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
language	= /usr/share/mysql/english
skip-external-locking
#
# localhost which is more compatible and is not less secure.
#bind-address		= 127.0.0.1
#
# * Fine Tuning
#
key_buffer		= 32M
max_allowed_packet	= 1G
thread_stack		= 256K
thread_cache_size	= 8
max_connections        = 300
table_cache            = 512
thread_concurrency     = 20
#
# * Query Cache Configuration
#
query_cache_limit       = 16M
query_cache_size        = 100K
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log		= /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
#log_slow_queries	= /var/log/mysql/mysql-slow.log
long_query_time = 4
log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id		= 1
log_bin			= /var/log/mysql/mysql-bin.log
# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
expire_logs_days	= 5
max_binlog_size         = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name

mysqldump]
quick
quote-names
max_allowed_packet	= 612M

[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition

[isamchk]
key_buffer		= 128M
Reply With Quote
  #3  
Old 5th December 2007, 19:11
mesti mesti is offline
Junior Member
 
Join Date: Dec 2007
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
Default hmmm

mysql> SHOW GLOBAL VARIABLES;
Attached Files
File Type: txt amysql.txt (13.8 KB, 190 views)

Last edited by mesti; 5th December 2007 at 19:13.
Reply With Quote
  #4  
Old 6th December 2007, 15:43
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Please run
Code:
top
and try to find out what's causing the load.
__________________
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
  #5  
Old 6th December 2007, 19:55
mesti mesti is offline
Junior Member
 
Join Date: Dec 2007
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
Default re

mysql 100%
Reply With Quote
  #6  
Old 7th December 2007, 15:14
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Please try this:

Code:
key_buffer              = 512M
max_allowed_packet      = 2M
thread_stack            = 128K
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
thread_concurrency = 4
wait_timeout = 180
#
# * Query Cache Configuration
#
query_cache_limit       = 1048576
query_cache_size        = 128M
query_cache_type        = 1
__________________
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
  #7  
Old 7th December 2007, 18:07
mesti mesti is offline
Junior Member
 
Join Date: Dec 2007
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
Exclamation re

somewhat better ,but yet not perfect the load
Reply With Quote
  #8  
Old 8th December 2007, 13:28
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
 
Default

Play around with the values a little bit to find out which ones are working best.
__________________
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
Load balancing on Fedora with Heartbeat (MySQL Cluster) rwillie6 HOWTO-Related Questions 7 17th December 2009 12:32
Question about the hardware requirement for mysql cluster with load balancing??? johN5Five^ HOWTO-Related Questions 3 12th April 2007 17:06
Howto suggestion suse PhP ver 4 + Ver 5 wwparrish Suggest HOWTO 11 7th August 2006 13:29
Server sometimes (1 or 2 hrs) down :/ edge Server Operation 25 31st July 2006 13:44
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 18:23.


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