Re: run out of memory

2007-08-14 Thread Jen mlists
2007/8/15, B. Keith Murphy <[EMAIL PROTECTED]>: > What operating system are you running and is it 32 or 64 bit? > Thanks for the reply. Here is my OS info: $ uname -r 2.6.9-42.ELsmp $ cat /etc/redhat-release Red Hat Enterprise Linux AS release 4 (Nahant Update 4) Yes I think it's 64bit OS. The

run out of memory

2007-08-13 Thread Jen mlists
Hello, My server box has 8G memory and 8CPU (DELL Standard Server),when I configure Mysql server (5.0.45) using large memory,mysqld would say it run out of memory. For example,when this line appear in my.cnf, key_buffer = 4000M mysqld can't startup.When I change it to, key_buffer = 2560M mysq

how to do replication for InnoDB

2007-07-19 Thread Jen mlists
hello list, I'm not familiar with Innodb.I have done well on MyISAM replication. Can you tell me how to replicate Innodb database?thanks. --jennifer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

replication error with system's "mysql" db

2007-07-17 Thread Jen mlists
Hello members, When I do mysql replication,I didn't replicate the system's "mysql" database. but someone updated the mysql db in master,then I got the errors on slave. How to resolve it?Do I need to always replicate mysql db?thanks. ERROR: 1146 Table 'mysql.mobilearea' doesn't exist 070717 15:2

Re: when should I start master's binlog?

2007-07-16 Thread Jen mlists
Hello Baron, 2007/7/17, Baron Schwartz <[EMAIL PROTECTED]>: Are you sure the master and slave had the same data at the time you started the slave replicating from the master? It looks to me like the slave had different data and you need to re-initialize the slave. I'm not so sure.The order I

when should I start master's binlog?

2007-07-16 Thread Jen mlists
Hello members, One of our master dbs didn't have binlog enabled.But I need to do replication on it. So I add the lines, [mysqld] log-bin server-id=1 in /etc/my.cnf and restart mysqld.Then I follow the general operation to do the master/slave replication. My question is,I only enable binlog befo