Warning: Invalid argument supplied for foreach() in /users/filmtheater/www/MySQLDumper-master/inc/sqlbrowser/sql_record_update_inputmask.php on line 19
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `information_schema`.`SYSTEM_VARIABLES`
Datensätze 31 - 60 von insgesamt 666 << < > >>
Ansicht: kompakt Die Abfrage enthält 15 Spalten | ||||||||||||||||
# | VARIABLE_NAME | SESSION_VALUE | GLOBAL_VALUE | GLOBAL_VALUE_ORIGIN | DEFAULT_VALUE | VARIABLE_SCOPE | VARIABLE_TYPE | VARIABLE_COMMENT | NUMERIC_MIN_VALUE | NUMERIC_MAX_VALUE | NUMERIC_BLOCK_SIZE | ENUM_VALUE_LIST [BB] | READ_ONLY | COMMAND_LINE_ARGUMENT | GLOBAL_VALUE_PATH | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31. | ARIA_RECOVER_OPTIONS | NULL | BACKUP,QUICK | COMPILE-TIME | BACKUP,QUICK | GLOBAL | SET | Specifies how corrupted tables should be automatically repaired | NULL | NULL | NULL | NORMAL,BACKUP,FORCE,QUICK,OFF | NO | OPTIONAL | NULL | |
32. | MAX_SP_RECURSION_DEPTH | 0 | 0 | COMPILE-TIME | 0 | SESSION | BIGINT UNSIGNED | Maximum stored procedure recursion depth | 0 | 255 | 1 | NULL | NO | OPTIONAL | NULL | |
33. | INNODB_FT_NUM_WORD_OPTIMIZE | NULL | 2000 | COMPILE-TIME | 2000 | GLOBAL | BIGINT UNSIGNED | InnoDB Fulltext search number of words to optimize for each optimize table call | 1000 | 10000 | 0 | NULL | NO | OPTIONAL | NULL | |
34. | PERFORMANCE_SCHEMA_MAX_INDEX_STAT | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of index statistics for instrumented tables. Use 0 to disable, -1 for automated scaling. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL | |
35. | WSREP_DRUPAL_282555_WORKAROUND | NULL | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Enable a workaround to handle the cases where inserting a DEFAULT value into an auto-increment column could fail with duplicate key error | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
36. | PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES | NULL | 210 | COMPILE-TIME | 210 | GLOBAL | BIGINT UNSIGNED | Maximum number of mutex instruments. | 0 | 256 | 1 | NULL | YES | REQUIRED | NULL | |
37. | TMP_MEMORY_TABLE_SIZE | 33554432 | 33554432 | COMPILE-TIME | 16777216 | SESSION | BIGINT UNSIGNED | If an internal in-memory temporary table exceeds this size, MariaDB will automatically convert it to an on-disk MyISAM or Aria table. Same as tmp_table_size. | 0 | 18446744073709551615 | 1 | NULL | NO | REQUIRED | NULL | |
38. | MAX_LENGTH_FOR_SORT_DATA | 1024 | 1024 | COMPILE-TIME | 1024 | SESSION | BIGINT UNSIGNED | Max number of bytes in sorted records | 4 | 8388608 | 1 | NULL | NO | REQUIRED | NULL | |
39. | REPORT_HOST | NULL | COMPILE-TIME | GLOBAL | VARCHAR | Hostname or IP of the slave to be reported to the master during slave registration. Will appear in the output of SHOW SLAVE HOSTS. Leave unset if you do not want the slave to register itself with the master. Note that it is not sufficient for the master to simply read the IP of the slave off the socket once the slave connects. Due to NAT and other routing issues, that IP may not be valid for connecting to the slave from the master or other hosts | NULL | NULL | NULL | NULL | YES | REQUIRED | NULL | |||
40. | PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0 to disable, -1 for automated sizing. | -1 | 1024 | 1 | NULL | YES | REQUIRED | NULL | |
41. | INNODB_SORT_BUFFER_SIZE | NULL | 1048576 | COMPILE-TIME | 1048576 | GLOBAL | BIGINT UNSIGNED | Memory buffer size for index creation | 65536 | 67108864 | 0 | NULL | YES | REQUIRED | NULL | |
42. | PERFORMANCE_SCHEMA_MAX_STAGE_CLASSES | NULL | 160 | COMPILE-TIME | 160 | GLOBAL | BIGINT UNSIGNED | Maximum number of stage instruments. | 0 | 256 | 1 | NULL | YES | REQUIRED | NULL | |
43. | PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Number of rows per thread in EVENTS_STATEMENTS_HISTORY. Use 0 to disable, -1 for automated sizing. | -1 | 1024 | 1 | NULL | YES | REQUIRED | NULL | |
44. | SLAVE_TRANSACTION_RETRY_ERRORS | NULL | 1158,1159,1160,1161,1205,1213,1429,2013,12701 | COMPILE-TIME | GLOBAL | VARCHAR | Tells the slave thread to retry transaction for replication when a query event returns an error from the provided list. Deadlock error, elapsed lock wait timeout, net read error, net read timeout, net write error, net write timeout, connect error and 2 types of lost connection error are automatically added to this list | NULL | NULL | NULL | NULL | YES | REQUIRED | NULL | ||
45. | LARGE_FILES_SUPPORT | NULL | ON | COMPILE-TIME | NULL | GLOBAL | BOOLEAN | Whether mysqld was compiled with options for large file support | NULL | NULL | NULL | OFF,ON | YES | NULL | NULL | |
46. | PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of rows in SETUP_ACTORS. | -1 | 1024 | 1 | NULL | YES | REQUIRED | NULL | |
47. | ARIA_PAGECACHE_AGE_THRESHOLD | NULL | 300 | COMPILE-TIME | 300 | GLOBAL | BIGINT UNSIGNED | This characterizes the number of hits a hot block has to be untouched until it is considered aged enough to be downgraded to a warm block. This specifies the percentage ratio of that number of hits to the total number of blocks in the page cache. | 100 | 18446744073709551615 | 100 | NULL | NO | REQUIRED | NULL | |
48. | PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Size of session attribute string buffer per thread. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL | |
49. | WSREP_AUTO_INCREMENT_CONTROL | NULL | ON | COMPILE-TIME | ON | GLOBAL | BOOLEAN | To automatically control the assignment of autoincrement variables | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
50. | DEFAULT_STORAGE_ENGINE | InnoDB | InnoDB | COMPILE-TIME | InnoDB | SESSION | VARCHAR | The default storage engine for new tables | NULL | NULL | NULL | NULL | NO | NULL | NULL | |
51. | INNODB_BACKGROUND_SCRUB_DATA_COMPRESSED | NULL | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Deprecated parameter with no effect. | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
52. | DELAYED_INSERT_LIMIT | NULL | 10 | CONFIG | 100 | GLOBAL | BIGINT UNSIGNED | After inserting delayed_insert_limit rows, the INSERT DELAYED handler will check if there are any SELECT statements pending. If so, it allows these to execute before continuing. | 1 | 4294967295 | 1 | NULL | NO | REQUIRED | NULL | |
53. | GROUP_CONCAT_MAX_LEN | 1048576 | 1048576 | COMPILE-TIME | 1048576 | SESSION | INT UNSIGNED | The maximum length of the result of function GROUP_CONCAT() | 4 | 4294967295 | 1 | NULL | NO | REQUIRED | NULL | |
54. | 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 | NULL | |
55. | RANGE_ALLOC_BLOCK_SIZE | 4096 | 4096 | COMPILE-TIME | 4096 | SESSION | BIGINT UNSIGNED | Allocation block size for storing ranges during optimization | 4096 | 4294967295 | 1024 | NULL | NO | REQUIRED | NULL | |
56. | SLOW_QUERY_LOG | OFF | OFF | COMPILE-TIME | OFF | SESSION | BOOLEAN | Log slow queries to a table or log file. Defaults logging to a file 'hostname'-slow.log or a table mysql.slow_log if --log-output=TABLE is used. Must be enabled to activate other slow log options. | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
57. | VERSION_COMMENT | NULL | Debian 11 | COMPILE-TIME | NULL | GLOBAL | VARCHAR | Value of the COMPILATION_COMMENT option specified by CMake when building MariaDB, for example mariadb.org binary distribution. | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
58. | BIND_ADDRESS | NULL | COMPILE-TIME | GLOBAL | VARCHAR | IP address to bind to. | NULL | NULL | NULL | NULL | YES | REQUIRED | NULL | |||
59. | INNODB_TMPDIR | COMPILE-TIME | SESSION | VARCHAR | Directory for temporary non-tablespace files. | NULL | NULL | NULL | NULL | NO | OPTIONAL | NULL | ||||
60. | PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Number of rows per thread in EVENTS_TRANSACTIONS_HISTORY. Use 0 to disable, -1 for automated sizing. | -1 | 1024 | 1 | NULL | YES | REQUIRED | NULL |
Datensätze 31 - 60 von insgesamt 666 << < > >>