/adei/trunk : contents of docs/mysql.txt at revision 512

: (revision 512)

To get this branch, use:

bzr branch
http://darksoft.org/webbzr/adei/trunk

browse files
view without revision information
view revision
view changes to this file
download file

Known problems
==============
 - MySQL (at least 5.0.45, 5.0.51) has problems with queries dealing with
 huge rowset. After certain threshold (involving around 500,000 rows) the
 optimizator stop using INDEXes.
    * You can check if it is actually happening with 'EXPLAIN <query>' command,
    * To force usage of indexes it is possible to add "FORCE INDEX (PRIMARY)"
    keyword after table name in SELECT query.
    * The $MYSQL_FORCE_INDEXES configuration option is forces usage of indexes 
    when necesary and is intended to fix the described behaviour.


33 by Suren A. Chilingaryan Documentation and configuration updates	1	Known problems
	2	==============
	3	- MySQL (at least 5.0.45, 5.0.51) has problems with queries dealing with
	4	huge rowset. After certain threshold (involving around 500,000 rows) the
	5	optimizator stop using INDEXes.
	6	* You can check if it is actually happening with 'EXPLAIN <query>' command,
	7	* To force usage of indexes it is possible to add "FORCE INDEX (PRIMARY)"
	8	keyword after table name in SELECT query.
	9	* The $MYSQL_FORCE_INDEXES configuration option is forces usage of indexes
	10	when necesary and is intended to fix the described behaviour.
	11