People who code: we want your input. Take the Survey

Questions tagged [mysql5.7]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
174 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 ...
1
vote
1answer
96 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 ...
0
votes
1answer
65 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
0answers
18 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
vote
0answers
583 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). ...
2
votes
0answers
273 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 ...
0
votes
1answer
492 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 ...
0
votes
1answer
34 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 ...
1
vote
1answer
3k 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....
1
vote
1answer
571 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 ...
0
votes
0answers
69 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 ...
0
votes
1answer
169 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....
1
vote
0answers
60 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 ...