Set table_cache parameter to match the number of open tables and concurrent connections. Watch the open_tables value and if it is growing quickly you need to increase the size of “table_cache”. And for the parameter “open_file_limit” set this limit as 20 max_connections table_cache*2. If you have complex queries “sort_buffer_size” and “tmp_table_size” are likely to be very important. Values will depend on the query complexity and available resources, but 4Mb and 32Mb, respectively are recommended starting points.

Question

trilok sharma · Accepted Answer

Set table_cache parameter to match the number of open tables and concurrent connections. Watch the open_tables value and if it is growing quickly you need to increase the size of “table_cache”. And for the parameter “open_file_limit” set this limit as 20 max_connections table_cache*2. If you have complex queries “sort_buffer_size” and “tmp_table_size” are likely to be very important. Values will depend on the query complexity and available resources, but 4Mb and 32Mb, respectively are recommended starting points.

[Which of the following is a set function ?]

[To set the line-width attribute the following command is used.]

[Are the below statements true about skiplists?In a sorted set of elements skip lists can implement the below operationsi.giv...

[ In an application program, to set line-type attributes the following statement is used.]

[The property (or set of properties) that uniquely defines each row in a table is called the:]

[he process of digitizing a given picture definition into a set of pixel-intensity for storage in the frame buffer is called]

[ __________ is a database object that defines how the rows of a table or index are mapped to a set of partitions based ...

[Sarkaria Commission had been set up to look into]

[ISRO has plans to set up India's own space station by ________.]

[Who has coined the terms status, status set, status sequence? ]

Featured Courses

Popular Pages

SAT (Scholastic Assessment Test)

NET

Reasoning special by Parwez Alam

Defence

Study24x7

UPSC & State PSC

Henry Harvin

CBSE Study Materials

SSC Preparation Strategies & Study Mater...

Banking/IRDA

Get the App

[MySQL Database]

[Kendriya Vidyalaya Sangathan (KVS) Exam Preparation Guide]

[Some useful tips for UPSC preparation]

[How to become a Data Scientist]

[Daily NEWS Analysis | The Hindu Analysis 27th January | UPS...

[Blockchain Game Development Company - A guide for your gami...

[8 Tips To Clear SSB Interview]

[The Constitution of India]

[UPSC Exam Mock Tests and Books]

[How Much Does It Cost to Develop a P2P Payment App Like Ven...