Portal Home > Knowledgebase > Articles Database > Data in mysql get changed weirdly.
Posted by heropage, 03-17-2008, 12:21 PM My table "video" keep update and insert quite often.(viewed_time will update when user view a video) And today, all the viewed_time have been changed, it decreased a lot.(for example, it's supposed to 10000,now it's only 100) And I can see it says overhead in phpMyAdmin. Also I just notice the type of the table is innodb whereas others are myisam. That's scary! Since the viewed_time is not so important, if it's some critical data, that's disaster!
Posted by heropage, 03-17-2008, 04:02 PM But after I optimized the table(because I see the overhead). It happened again. Not sure it's something to do with innodb or not
Add to Favourites Print this Article