Re: Replication only DB

do a replication of only 1 DB? > > thank Arcangelo > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Deluxe Web [EMAIL PROTECTED] -- MySQL General Mailing

INNODB MONITOR OUTPUT

Hi Do you see any problems? = 050303 12:51:11 INNODB MONITOR OUTPUT = Per second averages calculated from the last 20 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 14266, signal count 14261 M

innodb_buffer_pool_size - max_connections?

Can I assume that that with a innodb_buffer_pool_size of 1G I can accept only 500 max_connections (stack size 2M*500 connections). Also, I noticed that I can't set a innodb_buffer_pool_size > 1G. Ideas? Max -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc

my.cnf and InnoDB

Can you help me figure out the max connections # for a 2GB ram (2GB swap mem) server running myslq 4.0.16-Max-log and fedora core1. [mysqld] max_connections= ? innodb_buffer_pool_size=1G The database size is approx 100 Mb with 1,700++ tables, increasing daily.. ulimit -a core file size

Re: Mysql tuning - server Crash 1

> - Original Message ----- > From: "Deluxe Web" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Monday, February 28, 2005 11:44 AM > Subject: Re: Mysql tuning - server Crash 1 > > > Hi > > I understand.. I should switch to debian :)

Re: Mysql tuning - server Crash 1

p://www.innodb.com/order.php > > - Original Message - > From: "Deluxe Web" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Monday, February 28, 2005 9:13 AM > Subject: Re: Mysql tuning - server Crash 1 > > > In my .err. file

Re: Mysql tuning - server Crash 1

essage- > > From: Heikki Tuuri [mailto:[EMAIL PROTECTED] > > Sent: Sunday, February 27, 2005 2:58 PM > > To: mysql@lists.mysql.com > > Subject: Re: Mysql tuning - server Crash 1 > > > > Max, > > > > - Original Message - > > From: &q

Re: Mysql tuning - server Crash 1

is currently down. > > Oh well. > > Donny > > > -Original Message- > > From: Heikki Tuuri [mailto:[EMAIL PROTECTED] > > Sent: Sunday, February 27, 2005 2:58 PM > > To: mysql@lists.mysql.com > > Subject: Re: Mysql tuning - server Crash

Re: Mysql tuning - server Crash 1

ons, and row level locking for MySQL > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM > tables > http://www.innodb.com/order.php > > > - Original Message - > From: "Deluxe Web" <[EMAIL PROTECTED]> > Newsgroups: mailing.d

Mysql tuning - server Crash 1

Hi there, I have a problem with mysql. I have an application basically to track clicks to my website and last night it crashed. Can you have a look aty my situation? I run a server with 2GB RAM and a XEON processor! Thank you. - Max - error log - InnoDB: Warning: a long semaphore wait: --Thre

Fwd: Mysql tuning - server Crash 2

show status (now) +--+--+ | Variable_name| Value| +--+--+ | Aborted_clients | 1| | Aborted_connects | 2| | Bytes_received | 18819744 | | Bytes_sent | 67675629 | |