Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [mysql-5.7]

MySQL version 5.7 - please also tag with mysql for search purposes.

Filter by
Sorted by
Tagged with
0 votes
0 answers
17 views

How to enable keyring_file on replication server MySQL?

I recently activated the keyring_file plugin on my master server (5.7.44-enterprise-commercial-advanced-log), so the replication server presented errors when trying to execute alter table xxxxxx ...
alexandredelcol's user avatar
0 votes
0 answers
34 views

Query performance degrade after upgrade from MySQLv5.6 to v5.7

I upgraded the MySQL Server from v5.6 to v5.7 and since then I see query performance degrade. For example, I have the following select query that selects some columns and has a single column in the ...
msbeast's user avatar
  • 11
0 votes
1 answer
64 views

How do I convert blob to binary string?

I am trying to store bitflags in MySQL to track user permissions for certain resources. However, I am experiencing some strange behavior with the binary field type and I cannot find a way to select a ...
Cardinal System's user avatar
0 votes
0 answers
9 views

GCP Point in time recovery log storage to buckets

GCP now offers storing binary logs in Cloud Storage instead of on your MySQL disk, but for older instances, you need to disable and re-enable binary logs to start storing them in Cloud Storage. My DB ...
lankylichen's user avatar
0 votes
1 answer
55 views

What could cause replication to break on MySQL when replicating from 5.7.40 to 8.0 replica

We have a MySQL primary running on 5.7.40. We are in process of testing the upgrade to 8.0.36 (this is on AWS RDS). We had 2 MySQL-8 replicas and 2 MySQL-5.7 replicas replicating from the primary. At ...
Rahul's user avatar
  • 119
0 votes
0 answers
30 views

Performance Differences in JOIN query Between MySQL 5.7 and MySQL 8.0

Hello MySQL Community, I wanted to share some observations regarding the performance differences between MySQL 5.7 and MySQL 8.0, specifically related to join algorithms. In a recent project, I ...
Amarjit Singh's user avatar
0 votes
0 answers
25 views

Why trying to enable NULL values in a MySQL timestamp field fails?

I imported the table delete_me from the following mysqldump's exported file -- MySQL dump 10.13 Distrib 5.7.42, for Linux (x86_64) -- -- Host: 192.168.00.00 Database: main -- ----------------------...
0xC0DEGURU's user avatar
0 votes
0 answers
25 views

MySQL 5.7 on Amazon Aurora - how to read the IO Cache vs. Disk Read metric?

I'm trying to determine how often InnoDB is hitting RAM vs. disk. Does db.Cache.innoDB_buffer_pool_hits.avg mean InnoDB went to the buffer pool? Does db.Cache.Innodb_buffer_pool_reads.avg mean that ...
mstrom's user avatar
  • 133
1 vote
2 answers
39 views

Finding files a user has access to is slow when ordering

I'm working on a system where users are sorted into groups, and then those groups are applied on files. At a high level, what I need to do is to be able to pull out the 10 most recently-updated files ...
chraume's user avatar
  • 11
1 vote
1 answer
56 views

Mysql 5.7 Slave replication is Slow

We are trying to debug a slave lag issue - it is currently lagging behind the master by 24 hours. Deployed on a AWS EC2 machine Database size is around 600 GB Grows at roughly 500 MB to 1 GB per day ...
user1428716's user avatar
0 votes
0 answers
45 views

MySQL - Can FLUSH TABLES Be Triggered Automatically by MySQL Itself?

As it says in the title, I am looking to determine whether MySQL itself will, on its own, issue a FLUSH TABLES command at any point. I have yet to find anything that points to a specific answer to ...
Marisa's user avatar
  • 23
0 votes
0 answers
98 views

FIX: mysqldump: Couldn't execute '/*!80000 SET SESSION information_schema_stats_expiry=0 */

I've already asked this question in the "Stack overflow" website. I don't understand why they closed my question even if I didn't get a working solution for my setup. Why did I submit it? I'...
Edo Meloni's user avatar
0 votes
0 answers
10 views

$mysqli->change_user returns Access denied NO password

