my Python application requires the following package -> https://pypi.org/project/mysqlclient/ The pain for me here is that the installation of this packages requires the following build stage at my Dockerfile: RUN curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash && apt-get update &&…
Since a few days I have fatal errors "InnoDB: innodb_fatal_semaphore_wait_threshold was exceeded for dict_sys.latch". Neither the underlying Debian Bookworm nor the MariaDB Server 10.11.4 was changed before. What could cause this issue? The log is showing: mariadbd[324032]: 2023-12-22 11:50:54 0…
I want to optimize performance of this MySQL query SELECT * FROM ( (SELECT * FROM users USE INDEX(names) WHERE name LIKE '%leo%') UNION (SELECT * FROM users USE INDEX(names) WHERE name LIKE '%le%') UNION (SELECT * FROM users USE…
I have some reports made on Spanish by someone. These work properly if I install the Tomcat server on Windows, however we recently switched the whole stack to Ubuntu and now I am facing this problem where all the accented…
I’m running a Wordpress-Woocommerce website on a VPS. My VPS configuration is as below: 4 Core CPU 8 GB RAM 40 GB NVMe I’m running CentOS 7 + Cyberpanel + Openlitespeed Server + QUIC CDN + MariaDB. PHP version: 8.1…
I have an expense table where multiple expenses can be tied to an ID, but each of these expenses can have a specific type. I can get the sum of ONE type. SELECT SUM(expense) AS total FROM expenses WHERE id…
I am using mysql Ver 15.1 Distrib 10.3.39-MariaDB, for Linux (x86_64) using readline 5.1 PHP 8.2.13 (cli) (built: Nov 24 2023 09:33:30) (NTS) I would like to use either or both of these to find data within mysql where the…
I am trying to figure out what would be the most efficient way of achieving the following: I have two tables: word_translations(id, word_id, language_id) and translations(id, text, word_translation_id, created_at, updated_at, user_id) So there is a one-to-many relationship between word_translations and…
I have two simple queries below: SELECT * from table_name where status IN (0, 1, 2, 3, 4) SELECT * from table_name where status NOT IN (5, 6) The possible value of status is 0 to 6, and column status…
I try to do time calculation in SQL on windows XAMP running PHP 8.x and MariaDB 10.x. I need to get the seconds between two datetimes. SELECT TIME_TO_SEC(TIMEDIFF(NOW(),'2023-12-05 21:19:22')) AS td, TIMESTAMPDIFF(SECOND,NOW(),'2023-12-05 21:19:22') AS tsd The '2023-12-05 21:19:22' part is…