MySQL vs Percona MySQL
- Thread starter ibaker
- Start date
CTXMedia
Well-known member
Perhaps because the tables in XF are predominantly InnoDB.
The Percona site also has some great blog entries with real-world examples of tests and optimisations; which is where I found a few SSD specific .cnf settings that came in handy.
p4guru
Well-known member
Exactly, by default XF has more if not all InnoDB tables (if InnoDB engine is enabled otherwise if InnoDB engine disabled all XF tables default to MyISAM) compared to vB4 which at most out of the box would of have 6x InnoDB tables.Perhaps because the tables in XF are predominantly InnoDB.
The Percona site also has some great blog entries with real-world examples of tests and optimisations; which is where I found a few SSD specific .cnf settings that came in handy.
ibaker
Well-known member
My current server has mySQL on it along with WHM/cPanel. My new server is now built and has by default mySQL and WHM/cPanel also on it. To migrate my sites over to the new server I was going to use the WHM account migration tool.
My question is...if I set the new server up with Percona first can I still migrate the accounts over OR do I have to have mySQL on the new server, migrate across and then install Percona?
My question is...if I set the new server up with Percona first can I still migrate the accounts over OR do I have to have mySQL on the new server, migrate across and then install Percona?
Mike Edge
Well-known member
If the database on the older server is 5.5 then either way is fine, if it is 5.1, I'd personally import it over to 5.1 first and then upgrade everything.
Similar threads
- Question
