Questions tagged [mysql-8.0]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
12 views

mysql 8 high availability with drbd, corosync and pacemaker

I would like to implement High Availability for MySQL8, is this version supported by drbd, heartbeat, corosync, pacemaker? I've looked around online to that regard but there isn't much information ...
1
vote
2answers
62 views

mysql 8.0 in-memory table slow insert

Please help with following strange issue.I defined in memory table but insert of 600.000 rows takes 13 minutes and causes heavy write to disk. The CPU is underutilized and I have enough free memory. ...
1
vote
0answers
8 views

MySQL 8.0.18 - ST_Area returns invalid value

I have a problem with ST_Area function in MySQL 8.0.16. The result of the procedure call returns a different result than any library used to calculate the area of a polygon. Example: I have a ...
0
votes
1answer
17 views

problem to import load data infile

I am trying to load data into mysql database form text file. LOAD DATA LOCAL INFILE 'P:\file.txt' INTO TABLE table_january FIELDS TERMINATED BY '\t' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ...
0
votes
1answer
20 views

mysql complex procedure debugging

I have below stored procedure which i would like to debug but its not throwing any errors into error table.This stored procedure is run by event manager on every minute. Here is the process : I ...
2
votes
0answers
69 views
+250

What kind of complications would I face downgrading from MySQL 8 to MySQL 5?

Let's assume I wanted to downgrade to from MySQL 8 to MySQL 5.7. I know this isn't supported, but what kind of complications am I likely to encounter. The docs say, The only supported alternative ...
0
votes
0answers
17 views

How import document when fixed width?

I need to import into a table files with TXT format and delimited by fixed width. I'm trying to model a script to perform bulk import, and I'm not able to declare.
0
votes
1answer
20 views

MySQL ERROR 1064 (42000) insert via bash script (RHEL)

MySQL Server: 8.0.16 Commercial OS: RHEL 7.5 I have written a simple script, to insert certain information into a database table. Following is my script # cat ~mysqldba/bin/connections.sh #!/...
1
vote
2answers
783 views

Changing Data Directory on MySQL 8

Need: To store / accesses dbTable data from a separate drive not the default I was using MySQL 5.7 so far & as specified in the solution - Link1 I added the my.ini file with the info as stated &...
0
votes
1answer
20 views

Percona Server - binlog not automatically purge with mysqladmin flush-logs

I have a little problem and I need your help please. Here is the story : I have Percona Server in version 8.0.13 with one slave and the old binlogs on master are not deleted automatically when flush-...
0
votes
1answer
16 views

Innodb cluster options missing

I have successfully installed and run an INNODB Cluster on mysql 8.0.19 However I cannot set options for the cluster when we run cluster=dba.getCluster(); cluster.options(); We get the following ...
0
votes
2answers
27 views

Upgrade all MySQL columns, tables, and databases from utf8mb3 to utf8mb4

I have thousands of columns across hundreds of tables in about a hundred databases inside a MySQL instance that need to be upgraded from utf8mb3 to utf8mb4. Is there a way to generate ALTER ...
2
votes
2answers
17 views

Is there a way to construct SQL statement to return desired value only if there is a single row found, and return 0 otherwise?

Consider below: SELECT customer.contact.id FROM customer.contact WHERE customer_office_id = [INTEGER] If only a single row is returned, I want the result set to return ...
-1
votes
2answers
137 views

MySQL 8 is slower than MySQL 5.7

select * from Some_Table used to work fine in MySQL 5.7. With the same data (around 2 million rows) in MySQL 8.0 it is taking double the time. We have upgraded from 5.7.26 to 8.0.17 and are seeing ...
0
votes
1answer
35 views

Mysql 8 accidentally lost ROOT user all privileges in localhost wampserver 3.2

Mysql 8 root user all privileges lost.I changed some permissions from phpmyadmin. . After that all tables disappeared. I found this answer Lost All Privileges in MYSQL.but did'nt help me. I am using ...
-2
votes
0answers
45 views

Why does using table alias in JOIN clause causes syntax error, when it didn't do so before?

How would you explain peculiarity where SQL used to work before and now does not: SELECT * FROM employee.user staff LEFT JOIN support.groups groups ON staff.group_id = groups.group_id Gives ...
0
votes
0answers
37 views

MySQL Group Replication - Peer address is not valid

I have been trying to set up an MySQL Innodb Cluster, initially with two databases, both MySQL 8.0.19. But I keep getting the same errors. On the first one (username@1.2.3.4:3306), I have created ...
1
vote
2answers
29 views

