Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku
My account: Login | Sign Up
Loading... 

Waiting for MySQL to archive a ~11GB InnoDB table of sales logs. Can't... | Thread profile

Thread profile page for " Waiting for MySQL to archive a ~11GB InnoDB table of sales logs. Can't do it 'live' as MySQL table-locks for tables it is only reading! grr 10:45 AM August 23, 2008 from web cenji Cenji Neutra " on http://twitter.com/cenji. This report page is a snippet summary view from a single thread " Waiting for MySQL to archive a ~11GB InnoDB table of sales logs. Can't do it 'live' as MySQL table-locks for tables it is only reading! grr 10:45 AM August 23, 2008 from web cenji Cenji Neutra ", located on the Message Board at http://twitter.com/cenji. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity, which are reported in a table below. Additional thread profile information is also shown in the following ways:

1) Top Contributing Authors
2) Related Threads on "eBay Auctions"
3) Related Threads on Other Sites

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a thread's popularity and/or exact posting volumes at any given reporting period.
Title: Waiting for MySQL to archive a ~11GB InnoDB table of sales logs. Can't...
Site: Twitter / cenji  Twitter / cenji - site profile
Forum: Cenji Neutra   Cenji Neutra - forum profile
Total authors: 2 authors
Total thread posts: 2 posts
Thread activity: no new posts during last week
Domain info for: twitter.com

Thread posts in Waiting for MySQL to archive a ~11GB InnoDB table of sales logs. Can't do it 'live' as MySQL table-locks for tables it is only reading! grr 10:45 AM August 23, 2008 from web cenji Cenji Neutra :

  

Top contributing authors for Waiting for MySQL to archive a ~11GB InnoDB table of sales logs. Can't do it 'live' as MySQL table-locks for tables it is only reading! grr 10:45 AM August 23, 2008 from web cenji Cenji Neutra

Name
Posts
cenji
1
user's latest post:
Waiting for MySQL to archive a...
Published (2008-08-23 10:45:00)
apollocase
1
user's latest post:
@ cenji Melbourne has developed...
Published (2008-08-23 19:46:00)

