MySQL Runtime Information: Handler_read_rnd_next very high

Next topic

Author	Message
Martin Burger	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/
André R.	Sunday 19 November 2006 4:22:29 am This depends on what eZ Publish version you are running. There where some added indexes in the 3.8 and 3.8.4 versions eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom
Martin Burger	Sunday 19 November 2006 7:33:43 am We are bound to 3.6.11 because we use Debian stable which provides only PHP 4.3.10 as package. Which indexes were added? Can I add them manually for version 3.6.11? http://www.netbeyond.de/
André R.	Monday 20 November 2006 12:52:13 am The indexes that where not 3.8 specific went into 3.6.9: http://pubsvn.ez.no/nextgen/stable/3.6/update/database/mysql/3.6/dbupdate-3.6.8-to-3.6.9.sql I guess you have added these indexes, so could you make a issue on this ? http://issues.ez.no eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom