Letakkan berkas disini

SQL upload ( 0 ) x -

Pengaturan Terkait dengan Halaman Klik pada bar untuk menggulir ke atas halaman
Tekan Ctrl+Enter untuk menjalankan kueri Press Enter to execute query
ascending
descending
Order:
Men-Debug SQL
Jumlah
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Tampilkan Buka Show trace Hide trace Jumlah Time taken
Bookmark
Segarkan
Tambah
Tidak ada penanda
Tambah bookmark
Opsi
Kembalikan nilai bawaan





Tampilkan Buka Kueri ulang Ubah Jelaskan Profil Bookmarks Kueri gagal Basis data : Waktu eksekusi kueri :

Sistem penasihat

Isu kinerja yang mungkin

Issue:
long_query_time disetel ke 10 detik atau lebih, jadi hanya kueri lambat yang membutuhkan waktu di atas 10 detik yang dicatat.
Recommendation:
Disarankan untuk mengatur long_query_time ke nilai yang lebih rendah, tergantung pada sistem anda. Biasanya nilai 1-5 detik disarankan.
Justification:
long_query_time saat ini disetel menjadi 10 detik.
Used variable / formula:
long_query_time
Test:
value >= 10
Issue:
Log kueri yang lambat dinonaktifkan.
Recommendation:
Aktifkan logging query dengan menetapkan slow_query_log ke 'ON'. Ini akan membantu pemecahan masalah pada query yang bekerja buruk.
Justification:
slow_query_log disetel ke 'OFF'
Used variable / formula:
slow_query_log
Test:
value == 'OFF'
Issue:
Versi dikompilasi dari sumber, bukan biner resmi MySQL.
Recommendation:
If you did not compile from source, you may be using a package modified by a distribution. The MySQL manual only is accurate for official MySQL binaries, not any package distributions (such as RedHat, Debian/Ubuntu etc).
Justification:
'source' ditemukan pada version_comment
Used variable / formula:
version_comment
Test:
preg_match('/source/i',value)
Issue:
There are lots of rows being sorted.
Recommendation:
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.
Justification:
Sorted rows average: 195.97 per detik
Used variable / formula:
Sort_rows / Uptime
Test:
value * 60 >= 1
Issue:
Terlalu banyak join tanpa indeks.
Recommendation:
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.
Justification:
Table joins average: 9.1 per detik, this value should be less than 1 per hour
Used variable / formula:
(Select_range_check + Select_scan + Select_full_join) / Uptime
Test:
value * 60 * 60 > 1
Issue:
The rate of reading the first index entry is high.
Recommendation:
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.
Justification:
Index scans average: 34.08 dalam sejam, this value should be less than 1 per hour
Used variable / formula:
Handler_read_first / Uptime
Test:
value * 60 * 60 > 1
Issue:
The rate of reading data from a fixed position is high.
Recommendation:
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.
Justification:
Rate of reading fixed position average: 185.85 per detik, this value should be less than 1 per hour
Used variable / formula:
Handler_read_rnd / Uptime
Test:
value * 60 * 60 > 1
Issue:
The rate of reading the next table row is high.
Recommendation:
Hal ini menunjukkan bahwa banyak kueri yang melakukan scan tabel secara menyeluruh. Menambahkan indeks dimana memungkinkan.
Justification:
Tingkat (kecepatan) membaca baris tabel selanjutnya: 1195.89 per detik, nilai ini seharusnya kurang dari 1 per jam
Used variable / formula:
Handler_read_rnd_next / Uptime
Test:
value * 60 * 60 > 1
Issue:
Banyak tabel sementara yang ditulis ke disk daripada disimpan di memori.
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 beginning of an Article by the Pythian Group
Justification:
49% dari semua tabel sementara sedang ditulis ke disk, nilai ini seharusnya kurang dari 25%
Used variable / formula:
Created_tmp_disk_tables / (Created_tmp_tables + Created_tmp_disk_tables) * 100
Test:
value > 25
Issue:
MyISAM key buffer (index cache) % used is low.
Recommendation:
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.
Justification:
max % MyISAM key buffer ever used: 0%, this value should be above 95%
Used variable / formula:
Key_blocks_used * key_cache_block_size / key_buffer_size * 100
Test:
value < 95
Issue:
Tingkat pembukaan tabel tinggi.
Recommendation:
Opening tables requires disk I/O which is costly. Increasing table_open_cache might avoid this.
Justification:
Tingkat koneksi yang dibatalkan adalah 2.6 per menit, ninlai ini seharusnya kurang dari 10 per jam
Used variable / formula:
Opened_tables / Uptime
Test:
value*60*60 > 10
Issue:
Ukuran file log InnoDB kurang besar.
Recommendation:
It is usually sufficient to set innodb_log_file_size to 25% of the size of innodb_buffer_pool_size. A very big innodb_log_file_size slows down the recovery time after a database crash considerably. See also this Article. You need to shutdown the server, remove the InnoDB log files, set the new value in my.cnf, start the server, then check the error logs if everything went fine. See also this blog entry
Justification:
Ukuran absolut log InnoDB anda adalah 3000 MiB
Used variable / formula:
innodb_log_file_size / (1024 * 1024)
Test:
value > 256
Issue:
Less than 80% of the query cache is being utilized.
Recommendation:
This might be caused by query_cache_limit being too low. Flushing the query cache might help as well.
Justification:
The current ratio of free query cache memory to total query cache size is 2%. It should be above 80%
Used variable / formula:
100 - Qcache_free_memory / query_cache_size * 100
Test:
value < 80
Issue:
The query cache size is above 128 MiB. Big query caches may cause significant overhead that is required to maintain the cache.
Recommendation:
Depending on your environment, it might be performance increasing to reduce this value.
Justification:
Current query cache size: 1.25 GB
Used variable / formula:
query_cache_size
Test:
value > 1024 * 1024 * 128
Issue:
The max size of the result set in the query cache is the default of 1 MiB.
Recommendation:
Changing query_cache_limit (usually by increasing) may increase efficiency. This variable determines the maximum size a query result may have to be inserted into the query cache. If there are many query results above 1 MiB that are well cacheable (many reads, little writes) then increasing query_cache_limit will increase efficiency. Whereas in the case of many query results being above 1 MiB that are not very well cacheable (often invalidated due to table updates) increasing query_cache_limit might reduce efficiency.
Justification:
query_cache_limit is set to 1 MiB
Used variable / formula:
query_cache_limit
Test:
value == 1024*1024