mysql innodb index: better one big or many compact?

I've a question for an expert in how innodb indexes are structured (mysql 8.0.18) Say I have 4 varchar columns on a table with one billion rows: country, state, city, attraction I have queries ...
0
votes
1answer
9 views

MySql8 Trailing String comparison

I am planning an upgrade of a legacy MySQL5.6 Database to MYSQL8.0.19 database. All my testing has been successful but have one issue preventing me from going live. By default in MYSQL5.6 the ...
0
votes
1answer
37 views

How optimization select in Msql 8? [closed]

i have a problem with optimization select on Mysql ver 8.0.17 I'd like to optimize a query that takes 60 seconds to run the first time, but when I run it the second time it takes less than a second (...
0
votes
1answer
15 views

Migration path for IDENTIFIED BY PASSWORD 'password_hash' when removed in MySQL 8

We have a solution where the management of users to a MySQL database is automated. Today we use MySQL 5.6 but we want to move to MySQL 8. According to https://docs.oracle.com/cd/E17952_01/mysql-8.0-...
-2
votes
2answers
7k views

How to set lowercase_table_name

I've been trying to setup lower_case_table_names for ages in MySQL 8.0 without success. What is the procedure to set this up in 8.0? In previous versions of mysql I was able to override the variable ...
0
votes
2answers
60 views

How to select all columns plus one alias column in MySQL

It is a simple question, but i could not find the answer. I want to select all the columns in my table with a SELECT * statement, but i also need to alias a UUID column this way: BIN_TO_UUID(ID) as ...
0
votes
0answers
241 views

I can't start mysqld.service -> status : Data Dictionary upgrade from MySQL 5.7 in progress in centos 7

I've installed mysql 8 on centos 7 and when i want to start the mysqld service , it says : Job for mysqld.service failed because the control process exited with error code. See "systemctl status ...
2
votes
1answer
484 views

Install mysql-shell from apt repository

I want to install and configure a high availability cluster for Mysql 8. To automate that, I want to use use apt repository (via ansible). My servers are debian jessy (8) distribution. I succesfully ...
0
votes
2answers
76 views

Mysql 8: count(*) on INT primary is 13500 times slower than supposed to be. any innodb dev here?

I am aware there are many questions on this topic, mysql has not improved much on these single-query performance bugs in the past years but my case is more unusual. If mysql would access the table ...
0
votes
1answer
57 views

MySQL CURDATE() and CURRENT_TIMESTAMP return different value?

I am facing a little confusion because of CURRENT_DATE value and CURRENT_TIMESTAMP value shows different date on MySQL. Scenario : 1) User calls API from Lumen backend to insert data on a table. One ...
0
votes
1answer
24 views

how to enalbe MySQL 8 innodb_dedicated_server option

Initially, I was looking for tuning the MySql 8 instance then I found that there is something like autoconfiguration feature added with the 8th version. Then I visited the official MySQL website for ...
3
votes
2answers
137 views

MySQL incorrectly saying serverID non unique when adding an instance to the InnoDB cluster

I Get the following error when adding the second instance to a MYSQL Innodb Cluster ERROR: Cannot add instance 'XXX' to the cluster because it has the same server ID of a member of the cluster. ...
0
votes
1answer
345 views

get row/value by primary key number

I'm writing my own python wrapper on top of official mysqldb connector. I'm trying to design method that would dynamically extract row data knowing KEY ID. SELECT * FROM cameras; +----------+--------...
0
votes
1answer
241 views

Wrong InnoDB table status (Size/Rows) after updating from MySQL 5.7 to 8

I've upgraded from Mysql 5.7 to 8 on Ubuntu 18.04 Made it by guide, very accurate, on a new empty server, checked all error/warning logs and fixed it. Everything works just fine with it. I have 2 ...
0
votes
1answer
35 views

Comparison and creating new column

Table A > - Product#|Customer|state|Type Glasses |mr. Xyz | MN |Instore Glasses |mr. abc | MN |Instore perishables|mr. abc12| TN |Instore N-perishables|mr. abc122| ...
1
vote
2answers
141 views

IN clause not working on mysql 8.0.17

I was on mysql:8.0.15 and I updated to mysql:8.0.17 On 8.0.15 ... and (col1, col2) in (('a', 'b')) the query return results, this is what I expect On 8.0.17 the same query with same data return 0 ...
3
votes
1answer
91 views

