LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 01-28-2009, 10:31 PM   #1
sir-lancealot
Member
 
Registered: Aug 2007
Posts: 346

Rep: Reputation: 31
Unhappy mysql 5 startup help needed


ok, think I am on to something with my slowness. The slower mysql 4 server has the following when looking at a process list;

25243 ? S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/classic.pid
25274 ? S 0:25 \_ [mysqld]
25275 ? S 0:37 \_ [mysqld]
25276 ? S 0:00 \_ [mysqld]
25277 ? S 0:00 \_ [mysqld]
25278 ? S 0:00 \_ [mysqld]
25279 ? S 0:00 \_ [mysqld]
25280 ? S 0:00 \_ [mysqld]
25281 ? S 0:03 \_ [mysqld]
25282 ? S 0:00 \_ [mysqld]
25283 ? S 0:15 \_ [mysqld]


The newer/faster mysql5 box has the following running;
root 10245 0.0 0.0 4472 1092 pts/0 S 23:13 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid --log-error=/var/log/mysqld.log
mysql 10281 5.8 1.1 141544 24028 pts/0 Sl 23:13 0:19 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock


So queries that take 20 seconds are taking 5+ minutes on the newer/faster myslql 5 box and I am thinking it's the single thread and/or the skip-locking. I am looking at the /etc/my.cnf file and there is no mention of the skip-logging (notice it running in the ps). How do I not start mysql with that option and does the above threading also make sense? Any mysql guys out there can help is so appreciated as this is really getting stressful!

Last edited by sir-lancealot; 01-28-2009 at 10:32 PM.
 
Old 01-30-2009, 12:41 AM   #2
rylan76
Senior Member
 
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,552

Rep: Reputation: 103Reputation: 103
Hmm - queries that take 20 seconds?!

That already sounds like an eternity. At least it IS a virtual eternity on any MySQL setup that does NOT have tens of thousands of concurrent users, or an extremely old or slow system it running on.

What kind of loads are you running under? What are your system specs? Memory? Disk space? CPU count?

We once had a site http://poweralert.co.za that had these kinds of response times, but that was when thousands of people where hitting it at once. If you have an unloaded system that is having these kinds of response times to queries (never even mind 5 MINUTES - that is EONS long!) there is some very basic and extremely severe error in your MySQL installation or some configuration option. Or you have some kind of system error or problem (however, to have this kind of pathetic MySQL performance, your system would have to be so broken it probably wouldn't even boot...)

What distro are you running?

What kernel version?

What precise MySQL version?

How large is your database? What does the query that takes this long DO? What does it look like?

How many concurrent users are you trying to serve?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
startup program: is sudo needed? Patrick K Ubuntu 2 04-24-2007 10:29 AM
Is startup disk needed to boot fedora after suse install? sirius57 Fedora 11 05-19-2006 04:56 AM
Guidance needed: running an application on startup. nyumedic2000 Linux - General 1 07-15-2004 04:01 PM
MySQL Help needed muhammade Linux - General 9 01-28-2003 07:25 PM
Startup services... which are needed? Stephanie Linux - General 7 04-05-2002 08:59 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 06:22 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration