-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Marc Delisle schrieb:
Using the page selector directly still logs me out!
On the "big" server, nothing appears, mysqld is eating 98% of CPU.
What is "big"?
4400 databases.
Nothing appears? White page?
Browser still active, no white page, still seeing the previous page.
But is it now more worse than before on this Server?
yep.
ok, i disabled table stats by default, how now?
It works now on the big server, stats generation was really hitting hard the server! I believe that on a previous version, stats were disabled by default, it's better this way.
but it was a really simple LEFT JOIN ... but MySQL seems not to handle the information_schema like other tables ... MySQL seems not to store db and table statistics somewhere, it seems it is collected every time it is requested - this hits the server hard!
- -- Sebastian Mendel
www.sebastianmendel.de