Re: best way to copy a innodb table

how to break the table into 100,000 chunks? thanks From: Claudio Nanni claudio.na...@gmail.com To: Angela liu yyll2...@yahoo.com Cc: mysql@lists.mysql.com mysql@lists.mysql.com Sent: Thursday, December 1, 2011 2:24 PM Subject: Re: best way to copy a innodb

how to check how big a database is

In mysql 5.0 ,how to check how big a database is? Thanks

Re: how to check how big a database is

Thanks, this is really helpful. From: Peter Brawley peter.braw...@earthlink.net To: mysql@lists.mysql.com Sent: Tuesday, November 15, 2011 12:41 PM Subject: Re: how to check how big a database is On 11/15/2011 2:10 PM, Angela liu wrote: In mysql 5.0 ,how

I am my own boss!!

pHi friend...brI wish I had been more prepared this helped me get back on my feet miracles really do exist imagine what you could dobra

Re: InnoDB free - What does it really mean?

it refers to free innodb tablespace. From: Rozeboom, Kay [DAS] kay.rozeb...@iowa.gov To: mysql@lists.mysql.com mysql@lists.mysql.com Sent: Thursday, November 10, 2011 10:03 AM Subject: InnoDB free - What does it really mean? In the show table status output,

Monitor Locked query

Hi, Folks: Have any idea how to monitor Locked queries with Nagios? Thanks

Re: Fwd: Large insert query gives MySQL server gone away

Yeah, I think adjusting max packet size may be helpful, remember change that value in both server and client From: Johnny Withers joh...@pixelated.net To: Neil Tompkins neil.tompk...@googlemail.com Cc: [MySQL] mysql@lists.mysql.com Sent: Monday, October 10, 2011

How MyISAM handle auto_increment

Hi, Folks: I have questions regarding how MyISAM handles auto_increment clolumn? 1. is there a auto_increment counter for MyISAM to assign a new value to auto_increment columns?   2. if MyISAM has the counter, is the counter stored in memory or disk? Thnaks 

Re: How MyISAM handle auto_increment

Thanks, what about if mysqld restart, does auto_increment gets reset  ?  I saw this happened to Innodb, if table is empty and server restart, auto_incremnet gets reset to 0 From: mos mo...@fastmail.fm To: mysql@lists.mysql.com Sent: Monday, October 3, 2011 3:01

does mysql support master to master replication

Hi, Folks: Does mysql support master to master replication, or master to slave replication on;y?  I did not find the answer in MySQL manual, but found some discussion over the internet. Does anybody know?  if so, anybody has implemented master to master replication in production? Thanks

MySQL DBA certification exam

Hi, Folk: I have two questions about the DBA certification exam: 1.how many questions ? 2: how long is the exam? 3.what's the pass score? I could not find the answers on mysql web anybody knows? Thanks a lot

Isolation level per transaction?

HI, Folks: Can Isolation levels be set per transaction?  I know isolation levels can be set per session or globally, but not sure at transaction level. if so , can anybody give me an example? Thanks a lot

MySQL Administrator

Hi, Anybody knows: Is MySQL Administrator still available for  MySQL 5.1 and 5.5?

Innodb table space questions

Folks : two questions: 1. can Innodb create per database table space , not per table table space? 2. can we store table on specific tablespace like Oracle or DB2 when creating table? Many thanks.

Re: Innodb table space questions

...@gmail.com wrote: From: Eric Bergen eric.ber...@gmail.com Subject: Re: Innodb table space questions To: Angela liu yyll2...@yahoo.com Cc: mysql@lists.mysql.com Date: Monday, January 17, 2011, 10:09 PM reply inline On Mon, Jan 17, 2011 at 9:30 PM, Angela liu yyll2...@yahoo.com wrote: Folks