# MariaDB Serverless Single Node

For cloud databases using the MariaDB Serverless Single Node topology, the following Configuration Manager parameters are available to configure the behavior of the MariaDB Server:

| Name                                                                                                                                                                                                              | Default Value                                                                                                                                              |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [auto\_increment\_increment](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables#auto_increment_increment)                         | 1                                                                                                                                                          |
| [autocommit](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#autocommit)                                                                             | ON                                                                                                                                                         |
| [cracklib\_password\_check](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/plugins/password-validation-plugins/cracklib-password-check-plugin#cracklib_password_check)                                  | OFF                                                                                                                                                        |
| [default\_password\_lifetime](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#default_password_lifetime)                                             | 0                                                                                                                                                          |
| [default\_time\_zone](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#time_zone)                                                                     | system                                                                                                                                                     |
| [disconnect\_on\_expired\_password](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#disconnect_on_expired_password)                                  | OFF                                                                                                                                                        |
| [div\_precision\_increment](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#div_precision_increment)                                                 | 4                                                                                                                                                          |
| [eq\_range\_index\_dive\_limit](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#eq_range_index_dive_limit)                                           | 200                                                                                                                                                        |
| [event\_scheduler](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#event_scheduler)                                                                  | OFF                                                                                                                                                        |
| [expire\_logs\_days](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables#expire_logs_days)                                         | 4                                                                                                                                                          |
| [explicit\_defaults\_for\_timestamp](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#explicit_defaults_for_timestamp)                                | OFF                                                                                                                                                        |
| [innodb\_autoextend\_increment](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/innodb/innodb-system-variables#innodb_autoextend_increment)                                           | 64                                                                                                                                                         |
| [innodb\_autoinc\_lock\_mode](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/innodb/innodb-system-variables#innodb_autoinc_lock_mode)                                                | 2                                                                                                                                                          |
| [log\_slow\_filter](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#log_slow_filter)                                                                 | admin, filesort, filesort\_on\_disk, filesort\_priority\_queue, full\_join, full\_scan, query\_cache, query\_cache\_miss, tmp\_table, tmp\_table\_on\_disk |
| [log\_slow\_rate\_limit](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#log_slow_rate_limit)                                                        | 1                                                                                                                                                          |
| [log\_slow\_verbosity](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#log_slow_verbosity)                                                           |                                                                                                                                                            |
| [long\_query\_time](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#long_query_time)                                                                 | 10.0                                                                                                                                                       |
| [lower\_case\_table\_names](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#lower_case_table_names)                                                  | 0                                                                                                                                                          |
| [max\_allowed\_packet](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#max_allowed_packet)                                                           | 33554432                                                                                                                                                   |
| [max\_password\_errors](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#max_password_errors)                                                         | 4294967295                                                                                                                                                 |
| [optimizer\_search\_depth](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#optimizer_search_depth)                                                   | 62                                                                                                                                                         |
| [optimizer\_switch](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#optimizer_switch)                                                                | AUTO\_GENERATED                                                                                                                                            |
| [read\_only](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#read_only)                                                                              | OFF                                                                                                                                                        |
| [session\_track\_system\_variables](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#session_track_system_variables)                                  | autocommit, character\_set\_client, character\_set\_connection, character\_set\_results, time\_zone                                                        |
| [simple\_password\_check\_digits](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/plugins/password-validation-plugins/simple-password-check-plugin#simple_password_check_digits)                         | 1                                                                                                                                                          |
| [simple\_password\_check\_letters\_same\_case](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/plugins/password-validation-plugins/simple-password-check-plugin#simple_password_check_letters_same_case) | 1                                                                                                                                                          |
| [simple\_password\_check\_minimal\_length](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/plugins/password-validation-plugins/simple-password-check-plugin#simple_password_check_minimal_length)        | 8                                                                                                                                                          |
| [simple\_password\_check\_other\_characters](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/plugins/password-validation-plugins/simple-password-check-plugin#simple_password_check_other_characters)    | 1                                                                                                                                                          |
| [slow\_query\_log](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#slow_query_log)                                                                   | OFF                                                                                                                                                        |
| [sql\_mode](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#sql_mode)                                                                                | ERROR\_FOR\_DIVISION\_BY\_ZERO, NO\_AUTO\_CREATE\_USER, NO\_ENGINE\_SUBSTITUTION, STRICT\_TRANS\_TABLES                                                    |
| [strict\_password\_validation](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#strict_password_validation)                                           | ON                                                                                                                                                         |
| [transaction\_isolation](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#transaction_isolation)                                                      | REPEATABLE-READ                                                                                                                                            |
