Can you send us a copy of your my.cnf at the moment. Also, if you can provide some reports that will help us determine the best functionality, that would also help 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 helpful: show innodb status; show table status; Thank you! On 10/18/07, Jeff Mckeon <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > >
