Topics Tagged with innodb

I am posting it here because I would really like to read other opinions. I am creating a module for a framework that anyone could install in its system and behave the similar (almost) way. I am starting with that because it is important that I don't control system settings nor could advise anyone for using the module to alter their my.cnf or my.ini . Recently I have start suspecting that something is terribly wrong about InnoDB. I made the fallowing test in 3 servers (I don't go further analyzing servers because the results where almost the same and the …

Hello, I'm having a problem with my MySQL InnoDB table, only one of five. Every now and then a row or two will go missing completely with no trace of it being there in the first place. I have a website which takes HTTP requests from my desktop side client app and if their HWID isn't in the database, it adds it. The app connects every 1-5 minutes and works flawlessy (if I delete their row while it's running, it re-adds it. If I delete the row, then run the app, it re-adds it again). But for some reason, once …

I have two databases, tvguide and episodes1. Both are InnoDB, and I use Phpmyadmin to edit them. I tried creating a foreign key between the "episode" field of episodes1 and tvguide, and this error message came up: Error creating foreign key (check data types) : episode How can I fix this and ensure both tables join? I have InnoDB set for both databases, so this shouldn't happen, but why? Here are the table definitions: episodes1 table: [url]www.pastebin.com/54Cc5TNg[/url] episodedata1 table: [url]www.pastebin.com/AxWeHnkn[/url] Otherwise, I have few issues with my PHP script, the pagination works fine, although some issues with that one [but …

As you probably have heard, Oracle bought Sun for $7.4 billion today. I'm no Larry Ellison fan, because frankly, I think he's a few cards short of a full deck but I think in the long run, this is good for Sun. Not all of Sun but a lot of it. And Linux will get a boost out of it as the operating system of choice. My Sun Predictions/Hopes: [B]1. MySQL and InnoDB Reunite[/B] - Ah, it's good to have these two back together again. Oracle bought InnoDB in 2005--much to my surprise and disappointment--but now with Oracle's purchase of …