Faıldardy osynda aparyńyz

SQL júktep salý ( 0 ) x -

Saýaldy oryndaý úshin Ctrl+Enter basyńyz Saýaldy oryndaý úshin «Enter» basyńyz
ósýmen
kemýmen
Reti:
SQL kúıin keltirý
Sany
Oryndaý reti
Alǵan ýaqyt
Reti boıynsha:
Saýaldardy toptastyrý
Saýaldardy toptastyrylmaý
Jıý Jaıý Qadaǵalaýdy kórsetý Qadaǵalaýdy jasyrý Count: Alynǵan ýaqyt:
Opsıalar
Restore default values
Jıý Jaıý Jańǵyrtý Óńdeý Explain áreketi Profaıldaý Saýal sátsiz aıaqtaldy Derekqor: Saýaldyq ýaqyt:

Keńesshi júıesi

Ónimdiliktiń yqtımal máseleleri

Issue:
Jumys ýaqyty 1 kúnnen az, ónimdilikti baptaý dál bolmaýy múmkin.
Recommendation:
Neǵurlym naqty ortasha mánder bolýy úshin, osy taldaýshyny iske qosý aldynda serverge bir kúnnen artyq jumys isteýge múmkindik berý usynylady
Justification:
Jumys ýaqyty 0 kún, 0 saǵat, 9 mınýt jáne 29 sekýnt ǵana
Used variable / formula:
Uptime
Test:
value < 86400
Issue:
long_query_time 10 sekýntke nemese odan da kóbirek mánge ornatylǵan, sondyqtan 10 sekýntten joǵary ýaqytty jumsaıtyn baıaý saýaldar ǵana jazylady.
Recommendation:
Ortańyzǵa táýeldi long_query_time mánin tómen ornatý usynylady. Ádette 1-5 sekýnt máni usynylady.
Justification:
long_query_time máni aǵymda 10 sekýntke ornatylǵan.
Used variable / formula:
long_query_time
Test:
value >= 10
Issue:
Baıaý saýaldardy jurnalǵa jazýy óshirilgen.
Recommendation:
slow_query_log parametrin «ON» kúıine qoıý arqyly baıaý saýaldy jurnalǵa jazýyn qosý. Bul nashar oryndalatyn saýaldardyń aqaýlyqtaryn joıýǵa kómektesedi.
Justification:
slow_query_log máni «OFF» úshin ornatylǵan
Used variable / formula:
slow_query_log
Test:
value == 'OFF'
Issue:
Derlik ońtayly keshteý ádisi.
Recommendation:
You are using the MySQL Query cache with a fairly high traffic database. It might be worth considering to use memcached instead of the MySQL Query cache, especially if you have multiple replicas.
Justification:
Saýal keshi qosylǵan jáne server sekýntine 198 saýaldy qabyldaıdy. Eger sekýntine 100-den kóbirek saýal bolsa, bul ereje oryndalady.
Used variable / formula:
Questions / Uptime
Test:
value > 100
Issue:
Tym kóp suryptaý ýaqytsha kestelerdi týdyrady.
Recommendation:
Júıelik jad shekteýlerine baılanysty sort_buffer_size jáne/nemese read_rnd_buffer_size ulǵaıtýyn qarastyryńyz.
Justification:
Ýaqytsha kestelerdiń ortashasy: 9.7 mınýtyna, bul mán saǵatyna 1-den kem bolýy qajet.
Used variable / formula:
Sort_merge_passes / Uptime
Test:
value * 60 * 60 > 1
Issue:
Munda birqatar suryptalayp jatqan joldar bar.
Recommendation:
Joldardy suryptaýdyń kóp mólsherimen eshqandaı qate bolmasa da, suryptaýdy qajet etetin saýaldar ORDER BY sóılemindegi ındekstelgen baǵandardy paıdalanatyna kóz jetkizýińiz múmkin, sebebi bul áldeqaıda jyldam suryptaýǵa ákeledi.
Justification:
Suryptalǵan joldar ortasha: 417.98 sekýntine
Used variable / formula:
Sort_rows / Uptime
Test:
value * 60 >= 1
Issue:
Munda tym kóp ındekssiz jalǵasýlar bar.
Recommendation:
Bul jalǵasýlar kesteni tolyq skanerleý isteıtinin bildiredi. Jalǵasý sharttarynda paıdalanylatyn baǵandar úshin ındeksterdi ústeý keste jalǵasýlaryn aıtarlyqtaı jyldamdatady.
Justification:
Keste jalǵasý ortashasy: 206.15 sekýntine, bul mán saǵatyna 1-den kem bolýy qajet
Used variable / formula:
(Select_range_check + Select_scan + Select_full_join) / Uptime
Test:
value * 60 * 60 > 1
Issue:
Birinshi ındeks jazbasyn oqu araqatynasy joǵary.
Recommendation:
Bul, ádette, jıi ındekstik tolyq skanerleýdi kórsetedi. Indekstik tolyq skanerleý kestelik skanerleýden tezirek bolady, biraq úlken kestelerde kóp prosesorlyq sıkldaryn qajet etedi, eger sol kestelerde UPDATE jáne DELETE nusqaýlary úlken kólemderine bul bar nemese bolǵan kezde «OPTIMIZE TABLE» nusqaýy oryndalsa, ındekstik tolyq skanerleýleriniń kólemin azaıtýǵa jáne/nemese jyldamdatýǵa bolady. Osy ındekstik tolyq skanerleýinen bólek, saýaldardy qaıta jazý arqyly ǵana azaıtýǵa bolady.
Justification:
Indeksti skanerleý ortashasy: 157.89 sekýntine, bul mán saǵatyna 1-den az bolýy qajet
Used variable / formula:
Handler_read_first / Uptime
Test:
value * 60 * 60 > 1
Issue:
Turaqty jaıǵasymdy oqý jaraqatynasy joǵary.
Recommendation:
Bul nátıjelerdi suryptaýdy jáne/nemese kesteni tolyq skanerleýdi qajet etetin kóptegen saýaldar baryn kórsetedi, sonyń ishinde ındeksterdi paıdalanbaıtyn jalǵasý saýaldary. Qoldanylatyn jerde ındeksterdi ústeńiz.
Justification:
Turaqty jaıǵasymdy oqý ortashasynyń araqatynasy: 221.93 sekýntine, bul mán saǵatyna 1-den kem bolýy qajet
Used variable / formula:
Handler_read_rnd / Uptime
Test:
value * 60 * 60 > 1
Issue:
Kelesi keste jolyn oqý araqatynasy joǵary.
Recommendation:
Bul kóptegen saýaldar kesteniń tolyq skanerleýler istelip jatyrǵanyn kórsetedi. Qoldanbaly jerde ındeksterdi ústeńiz.
Justification:
Kelesi keste jolyn oqý araqatynasy: 7437.35 sekýntine, bul mán saǵatyna 1-den kem bolýy qajet
Used variable / formula:
Handler_read_rnd_next / Uptime
Test:
value * 60 * 60 > 1
Issue:
Kóptegen ýaqytsha kesteler jadta saqtalýdyń ornyna dıskige jazylyp jatqan.
Recommendation:
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 MySQL Documentation
Justification:
Dıskige jazylǵan ýaqytsha kestelerdiń araqatynasy: 9.91 mınýtyna, bul mán saǵatyna 1-den kem bolýy qajet
Used variable / formula:
Created_tmp_disk_tables / Uptime
Test:
value * 60 * 60 > 1
Issue:
MyISAM key buffer (index cache) % used is low.
Recommendation:
key_buffer_size ólshemin azaıtý qajet bolýy múmkin, ındekster alastalǵanyna kóz jetkizý úshin kestelerińizdi qaıta tekserińiz nemese qandaı ındeksterdiń paıdalanylatyny týraly saýaldar men kútýlerdi tekserińiz.
Justification:
Eń kóp % MyISAM kilt býferi esqashan paıdalanylǵan: 0%, bul mán 95 % joǵary bolýy qajet
Used variable / formula:
Key_blocks_used * key_cache_block_size / key_buffer_size * 100
Test:
value < 95
Issue:
Ashyq kesteler araqatynasy joǵary bolyp tabylady.
Recommendation:
Kestelerdi ashý dıskilik kirgizý/shyǵarý áreketterin qajetetedi, ol shyǵyndy bolýy múmkin. table_open_cache mánin kóbeıtkende odan aýlaqtandyrý múmkin.
Justification:
Ashylǵan keste araqatynasy: 1.73 sekýntine, bul mán saǵatyna 10-nan tómen bolýy qajet
Used variable / formula:
Opened_tables / Uptime
Test:
value*60*60 > 10
Issue:
Ashyq faıldar araqatynasy joǵary bolyp tabylady.
Recommendation:
open_files_limit kóbeıtýdi qarastyryńyz, jáne open_files_limit ózgertkennen keıin qaıta iske qosylǵan kezde qateler jurnalyn tekserińiz.
Justification:
Ashyq faıldar araqatynasy: 1.48 mınýtyna, bul mán saǵatyna 5-ten kem bolýy kerek
Used variable / formula:
Open_files / Uptime
Test:
value * 60 * 60 > 5
Issue:
Tym kóp qosylymdar úzildi.
Recommendation:
Qosylymdar ádette olardyń ókilettiligi múmkin emes kezde úziledi. Bul maqala qaınardy tabýǵa kómektesýi múmkin.
Justification:
Úzilgen qosylymdar araqatynasy 25.31 saǵatyna, bul mán saǵatyna 1-den kem bolýy kerek
Used variable / formula:
Aborted_connects / Uptime
Test:
value * 60 * 60 > 1