Increased disk consumption after upgrading to MySQL 8

I have a MySQL 8 DB in AWS RDS, and after upgrading from MySQL 5.7 to 8 a couple months ago, we have noticed free disk space being consumed at a very rapid rate, at least double the previous rate. ...
0
votes
1answer
31 views

Joining two select statements

Im using MySql 8.0 and I've been exercising a lot of quries but this one I cant seem to figure it out. I need to join somehow two select statements that I've written and they display the correct ...
0
votes
1answer
43 views

SSL Configuration fails with a warning MySQL 8.0

Hi I am trying to set up a MySQL server 8.0.16 on RHEL 7.5. The configuration I am willing to include for this server contains SSL related options. The MySQL server is initialized but with a warning ...
0
votes
0answers
9 views

NDB cluster cant create new table. Error code:1005

While creating a new table i am getting Error code 1005. Here is my query: CREATE TABLE `ps_subscription_persistence_1` ( `id` varchar(40) NOT NULL, `packet` varchar(204) DEFAULT NULL, KEY `...
0
votes
2answers
64 views

MySQL Coalesce date missing results, why?

Running MySQL 8.0.16, settings left at defaults as far as I know. I have a table, let's call it the_table, with columns id: bigint primary key auto_increment the_time: datetime I have a record ...
1
vote
1answer
57 views

Restoring a mysqldump loses user privileges for routines?

When I try and restore a mysqldump, the user privileges against some routines are missing. From what I can tell that is happeneing the routines that are in schemas that are loaded after the mysql ...
0
votes
0answers
24 views

InnoDB Cluster Error

Is anyone encountered this error "Unable to join the group: peers not configured" in creating Innodb cluster? or I need to configure group replication first? I follow the documentation step by step ...
0
votes
1answer
338 views

MySQL - Blank fields in tab-delimited .txt file causing errors in LOAD DATA INFILE

I am working with MySQL 8.0 through MySQL Workbench on a Windows machine. I am having an enormous amount of problems importing an excel file into a MySQL database. I think the problem is that my data ...
0
votes
0answers
7 views

MySQL 8.0 appending unknown character to column

I'm inserting a CSV files into MySQL 8.0 using Python 3.7: bulk_insert_sql = "LOAD DATA LOCAL INFILE filename.csv INTO TABLE table_name FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' IGNORE 1 ...
0
votes
0answers
28 views

Error importing MySQL/Percon server tablespace for individual tables

I am using Percona-Server 8.0.x and I am following percona xtraback documentation. https://www.percona.com/doc/percona-xtrabackup/8.0/xtrabackup_bin/restoring_individual_tables.html I am exporting ...
1
vote
1answer
76 views

RDS MySQL 8.0.16 has empty “INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS” table

On aws RDS I have an mysql 8.0.16 instance running. My problem is now, that the INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS table is empty. This is a problem for me because I would like to create ...
-3
votes
1answer
52 views

From a backup strategy perspective, would it be efficient to use a relational DB (as MySql) and a document oriented DB (as MongoDB) in the same app?

I am developing an app where I need to store an undetermined number of properties for any given entity, for example: Entity || # of properties** Apples || 14 Oranges || 4 Pears |...
0
votes
0answers
20 views

Applying batch of row changes (delete) MySQL Replication Stuck

I am using Master Slave replication for master and slave . Master Configuration 64 GB RAM 2 TB SSD Slave Configuration : 16 GB RAM 2 TB SSD My database size is 750 GB. When i configured ...
-1
votes
1answer
155 views

Every Attempt at Error Handling Fails with GET

UPDATED (12.3.2019) I'm using MySQL 8.x and every attempt at putting any error handling that provides internal details fails on the "GET" (red highlight) stating: GET is not valid at this position ...
1
vote
1answer
408 views

MySQL Error seems unfixable: Index column size too large

I'm getting: ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes. There are many questions about this here, I tried many of them. No luck. My context: MySQL 8.0.13 ...
0
votes
3answers
2k views

MYSQL 8.0 server not found in Workbench directory in Windows 10?

I have upgraded my workbench to 8.0CE and also removed the previous 5.7 MYSQL server as well as Workbench 6.3. This is the directory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE Also when I typed ...
3
votes
2answers
82 views

How to store values that include numbers and strings? Example: 1.25, trace, not applicable, etc

I created a database for nutritional table information. This database have values like carbohydrates, protein and fats of a food (there is a total of 28 fields). The problem is that there are special ...

1 2 3 4 5