LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-25-2003, 06:50 PM   #1
mikeshn
Member
 
Registered: Feb 2002
Posts: 586

Rep: Reputation: 30
SQL performance: Memory or CPU


What is more important to SQL: Memory or CPU?
I mean to get good performance for SQL, what plays more important role?

Thanks
 
Old 07-25-2003, 08:28 PM   #2
jeremy
root
 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 11,956

Rep: Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108
It depends a lot on your setup and the SQL server you'll be using but assuming a decent CPU you'll usually end up being IO bound (ie. buy the fastest disks possible).

--jeremy
 
Old 07-25-2003, 08:47 PM   #3
daihard
Member
 
Registered: Jul 2003
Location: Seattle, WA
Distribution: Kubuntu 12.04
Posts: 913

Rep: Reputation: 34
Question Re: SQL performance: Memory or CPU

Quote:
Originally posted by mikeshn
What is more important to SQL: Memory or CPU?
I mean to get good performance for SQL, what plays more important role?

Thanks
You're leaving out too many variables. SQL itself is just a query language. There are a lot of database products that use SQL (e.g. MySQL, Postgre, Oracle, SQLite, etc). Are you talking about any partcular SQL database product?
 
Old 07-26-2003, 08:33 AM   #4
mikeshn
Member
 
Registered: Feb 2002
Posts: 586

Original Poster
Rep: Reputation: 30
MySQL
 
Old 07-26-2003, 12:27 PM   #5
jeremy
root
 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 11,956

Rep: Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108Reputation: 3108
mikeshn,

In my experiance the biggest performance win with MySQL is usually making sure all SQL queries in a given app are tuned properly. As far as hardware goes you are still leaving out too many variables for a solid answer. Memory and disk are very important though. I would also recommend reiser for the filesystem. You'll also need to monitor performance and tweak the MySQL config a bit in the begining.

--jeremy
 
Old 07-26-2003, 04:22 PM   #6
daihard
Member
 
Registered: Jul 2003
Location: Seattle, WA
Distribution: Kubuntu 12.04
Posts: 913

Rep: Reputation: 34
Quote:
Originally posted by jeremy
In my experiance the biggest performance win with MySQL is usually making sure all SQL queries in a given app are tuned properly.
That's probably true for a lot of other engines. It can be tricky, too, because each database engine has its own query optimiser. You have to read the documentation well in order to understand how the optimiser in a particular product works and fine-tune your SQL queries accordingly.
 
  


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
CPU performance mifan Linux - Software 7 08-15-2005 07:10 PM
SQL query performance smaida Programming 6 06-08-2005 10:22 AM
Help Configuring the Memory Used by a Process in RedHat? (Cache Memory on CPU) geogecko Linux - General 3 02-23-2005 04:32 PM
CPU Performance Management desertstalker Debian 1 06-11-2004 09:52 PM
ACID maintenance and performance tuning using sql mikmok Linux - General 0 03-02-2004 01:16 PM


All times are GMT -5. The time now is 01:06 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration