LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 03-14-2009, 07:49 AM   #1
Ujjain
Member
 
Registered: Mar 2009
Posts: 33

Rep: Reputation: 15
MySQL performance seems spite awful


I used to see a lot of these lines in my logs.
Code:
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
I have made these changes this morning:
  • Copied MySQL Configuration File /etc/my.cnf from a well-performing server
  • Cleared 25GB of MySQL Binary Logs
  • Ran mysqlcheck on all databases for both repair and optimize.
I am looking for suggestions. MySQL performance has been spite awful lately and I want to see a 99,99% uptime for the next 3 months.
 
Old 03-14-2009, 11:12 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,553

Rep: Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946
Quote:
Originally Posted by Ujjain View Post
I used to see a lot of these lines in my logs.
Code:
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
I have made these changes this morning:
  • Copied MySQL Configuration File /etc/my.cnf from a well-performing server
  • Cleared 25GB of MySQL Binary Logs
  • Ran mysqlcheck on all databases for both repair and optimize.
I am looking for suggestions. MySQL performance has been spite awful lately and I want to see a 99,99% uptime for the next 3 months.
That's one piece of the puzzle. What application is accessing the database? How many users? How big is the database(s) in question?

Alot of database messages will depend on how things are getting into and out of the database...if you have record contention, or if the process is IO bound on one spindle, and you have a large database, that'll do it as well.
 
Old 03-14-2009, 01:12 PM   #3
robertjinx
Member
 
Registered: Oct 2007
Location: Prague, CZ
Distribution: RedHat / CentOS / Ubuntu / SUSE / Debian
Posts: 749

Rep: Reputation: 73
Try to use mysqltuner.pl to improve performance also check the file system for any errors.

To download mysqltuner.pl go to: http://wiki.mysqltuner.com/MySQLTuner

Good luck!
 
  


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
MySQL performance Sheridan Linux - Server 29 07-09-2010 06:30 AM
MySQL Performance Ammad Linux - General 5 07-25-2008 06:21 AM
Partitioning in spite of bad sector EGR Linux - Newbie 4 05-23-2006 03:42 AM
Awful Nvidia performance linux-rulz Linux - Hardware 5 07-09-2005 02:47 PM
Awful sonund performance (ALSA-Slackware 10.1) rul3r Linux - Software 5 06-29-2005 11:09 PM

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

All times are GMT -5. The time now is 05:59 AM.

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