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 :
Modus jelajah

Atur mode jelajah.

Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya.
Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya.
Dokumentasi Whether a user should be displayed a "show all (rows)" button.
Dokumentasi Jumlah baris yang ditampilkan saat browsing hasil set. Jika hasil set berisi lebih dari satu baris, tautan "Previous" and "Next" akan ditampilkan.
Dokumentasi SMART - yaitu urutan untuk kolom jenis TIME, DATE, DATETIME dan TIMESTAMP, urutan ascending dan sebaliknya.
Dokumentasi Sorot baris yang ditunjuk dengan kursor mouse.
Dokumentasi Sorot baris terpilih.
Dokumentasi
Dokumentasi
Dokumentasi Ulangi header setiap X sel, 0 menonaktifkan fitur ini.
Dokumentasi Jumlah maksimum karakter yang ditunjukkan pada kolom non-angka pada mode jelajah.
Dokumentasi Berikut ini adalah tautan Edit, Salin, dan Hapus.
Dokumentasi Apakah untuk menampilkan link baris bahkan tanpa adanya unique key.
Dokumentasi Default sort order for tables with a primary key.
Dokumentasi Saat browsing tabel, penyortiran setiap tabel akan diingat.
Dokumentasi Untuk pengaturan tampilan
SELECT * FROM `SYSTEM_VARIABLES` ORDER BY `VARIABLE_TYPE` ASC
[ Edit dikotak ] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan ]
|
|
|
Saring baris:
VARIABLE_NAME SESSION_VALUE GLOBAL_VALUE GLOBAL_VALUE_ORIGIN DEFAULT_VALUE VARIABLE_SCOPE VARIABLE_TYPE Menaik Menurun 1 VARIABLE_COMMENT NUMERIC_MIN_VALUE NUMERIC_MAX_VALUE NUMERIC_BLOCK_SIZE ENUM_VALUE_LIST READ_ONLY COMMAND_LINE_ARGUMENT
INSERT_ID 0 NULL COMPILE-TIME 0 SESSION ONLY BIGINT UNSIGNED The value to be used by the following INSERT or AL... 0 18446744073709551615 1 NULL NO NULL
INNODB_STATS_TRANSIENT_SAMPLE_PAGES NULL 8 COMPILE-TIME 8 GLOBAL BIGINT UNSIGNED The number of leaf index pages to sample when calc... 1 18446744073709551615 0 NULL NO REQUIRED
TMP_MEMORY_TABLE_SIZE 16777216 16777216 COMPILE-TIME 16777216 SESSION BIGINT UNSIGNED If an internal in-memory temporary table exceeds t... 1024 18446744073709551615 1 NULL NO REQUIRED
BINLOG_FILE_CACHE_SIZE NULL 16384 COMPILE-TIME 16384 GLOBAL BIGINT UNSIGNED The size of file cache for the binary log 8192 18446744073709551615 4096 NULL NO REQUIRED
BINLOG_STMT_CACHE_SIZE NULL 32768 COMPILE-TIME 32768 GLOBAL BIGINT UNSIGNED The size of the statement cache for updates to non... 4096 18446744073709551615 4096 NULL NO REQUIRED
MYISAM_MMAP_SIZE NULL 18446744073709551615 COMPILE-TIME 18446744073709551615 GLOBAL BIGINT UNSIGNED Restricts the total memory used for memory mapping... 7 18446744073709551615 1 NULL YES REQUIRED
TMP_TABLE_SIZE 16777216 16777216 COMPILE-TIME 16777216 SESSION BIGINT UNSIGNED Alias for tmp_memory_table_size. If an internal in... 1024 18446744073709551615 1 NULL NO REQUIRED
KEY_CACHE_BLOCK_SIZE NULL 1024 COMPILE-TIME 1024 GLOBAL BIGINT UNSIGNED The default size of key cache blocks 512 16384 512 NULL NO REQUIRED
JOIN_BUFFER_SIZE 262144 262144 COMPILE-TIME 262144 SESSION BIGINT UNSIGNED The size of the buffer that is used for joins 128 18446744073709551615 128 NULL NO REQUIRED
WARNING_COUNT 0 NULL COMPILE-TIME NULL SESSION ONLY BIGINT UNSIGNED The number of errors, warnings, and notes that res... 0 18446744073709551615 1 NULL YES NULL
SORT_BUFFER_SIZE 524288 524288 CONFIG 2097152 SESSION BIGINT UNSIGNED Each thread that needs to do a sort allocates a bu... 1024 18446744073709551615 1 NULL NO REQUIRED
JOIN_BUFFER_SPACE_LIMIT 2097152 2097152 COMPILE-TIME 2097152 SESSION BIGINT UNSIGNED The limit of the space for all join buffers used b... 2048 18446744073709551615 2048 NULL NO REQUIRED
RAND_SEED1 41587508 NULL COMPILE-TIME 0 SESSION ONLY BIGINT UNSIGNED Sets the internal state of the RAND() generator fo... 0 4294967295 1 NULL NO NULL
BULK_INSERT_BUFFER_SIZE 8388608 8388608 COMPILE-TIME 8388608 SESSION BIGINT UNSIGNED Size of tree cache used in bulk insert optimisatio... 0 18446744073709551615 1 NULL NO REQUIRED
PSEUDO_THREAD_ID 3166495 NULL COMPILE-TIME 0 SESSION ONLY BIGINT UNSIGNED This variable is for internal server use 0 18446744073709551615 1 NULL NO NULL
MAX_HEAP_TABLE_SIZE 16777216 16777216 COMPILE-TIME 16777216 SESSION BIGINT UNSIGNED Don't allow creation of heap tables bigger than th... 16384 18446744073709551615 1024 NULL NO REQUIRED
KEY_CACHE_DIVISION_LIMIT NULL 100 COMPILE-TIME 100 GLOBAL BIGINT UNSIGNED The minimum percentage of warm blocks in key cache 1 100 1 NULL NO REQUIRED
MAX_BINLOG_CACHE_SIZE NULL 18446744073709547520 COMPILE-TIME 18446744073709547520 GLOBAL BIGINT UNSIGNED Sets the total size of the transactional cache 4096 18446744073709551615 4096 NULL NO REQUIRED
MAX_SESSION_MEM_USED 9223372036854775807 9223372036854775807 COMPILE-TIME 9223372036854775807 SESSION BIGINT UNSIGNED Amount of memory a single user session is allowed ... 8192 18446744073709551615 1 NULL NO REQUIRED
KEY_BUFFER_SIZE NULL 16777216 CONFIG 134217728 GLOBAL BIGINT UNSIGNED The size of the buffer used for index blocks for M... 0 18446744073709551615 4096 NULL NO REQUIRED
INNODB_MAX_UNDO_LOG_SIZE NULL 10485760 COMPILE-TIME 10485760 GLOBAL BIGINT UNSIGNED Desired maximum UNDO tablespace size in bytes 10485760 281474976710656 0 NULL NO OPTIONAL
MAX_ROWID_FILTER_SIZE 131072 131072 COMPILE-TIME 131072 SESSION BIGINT UNSIGNED The maximum size of the container of a rowid filte... 1024 18446744073709551615 1 NULL NO REQUIRED
QUERY_CACHE_SIZE NULL 1048576 COMPILE-TIME 1048576 GLOBAL BIGINT UNSIGNED The memory allocated to store results from old que... 0 4294967295 1024 NULL NO REQUIRED
INNODB_STATS_SAMPLE_PAGES NULL 8 COMPILE-TIME 8 GLOBAL BIGINT UNSIGNED Deprecated, use innodb_stats_transient_sample_page... 1 18446744073709551615 0 NULL NO REQUIRED
MAX_BINLOG_STMT_CACHE_SIZE NULL 18446744073709547520 COMPILE-TIME 18446744073709547520 GLOBAL BIGINT UNSIGNED Sets the total size of the statement cache 4096 18446744073709551615 4096 NULL NO REQUIRED
|
|
|
Saring baris:
Operasi hasil kueri Cetak Cetak Salin ke clipboard Salin ke clipboard Ekspor Ekspor Tampilkan bagan Tampilkan bagan Buat tampilan Buat tampilan
Markahi kueri SQL ini Markahi kueri SQL ini