Unanswered Questions
1,876 questions with no upvoted or accepted answers
7
votes
1
answer
494
views
Mysql change ft_max_word_len bug
So, I have MySQL installed on my machine, and I need to change the ft_max_word_len, the maximum word length that MySQL will index. However, when I set it up via the tools provided, and query it, it ...
- 111
5
votes
1
answer
3k
views
Proper way to override Mysql my.cnf on CentOS/RHEL?
Context: I'm porting an opensource server software (and writing associated documentation) from Debian/Ubuntu to CentOS/RHEL.
For the software to run correctly, I need to add a dozen of specific ...
CommunityBot
- 1
5
votes
1
answer
7k
views
MySQL is using too much memory, and never freeing it
MySQL is using too much memory, and never freeing some of it.
Despite show full processlist show that all threads are aslept, memory usage is too high. Also I see that some mysql commands (via htop) ...
- 101
4
votes
1
answer
9k
views
MariaDB using much more memory than it should
We are using MariaDB 10.3.32 on a Ubuntu 20.04.4 machine with 6 GB of memory, about 20 applications running on it. Databases are all InnoDB.
Even with mostly default settings (see on the bottom), ...
CommunityBot
- 1
4
votes
1
answer
10k
views
Multiple files found for the same tablespace ID
After a management over-sight, the hard disk utilization of the mysql server went to 100%. In panic, I shut down most of the services - including mysqld, which I guess caused this problem. ...
CommunityBot
- 1
4
votes
1
answer
1k
views
MySQL (InnoDB) - processes waiting on futex
Currently troubleshooting a MySQL server spending a lot of time in futex syscalls. All databases are InnoDB and seeing high load on my 16 core machine, and slightly more than half of CPU time is in ...
- 182
4
votes
2
answers
5k
views
Large lag on mysql replication (Relay_Log_Pos and Exec_Master_Log_Pos does not increase)
Today my two slave's (one mysql 5.1 and second MariaDB 5.5, master is mysql 5.1) started lagging. Similar situation are quite often with lags rises to even 10000 seconds, because slaves have worse ...
CommunityBot
- 1
4
votes
0
answers
3k
views
Amazon RDS: Sudden increase in Read IOPS and Throughput
I am using Amazon RDS to host the databases for my website. I am using the large instances for both my master and my read replica. Everything was running smoothly until suddenly the Read IOPS, Read ...
- 955
4
votes
0
answers
886
views
mysql client slow login strace
I am experiencing an issue with slow connections/logins to a loaded mysql server, even when connecting via the unix socket file (CentOS 6.3). Queries are completing very quickly -- (0.00 sec) in this ...
- 835
4
votes
0
answers
6k
views
mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect
When I'm trying to install MySQL 5.5 community edition on my Ubuntu 10.04 by compiling the source code, I met the following problem:
$ fg % 1
sudo ../bin/mysqld_safe --basedir=/usr/local/...
CommunityBot
- 1
3
votes
1
answer
1k
views
XAMPP mysql (Mariadb) has become unreliable
I have used XAMPP for years in Windows without any problems, but lately, it has become unreliable due to mysql (MariaDB). In XAMPP Control Panel mysql sometimes starts alright, sometimes it will crash ...
Mica
3
votes
0
answers
796
views
After upgrade Ubuntu 18.04 to 20.04, MySQL server is not starting
I upgraded Ubuntu 18.04 to 20.04
The process upgraded MySQL 5.7 to 8.0
It instantly started to throw errors in error logs
[ERROR] [MY-013379] [Server] Server upgrade started with version 80033, but ...
- 31
3
votes
2
answers
1k
views
MySQL - Select queries 10x slower on Azure VM vs on-prem VM
We have been working on a project to migrate a MySQL database from an on-premise Linux server to a Windows VM on Azure (IaaS). (There's a specific reason because of which we have gone with the IaaS ...
- 1,408
3
votes
0
answers
5k
views
MySQL 8 InnoDB taking a long time to start
I upgrade some month ago from Ubuntu 18.04 to 20.04.
So MySQL upgrade from 5.7.33 to 8.0.23.
I notice after the upgrade that MySQL is slow to start.
2021-02-24T09:20:16.972632Z 0 [System] [MY-013172] [...
- 163
3
votes
1
answer
1k
views
MariaDB table has a metadata lock, but no blocking thread
I have a MariaDB 15.1 installed on a Debian system:
$ mariadb --version
mariadb Ver 15.1 Distrib 10.4.14-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
A script regularly loads data into ...
- 215