On Sep 4, 2008, at 1:48 PM, Ranjeet Walunj wrote:
Hi ryan.
As pointed by Johnny, it is difficult to give optimization advise
without exactly knowing the performance of your machine.
I'm assuming you are using the machine as Database Server and not
running application (Web/other) on the same.
(And you are using InnoDB as engine)
I would suggest keeping innodb_buffer_pool_size pretty high (+20G)
This is a dedicated MySQL server - nothing else running on it at all,
so all that RAM is up for grabs. Mysqld is running in 64 bits, and
after bumping innodb_buffer_pool_size to 4G our performance concerns
are completely gone - I'll ramp that up after doing a bit more
research on InnoDB tuning.
Please read up here :
http://www.mysqlperformanceblog.com/2007/11/03/choosing-innodb_buffer_pool_size/
Also if possible get a copy of "High performance MySQL" and go
through it as it covers many good techniques for high performance
MySQL setup.
I'll have to crack open my copy - haven't read through it in a while,
and quite honestly I had forgot to make any adjustments on the InnoDB
side of things because when I inherited the old MySQL server we were
on the devs were mostly using MyISAM tables.
Some of the default InnoDB settings are horribly wrong from high
performance point of view. Can you post your complete my.cnf on
pastebin or somewhere ?
http://pastebin.com/m2ebec4f6 includes everything in my.cnf but
comments and blank lines, SHOW STATUS\G, SHOW INNODB STATUS\G, AND
SHOW VARIABLES\G
All your help is much appreciated - I just wonder if there's not been
a simple script set up by someone to autogen my.cnf based on system
variables like available RAM, etc? Surely there's some general
recommendations depending on those specific system things, rather than
"just copy my-huge.cnf and modify"...
--
Ryan Schwartz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
