Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql5.7]

21 questions
2
votes
1 answer

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 says it cannot connect to the…
John
  • 887
  • 4
  • 15
  • 25
2
votes
1 answer

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 because the control process exited with error…
Tron Natthakorn
  • 21
  • 3
2
votes
0 answers

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 can you help us understand the reason for this?…
Edward Spencer
  • 21
  • 2
1
vote
0 answers

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 variables like 'plugin_dir'; And its showing…
sanjayparmar
  • 633
  • 8
  • 19
1
vote
0 answers

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: # Database db_hm: image: mysql:5.7 volumes: …
Budianto IP
  • 141
  • 6
1
vote
1 answer

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'@'localhost' (using password: YES) error. I tried to…
simonelippolis
  • 53
  • 6
1
vote
1 answer

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 create a new database often. Please see the image…
Courtenay
  • 111
  • 3
1
vote
0 answers

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). 'Last_Error: Could not execute Update_rows event…
Sam89
  • 11
  • 4
1
vote
1 answer

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.3), Nginx (1.17.9), Percona MySQL (5.7), Redis,…
Ibrahim S
  • 11
  • 1
  • 3
1
vote
1 answer

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 variable_name = "Connections" The output for the…
Manikandan Ram
  • 399
  • 2
  • 15
0
votes
0 answers

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 other the live one). Both are running this version…
Andrew Newby
  • 1,102
  • 2
  • 25
  • 58
0
votes
1 answer

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.open_files_limit | +---------------------------+ | …
Evgeniy Solomanidin
  • 1
  • 1
0
votes
0 answers

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 is stuck in a "Starting" state even after a…
Omar Ebrahim
  • 1
0
votes
1 answer

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 database. SELECT @@version in the client shows…
Chris Strickland
  • 103
  • 2
0
votes
1 answer

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 our database from one charset to…
Alex Bailey
  • 101
  • 1
1
2