Sedang Disiapkan

225464 Urgent MySQL Optimization

MySQL is locking badly leaving my service unavailable.

Your job is to optimize MySQL settings and code so that MySQL will continue to work.

Website is a flash arcade where it seems that the game rating system is causing issues. Database has probaly become too big and checking against too many IPs.

List of current mysql processes for your information.

895 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

995 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

1071 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

1117 miniclip_octo localhost miniclip_miniclip Query 3 Opening tables SELECT `game` FROM `games_categories` WHERE `category`='8' AND `ord` IN (156, 191, 208, 27, 155, 59,

1160 miniclip_octo localhost miniclip_miniclip Query 12 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

1163 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

1171 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

1178 miniclip_octo localhost miniclip_miniclip Query 13 Opening tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

1179 miniclip_octo localhost miniclip_miniclip Query 12 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

1182 miniclip_octo localhost miniclip_miniclip Query 10 Opening tables SELECT `game` FROM `games_categories` WHERE `category`='7' AND `ord` IN (7, 8, 5, 1, 3, 6, 1)

1191 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

1425 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

1452 miniclip_octo localhost miniclip_miniclip Query 2 Opening tables SELECT `game` FROM `games_categories` WHERE `category`='8' AND `ord` IN (116, 143, 172, 118, 220, 21

1673 miniclip_octo localhost miniclip_miniclip Query 12 closing tables SELECT `game` FROM `games_categories` WHERE `category`='8' AND `ord` IN (82, 184, 76, 36, 23, 252, 1

1820 miniclip_octo localhost miniclip_miniclip Query 12 Opening tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

1838 miniclip_octo localhost miniclip_miniclip Query 13 Opening tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2286 miniclip_octo localhost miniclip_miniclip Query 25 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2309 miniclip_octo localhost miniclip_miniclip Query 25 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2342 miniclip_octo localhost miniclip_miniclip Query 16 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2352 miniclip_octo localhost miniclip_miniclip Query 25 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2397 miniclip_octo localhost miniclip_miniclip Query 16 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2421 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2422 miniclip_octo localhost miniclip_miniclip Query 16 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2428 miniclip_octo localhost miniclip_miniclip Query 24 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2430 miniclip_octo localhost miniclip_miniclip Query 15 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2432 miniclip_octo localhost miniclip_miniclip Query 12 Locked SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2433 miniclip_octo localhost miniclip_miniclip Query 12 Sending data SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2435 miniclip_octo localhost miniclip_miniclip Query 12 Opening tables SELECT `game` FROM `games_categories` WHERE `category`='5' AND `ord` IN (33, 106, 8, 19, 67, 38, 31)

2437 miniclip_octo localhost miniclip_miniclip Query 16 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2439 miniclip_octo localhost miniclip_miniclip Query 12 Opening tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2441 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT `game` FROM `games_categories` WHERE `category`='5' AND `ord` IN (60, 62, 72, 81, 25, 73, 88)

2442 miniclip_octo localhost miniclip_miniclip Query 12 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2445 miniclip_octo localhost miniclip_miniclip Query 9 Opening tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2448 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2452 miniclip_octo localhost miniclip_miniclip Query 12 closing tables SELECT `game` FROM `games_categories` WHERE `category`='6' AND `ord` IN (9, 50, 9, 60, 47, 8, 1)

2453 miniclip_octo localhost miniclip_miniclip Query 9 Opening tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2455 miniclip_octo localhost miniclip_miniclip Query 12 Locked SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2456 miniclip_octo localhost miniclip_miniclip Query 12 Opening tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2457 miniclip_octo localhost miniclip_miniclip Query 14 closing tables SELECT `game` FROM `games_categories` WHERE `category`='5' AND `ord` IN (9, 3, 46, 89, 28, 83, 27)

2459 miniclip_octo localhost miniclip_miniclip Query 12 Opening tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2460 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT `game` FROM `games_categories` WHERE `category`='6' AND `ord` IN (35, 23, 34, 12, 56, 21, 17)

2464 miniclip_octo localhost miniclip_miniclip Query 13 Sending data SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2466 miniclip_octo localhost miniclip_miniclip Query 12 Sending data SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2467 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT `game` FROM `games_categories` WHERE `category`='6' AND `ord` IN (24, 39, 3, 42, 30, 1, 35)

2469 miniclip_octo localhost miniclip_miniclip Query 12 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2470 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2471 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2472 miniclip_octo localhost miniclip_miniclip Query 12 Locked SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2475 miniclip_octo localhost miniclip_miniclip Query 12 Sending data SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2476 miniclip_octo localhost miniclip_miniclip Query 13 closing tables SELECT g.*, gr.total_value, gr.total_votes FROM games g LEFT JOIN games_ratings gr ON g.id=[url removed, login to view] WHE

2477 miniclip_octo localhost miniclip_miniclip Query 25 closing tab

Kemahiran: Semua Boleh, PHP

Lihat lebih lanjut: website optimization service, leaving job, urgent mysql, query optimization, ord, optimize mysql, job optimization, database optimization, mysql select locking, 1452, php mysql big data, php localhost, php mysql optimize, mysql flash tables, optimization database, website locking, php rating system mysql, mysql urgent, query optimize, mysql join, php join tables, urgent database, optimize php mysql, game flash mysql, rating system database

Tentang Majikan:
( 15 ulasan ) Helsinki, Finland

ID Projek: #1971701

Dianugerahkan kepada:

brdless

As described in PMB.

$105 USD dalam 2 hari
(69 Ulasan)
5.9