Questions tagged [mysql5.7]
21 questions
0
votes
1 answer
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 table we could not achieve that (We are using…
Miko Meltzer
- 1
- 1
0
votes
1 answer
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 unsigned integer when I query it, so it…
Vjz
- 1
- 3
0
votes
1 answer
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 mdl_backup_ids_temp;
DROP TABLE…
John Pantelidis
- 21
- 2
0
votes
0 answers
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 clones of the exact same system and hardware and…
Tuatara
- 1
0
votes
1 answer
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 pointers may be invalid and cause the dump to…
Luke Hol
- 1
- 1
0
votes
1 answer
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 process.
Hoping for earliest response
03amittrivedi
- 19
- 1
- 1
- 3