PHP 8.2.14 MySQL 5.7.23-23 - Percona Server (GPL), Release 23, Revision 500fcf5 This is on a shared webhost with CPanel. I'm importing this test script on page load... $conn = new mysqli("...
chillywilly's user avatar
0 votes
0 answers
61 views

Upgrading from MySQL 5.7 to 8

I am looking at upgrading MySQL 5.7 to MySQL 8.0 (all in AWS). I have the added benefit of a QA environment to work with, which is the obvious starting point. I ran through their article here: ...
Travis's user avatar
  • 145
1 vote
2 answers
184 views

can be NULL same as 0000-00-00 in a nullable DATETIME column while selecting rows?

I am working on some PHP code optimization and while I am going through I find some SELECT statements with the following conditions: WHERE `date_exported` = '0000-00-00 00:00:00' OR `date_exported` IS ...
ReynierPM's user avatar
  • 1,764
2 votes
1 answer
88 views

MySQL abnormal connection peak and page cleaner warnings

I'm running MySql 5.7.42 on Ubuntu 18.04 on VM with 12 Core, 64GB Ram and SSD storage. This server is dedicated as DB server, some scripts and maintenance (backups) runs nightly but no other services ...
Sbraaa's user avatar
  • 21
0 votes
1 answer
184 views

Upgrading MySQL utf8mb3 to utf8mb4 - how to replicate documentation behaviour?

I'm looking to upgrade MySQL fields from mb3 to mb4 in a large database and from reading the documentation I understand that the biggest problem is mb3 stores stuff in 3 bytes, but mb4 stores stuff in ...
KillerKode's user avatar
1 vote
1 answer
28 views

Pivot-Type Action

