O
O
Optimus2015-10-19 13:27:02
PHP
Optimus, 2015-10-19 13:27:02

Is phpmyadmin slow with InnoDB?

In phpmyadmin I click the table overview (1 million records) then I click the ">>" icon to go to the last record, it thinks for more than a minute if the InnoDB table and at the end goes, with myisam the transition on the same button is instant.
What's the problem, are my settings wrong?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
Ihor Gevorkyan, 2015-10-19
Pyan @marrk2

InnoDB is designed for relational relationships between tables (primary / foreign keys), works much slower than MyISAM for this very reason. Certainly noticeable with so much data.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question