Hey all,

I've got a new server set up, with dual Intel quad core processors, 4 gig of
ram, OpenSuse 10.3 (64bit) and MySql 5.0.45.

The majority of the tables are MyISAM with a few InnoDB here or there. I'm
using the huge-my.cnf as the base for my config.

Can anyone suggest some tweeking to the my.conf that will give me the best
performance on this platform?

Thanks,

Jeff

Can you send us a copy of your my.cnf at the moment.

Also, if you can provide some reports that will us determine the best
functionality, that would also a lot. It is useful to know what is
getting read/writing (or which function is being requested the most...).
Table format is also important, as you indicated...

At the MySQL command line run:
show status;
Copy/pipe output to a text file for us to view...
Also it would be ful:
show innodb status;
show table status;

Thank you!

On 10/18/07, Jeff Mckeon <jsmForum@optonline.net> wrote:
>
> Hey all,
>
> I've got a new server set up, with dual Intel quad core processors, 4 gig
> of
> ram, OpenSuse 10.3 (64bit) and MySql 5.0.45.
>
> The majority of the tables are MyISAM with a few InnoDB here or
> there. I'm
> using the huge-my.cnf as the base for my config.
>
> Can anyone suggest some tweeking to the my.conf that will give me the best
> performance on this platform?
>
> Thanks,
>
> Jeff
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=c...tler@gmail.com
>
>