Avatar

Performance enhancements? (General)

by Auge ⌂, Friday, December 27, 2013, 03:49 (3770 days ago) @ Wendell

Hello

I assume you do it in the tab "operations"->"optimize table"[1]. And, as an additional assumption, you do it for every table step by step?


In phpMyAdmin, once I select the database, it gives a list of all tables (Structure tab). I use the link under the list to "check all", then use the dropdown to select "optimize table".

Ah, ok.

Results page:
[image]

The five tables with "OK" was optimised at this point.

One question: The column "Overhead" (by the way, this is the correct translation for "Überhang") was empty in every row before you optimised the database tables or differed their value from "0" or "-" in the rows of the above named tables? I would expect a byte size greater than 0. Otherwise I don't know what should be optimised.

So, it's 4:45 am here, time to go to bed.

Tschö, Auge

PS: A giant lag of ca. 15 seconds while generating the postings entry!

--
Trenne niemals Müll, denn er hat nur eine Silbe!


Complete thread:

 RSS Feed of thread