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.

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

The parameter to “setLineWidthScaleFactor (lw) “function specifies?

Which of the following is a set function ?

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

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:

Which of the following component is not installed by SQL Server setup 2012 required by the product ?

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 o...

Two finite sets have m and n elements. The total number of subsets of the first set is 56 more than the total number of subse...

Featured Courses

Popular Pages

SAT (Scholastic Assessment Test)

Reasoning special by Parwez Alam

NET

Study24x7

Defence

Henry Harvin

UPSC & State PSC

CBSE Study Materials

SSC Preparation Strategies & Study Mater...

Banking/IRDA

Get the App

Importance of Outdoor Games in a kid's life

MySQL Database

What is Blockchain in Simple Words?

Kendriya Vidyalaya Sangathan (KVS) Exam Preparation Guide

P2P Crypto Exchange Script - Build your trading platform wit...

10 Advantages of Online Classes

Centralized Crypto Exchange Development: Building a Secure T...

The Role of Binance Clone Script in Revolutionizing the Cryp...

Supercharge Your crypto exchange with an Binance Clone Scrip...

How to Build a Crypto Exchange Business Like Coinbase Using ...