Wordpress

[farias]

Ajout de cache REDIS:

[farias]

Avec la migration je suis passé de PHP 8.4.12 => 8.4.15

[farias]

Migration InnoDB :

# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2618
Server version: 10.11.14-MariaDB-0+deb12u2-log Debian 12

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SELECT CONCAT('ALTER TABLE ',TABLE_NAME,' ENGINE=InnoDB;') 
    -> FROM INFORMATION_SCHEMA.TABLES
    -> WHERE ENGINE='MyISAM'
    -> AND table_schema = 'farias17';
+-----------------------------------------------------------+
| CONCAT('ALTER TABLE ',TABLE_NAME,' ENGINE=InnoDB;')       |
+-----------------------------------------------------------+
| ALTER TABLE af_es_pluginconfig ENGINE=InnoDB;             |
| ALTER TABLE af_users ENGINE=InnoDB;                       |
| ALTER TABLE af_commentmeta ENGINE=InnoDB;                 |
| ALTER TABLE af_flag_album ENGINE=InnoDB;                  |
| ALTER TABLE af_flag_comments ENGINE=InnoDB;               |
| ALTER TABLE af_ai1ec_event_category_colors ENGINE=InnoDB; |
| ALTER TABLE af_xmlgooglemaps_cache ENGINE=InnoDB;         |
| ALTER TABLE af_es_emaillist ENGINE=InnoDB;                |
| ALTER TABLE af_xmlgooglemaps ENGINE=InnoDB;               |
| ALTER TABLE af_links ENGINE=InnoDB;                       |
| ALTER TABLE af_es_templatetable ENGINE=InnoDB;            |
| ALTER TABLE af_es_deliverreport ENGINE=InnoDB;            |
| ALTER TABLE af_xmlgooglemaps_gpxfile ENGINE=InnoDB;       |
| ALTER TABLE af_flag_gallery ENGINE=InnoDB;                |
| ALTER TABLE af_es_notification ENGINE=InnoDB;             |
| ALTER TABLE af_xmlgooglemaps_gpxfile_item ENGINE=InnoDB;  |
| ALTER TABLE af_translations_log ENGINE=InnoDB;            |
| ALTER TABLE af_es_sentdetails ENGINE=InnoDB;              |
| ALTER TABLE af_translations ENGINE=InnoDB;                |
+-----------------------------------------------------------+
19 rows in set (0,004 sec)

[farias]

Je viens de mettre Redis Cache :

[farias]

C’est pas encore bon …

[farias]

Je vais virer la SWAP :

# /sbin/sysctl vm.swappiness=0
vm.swappiness = 0
# /sbin/swapoff -a
# /sbin/swapon -a

[farias]

Optimisation MariaDB :

# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 471
Server version: 10.11.14-MariaDB-0+deb12u2-log Debian 12

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show status like 'Threads_created';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| Threads_created | 4     |
+-----------------+-------+
1 row in set (0,002 sec)

MariaDB [(none)]> show status like 'Connections';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Connections   | 476   |
+---------------+-------+
1 row in set (0,001 sec)

MariaDB [(none)]> set global thread_cache_size = 90;
Query OK, 0 rows affected (0,001 sec)

[farias]

Je viens aussi de mettre : /etc/mysql/mariadb.conf.d/50-server.cnf

[mysqld]
skip-name-resolve

[farias]

Je lance :

# mysqlcheck --auto-repair --optimize --all-databases
...

[farias]

Je comprends pas le problème avec la base.

Pourtant j’ai aucune requete qui dort :

# mysqladmin processlist 
+-----+------+-----------+----+---------+------+----------+------------------+----------+
| Id  | User | Host      | db | Command | Time | State    | Info             | Progress |
+-----+------+-----------+----+---------+------+----------+------------------+----------+
| 288 | root | localhost |    | Query   | 0    | starting | show processlist | 0.000    |
+-----+------+-----------+----+---------+------+----------+------------------+----------+

C’est toujours instantanée …

[farias]

Optimisation :

# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 9343
Server version: 10.11.14-MariaDB-0+deb12u2-log Debian 12

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SHOW VARIABLES LIKE 'max_allowed_packet';
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| max_allowed_packet | 16777216 |
+--------------------+----------+
1 row in set (0,001 sec)

MariaDB [(none)]> SHOW VARIABLES LIKE 'net_buffer_length';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| net_buffer_length | 16384 |
+-------------------+-------+
1 row in set (0,004 sec)

MariaDB [(none)]> set global net_buffer_length=1000000;
Query OK, 0 rows affected, 1 warning (0,000 sec)

MariaDB [(none)]> set global max_allowed_packet=1000000000;
Query OK, 0 rows affected, 1 warning (0,000 sec)

MariaDB [(none)]> \quit
Bye

[farias]

Update :