There are comments in each file about what kind of system they were designed for. You can read up on what each option does in the on line manual so you can really customize it to what you will be doing. To use one of the files, you will put it in the appropriate place and name it my.cnf. On a Mac, and other BSD Unix I think, it goes in /etc. Shutdown and relaunch MySQL and see if you get a boost.
On Monday, August 18, 2003, at 10:53 AM, Creigh Shank wrote:
How would I tune my.cnf for a larger memory box? (Running on UPS; production machine(s) will go into Co-Lo with UPS and generator.) I realize there is some risk here. I am more concerned with the system failing and some kind of mirroring solution to protect data.
Creigh
At 10:34 AM 8/18/2003 -0400, you wrote:
Depends on db size... kinda risky putting it in memory if it's being updated and power goes bye-bye..
You should be able to get alot more performance just tuning my.cnf for a
larger memory box..
On Mon, 18 Aug 2003, Creigh Shank wrote:
> Have a very large database and due to performance requirements it seems
> that running MySQL in RAMDisk might be a good solution. Access to the
> database is through PHP. Any suggestions or experiences?
>
> Creigh
> 305-541-1122
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]