In Progress

Fix poorly written MySql queries

We have a site where the index page loads very slowly due to poorly written queries - here is an overview of its issues. Need someone who can write queries with joins and understands what an index is etc. Here are the issues and suggested corrections:

Too many sorts are causing temporary tables. Consider increasing sort_buffer_size and/or read_rnd_buffer_size, depending on your system memory limits.

There are lots of rows being sorted. While there is nothing wrong with a high amount of row sorting, you might want to make sure that the queries which require a lot of sorting use indexed columns in the ORDER BY clause, as this will result in much faster sorting.

There are too many joins without indexes. This means that joins are doing full table scans. Adding indexes for the columns being used in the join conditions will greatly speed up table joins.

The rate of reading the first index entry is high. This usually indicates frequent full index scans. Full index scans are faster than table scans but require lots of CPU cycles in big tables, if those tables that have or had high volumes of UPDATEs and DELETEs, running 'OPTIMIZE TABLE' might reduce the amount of and/or speed up full index scans. Other than that full index scans can only be reduced by rewriting queries.

The rate of reading data from a fixed position is high. This indicates that many queries need to sort results and/or do a full table scan, including join queries that do not use indexes. Add indexes where applicable.

The rate of reading the next table row is high. This indicates that many queries are doing full table scans. Add indexes where applicable.

Many temporary tables are being written to disk instead of being kept in memory. Increasing max_heap_table_size and tmp_table_size might help. However some temporary tables are always being written to disk, independent of the value of these variables. To eliminate these you will have to rewrite your queries to avoid those conditions (Within a temporary table: Presence of a BLOB or TEXT column or presence of a column bigger than 512 bytes) as mentioned in the beginning of an Article by the Pythian Group

MyISAM key buffer (index cache) % used is low. You may need to decrease the size of key_buffer_size, re-examine your tables to see if indexes have been removed, or examine queries and expectations about what indexes are being used.

Skills: Database Administration, Database Programming, MySQL, PHP, SQL

See more: how to make mysql query faster, mysql long running queries, mysql query optimization tool, mysql query optimization tips and tricks, slow query table mysql, mysql query slow, query optimization in mysql with example, fix mysql query, building xml files mysql queries, optimize mysql queries, oscommerce mysql queries pproducts_model, complex php mysql queries, fix corrupt database mysql, optimize mysql queries script, php mysql queries css instead tabs, send mysql queries perl, fix databse error mysql, oscommerce mysql queries, cacti mysql queries, mysql queries locked state

About the Employer:
( 347 reviews ) Lumberton, United States

Project ID: #17894170

Awarded to:

shiningdevelopor

⭐⭐⭐⭐⭐⭐⭐ I can finish your project perfectly in a short time. ⭐⭐⭐⭐⭐⭐⭐ I ready your detail extremely carefully. I have a good skill many experiences in php and mysql. If you hire me, you will get the only perfect res More

$150 USD in 3 days
(49 Reviews)
6.0

18 freelancers are bidding on average $252 for this job

$1111 USD in 10 days
(87 Reviews)
7.8
sat12

Hi, i will fix mysql queries. I am Joomla,PHP programmer having 5 years of experience. I am very good in wordpress,php,mysql,joomla. I have done highest projects here in Joomla. You can see my joomla profile here More

$377 USD in 3 days
(367 Reviews)
6.9
Europa17

HI there Nice to meet you. Just checked out your job description carefully. I am good at Mysql and database management so I can help you with your project. Please send me a message so we can discuss further. Looki More

$155 USD in 3 days
(38 Reviews)
6.2
polarjin2017

Hello? How are you? I have read your brief description. I have good skills in database file....... So I think we can work together. Hope to work with you. Thank you.

$133 USD in 3 days
(66 Reviews)
6.3
angel915

I have 10 +years experience in Web development and app development. I will complete your task on time. Feel free to ask me any questions. Thanks..

$244 USD in 7 days
(20 Reviews)
5.0
veskojl

Hi, I'm a DB expert from Bulgaria(EU) with strong experience in wide variety of RDBMS: MySQL, PostgreSQL, MS SQL Server, Oracle, Teradata and a few others.. I have a solid knowledge in writing and tuning complex More

$500 USD in 7 days
(2 Reviews)
3.9
jacobian64

hi there, I can fix your sql and you can check out my portfolio here to know me more. [login to view URL]

$155 USD in 3 days
(5 Reviews)
3.8
Grisha97924

HI Dear. I am an expert in MySQL so can fix your issues. I am confident to your project. I can start work now. I will do best work for your project. Thank you. Regards.

$200 USD in 3 days
(16 Reviews)
4.1
$100 USD in 4 days
(2 Reviews)
3.6
gulshan645

Hello ! Greetings ! I am PHP and mySQL expert with around 10 years of professional experience in web dvelopemnt. I have used mySQL in many websites. Let me know if you have some time to discuss the details further. More

$250 USD in 3 days
(7 Reviews)
3.9
Jincowboy9174

[login to view URL] Web Development for Business Growing? My experiences range from building responsive software design that work well cross-browser to Business Goal. I am glad to discuss with you for providing full solution to More

$155 USD in 3 days
(4 Reviews)
1.8
MetroFreelance

Hi there I have extensive experience implementing indexes and other query optimisations to speed up queries. If, as your post suggests, there are unindexed joins happening then adding these indexes will make an enorm More

$99 USD in 7 days
(1 Review)
0.3
prologicsoft

Greetings from Prologic Web Services! After looking at the project description I feel we can do this project for you with complete ease and within the allotted time frame as well as the budget. Past Projects More

$155 USD in 3 days
(0 Reviews)
0.0
V2IDEAS

I am able to write queries with joins and understand what an index is etc. and will fix issues of your current MySql queries with accuracy. I have immense experience with MySQL. Some of my work on MySQL queries for More

$150 USD in 3 days
(0 Reviews)
0.0
bradowen

I will start by adding indexes to your tables, and would need to see your sql queries to see if we can get rid of the temporary tables. It appears you are trying to speed up the processes, and just adding the indexes More

$250 USD in 3 days
(0 Reviews)
0.0
Wahab2028375

We are expert in our [login to view URL] trust on Us.

$155 USD in 3 days
(0 Reviews)
0.0
nathsonali

I am good at query writing and optimisation. Still from every project was successful. I have reduce query time from 4 hours to 30 min . I am good indexing, triggers, stored procedure writing

$188 USD in 5 days
(0 Reviews)
0.0