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 table Sure you can, and you should. but in case you also update/delete rows from the first table you have to set up trigger to log changes. if you are lucky (only inserts) then its easier. Cheers Claudio 2011/12/1 Angela liu yyll2...@yahoo.com Hi, folks: I have a situation: A large innodb table t1 with 45 million rows, need to have a new table t2 exactly the same as t1, to copy the data from t1 to t2, I have the following query: create table t2 like t1; insert into t2 select * from t1; but the above insert may run long time , that can interface with performance, is there a way to chunk the insert into the new table? like breaking it down into chunks of 100,000 rows ? Thanks -- Claudio
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 to check how big a database is? Thanks See Database size at http://www.artfulsoftware.com/queries.php PB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=yyll2...@yahoo.com
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 href=http://www.emballagedigest.fr/advertising/redirect.php?jalucamp;69neb=google.comamp;69qefy=twitter.comamp;url=7daily-business-news.ru/profile/;http://www.emballagedigest.fr/advertising/redirect.php?jalucamp;69neb=google.comamp;69qefy=twitter.comamp;url=7daily-business-news.ru/profile//abrsee you later/p
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, there is comment field labeled InnoDB free. Can someone explain what kind of free space is counted in this figure? Is it space that is not currently part of any segment? Does it include empty pages within segments? Does it include unused space within pages? Kay Rozeboom Information Technology Enterprise Iowa Department of Administrative Services Telephone: 515.281.6139 Fax: 515.281.6137 Email: kay.rozeb...@iowa.gov
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 4:13 PM Subject: Re: Fwd: Large insert query gives MySQL server gone away Max packet size? On Oct 10, 2011 6:12 PM, Neil Tompkins neil.tompk...@googlemail.com wrote: As per the subject we've a large insert query that gives up the error MySQL server has gone away when we try to execute it. Any ideas why ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
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 PM Subject: Re: How MyISAM handle auto_increment At 04:46 PM 10/3/2011, you wrote: 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? Yes 2. if MyISAM has the counter, is the counter stored in memory or disk? Thnaks It is stored with the table definition. It is only reset to 0 when the table is (re)created. You can get the last AutoInc for the record that was just added by Select Last_Insert_Id(). See http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=yyll2...@yahoo.com
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 Angela
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
Thanks first, I checked MySQL 5.1 manual, looks like , 'create tablespace' is ok only with NDB and NDBCLUSTER, NOT INNODB And I did not find 'create tablespace' in MySQL 5.5 manual:( looks like MySQL5.5 does not offer 'create tablespace' anymore. --- On Mon, 1/17/11, Eric Bergen eric.ber...@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 : two questions: 1. can Innodb create per database table space , not per table table space? No. The only available options are creating a global tablespace which can be many files or a file per table. 2. can we store table on specific tablespace like Oracle or DB2 when creating table? You can only choose to store a table in it's own tablespace or in the global one. Many thanks. -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net