Questions tagged [mysql]
All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.
22,453 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
22
views
MySQL 5.6 not writing any logs
We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We have enabled the error, general & slow logging in the config file, but the logs are not being written even in case of ...
0
votes
0
answers
21
views
When I hit iiq console in command prompt my Sailpoint says database version doesn't match the system version
In mine it says Application's system version 8.4-104 does not match IdentityIQ database's system version 8.4-87
I tried to update the database its still not working. If it works I can import xml files ...
0
votes
2
answers
37
views
MySQL Error 2013: How to increase server timeout for long-running queries
I’m running a query on a large MySQL table and consistently get Error Code: 2013 – Lost connection to MySQL server during query.
Query example:
WITH duplicates AS (
SELECT
event_time,
...
-2
votes
2
answers
60
views
total price of guest house booking
we have a price table mysql database, date fields:
(price per day)
from
to
price
2025年02月01日
2025年05月31日
100
2025年06月01日
2025年08月20日
120
2025年08月21日
2025年10月31日
130
And for the reservation form 2025年05月20日 ...
0
votes
1
answer
44
views
MySQL Replication working but not updating
I seem to have an impossible situation.
I have set up MySQL (8.0) on a Master and Slave and followed instructions to set up replication.
Replication seems to be running but none of the tables in the ...
0
votes
0
answers
12
views
MySQL innodb_undo_directory: how do I move it without MySQL failing to start up 2/3 times?
I am trying to move innodb_undo_directory files to a different device mounted on Linux (WSL 2.0). (NB: Specifically, I am trying to move all high-write-load files away from the default datadir on my ...
0
votes
0
answers
30
views
Table is freeze, not able to do any change in Innodb table in MySQL
I am using MySQL 8.0. I have a sales table with only 30,000 rows. I had a problem where the table was frozen and I couldn't alter the values in any of the columns. I attempted to duplicate the data ...
1
vote
2
answers
46
views
User variable in "WHERE IN" statement
I'm having difficulty using a WHERE IN() and a user variable together.
When I use a WHERE IN() statement without a variable, everything works well:
-- Returns three rows
SELECT id FROM users WHERE ...
1
vote
1
answer
29
views
Does tmp_table_size grows based on users growth and usage?
From sources : The tmp_table_size variable is categorized as a global buffer because its value is a single, server-wide setting. It doesn't get set or changed on a per-session basis. This makes it ...
Mannoj's user avatar
- 1,593
-1
votes
1
answer
34
views
Can the NKTg Law analogy help in modeling database performance under variable data loads?
I recently came across the NKTg Law on Varying Inertia in physics, which describes an object’s movement tendency based on its position (x), velocity (v), and mass (m), with m allowed to change over ...
0
votes
1
answer
28
views
Percona CREATE TABLE throws `ERROR 1062 (23000): Duplicate entry '4220' for key 'columns.PRIMARY'`
I just installed Percona over MySQL 8.0 on WSL Ubuntu 22. I made database gtm and I am trying to create a table inside it.
mysql> show tables;
Empty set (0.00 sec)
mysql> CREATE TABLE employees ...
0
votes
0
answers
22
views
Official example of `CREATE JSON DUALITY VIEW` gives syntax error
According to the release note of MySQL 9.4, JSON duality views are now supported.
27.7.1 JSON Duality View Syntax shows this example:
CREATE TABLE customers (
id INT NOT NULL AUTO_INCREMENT ...
0
votes
0
answers
23
views
AWS Aurora MySQL table archive running slow for one table
I'm working on archiving a bunch of tables in an environment where archiving was never done, with some data going back 10 years. I've written a script to perform the work, which loops through the ...
0
votes
0
answers
21
views
How to get the last event id for each day & level of windows event viewer? [duplicate]
I've built a MySQL database from a Windows Event Viewer, trying to track down the last event for each possible level of event. For example, the last event for level Warning on 8/2/2025 might be 10016 (...
0
votes
1
answer
35
views
cluster vs replica in mariadb or mysql
I'm confused between two words of cluster and replica in mariadb.
I saw some tutorial and they explain cluster or replica.
Is replica same cluster or not?
If not , please explain their diffrences.