| MySQL take too much time to start [message #3049] |
Wed, 07 May 2008 07:14  |
flashweb Messages: 3 Registered: May 2008 Location: India |
Junior Member |
|
|
Hi,
My MySQL server take too much time to start. I moved the data folder to its own hard disk, but still no improvement.
# uptime;date;service mysqld start;date;uptime;service httpd start
05:46:15 up 5 days, 1:24, 2 users, load average: 0.24, 1.07, 1.23
Wed May 7 05:46:15 CDT 2008
Starting MySQL: [ OK ]
Wed May 7 06:04:21 CDT 2008
06:04:21 up 5 days, 1:42, 1 user, load average: 1.77, 1.65, 1.50
Starting httpd: [ OK ]
#
You see MySQL take 18 minutes to start 
This happends when ever i restart the server or restart mysql.
Here is the process while MySQL starts
# ps aux|grep mysql
root 23549 0.0 0.0 4448 1168 pts/0 S+ 05:24 0:00 /bin/sh /sbin/service mysqld start
root 23556 0.0 0.0 4628 1272 pts/0 S+ 05:24 0:00 /bin/bash /etc/init.d/mysqld start
root 23613 1.5 7.5 157668 154580 pts/0 D+ 05:24 0:01 chown -R mysql:mysql /backup/mysql
root 23780 0.0 0.0 3896 664 pts/1 S+ 05:26 0:00 grep mysql
#
It is chown that make the MySQL startup slow.
MySQL data size is about 10 GB.
Any solution or it is normal ?
Thanks,
Yujin
http://uploads.bizhat.com
|
|
|
| Re: MySQL take too much time to start [message #3050 is a reply to message #3049 ] |
Wed, 07 May 2008 07:39   |
flashweb Messages: 3 Registered: May 2008 Location: India |
Junior Member |
|
|
The databases are
# du -h --max-depth=1
3.2M ./filmreviews
680K ./mysql
2.0M ./mail_list
2.2M ./topsites
7.5G ./freebb
9.2M ./dating
16M ./freemarr
2.2G ./blog1
13M ./cms
377M ./spam_filter
4.0K ./test
33M ./buysforums
8.2M ./bizjobs
5.5M ./buysbilling
11G .
#
http://uploads.bizhat.com
|
|
|
|
| Re: MySQL take too much time to start [message #3082 is a reply to message #3049 ] |
Thu, 15 May 2008 07:51   |
karlmeh Messages: 1 Registered: May 2008 |
Junior Member |
|
|
hi
if you will run mysql in CLI (command line interface). then it 'll not take much time to start with ....
there might be also problem of file corrupt or might be your MYSQL software did not installed properly
hope this will help you
thank's
Karl Meh
[Updated on: Thu, 15 May 2008 07:53] registry cleaner
|
|
|
| Re: MySQL take too much time to start [message #3083 is a reply to message #3049 ] |
Thu, 15 May 2008 10:14  |
flashweb Messages: 3 Registered: May 2008 Location: India |
Junior Member |
|
|
Thanks all for the reply.
The problem was chown in init script. I checked init script of another server, that do not have the chown part in init script. So i removed the chown command from init script and is working fine.
http://uploads.bizhat.com
|
|
|