MySQL version 8.0 - please also tag with mysql for search purposes.
0
votes
1answer
10 views
Problems Linking the max value of an attribute in a table to its primary Key
I need to extract the order_id with the max number of items, I've figured out how to extract the max value but I'm having problems linking it to the particular order_id.
PS: I'm a uni student so ...
0
votes
0answers
9 views
Bizarre MySQL Replication Connection Issue
I am configuring MySQL master-master replication (AKA master-slave replication done twice) between two servers.
After I set the master settings on each server (CHANGE MASTER TO master_hos..., etc.) ...
1
vote
1answer
17 views
Cannot set innodb_buffer_pool_size above 1023M in my.ini
Windows server 2012 R2 with 64GB RAM, MySQL 8. The Database is about 5GB.
I am using a buffer pool of 1023M, as shown below:
innodb_buffer_pool_size=1023M
If I enter anything above 1023M e.g. 1024M ...
-3
votes
0answers
78 views
select with where clause not working properly in mysql 8.0 as it is not returning anything though values are there in the single table of the database [closed]
Please follow the images,
Here the table verblist contains the value 'beat' in column baseVerb
But still on executing select query "SELECT * FROM datavaldb.verblist where baseVerb = 'beat';"
It is ...
0
votes
1answer
41 views
What's your data ETL methodology? [closed]
I think this is more like an open question: How do you do the ETL for your company?
We are using MySQL as our database management system and we have a production schema. Every month, when we received ...
0
votes
2answers
39 views
Using MySQL 8.0 “Upgrade Checker” on RDS
The MySQL 8.0 Shell came with an "Upgrade Checker".
Useful to run before upgrading, as you may detect incompatible issues with your table structure / etc.
Running its python version from the shell ...
0
votes
1answer
33 views
How to structure table in MySQL for group chat application? [closed]
I'm making a messaging application, and I need a way to organize and store messages. I was thinking something like a table that had all the group chat IDs and who was in which group chat, but MySQL ...
1
vote
1answer
28 views
How to verify if given user@host with 'password' exists in MySQL 8.0+?
I write sanity check script for an application. One of the tests is supposed to verify that a given user@host with 'password' exists in MySQL. I'm using simple native hash passwords. In MySQL5.7- ...
0
votes
0answers
21 views
MySQL 8 cannot start, when recovering from logs?
Without any reason, MySQL server not working anymore. I don't know any reason why this could happened, and don't know any actions made before this happened. What i did is just make apt update &&...
0
votes
1answer
37 views
SQL query does not recognise derived table
So I've made a simple SQL query:
SELECT companyname
FROM works w1, (
SELECT companyname,sum(salary) AS sumsal
FROM works
GROUP BY companyname
...
2
votes
1answer
31 views
Mysql temp table insert from json can't handle null values
The MySql-8 JSON_TABLE function allows you to handle JSON data as if it was a table.
I'm trying to use it to populate a temporary table using the generated table but I believe I'm hitting a bug.
...
0
votes
3answers
27 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 ...
-1
votes
0answers
18 views
Mysql - Failed to connect to MYSQL at localhost:3306
MySQL 5.7 was working well until I added a line in the my.ini.
The default character set that will be used when a new schema or table is
created and no character set is defined
character-set-...
0
votes
1answer
24 views
MySQL 8.0 Triggers Current_User not working
I have this trigger that inserts a row to a table
CREATE
DEFINER=`root`@`localhost`
TRIGGER `user_log_AFTER_INSERT`
AFTER INSERT ON `user_log`
FOR EACH ROW
BEGIN
INSERT INTO ...
0
votes
0answers
65 views
Error connecting to mysql-8.0.12 with Sequel Pro 1.1.2
I just installed mysql-8.0.12-macos10.13-x86_64 on Mac v10.13.6, but when I try to connect using Sequel Pro 1.1.2 I got his error and I can't connect to localhost
NSInvalidArgumentException
-[...
1
vote
1answer
42 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 ...
3
votes
1answer
56 views
MySQL creates tables very slow
On my home machine running Ubuntu 18.04 and MySQL version 8.0.12 with better hardware, table creation, database creation and so on are very slow. On my other computer with older hardware (slower SSD), ...
0
votes
0answers
43 views
MySQL creating database really slow
I had a problem on my MySQL server, where creating tables/databases is really slow (had to wait a couple of hours), so I reinstalled the server and MySQL from scratch, but the problem didn't go away.
...
0
votes
2answers
23 views
Where is the cache for the MySQL caching_sha2_password auth plugin stored?
Where is the cache for the new default authentication plugin caching_sha2_password in MySQL 8 stored? I want to know for future reference how to clear it in case I ever run into any problems using it.
4
votes
3answers
276 views
2
votes
1answer
75 views
MySQL 8: Truncate table stuck in `checking permissions` state for minutes
Sometimes but not always truncate table statements get stuck in checking permissions state for several minutes (up to 7-8 minutes).
I'm running MySQL 8.0.12 (for Linux on x86_64 (MySQL Community ...
0
votes
1answer
31 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
27 views
MySQL upgrading from 5.7 to 8 - Throwing strange error and won't start up
I followed the instructions on the MySQL web site and got MySQL server 8 mostly installed but it won't launch because it fails pretty quickly during the upgrade process. The apt-get portion installed ...
2
votes
2answers
31 views
unexpected additional columns
in most of my tables, command
SELECT column_name FROM information_schema.columns WHERE table_name='table'
worked as expected, but in one table i am getting additional tables that i was not expecting....
2
votes
1answer
17 views
column_name ordered same as describe table
I was under impression that default order of columns is internal mysql order but for some reason describe table and selecting column_name gives me compleatly different order.
How can I set ORDER BY ...
0
votes
1answer
40 views
MySQL MSI appears to be installing wrong (latest) MySQL version
For compatibility reasons with other software, I'm trying to install MySQL 5.6.40 on Windows 10. Any version from 5.7 onward is incompatible with my other programs.
I've been trying to use the MSI ...
1
vote
1answer
155 views
How do I create a point with an SRID in MySQL?
MySQL supports using ST_PointFromText to construct a point with an SRID,
ST_PointFromText(wkt[, srid [, options]])
Constructs a Point value using its WKT representation and SRID.
This ...
0
votes
0answers
459 views
MySQL: ROW_NUMBER() OVER PARTITION Question
I am looking to essentially recreate the ROW_NUMBER() OVER PARTITION function that I have used in SQL Server Management Studio previously to do the following in MySQL. MySQL doesn't seem to want to ...
3
votes
1answer
231 views
Why does REGEXP_REPLACE concatenate with a previous result?
This looks like strange behaviour, and I get the same on the MySQL command line as via db<>fiddle:
create table t(foo varchar(255));
insert into t (foo) values
('the quick brown fox'),
('jumped ...
3
votes
1answer
946 views
MySQL restore lost data after update from 5.7 -> 8.0.11
I have a docker-compose file where I use the official mysql:latest image as my database server.
After a docker pull mysql and a docker-compose up the image updated from 5.7 -> 8.0.11
This update ...
-3
votes
1answer
655 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 ...
8
votes
1answer
368 views
What happened to MySQL 6 & 7?
With the recent release of MySQL 8, I can't seem to find any information about why version numbers 6 and 7 were skipped. Anyone know?
3
votes
3answers
203 views
High disk IO with MySQL master-master replication
We've been evaluating an active-passive master-master replication setup for our MySQL database, running on version 8.0. While diagnosing some general slowness issues, we were surprised to see very ...
1
vote
1answer
47 views
MySQL test if function is available
Since MySQL 5.8 the function GeomFromText() is no longer available and one should use ST_GeomFromText() instead, which works exactly the same. Progress, of course :-(
Ref: https://dev.mysql.com/doc/...
