• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.2 InnoDB : username change after switch from MyISAM to InnoDB takes ages

allewreK

Active member
#1
Hello,

Yeterday I changed all my tables to InnoDB because they were MyISAM for more than 2 years because of an import from vbulletin.

The problem is that, since I made the change, it takes like 3 minutes to change an username. It's strange, since changing the user's email on the same account is fine.

Any ideas ? I have a quite big database.

Regards.
 

HWS

Well-known member
#2
Looks like you just switched the table engines without any optimizing for InnoDB. Your MySQL server has to be configured for InnoDB if you only used Myisam before.

In addition some settings have to be applied before switching the engines because it is not possible to change them at a running InnoDB server.
 

allewreK

Active member
#4
Username changes have to search and update quite a bit of tables where email updates need to update one field in one table.
Ok I understand what it's longer.

Looks like you just switched the table engines without any optimizing for InnoDB. Your MySQL server has to be configured for InnoDB if you only used Myisam before.

In addition some settings have to be applied before switching the engines because it is not possible to change them at a running InnoDB server.
Brogan suggested me that I could do it on a live server without known problems. What would you suggest me to do now that it has been done ? Because except for that problem, my board is really fast, a specially on message and conversations insert !
 

HWS

Well-known member
#5
Brogan suggested me that I could do it on a live server without known problems. What would you suggest me to do now that it has been done ? Because except for that problem, my board is really fast, a specially on message and conversations insert !
I suggest that you take a look at your my.cnf and optimize the InnoDB settings according to your needs and your server hardware.

A simple user name change should not take 3 minutes!
 

digitalpoint

Well-known member
#6
With everything else being equal (a tuned setup for MyISAM tables and a tuned setup for InnoDB tables), it's probably always going to be a little slower for InnoDB because it has the overhead of managing record locks. But yeah... it shouldn't take minutes.