ile in Linux.
==== Mysql Workbench ====
https://dev.mysql.com/downloads/workbench/
Plugins & Script... to generate random rows in MySQL is to use the ORDER BY RAND() clause. This can work fine for small t... will have a serious performance problem, as in order to generate the list of random rows, MySQL needs... tabase db_name ;
mysql> CREATE USER 'user'@'%' IDENTIFIED BY 'secret';
mysql> grant all privileges
====== mysql replication ======
Des questions:
* vérifier automatiquement que la réplication foncti... lage possible du replica.
* max_binlog_size : default & max = 1GB
* [[https://mariadb.com/kb/en/... y-log/|Relay Log]]
* **max_relay_log_size** : default = 0
[[https://mariadb.com/kb/en/using-and-m... ing]]
To be sure replication is not broken while deleting log files, perform the following steps:
Tips =====
===== Change root password =====
<code bash>
sudo systemctl stop mariadb.service
sudo my... FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' identified by 'secret' ;
</code>
then stop ''mysqld_safe'' and restart service.
==== Installation ====
... B.org]] propose un outil pour calculer le fichier de définition du dépôt pour l'installation et la mis
