my.cnf
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # skip_innodb innodb_data_file_path=idbdata1:200M:autoextend set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_log_file_size=20M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1
[mysql.server] user=mysql basedir=/var/lib
[safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
At 11:23 AM 8/18/2003 -0400, you wrote:
plz forward the my.cnf inline to the mysql list... i got it uuencoded and it doesn't seem to want to decode for some reason... thanks..
On Mon, 18 Aug 2003, Creigh Shank wrote:
Here it is. Included php.ini, too.
At 10:49 AM 8/18/2003 -0400, you wrote:
>If you can post your current my.cnf + box configuration I'm sure we can
>come up with some suggestions..
>
>
>On Mon, 18 Aug 2003, 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]
> >