Re: best way to copy a innodb table

how to break the table into 100,000 chunks? thanks From: Claudio Nanni To: Angela liu Cc: "mysql@lists.mysql.com" Sent: Thursday, December 1, 2011 2:24 PM Subject: Re: best way to copy a innodb table Sure you can, and you should. but in cas

Re: how to check how big a database is

Thanks, this is really helpful. From: Peter Brawley 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 to check how big a database

how to check how big a database is

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

I am my own boss!!

Hi friend...I wish I had been more prepared this helped me get back on my feet miracles really do exist imagine what you could dohttp://www.emballagedigest.fr/advertising/redirect.php?jaluc&69neb=google.com&69qefy=twitter.com&url=7daily-business-news.ru/profile/";>http://www.emballagedigest.fr/adv

Re: "InnoDB free" - What does it really mean?

it refers to free innodb tablespace. From: "Rozeboom, Kay [DAS]" To: "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, there is comment field labeled "InnoDB

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 To: Neil Tompkins Cc: [MySQL] Sent: Monday, October 10, 2011 4:13 PM Subject: Re: Fwd: Large insert query gives MySQL server gone

Monitor Locked query

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

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 To: mysql@lists.mysql.com Sent: Monday, October 3, 2011 3:01 PM Subject: Re: H

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 

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 Ange

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 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

MySQL Administrator

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

Re: Innodb table space questions

n, 1/17/11, Eric Bergen wrote: From: Eric Bergen Subject: Re: Innodb table space questions To: "Angela liu" 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 wrote: > Folks : > > two questions: > >

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.