Re: Performance Innodb my.cnf

Hi Ortis, How abt the hits or load i.e ( DML, DDL ) to the server. My initial assessment after looking at you cnf file is 1) Calculate and place an appropriate value for innodb_buffer_pool_size 2) Reduse the innodb_thread_concurrency to 4 or 8. and how about the no. of tables in the database and

Re: INNODB my.cnf

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I need some inputs regarding my.cnf : We are using INNODB in our application.We have around 10 million records in the database. This will size up to around 10GB of data. Could you please suggest a sample my.cnf for this configuration.

Re: INNODB my.cnf

Hi, Attached is the sample my.cnf for Innodb engine type. Thanks, ViSolve DB Team. - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, September 08, 2006 7:31 PM Subject: INNODB my.cnf Hi All, I need some inputs regarding my.cnf : We are using

INNODB my.cnf

Hi All, I need some inputs regarding my.cnf : We are using INNODB in our application.We have around 10 million records in the database. This will size up to around 10GB of data. Could you please suggest a sample my.cnf for this configuration. Machine used : Sun netra 240 , dual processor

InnoDB my.cnf settings on OS X 10.3 Server?

I am trying to figure out the best innodb paramaters in the my.cnf file. Server is XServe, single CPU, G4 1 GHz, OS X Panther 10.3.4 with 2 GB RAM and 180GB hard drive, MySQL version 4.0.20. Right now I am running on default params. Does anyone out there have a suggested innodb parameters or

Re: InnoDB my.cnf settings on OS X 10.3 Server?

Kieran Kelleher wrote: Does anyone out there have a suggested innodb parameters or even a working set of params that I could start with. The InnoDB manual gives good suggestion. Some minor comments (none particularly OS X specific, but InnoDB works fine on it) innodb_buffer_pool_size is very

RE: InnoDB my.cnf settings on OS X 10.3 Server?

: InnoDB my.cnf settings on OS X 10.3 Server? I am trying to figure out the best innodb paramaters in the my.cnf file. Server is XServe, single CPU, G4 1 GHz, OS X Panther 10.3.4 with 2 GB RAM and 180GB hard drive, MySQL version 4.0.20. Right now I am running on default params. Does anyone out

Re: Mysql 4.0.20, InnoDB my.cnf problems

C.F. Scheidecker Antunes [EMAIL PROTECTED] wrote: Can anyone point me out what is going on wrong in this scenario? The .err file in the datadir can give you a clue. Take a look at the end of it. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is

Mysql 4.0.20, InnoDB my.cnf problems

Hello all, I would like to create InnoDB databases within MySQL. I have installed MySQL 4.0.20 and I have tried to uncomment the following on my /etc/my.cnf. MySQL is run on top of Fedora Core 2 Linux. # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir =

mysql InnoDB .my.cnf help

Hi. I am wanting to create an Innodb databse. I am using mysql 4.0 on unix. Could someone send me a sample configuration file of thier /etc/.my.cnf? I've looked at the documentation, but I always enjoy looking at something from a real system... Thanks, Taylor Taylor Lewick Unix System