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.
184 questions from the last 365 days
0
votes
2
answers
13
views
Are leaf nodes on an InnoDB secondary index sorted by both secondary and primary key columns?
For example, if a table has columns A, B, ID, and (ID) is the primary key, and (A) is a secondary index.
I wonder if the leaf nodes on the secondary index (A) is sorted by (A,ID), or just (A), and the ...
- 101
0
votes
1
answer
26
views
Why does loading plugins fail with "cannot open shared object file" on an ARM-based Linux VM?
I am running DolphinDB Server (version 2.00.16.4) on a Linux virtual machine on my MacBook (Apple Silicon / ARM architecture).
When I try to load the MySQL plugin, I encounter the following error:
...
1
vote
2
answers
61
views
Safe process to update production data?
We have multiple webshops with 500.000+ customers, it sometimes occur data becomes faulty due to a bug or a failed import. We currently fix this by executing queries correcting the data directly on ...
- 73
-1
votes
1
answer
50
views
Access denied for user to a database?
A user I'm supporting is getting an error. The user has grants to various tables in mydb, but when they try to access them, they get the error:
Access denied for user 'myuser'@'myhost' to database '...
- 147
0
votes
1
answer
27
views
SQL - returning NULLs if a subquery is empty
I have "device" and "event" tables. I want to combine the device record with particular events as columns.
There are multiple event types. The number of events is small (below 10) ...
- 197
1
vote
1
answer
37
views
Best database driver/connector for MariaDB in Go?
What database drivers and libraries do people use with MariaDB in Go? The page https://go.dev/wiki/SQLDrivers lists 3 MySQL drivers, but none for MariaDB. The SqlX seems to use the same drivers as ...
- 479
0
votes
1
answer
46
views
Constant Error 145: "Can't open file: 'mytable.myi'"
I’m running a MySQL ODBC 3.51 instance using VB6. A specific table keeps getting locked or corrupted, preventing the software from accessing it, and in the MySQL error log I keep finding entries like:
...
0
votes
1
answer
112
views
Unexplained MYSQL memory allocation
I’m running MySQL server on Linux.
I have a long-standing issue on my database server — it keeps consuming an excessive amount of memory for no clear reason. As a result, I was forced to periodically ...
0
votes
0
answers
77
views
How to fix “Access denied for user 'root'@'localhost'” in MySQL?
I'm trying to connect to my local MySQL database from PHP.
But I always get this error:
Access denied for user 'root'@'localhost' (using password: YES)
Here is my connection code:
<?php
$servername ...
0
votes
1
answer
72
views
Can this MySQL UPDATE cause a deadlock?
Let's say I have a table with a primary key id and I added a nullable int called worker_id. I have a large amount of records so I run workers in parallel. First I run
SELECT id
FROM foo
WHERE ...
- 427
0
votes
1
answer
23
views
Galera 4.24: Added option to disable application level protocol check to allow migration from MySQL to MariaDB?
The release notes at https://github.com/codership/documentation/blob/master/release-notes/release-notes-galera-26.4.24.txt say
Added option to disable application level protocol check to allow ...
- 479
1
vote
1
answer
105
views
Improve performance of full table scan in MySQL
I observed that full scan in MySQL is 10x times slower than in PostgreSQL.
More specifically - 6 sec vs 0.5 sec.
And there is no specific magic in PostgreSQL because in Oracle it is even faster - 0.2 ...
- 113
0
votes
2
answers
66
views
MySQL 8.4.6 community version hangs with waiting for handler commit
We are using MySQL 8.4.6 community edition. When we use our application which has like 1000 transactions per second with select, insert, update, delete queries. MySQL service hangs with waiting for ...
wdsanuradha
-2
votes
1
answer
100
views
MySQL-Table doesn't exists while it exists
As you can see in the picture, when I use select * from users, it tells me table doesn't exist. However, we can see the table exists by the show tables command.
Besides, I can see the .ibd and .frm ...
- 97
0
votes
3
answers
66
views
How do I backup tables separately from a hosted MySQL DB on Heroku?
I am trying to do a daily backup of a MySQL DB hosted on Stackhero (on Heroku) to a Google Cloud Storage bucket. We need to backup tables individually so that if data is corrupted / lost in a specific ...
