Home » Performance » MySQL » MySQL take too much time to start
MySQL take too much time to start [message #3049] Wed, 07 May 2008 07:14 Go to next message
flashweb  is currently offline 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 Sad

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 Go to previous messageGo to next message
flashweb  is currently offline 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 #3061 is a reply to message #3050 ] Sat, 10 May 2008 12:26 Go to previous messageGo to next message
debug  is currently offline debug
Messages: 82
Registered: March 2008
Member

Did you check mysql error log? It can be InnoDB recovery for example, if previously mysql was shut down incorrectly..


Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting
Re: MySQL take too much time to start [message #3082 is a reply to message #3049 ] Thu, 15 May 2008 07:51 Go to previous messageGo to next message
karlmeh  is currently offline 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 Go to previous message
flashweb  is currently offline 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
Previous Topic:memory usage and the thread cache
Next Topic:Skipping Errors in Binary Log with mysqlbinlog
Goto Forum:
  



Current Time: Thu Jul 3 19:55:20 EDT 2008

Total time taken to generate the page: 0.00555 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge