For the past week I’ve known what I had to do and that is to get InnoDB working on my MySQL server.
The row locks vs table locks were the big selling point as the table locks were making it so that I could only process 4 messages at once.
The difference in disk space is a concern of mine, but the supposed performance increases is currently outweighing that.
I say supposed performance increases because I have been converting one table for nearly three hours. I have no idea how far along the process is and at this point I am assuming that it is working at all. I can see the time stamps changing on the table space, but that is my only clue.
All of my other tables converted quickly, but this i the one huge table that I have. And of course the one that needs the innodb row locking the most. It is also the only table that didn’t have a good primary key.
I know this is what I need to do to perform the way I am the system to, but I just wish I had some kind of sign that it was still working …. something … anything ….