Tuning MySQL

2005-01-11 Thread Eric Gunnett
I have a quad processor server, with 4 gigs of memory. It is only running MySQL right now and seems really slow. Can someone give me a few suggestions on optimizing My.cnf file for this system. We are running mysql-standard-4.0.23-pc-linux-i68, on it. Here is the my.cnf file # The

Re: on big mysql .MYD files and linux's 2GB file size limit

2004-08-02 Thread Eric Gunnett
Depends on what file system you are running that is a ext2 limit if you move to ext3 or reiser you should be fine. But then a default config on MySQL will run into a 4.29 Gig limit, which you can change. Eric Gunnett System Administrator Zoovy, Inc. [EMAIL PROTECTED] Shannon R

Re: Bin-logs

2004-06-15 Thread Eric Gunnett
You can do a reset master, and it will start the log over at 001 and remove the old log files that are there. Eric Gunnett System Administrator Zoovy, Inc. [EMAIL PROTECTED] Jeff Smelser [EMAIL PROTECTED] 06/15/04 11:26AM -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am trying

Re: MySQL on Linux

2004-04-06 Thread Eric Gunnett
it actually took the table and zeroed it out leaving me with no data, and having to recover the 2 gig table, then watching it happen again. Eric Gunnett System Administrator Zoovy, Inc. [EMAIL PROTECTED] Alan Williamson [EMAIL PROTECTED] 04/06/04 02:47PM dan wrote: the most popular would

Tru64_Unix

2003-11-21 Thread Eric Gunnett
can take to isolate and eliminate this problem? Eric Gunnett System Administrator Zoovy, Inc. [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]