variables

MariaDB configuration analysis

Tue, 2021-03-30 10:38 — Shinguz

Taxonomy upgrade extras:

If we do customers database configuration analysis we check on one side if the most important MariaDB server system variables (innodb_buffer_pool_size, ...) are set appropriately but also if some MariaDB server system variables are configured completely wrong.

Fortunately MariaDB introduced in MariaDB 10.1 the INFORMATION_SCHEMA.SYSTEM_VARIABLES view where you can find all the relevant information. But one!

Read more about MariaDB configuration analysis
Shinguz's blog
Log in or register to post comments

MariaDB MaxScale Configuration Variables

Global Options

Variable

Language Undefined

tags:

Read more about MariaDB MaxScale Configuration Variables
Log in or register to post comments

MySQL and MariaDB variables inflation

Mon, 2016-12-12 21:43 — Shinguz

Taxonomy upgrade extras:

MySQL is well known and widely spread because of its philosophy of Keep it Simple (KISS).

We recently had the discussion that with newer releases also MySQL and MariaDB relational databases becomes more and more complicated.

Read more about MySQL and MariaDB variables inflation
Shinguz's blog
Log in or register to post comments

InnoDB Buffer Pool Instances is too small

Thu, 2015-07-16 20:09 — Shinguz

Taxonomy upgrade extras:

fpmmm Triggers and Rules

If you are using MariaDB/MySQL 5.5 and newer you should use several InnoDB Buffer Pool Instances for performance reasons.
Some rules to size InnoDB Buffer Pool instances are:

One InnoDB Buffer Pool Instance should be at least 1 Gibyte in size (innodb_buffer_pool_size / innodb_buffer_pool_instances >= 1 Gib).
InnoDB Buffer Pool Instances you can set equal to the number of cores of your machine.

Read more about InnoDB Buffer Pool Instances is too small
Log in or register to post comments

Binlog format MIXED with filtering

Wed, 2015-07-15 06:11 — Shinguz

Taxonomy upgrade extras:

fpmmm Triggers and Rules

Binlog format MIXED changes the binary log format (ROW or STATEMENT) depending on the queries (deterministic or not). This makes it impossible to define 100% correctly working binary log filter rules.

Read more about Binlog format MIXED with filtering
Log in or register to post comments

Flush time is set

Wed, 2015-07-15 06:10 — Shinguz

Taxonomy upgrade extras:

fpmmm Triggers and Rules

If the variable flush_time is set to a non-zero value, all tables are closed (and flushed) every flush_time seconds to disk. This can cause unnecessary and high I/O spikes.

For further information consult MariaDB or MySQL documentation.

Read more about Flush time is set
Log in or register to post comments

Table open cache too small

Wed, 2015-07-15 06:04 — Shinguz

Taxonomy upgrade extras:

fpmmm Triggers and Rules

multi-tenant

The Table Open Cache (table_open_cache or old name table_cache) is a cache to store file handles for all threads. The actual value of cache entries can be seen with the global status of open tables (Open_tables).
Increasing table_open_cache increases the number of file descriptors (open_files_limit) that MySQL requires.