Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mysql-5.7]

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

1098 questions
3
votes
1 answer

mysql 5.7.9-log set session mode gives warning about NO_AUTO_CREATE_USER is deprecated

When changing the session mode in mysql 5.7 I get the following warning. "(Code 3090): Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release." I don't exactly understand what it means. Is mysql removing the…
Chris Muench
  • 701
  • 5
  • 14
  • 34
2
votes
1 answer

Unexplained Read IO

I have been wrestling with a problem for the last week or so and I am hoping someone can help point me in the right direction. We have a mysql database (version 5.7.19) running on an NFS volume - the table we are having trouble with is using myisam…
MikeS
  • 21
  • 2
2
votes
1 answer

Unknown column in Having Clause

Getting this apparently nonsensical error Error code: 1054 Unknown column in having Clause while running this query Select date(START_TS), resource_key, count(INTERACTION_RESOURCE_ID) From tableName Group By date(START_TS), resource_key Having…
kestrel
  • 23
  • 1
  • 3
2
votes
4 answers

MySQL 5.7 + InnoDB: mysqld is CPU bound, with ever increasing memory usage

[ADDED ANSWER 2019-10-08] I've posted an answer to this question. tl;dr: Force MySQL to use jemalloc or tcmalloc. I recently upgraded from 5.5.25-rc (very old install), through 5.5.62, then 5.7.27. At the same time, I made the decision to migrate…
rowan194
  • 31
  • 6
2
votes
0 answers

MySQL Workbench: Unable to CREATE/UPDATE table from valid SELECT

I have an SQL SELECT statement of the form: SELECT a.date, a.count FROM ( SELECT d.date, x.count + y.count - z.count AS count FROM date_table d LEFT JOIN ( SELECT date, count FROM caluculated_table_x ) x ON d.date = x.date LEFT JOIN…
James Clubbe
  • 21
  • 1
1
vote
1 answer

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 ); INSERT INTO stk_info (TypeName) VALUES…
Travis
  • 145
  • 6
1
vote
0 answers

MySQL 5.7: Understanding SIGINT, KILL, and DECLARE HANDLER

I'm reading the documentation for MySQL 5.7 and I would like to know how to write a Stored Procedure that gracefully terminates when requested by the user. It seems like CTRL-C or SIGINT only kills the statements on the client end, and the…
Sam
  • 11
  • 2
1
vote
0 answers

MySQL occurring responds "Error 9001: Max connect timeout" even root account

We face a strange experience. There is the MySQL we are running on GCP. The metrics (current connection count, CPU, memory, IO, and disk) aren't abnormally high. After 06:25:01, all our connections respond with "Error 9001: Max connect timeout". I…
Sammy Lin
  • 11
  • 1
1
vote
2 answers

Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='

After I changed both table collition into utf8mb4_unicode_ci, the database still show this error: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' when I execute this query: select * from…
Dolphin
  • 775
  • 4
  • 18
  • 34
1
vote
1 answer

Use subquery result in parent query case statement

I have a hauls table that has columns id location_id completed_at and others. I would like to add a column to the query results that has the days since the previous completed haul. This query returns the expected results: SELECT `h`.*, ( …
Brian Kidd
  • 13
  • 4
1
vote
0 answers

MySQL Community edition as windows cluster role

I wanted to know if we can add MySQL Community edition instance as clustered role in Windows Failover Cluster. I worked on MySQL 5.7 Enterprise edition setup as clustered role in a 2 node WSFC cluster. Never worked on a similar setup for community…
udhayan dharmalingam
  • 373
  • 1
  • 4
  • 14
1
vote
1 answer

MySQL 5.7.34 not disabling STRICT_TRANS_TABLES whatever I do

I'm trying to disable STRICT_TRANS_TABLES on MySQL 5.7.34 and, no matter what I do, the option is always enabled. I put manually on my.cnf sql_mode=NO_ENGINE_SUBSTITUTION and no other modes, when I restarted the service, the SELECT…
Leandro Jacques
  • 153
  • 7
1
vote
1 answer

Getting catagory title total number of questions and answers order by number of questions

I have three tables. Which is in at this fiddle, http://sqlfiddle.com/#!9/4cadb2 Which is like this?. CREATE TABLE `user_answers` ( `id` int(250) NOT NULL, `question_id` varchar(250) NOT NULL, `user_id` int(250) NOT NULL, `answer` text NOT…
arunwebber
  • 69
  • 1
  • 12
1
vote
1 answer

MySQL 5.7 High Memory usage

I have a setup with MySQL 5.7 and the following configuration: [mysqld] innodb_buffer_pool_size=2GB innodb_buffer_pool_instances=2 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock bind-address =…
Lucas Basquerotto
  • 111
  • 5
1
vote
1 answer

innodb_table_stats length mismatch

This is very strange. I just copied all the binary files from one server to another. The new server comes up just fine with one exception. I keep getting this error message in my log every couple minutes... 2018-09-06T01:27:56.710923Z 284261 [ERROR]…
Glenn J. Schworak
  • 119
  • 1
  • 5
1
2 3