I have a schema that has a few tables. See below example schema and data set CREATE TABLE stk_info ( TypeId int not null auto_increment, Primary Key (TypeId), TypeName varchar(50) not null ...
Travis's user avatar
  • 145
0 votes
1 answer
27 views

Can conditionals be used in a WHERE condition?

I am working on something and found this SQL that I am not sure how to rewrite correctly, meaning using PHP PDO. The SQL looks like: $sql = 'SELECT * FROM table WHERE column ' . isset($variable) ? . '=...
ReynierPM's user avatar
  • 1,764
2 votes
1 answer
53 views

Can I update multiple columns at once with multiple conditionals?

Having the following table snippet: CREATE TABLE `some_table` ( `exp_col_1` TINYINT(1) NOT NULL DEFAULT '0', `mark_col_1_as_exported` TINYINT(1) DEFAULT '0', `exp_col_2` TINYINT(1) DEFAULT ...
ReynierPM's user avatar
  • 1,764
9 votes
1 answer
699 views

How to add index to a big table with 60M records without downtime?

we have been struggling with one issue in the past few days. We want to add an index to a huge table with 60M records. At first we tried adding it with basic mysql syntax. But it clogged our ...
Rohan's user avatar
  • 43
0 votes
0 answers
23 views

MySQL-Proxy works with HeidiSQL but not with DBeaver nor Workbench

For data analytical applications, our current development environment relies on a MySQL-Proxy (version 0.8) to connect to the MySQL data source. And the MySQL's version is 5.7.43-47-log. We noticed ...
Mike's user avatar
  • 13
1 vote
1 answer
21 views

Identify sequences of events starting at well-known start locations, end locations not predetermined, and WITH MYSQL 5.x

I'm working within the limitations of MySQL 5.x. Several security guards are responsible to walk around a property and visit checkpoints. Two specific gates permit entry and each guard must begin a &...
Newbuntudude's user avatar
0 votes
0 answers
152 views

Upgrade from MySQL 5.6 and 5.7 to MariaDB

We have several servers with MySQL 5.6.51 and several with MySQL 5.7.39. What are the right steps to upgrade to latest MariaDB LTS 10.11? I think we can't go directly to 10.11 or? MySQL 5.6.51 > ...
lear1's user avatar
  • 79
1 vote
1 answer
54 views

Will Dropping a corrupt table free up space in MySQL

We have a MyISAM Table in our database which has around 97 Gb worth of data with resulted in 95% disk utilization. Due to this we started clearing the data from the table by deleting the rows but this ...
Umang Pachaury's user avatar
0 votes
0 answers
15 views

Need to build MySQL replication with TSL cert between onPremises server as Master and Azure flex server as Slave

I have a requirement Need to build MySQL replication with TSL cert between onPremises server as Master and Azure flex server as Slave . On Master & slave host ssl is enabled . also i have followed ...
Uday Raj Gupta's user avatar
1 vote
2 answers
168 views

How to Identify Tables with Index Size Issues during MySQL 5.7 to 8.0 Migration?

I'm trying to migrate from MySQL 5.7 to MySQL 8.0 for my application's database. However, the precheck failed with an incompatibility error "25," stating that tables with redundant row ...
Abhijith Ea's user avatar
0 votes
0 answers
11 views

How Innodb Concurrency Tickets working in sorting by mysql?

Innodb concurrency tickets how reduced when the sorting performing query running? is tickets applied for sorting or not? If applied how it was calculated by mysql and is there any performance issue ...
Kannan M's user avatar
0 votes
0 answers
12 views

What is the Strategy for Rotating MySQL 5.7 certs with Active/Passive Pool?

Aside from migrating while we upgrade to 8.0, which is an option, what have people done workflow/strategy to rollout and rotate MySQL SSL credentials with zero downtime?
JShean's user avatar
  • 169
1 vote
1 answer
570 views

Moving from MySQL 5.7 to MySQL 8.0

I'm currently running MySQL 5.7 in one of the key servers. This version reaches end of life soon, so it's time to move to 8.0. Or give it a shot and jump on 8.1? This one is also running on dated ...
Marek's user avatar
  • 13
1 vote
1 answer
230 views

Restoring MySQL Database from mysqldump file produces seemingly random syntax errors

Sorry for the long title I wasn't sure how else to make it distinct from the auto-search results. I have a large-ish dump file (~44GB) and I'm trying to import this into MySQL on a different server. ...
DSZ's user avatar
  • 127
0 votes
1 answer
90 views

The most recent rows in for each type/agent

I have a table (still on MySQL 5.7) with lots of data. This table is written by some scripts. It works like a "checkin", where each agent is checking in in some period of time. It looks like ...
Marek's user avatar
  • 13
0 votes
0 answers
53 views

MySQL 5.7 - could not establish connection (every 2 months or so) - how to log / ID issue?

I have a v5.7.42 MySQL server (community) running on Ubuntu 20.04.6 LTS - My issue is about every two months or so , the site will show could not establish connection to database, service mysql status ...
James Gaul's user avatar
0 votes
0 answers
18 views

Dropping database stored with upper cases without downtime

my problem is the following. We are running a MySql server on AWS RDS and are about to upgrade from MySql 5.7 to 8.0.34. When testing this on a restored snapshot I discovered that there is a "...
northmoose's user avatar
1 vote
3 answers
541 views

Sudden spike in BinLogDiskUsage

Two days ago our MySQL RDS instance saw a sudden spike in BinLogDiskUsage, CPUUtilization, NetworkReceiveThroughput and NetworkTransmitThroughput. The result was a database that was extremely slow to ...
RED_Tom's user avatar
  • 13
1 vote
2 answers
36 views

data with underscore in it is being selected rather than being excluded

I hope someone could help me to clarify some doubts on this question. I have got a table with this schema: CREATE TABLE IF NOT EXISTS `entities` ( `id` int(6) unsigned NOT NULL, `...
Mario Raymundo's user avatar
0 votes
1 answer
213 views

Is Innodb Cluster synchronous?

I was reading the InnoDB Cluster page, but I did not find any information stating whether it's synchronous or not. Is it configurable to work in either synchronous or asynchronous mode? I currently ...
Astora's user avatar
  • 723
1 vote
1 answer
152 views

Can't use performance_schema in my mysql server

I am using AWS RDS aurora mysql 5.7 serverless but in RDS I have enabled the performance_schema parameter, I have connected my RDS to mysql workbench version 6.3 in mysql workbench when I am checking ...
Paras Sahu's user avatar
0 votes
0 answers
19 views

About error Error Code: 1872. Coordinator stopped because there were error(s) in the buffer_pool_size (s) RDS MYSQL 5.7

My replication instance is a read replica in rds Amazon, with those configurations select @@innodb_buffer_pool_size; 99857989632 SELECT @@innodb_buffer_pool_instances; 8 SELECT @@...
Marco Antonio's user avatar
0 votes
1 answer
81 views

MySQL Master Slave Asynchronous GTID Replication Failover/Switchover over ProxySQL with little downtime

This is a production setup and I have to perform a failover from Master A to new potential master B. MySQL Version is 5.7 and CentOS 7 is the OS. I have a simple master slave setup with A as Master ...
Avinash Pawar's user avatar
2 votes
1 answer
64 views

Constraint checks on multiple association tables vs. unique association table that centralizes these constraint checks

I have the following database schema (MySQL 5.7): I have assistants that may be linked to either: one customer (might evolve to multiple customers in the future, hence the association table) one or ...
Merinorus's user avatar
0 votes
2 answers
31 views

Replication Error: Last_IO_Errno: 1236 - Replicating two different channels from same master

Need little help with a production issue. Case: I had to migrate two schema from MasterA to MasterC. It would have been a simple exercise but because it was decided to migrate schema1 first and later ...
Avinash Pawar's user avatar
0 votes
1 answer
133 views

MySQL 5.7 to MariaDB 11 migration index problems

I'm having a problem with one big SQL. We're migrating a MySQL 5.7 database to a MariaDB 11, and the majority of queries are running faster, but i've problems with this one, and I don't know how to ...
Dimas's user avatar
  • 121
0 votes
0 answers
1k views

MySQL TEXT vs JSON column

We are using MySQL 5.7 and has recently introduced a new DB schema which basically stores key string and value json. Currently it is designed as CREATE TABLE foo ( key VARCHAR(124) NOT NULL, ...
rajeshnair's user avatar
1 vote
1 answer
1k views

AWS RDS MySQL upgrade from 5.7 to 8 failing due to ROW_FORMAT

We need to upgrade our DB to version 8, but we're getting an error in the migration log that's preventing us from upgrading. Creating indexes larger than 767 bytes on tables with redundant row format ...
user avatar
0 votes
0 answers
323 views

MySQL client not reading ~/.my.cnf

I have a server running MySQL 5.7.42 on Ubuntu Linux. I have a config file in ~/.my.cnf containing login info to connect to it from a shell on the same server: [client] host = localhost user = ...
Synchro's user avatar
  • 261
0 votes
1 answer
245 views

Joining Columns with different character set

I am joining two tables on varchar columns having CHARACTER SET utf8 COLLATE utf8_bin and one with CHARACTER SET latin1. Indexing is not working when i am joining these two tables on this column, I am ...
Manish Kumar's user avatar
0 votes
0 answers
87 views

MySQL System Timezone using Abbreviation (AST) vs Olson Timezone (America/Curacao)

I am working on a MySQL 5.7.41-44 instance running on a CentOS server. The Linux timezone (per timedatectl) is America/Curacao (AST, -0400). The MySQL @@system_time_zone returns AST (and not America/...
GWR's user avatar
  • 2,807
0 votes
0 answers
248 views

Mutliple sessions on commit status/ aurora_redo_log_flush event in AWS Aurora 2.11.1 - MySQL 5.7

Our database runs on Aurora 2.11.1 - MySQL 5.7 and we have enabled performance insights. It's usually runs in between 15 to 50 sessions at a given time. According to the performance insights around 20 ...
senrick's user avatar
3 votes
3 answers
1k views

MySQL 5.7.42, Gradual memory growth over time, memory leak?

I'm currently running a MySQL server (version 5.7.42) in production, and I've noticed a gradual increase in memory usage throughout the day. I suspect there might be a memory leak issue causing this ...
George's user avatar
  • 31

1
2 3 4 5
22