Known Issue : MariaDB Check and Repair | Info : : LinuxServer.io
▻https://info.linuxserver.io/issues/2023-05-29-mariadb
Utiliser mariadb-check pour réparer une BDD crashée
Voir aussi : ▻https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting
MariaDB reçoit une offre d’achat de Runa Capital II GP - Le Monde Informatique
▻https://www.lemondeinformatique.fr/actualites/lire-mariadb-recoit-une-offre-d-achat-de-runa-capital-ii-gp-9161
Le spécialiste de la base de données SQL open source, MariaDB, a reçu une offre de rachat non sollicitée par un fonds d’investissement, Runa Capital II GP.
Cela aurait il à voir avec ceci :
▻https://www.msn.com/en-us/money/markets/analysts-scratch-heads-over-mariadb-s-decision-to-ditch-dbaas-crown-jewels/ar-AA1ivwIO
’Their future is murky at the moment’
Database industry observers are slamming MariaDB’s decision to ditch two of its core products as it restructures the business in the face of financial challenges.…
Last week, the database company born out of a MySQL fork announced to investors it was ditching strategic products and cutting 28 percent of the workforce. The company also announced access to a $26.5 million loan facility.
SkySQL: MariaDB Cloud Database Services | MariaDB
▻https://mariadb.com/products/skysql
We believe the cloud should give you more freedom, not less. Yet many solutions force choices that result in dissatisfaction.
According to a December 2022 IDC survey*, 40% of respondents said they have moved database deployments from public clouds to another type of deployment (e.g. on-prem). Respondents cited reasons such as database performance and security features were not sufficient for their needs and public cloud vendor’s support was not satisfactory.
Experience the freedom to go anywhere with MariaDB Cloud, a managed database service for any cloud, your way.
*IDC Survey Spotlight: Why Some Are Moving Databases from the Public Cloud Back to the Datacenter, Doc #US49468223, March 2023
#MariaDB #Memory Allocation - MariaDB Knowledge Base
▻https://mariadb.com/kb/en/library/mariadb-memory-allocation
Allocating RAM for MySQL - The short answer
If using just MyISAM, set key_buffer_size to 20% of available RAM. (Plus innodb_buffer_pool_size=0)
If using just InnoDB, set innodb_buffer_pool_size to 70% of available RAM. (Plus key_buffer_size = 10M, small, but not zero.)
Rule of thumb for tuning mysql:
– Start with released copy of my.cnf / my.ini.
– Change key_buffer_size and innodb_buffer_pool_size according to engine usage and RAM.
– Slow queries can usually be ’fixed’ via indexes, schema changes, or SELECT changes, not by tuning.
– Don’t get carried away with the query cache until you understand what it can and cannot do.
– Don’t change anything else unless you run into trouble (eg, max connections).
– Be sure the changes are under the [mysqld] section, not some other section.
The 20%/70% assumes you have at least 4GB of RAM. If you have a tiny antique, or a tiny VM, then those percentages are too high.
Now for the gory details. (NDB Cluster is not discussed here.)
#mysqldumpslow - MariaDB Knowledge Base
▻https://mariadb.com/kb/en/mariadb/mysqldumpslow
mysqldumpslow is a tool to examine the #slow_query_log.
It parses the slow query log files, printing a summary result. Normally, mysqldumpslow groups queries that are similar except for the particular values of number and string data values. It “abstracts” these values to N and ´S´ when displaying summary output. The -a and -n options can be used to modify value abstracting behavior.
Server System Variables - #mariadb Knowledge Base
▻https://mariadb.com/kb/en/mariadb/server-system-variables/#default_storage_engine
toutes les variables système de MariaDB (configuration de #my.cnf)
#variable #default_storage_engine #mysql #optimisation #référence
Avec #MariaDB on peut exporter des tables en #CSV
▻https://mariadb.com/kb/en/mariadb/using-connect-exporting-data-from-mariadb
#MySQL