On 22 October 2013 12:47, imacat <ima...@mail.imacat.idv.tw> wrote: > On 2013/10/22 16:10, imacat said: > > On 2013/10/22 15:42, janI said: > >> On 22 October 2013 03:02, imacat <ima...@mail.imacat.idv.tw> wrote: > >>> On 2013/10/22 02:37, janI said: > >>>> On 21 October 2013 18:39, Tony Stevenson <pct...@apache.org> wrote: > >>>>> Andrea Pescetti wrote on Mon, Oct 21, 2013 at 06:27:50PM +0200: > >>>>>> Tony Stevenson wrote: > >>>>>>> Andrea Pescetti wrote on Mon, Oct 21, 2013 at 04:52:14PM +0200: > >>>> Imacat (admin) has responded to my question if help is wanted, answer > was > >>>> that it would be be fine if infra does it (like me) and offered to > help. > >>>> > >>>> If we think along these lines, my plan would be the following: > >>> > >>> You can ignore me if my help is not needed. But, still, > >> > >> I would never ignore a helping hand, and especially not a qualifed one > as > >> yours. > > > > Ah... That is totally unnecessary. ^^; > > > >>>> 1) Thursday evening (16-22 UTC), I wil combine the single forum > databases > >>>> into the EN database. This will mean short breaks on the single forum, > >>>> about 10min each (to copy the tables). > >>>> If time permits, I will convert the FULLTEXT back to MyIsam. > >>> That's 0-6 UTC+8 here. I have works on Friday. I can stay up to > at > >>> most 19 UTC (3 UTC+8), but not after that. > >> > >> ok, lets do this in another way, please select 2 forums (that have the > >> lowest usage) from the db list below: > >> > >> | en | > >> | es | > >> | fr | > >> | hu | > >> | it | > >> | ja | > >> | nl | > >> | pl | > >> | vi | > >> | zh | > >> +--------------------+ > >> > >> Then I will move tables in these 2 and convert the FULLTEXT tables, as > soon > >> as I hear from you, and then you can test. Please give me a UTC time, > where > >> you can test (today/tomorrow), then I do the changes just before that > time. > > > > Ah... it's embarrassing that, I will travel to another city later to > > deliver an OpenOffice macro class for two days, and will return before > > Thursday evening (16-22 UTC). ^^; That's the earliest time I'm > > available this week. > > > > And, currently, VI has the lowest traffic. But we have to notify > > Phan first. > > But I suppose this is the time "back up" or "cover" is for. :p You > may ask RGB or Phan for help on this. >
thx, I have already asked Phan, with ref. to RGB as well. I am btw making a test forum, http://forum.openoffice.org/test/forum so I can test the table changes without disturbing anyone. I have copied the EN db for that purpose. rgds jan I. > >> If it works with these 2 forums, I feel more secure with the rest, and > >> maybe Ricardo can do a check on them since he is in the same TZ. > >> > >> > >> > >>> And what do you mean by "combining short forum databases into the > EN > >>> databases"? So we will only have EN database in the future? > >>> > >> > >> Yes, and it will problaly be called "forumsaoodb". > >> > >> Remark, this is not a problem because all tables (in use) have the > naming > >> standard: > >> phpbb_<forum>_<table> > >> > >> if you look e.g. in IT, you will see > >> | phpbb_it_sessions_keys | > >> | phpbb_it_sitelist | > >> | phpbb_it_smilies | > >> > >> > >> There are 2 databases I dont understand at the moment: > >> > >> | ps_helper | > >> | test | > >> > >> any ideas ? > > > > The "ps_helper" database: > > > > https://www.google.com.tw/#q=ps_helper+mysql > > > > The "test" database can be safely ignored. It's a standard MySQL > > database for testing purpose. When installing Perl DBD::mysql library, > > we need a database to test if DBD::mysql is working. There should > > always a database named "test" (although some DB admins prefer to remove > > it), but you do not need to bother with its contents. > > > >> > >> > >>> > >>>> 2) Friday morning (8-11 UTC) I will convert tables. This happens > online, > >>>> and only means slow system while I do it. > >>> > >>> That is 16-19 UTC+8. Normally I would be stuck in the traffic > going > >>> home at this time on Fridays, but I could stay in the office if > necessary. > >>> > >> > >> see above. > >> > >> > >>>> 3) Friday afternoon (15 UTC, depending on pctony), we can take the > forums > >>>> down for approx 2hours to move the databases. > >>> > >>> That would be perfect for me. > >>> > >> it would for me too, but pctony has to go to hospital with his kid, so > we > >> try to see if we can do it thursday (24/10). > >> > >> I would really apriciate your help with the first 2 forums, to make a > more > >> thorough test. And then hope that ricardo could do a smoke test on the > >> others. > >> > >> This is of course a service that infra provides so if you want it > >> postponed, we will have to find a way. > >> > >> > >>> > >>> And also, please add the date (10/24, 10/25). It's confusing to > >>> guess if Friday is 10/25 or 11/1. (And normally I would bet on 11/1 as > >>> 10/25 is very close.) > >>> > >> > >> Sorry about that, good idea. > >> > >> rgds > >> jan I. > >> > >>> > >>>> > >>>> In order to finalize the database changes Thursday and move friday, we > >>> need > >>>> someone with access to all forums to help with the test. > >>>> > >>>> Could this be an acceptable plan ? The time is needed, but if > preferred > >>> I > >>>> can do it friday or saturday evening instead (depending on pctony). > >>>> > >>>> rgds > >>>> jan I. > >>>> > >>>> > >>>> > >>>> > >>>> > >>>>> This is now impacting other services and needs to be resolved ASAP, > >>> please. > >>>>> > >>>>> FWIW the total downtime was 11 minutes. Which is pretty fast > >>>>> considering all the changes that had to be incorporated. > >>>>> > >>>>> > >>>>>> > >>>>>> Regards, > >>>>>> Andrea. > >>>>> > >>>>> -- > >>>>> Cheers, > >>>>> Tony > >>>>> > >>>>> ---------------------------------- > >>>>> Tony Stevenson > >>>>> > >>>>> t...@pc-tony.com > >>>>> pct...@apache.org > >>>>> > >>>>> http://www.pc-tony.com > >>>>> > >>>>> GPG - 1024D/51047D66 > >>>>> ---------------------------------- > >>>>> > >>>>> > >>>>> > >>>>> --------------------------------------------------------------------- > >>>>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org > >>>>> For additional commands, e-mail: dev-h...@openoffice.apache.org > >>>>> > >>>>> > >>>> > >>> > >>> > >>> -- > >>> Best regards, > >>> imacat ^_*' <ima...@mail.imacat.idv.tw> > >>> PGP Key http://www.imacat.idv.tw/me/pgpkey.asc > >>> > >>> <<Woman's Voice>> News: http://www.wov.idv.tw/ > >>> Tavern IMACAT's http://www.imacat.idv.tw/ > >>> Woman in FOSS in Taiwan http://wofoss.blogspot.com/ > >>> OpenOffice http://www.openoffice.org/ > >>> EducOO/OOo4Kids Taiwan http://www.educoo.tw/ > >>> Greenfoot Taiwan http://greenfoot.westart.tw/ > >>> > >>> > >> > > > > > > > -- > Best regards, > imacat ^_*' <ima...@mail.imacat.idv.tw> > PGP Key http://www.imacat.idv.tw/me/pgpkey.asc > > <<Woman's Voice>> News: http://www.wov.idv.tw/ > Tavern IMACAT's http://www.imacat.idv.tw/ > Woman in FOSS in Taiwan http://wofoss.blogspot.com/ > OpenOffice http://www.openoffice.org/ > EducOO/OOo4Kids Taiwan http://www.educoo.tw/ > Greenfoot Taiwan http://greenfoot.westart.tw/ > >