Author: MariaDB Knowledge Database

Feed: MariaDB Knowledge Base Article Feed. Author: . What is a Database? The easiest way to understand a database is as a collection of related files. Imagine a file (either paper or digital) of sales orders in a shop. Then there's another file of products, containing stock records. To fulfil an order, you'd need to look up the product in the order file and then look up and adjust the stock levels for that particular product in the product file. A database and the software that controls the database, called a database management system (DBMS), helps with this kind of ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . When ONLY_FULL_GROUP_BY is set of course you are not allowed to to specify columns in select statement that are not in the group by. But there is an exception: when grouping by id which is a primary key (i.e. unique by definition) all other columns in the same table are functionally dependent upon it. That’s why the following query does not (should not) raise any error: SELECT id, title, genre FROM films GROUP BY id; This acts as expected in MySql, but in mariaDB raises the famous error nonaggregated incompatible with sql_mode=only_full_group_by ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . I have a working C# .NET application that connects to a Synology NAS with MariaDB5. I need to access to the functions in MySQL version 8 so have tried migrating to MariaDB 10. I've installed MariaDB 10, imported the database, created the user, granted permissions but it won't connect. I've stopped MariaDB 5 and even uninstalled it but it still won't connect. I've changed the port number in the connection string to 3307 but can't find anything else that should be changed in the connection string. The only difference between 5 and ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB is applying to participate in the 2020 Google Season of Docs. Please join us on Zulip to mingle with the community. You can also subscribe to maria-docs@lists.launchpad.net, the documentation mailing list. Migration Documentation You will choose a major relational DBMS, and, focusing on the most recent stable releases, document the process to migrate to MariaDB, including MariaDB equivalents to features in that system, and a detailed list of features that exist in one but not the other, as well as possible workarounds. For an example, see the work-in-progress Migrating from SQL ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Valentina Studio is a graphical front end for MariaDB with two versions: a free version which supports features offered only in paid for versions of competing products and a Pro version that adds advanced features. Free Valentina Studio offers the following features: natively available on macOS, Windows & Linux a feature rich, visual SQL Editor with powerful search functionality a highly productive data editor support for many data sources including all versions of MariaDB and MySQL 5.0.6 and later* ODBC import Schema editor with powerful visual diagramming features; import diagrams from MySQL ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB starting with 10.5.2The prepared_statements_instances table was introduced in MariaDB 10.5.2. The prepared_statements_instances table contains aggregated statistics of prepared statements. The maximum number of rows in the table is determined by the performance_schema_max_prepared_statement_instances system variable, which is by default autosized on startup. The table contains the following columns: +-----------------------------+--------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------------+--------------------------------------------------------+------+-----+---------+-------+ | OBJECT_INSTANCE_BEGIN | bigint(20) unsigned | NO | | NULL | | | STATEMENT_ID | bigint(20) unsigned | NO | | NULL | | | STATEMENT_NAME | varchar(64) | ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB starting with 10.5.2The memory_summary_global_by_event_name table was introduced in MariaDB 10.5.2. The memory_summary_global_by_event_name table contains memory usage statistics aggregated by event and event. The table contains the following columns: +------------------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------------------+---------------------+------+-----+---------+-------+ | EVENT_NAME | varchar(128) | NO | | NULL | | | COUNT_ALLOC | bigint(20) unsigned | NO | | NULL | | | COUNT_FREE | bigint(20) unsigned | NO | | NULL | | | SUM_NUMBER_OF_BYTES_ALLOC | bigint(20) unsigned | NO | | NULL | | | ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB starting with 10.5.2The memory_summary_by_user_by_event_name table was introduced in MariaDB 10.5.2. The memory_summary_by_user_by_event_name table contains memory usage statistics aggregated by user and event. The table contains the following columns: +------------------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------------------+---------------------+------+-----+---------+-------+ | USER | char(32) | YES | | NULL | | | EVENT_NAME | varchar(128) | NO | | NULL | | | COUNT_ALLOC | bigint(20) unsigned | NO | | NULL | | | COUNT_FREE | bigint(20) unsigned | NO | | NULL | | | SUM_NUMBER_OF_BYTES_ALLOC ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB starting with 10.5.2The memory_summary_by_thread_by_event_name table was introduced in MariaDB 10.5.2. The memory_summary_by_thread_by_event_name table contains memory usage statistics aggregated by thread and event. The table contains the following columns: +------------------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------------------+---------------------+------+-----+---------+-------+ | THREAD_ID | bigint(20) unsigned | NO | | NULL | | | EVENT_NAME | varchar(128) | NO | | NULL | | | COUNT_ALLOC | bigint(20) unsigned | NO | | NULL | | | COUNT_FREE | bigint(20) unsigned | NO | | NULL | | | ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB starting with 10.5.2The memory_summary_by_host_by_event_name table was introduced in MariaDB 10.5.2. The memory_summary_by_host_by_event_name table contains memory usage statistics aggregated by host and event. The table contains the following columns: +------------------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------------------+---------------------+------+-----+---------+-------+ | HOST | char(60) | YES | | NULL | | | EVENT_NAME | varchar(128) | NO | | NULL | | | COUNT_ALLOC | bigint(20) unsigned | NO | | NULL | | | COUNT_FREE | bigint(20) unsigned | NO | | NULL | | | SUM_NUMBER_OF_BYTES_ALLOC ... Read More