tag:blogger.com,1999:blog-14455177.post7212456625841680302..comments2024-03-07T18:57:25.977+01:00Comments on Mikael Ronstrom: Recovery features for ALTER TABLE of partitioned tablesMikael Ronstromhttp://www.blogger.com/profile/07134215866292829917noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-14455177.post-36587422445492103212009-09-29T12:31:52.303+02:002009-09-29T12:31:52.303+02:00I wonder if this DDL log will evolve so that one d...I wonder if this DDL log will evolve so that one day we can have transaction support for DDL commands? That's a feature I would really appreciate.<br /><br />Regards,<br />StefanProgrammer without a bloghttps://www.blogger.com/profile/08976203666753350290noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-58120142844934073252009-01-29T15:49:00.000+01:002009-01-29T15:49:00.000+01:00I'm using a high load mysql server (5.1.30) and I ...I'm using a high load mysql server (5.1.30) and I have to say, I'm not impressed with the error-recovery capabilities of it...<BR/><BR/>I'm doing lots of alter-tables (add/drop partitions), and whenever my server crash (usualy during a power-spike), I'm left with leftover files that don't allow me to continue working.<BR/><BR/>Most of my problems are because of crashes during an alter-table of a memory table (though I did encounter several problems with innodb), where I'm usually left with #sql-table_name files which make the table unaccesable...<BR/><BR/>Whenever that occurs, I usually have to drop my entire database, delete the leftover files manually, and hope it'll work again...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14455177.post-42503084449211299832008-12-22T23:39:00.000+01:002008-12-22T23:39:00.000+01:00Hi Mikael, I have a question, and I want you to he...Hi Mikael, <BR/>I have a question, and I want you to help me solve it, please. I'm starting to work with partition in Mysql. I want to know if there is any way to increase the maximum number of partitions Mysql. In addition I would like to know why this number is so small (1024).<BR/><BR/>Att<BR/>Ricardo GomezAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-14455177.post-28992655798920130052008-12-22T23:38:00.000+01:002008-12-22T23:38:00.000+01:00Hi Mikael,I have a question, and I want you to hel...Hi Mikael,<BR/>I have a question, and I want you to help me solve it, please. I'm starting to work with partition in Mysql. I want to know if there is any way to increase the maximum number of partitions Mysql. In addition I would like to know why this number is so small (1024).<BR/><BR/>Very thanks!!<BR/><BR/>Att<BR/><BR/>Ricardo GomezAnonymousnoreply@blogger.com