Can any one please help me how to solve performance issue in mysql database.
Problem is from java/hibernet i will read a file which contains 10Lakhs records. with hibernet select query i am checking whether data already exist or not.
From java application logs i can see the select queries are executed very fast till 2 Lakhs records, after that it is pausing for some time and then executing few select statements.if same database is connected by multiple clients it is becoming much slow.Below is my sql file my.cnf configuration ,Please let me know which parameter should add or change values for solving my performance issue.
my.cnf file contains the following information.
innodb_buffer_pool_size = 2G
init_connect=SET collation_connection = utf8_general_ci; SET NAMES utf8;
set-variable = max_allowed_packet=32M
please give me a reply where to change parameters to solve performance issue.
Are you sure you have the correct indexes on the tables so that accessing the individual records is done efficiently? I would look more closely at your queries rather than the database server settings first. If you are convinced that your queries are efficient and using indexes then look at the settings above.