Questions tagged [mysql5.7]
The mysql5.7 tag has no usage guidance.
22
questions
2
votes
1
answer
925
views
Jira upgrade 8.19.0 cannot connect to mysql 5.7.35
I have confluence and jira running on a standalone server.
I just upgraded confluence - no problems. It runs connected to mysql and is up as we speak on the latest version.
I just updated jira but it ...
- 907
2
votes
1
answer
3k
views
Why ubuntu 20.04 cannot support mysql 5.7.33?
Today I tried to update ubuntu from 18.04 LTS to 20.04 LTS.
with do-release-uprade
After upgrade completed, I tried to start mysql with service mysql start
The result is
Job for mysql.service failed ...
2
votes
0
answers
937
views
High CPU since upgrading to MySQL 5.7 from 5.6
We are using an AWS RDS managed MySQL db.m4.2xlarge instance with db engine 5.7.30, we upgraded from 5.6 two days ago and have high CPU since - generally 10-15% higher reaching 100% at peek. Please ...
1
vote
1
answer
2k
views
Mysql greater threads running
I have my Mysql DB instance in RDS, My CPU is jumping from 50% to 100%.. Later i checked my DB threads..
I was surprised with my thread count.
SHOW STATUS WHERE variable_name LIKE "Threads_%" OR ...
- 409
1
vote
1
answer
108
views
Why is MySQL service shutting down every day almost at the same time?
I read the log file to see if there is anything specific that triggers shut down, but couldn't find it. It happens at 1.30AM almost every day, And then I need to manually restart MySQL. There are ...
- 11
1
vote
0
answers
766
views
Why does MySQL 5.7 inside a docker container always crash?
I have a MySQL 5.7 docker container that was provisioned via a docker-compose file, the file looks like this:
version: '3'
# Run command: docker compose --env-file .env.local up
services:
# ...
- 141
1
vote
2
answers
1k
views
Unable to login to my mySql server as root, and unable to reset root password
I'm trying to access and backup a mySql Database but without success. I know the root password, but if I try to login to the DB using it I get a
ERROR 1045 (28000): Access denied for user 'root'@'...
1
vote
1
answer
346
views
Create database creates a db with a #mysql50# before the name
Just in the last day, whenever I create a new database, it is prepending the database name with:
#mysql50#
And I am unable to connect to this database. Im having real issues on our PROD server as we ...
- 111
1
vote
0
answers
3k
views
MySql Slave Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.00116, end_log_pos 8631
I have Active-Passive-Master-Master replication setup in Mysql with version 5.7.
I found the below error in MySql2 (passive Master server) but the status show it's in sync with Master server (mysql1).
...
- 11
1
vote
0
answers
130
views
Error while adding MySql Plugin
OS- Ubuntu 16.04
Mysql Version- 5.7
Getting error while installing plugin into Mysql ex.
INSTALL PLUGIN QUERY_RESPONSE_TIME_AUDIT SONAME 'query_response_time.so';
check plugin directory
show ...
- 643
1
vote
1
answer
8k
views
Constant problems with php-fpm, CPU usage 100% non-stop (No visitors even)
We are running two servers one for the application and one for the DB and some other software to keep the load off from the application's server, we are running CentOS and the latest version of PHP (7....
- 11
0
votes
0
answers
197
views
MySQL service stuck in starting state after restoring database failed
I was restoring a MySQL database using the import wizard, importing from dump files. This took a while but in doing so the disk ran out of space so never finished importing.
Now, the MySQL57 service ...
0
votes
1
answer
126
views
mysql -V shows a different version than mysqld -V
I'm running centos 7 with mySQL 5.7.xxx. mysql -V shows Ver 14.14 Distrib 5.7.26-29, but mysqld -V shows Ver 5.7.11-4. systemctl status mysql and systemctl status mysqld both show the same running ...
- 103
0
votes
1
answer
227
views
Converting a Medium Sized Database from one charset to another with minimal downtime
Our company (small business) had recently taken on new business in an APAC region which requires us to support 4 bit characters across our MySQL 5.7 DB.
This requirement means that we need to convert ...
- 101
0
votes
1
answer
497
views
Mysql - Data_free value in a table cannot be decreased
We have a large MySQL5.7 production table.
We try to decrease the Data_free value.
We normally just run the Optimize command on various database tables to shrink it to 7MG size.
However, with one ...
0
votes
1
answer
502
views
Monitoring Byte Usage of Large MySQL InnoDB Buffer Pools?
I am trying to monitor the total number of used bytes in a MySQL 5.7 InnoDB Buffer Pool, that can go up to 100GB, using Innodb_buffer_pool_bytes_data but it seems that this status variable is a 32-bit ...
- 1
0
votes
1
answer
314
views
Dropped temporary table still exist on the MySQL DB
I am using Azure Database for MySQL server with the MySQL version 5.7 .The issue that I am dealing is that when I am trying to drop a temporary table with these commands :
DROP TEMPORARY TABLE ...
0
votes
0
answers
23
views
MYSQL missing days of entries
I have a production POS running UBUNTU 16.04 with MYSQL Ver 14.14 Distrib 5.7.32, for Linux (x86_64) using EditLine wrapper
Today the system lost all records between Jan 04 - Jan 09.
I have various ...
- 1
0
votes
1
answer
2k
views
MySQL crashes after upgrade to mysql 8
After we upgraded our database to MySQL 8, one query stopped working and is causing the database to crash.
MySQL version 8.0.19, before: 5.7
Error.log output:
Trying to get some variables.
Some ...
- 1
0
votes
1
answer
97
views
How to upgrade mysql5.5 to 5.7
I have a MYSQL Server 5.6 on ubuntu 14.04, having more than 2000 databses.
Now we have to upgrade it to MYSQL version 5.7. Kindly let me know how can i take backup of this huge data & upgrade ...
0
votes
0
answers
249
views
Perl script slower on other server compared to dev (with same spec)
I'm trying to figure out why a Perl script I have, isn't performing anywhere near as well once I put it on the live server.
The whole script is identical on both servers (one is a test server, the ...
- 1,184
0
votes
1
answer
347
views
Cannot change max_connections in mysql 5.7
Any ideas why I cannot change max_connections in MySQL. The stack is: Ubuntu 14.04 and MySQL 5.7.15
mysql> select @@global.open_files_limit;
+---------------------------+
| @@global....
