LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
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 06-25-2007, 05:44 AM   #1
Illarane
LQ Newbie
 
Registered: May 2007
Posts: 5

Rep: Reputation: 0
Severe performance issues when querying InnoDB databases >= 2m rows on MySQL 4.1.20


Hiya,

I'm a software developer working with MySQL 4.1.20 on a RHEL 4 server and we have several tables for error logs and the like containing upwards of several million rows. When we query those tables (anything except INSERT, basically), the MySQL server falls over.

Has anyone experienced this, or does anyone know how I might be able to fix it/have a link that will help?

Thanks,

Ben.
 
Old 06-25-2007, 10:00 PM   #2
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
What do the mysql logs indicate? What type of server? Is there heavy disk I/O? More details on hardware and anything specific with your setup would be helpful.
 
Old 06-28-2007, 05:58 AM   #3
Illarane
LQ Newbie
 
Registered: May 2007
Posts: 5

Original Poster
Rep: Reputation: 0
The logs don't seem to indicate anything; it just stops responding.

The server is a Dell PowerEdge 6-something-or-other (it's in our datacentre, and I can't remember the exact number) with 4Gb RAM and two 2GHz Xeon processors.

The operating system itself is installed on a pair of 149GB discs configured to use RAID1. MySQL and the rest of the data sits on a 4x149GB RAID5 stripe.

I'm not sure how to check disc usage during the queries.
 
  


Reply

Tags
mysql


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 issues ub3rj3phf Linux - General 1 02-10-2007 11:40 PM
MySQL Innodb troubles Baltasar Linux - Software 1 04-20-2005 10:01 AM
MySQL & InnoDB riluve Linux - Software 0 03-13-2005 10:19 PM
Help mysql innodb recovery from .frm pig.2003 Linux - Software 0 11-10-2004 03:35 AM
InnoDB problem with MySQL jerry_redhat Linux - Software 2 07-09-2003 01:20 AM


All times are GMT -5. The time now is 02:56 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration