improve performance of mysql database and query

₹100 INR / hour

Closed

Posted

almost 5 years ago

₹100 INR / hour

I need to improve MySQL performance. when I run this query it takes a long time. so I need to improve MySQL performance. table raw is 6,39,074. we have change this value to improve performance of mysql database. innodb_buffer_pool_size 134217728 key_buffer_size 16777216 max_connections 151 query_cache_size 16777216 this value is the system by default value so can anyone guide us how many value increase in this variable. we have 4bg ram ubuntu 16.04 server.

MySQL

Linux

Database Administration

PHP

System Admin

Project ID: 20230040

About the project

10 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

10 freelancers are bidding on average ₹492 INR/hour for this job

@coolguyinus2004

table raw is 6,39,074. The query speed you cant incease by just changing the other Mysql values you put here. You need to optimize table and do PHP work for this. Let me know from you if you have enough budget so i can review more on this.

₹3,000 INR in 40 days

4.9

(355 reviews)

7.7

@vili1977

Hello. I would like to help you with mysql optimization issue. I have expeience. Please read my feedbaks. Thank you.

₹1,000 INR in 1 day

4.9

(892 reviews)

7.5

@shanmup

Fine tuning mysql performance is not only the server setup and it is also depends on the query you are using so give me the query as well as the mysql server credentails to fix quickly. Come on chat quick fix. Thanks

₹100 INR in 40 days

5.0

(14 reviews)

4.6

@janmatyoo

Hi, I want to take this job because I have more than 3 years of experience in mysql databases. I want to know more about the details of this job. Thank you!

₹100 INR in 40 days

0.0

(0 reviews)

0.0

@alexisreyes88

Hello regards, if you allow me to help you, I believe that your problem can be solved in a very short time, I have more than 4 years of experience in administration and optimization of mysql databases. I need to see the complete configuration of the server as well as the query and the structure of the tables involved to review it better.

₹200 INR in 40 days

0.0

(0 reviews)

0.0

@ricardoab

Send me more details of your database & tables, so I give you a real answer about your problem. Thanks Ricardo

₹100 INR in 16 days

0.0

(0 reviews)

0.0

@Syed1119

Will help you optimise the sql for high performance and will automate this process

₹111 INR in 5 days

0.0

(0 reviews)

0.0

@kapillanghani8

Over 5 years’ experience in Information Technology and consulting including Database Administrator , System analysis, Security, development, and implementation in Oracle , Oracle e-Business Suite, SQL SERVER and MySQL Databases. Experience using Oracle E-Business Suite R12, 11i and Oracle Database 10g, 11g and 12c environment, I will always available on Remote base for Every Activity.

₹100 INR in 40 days