Saturday 18 November 2006 5:50:34 am
Hello! I checked the runtime information of a MySQL instance that hosts databases for eZ publish. The variable "Handler_read_rnd_next" is very high (relative to the number of visits): 3 M The description of phpMyAdmin says: "The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have." So, why does eZ publish cause a lot of table scans? Or, is any index missing? Regards, Martin
http://www.netbeyond.de/
|