View Single Post
Re: Server DOWNTIME 9./10th August
Old
  (#3)
Onno Kreuzinger
aka: memed / Server Admin
 
Onno Kreuzinger's Avatar
 
Status: Offline
Posts: 705
Join Date: Jan 2004
Location: germany
Default Re: Server DOWNTIME 9./10th August - 10-08-2007

Hi,

after having slept and done some other non pc stuff, I was able to reinitialise innodb as descibed above:
delete (move) old innodb files, restart mysql (only difference: this time I started in on the console), stop mysql, restart whole server: done
Now we can convert back any required db to innodb format. According to the error logs only minor db updates for session and cache handling did got lost (none at BU sites).

Phew, desaster prevented, hours lost, never again I swear, I will touch a DB engine I dont know in depth :-)
And Mysql/MyISAM has its right for existence, the server became 35% faster after droping and disabling innodb. (it still is, the engine innodb is not yet used, 10MB db file so far), and ist restarts in seconds.


Cheers Onno


sunny morning view from my balcony:

see our WIKI!
see our filebase!
  
Reply With Quote