Waiting for MySQL to archive a ~11GB InnoDB table of...  Twitter / cenji - site profile cenji - forum profile Waiting for MySQL to archive a ~11GB InnoDB table of sales logs. Can't do it 'live' as MySQL table-locks for tables it is only reading! grr 10:45 AM Aug 23rd, 2008 from web
Waiting for MySQL to archive a ~11GB InnoDB table of sales logs. Can't do it 'live' as MySQL table-locks for tables it is only reading! grr 10:45 AM Aug 23rd, 2008 from web
Adding 'Cenji Neutra' to my friend list 6:19 AM Feb...  Twitter / Pauly_Richez - site profile Pauly Richez - forum profile Adding 'Cenji Neutra' to my friend list 6:19 AM Feb 23rd from metaLIFE
Adding 'Cenji Neutra' to my friend list 6:19 AM Feb 23rd from metaLIFE
Revista Neutra 16: “Ciudad ¡Fiesta!” /Plataforma...  Twitter / Inipopstar - site profile Ingrid Krauss - forum profile Revista Neutra 16: “Ciudad ¡Fiesta!” /Plataforma Arquitectura/ - Hemos recibido Neutra, revista del ... http://tinyurl.com/6nc3z3 4:08 AM Sep 8th from web
Revista Neutra 16: “Ciudad ¡Fiesta!” /Plataforma Arquitectura/ - Hemos recibido Neutra, revista del ... http://tinyurl.com/6nc3z3 4:08 AM Sep 8th from web
Every day the Neutra office stays on the market is...  Twitter / lemonodor - site profile john wiseman - forum profile Every day the Neutra office stays on the market is another day my dream stays alive. http://www.neutra.org/sale.... 12:12 PM June 10, 2008 from web
Every day the Neutra office stays on the market is another day my dream stays alive. http://www.neutra.org/sale.... 12:12 PM June 10, 2008 from web
Among other things, this means Oracle will now own MySQL....  Twitter / looselycoupled - site profile Allen - forum profile Among other things, this means Oracle will now own MySQL. MySQL already licenses Oracle's innoDB storage engine. #mysql #oracle #innoDB 11:12 AM Apr 20th from web
Among other things, this means Oracle will now own MySQL. MySQL already licenses Oracle's innoDB storage engine. #mysql #oracle #innoDB 11:12 AM Apr 20th from web
Sip, problema del InnoDB, cambie ENGINE=InnoDB por...  Twitter / CaDs - site profile Carlos Donderis - forum profile Sip, problema del InnoDB, cambie ENGINE=InnoDB por TYPE=MyISAM en todas las tablas y ahora funciona. Toca leer documentacion... 04:34 PM August 08, 2008 from twhirl
Sip, problema del InnoDB, cambie ENGINE=InnoDB por TYPE=MyISAM en todas las tablas y ahora funciona. Toca leer documentacion... 04:34 PM August 08, 2008 from twhirl
Rm ib_logfile* before starting mysqld if you're chaning...  Twitter / alexforrow - site profile Alex Forrow - forum profile Rm ib_logfile* before starting mysqld if you're chaning innodb_log_file_size in my.cnf. Otherwise its a simple way to break InnoDB. 1:33 AM Jun 26th from digsby
Rm ib_logfile* before starting mysqld if you're chaning innodb_log_file_size in my.cnf. Otherwise its a simple way to break InnoDB. 1:33 AM Jun 26th from digsby
InnoDBに200万件くらいinsertする操作してたら...  Twitter / penguinana - site profile penguinana - forum profile InnoDBに200万件くらいinsertする操作してたら遅かったのでkillったらstateがendのままディスクIO使いまくってる。InnoDBよく分からん。。innoDBはkillしたらいかん。MySQL再起動してる。 ... 10:56 AM Dec 9th from web
InnoDBに200万件くらいinsertする操作してたら遅かったのでkillったらstateがendのままディスクIO使いまくってる。InnoDBよく分からん。。innoDBはkillしたらいかん。MySQL再起動してる。 ... 10:56 AM Dec 9th from web
InnoDBはクエリをkillしてmysqlを落とすと死滅...  Twitter / penguinana - site profile penguinana - forum profile InnoDBはクエリをkillしてmysqlを落とすと死滅したことになる。リカバリオプションでMySQLを再起動すればよいが、幸運なケースで最悪の場合ダンプ→dropしろといわれる。dropは受け付けるけれどもinnoDBは正常にならずどうしていいか分かりませんでした。スヤスヤ ... 1:38 PM Dec 9th from web
InnoDBはクエリをkillしてmysqlを落とすと死滅したことになる。リカバリオプションでMySQLを再起動すればよいが、幸運なケースで最悪の場合ダンプ→dropしろといわれる。dropは受け付けるけれどもinnoDBは正常にならずどうしていいか分かりませんでした。スヤスヤ ... 1:38 PM Dec 9th from web
InnoDBは死滅したままで、リカバリオプショ...  Twitter / penguinana - site profile penguinana - forum profile InnoDBは死滅したままで、リカバリオプションつけないとMySQL起動してくれないし、つけるとInnoDBストレージエンジンはinsertとupdate受け付けなくなるので、どうしても必要なテーブルをMyISAMに移して復帰したことにした。InnoDB勉強する必要がある。 ... 1:34 PM Dec 9th from web
InnoDBは死滅したままで、リカバリオプションつけないとMySQL起動してくれないし、つけるとInnoDBストレージエンジンはinsertとupdate受け付けなくなるので、どうしても必要なテーブルをMyISAMに移して復帰したことにした。InnoDB勉強する必要がある。 ... 1:34 PM Dec 9th from web
./mysqld --no-defaults --skip-innodb --verbose...  Twitter / stewartsmith - site profile stewartsmith - forum profile ./mysqld --no-defaults --skip-innodb --verbose --help|grep '^innodb ' # this does not work 12:17 AM Jun 25th from Laconica
./mysqld --no-defaults --skip-innodb --verbose --help|grep '^innodb ' # this does not work 12:17 AM Jun 25th from Laconica