Questions tagged [mysql-5.7]
MySQL version 5.7 - please also tag with mysql for search purposes.
1,078
questions
1
vote
1
answer
156
views
Is MySQL Community Server 5.7.11 compatible with SLES 11 SP3?
According to the MySQL download page for the MySQL Community Server there are only binaries available for SLES 12.
My question is if the MySQL Community Server 5.7.11 [and higher] is compatible with ...
- 679
1
vote
1
answer
938
views
MySQL can't connect using private IP address [closed]
I have a fresh install of MySQL 5.7 on my Windows machine. When I make a connection using root@localhost, I am able to connect, but when i try to make a connection [email protected] (the private IP ...
- 305
1
vote
1
answer
883
views
Slower running Query with better Filter?
mysql> SELECT *
FROM history_uint h
WHERE h.itemid='1825689'
ORDER BY h.clock DESC
LIMIT 2 OFFSET 0 ;
Empty set (0.00 sec)
Explain:
id: 1
...
- 217
3
votes
2
answers
14k
views
MySQL 5.7 - Disable use of SSL connection
For some reason when setting up a server with MySQL 5.7, it was created to use SSL connections:
have_ssl=YES,
have_openssl =YES
There is no SSL configured in my.cnf.
How can I disable this option? ...
- 81
6
votes
2
answers
3k
views
MySQL 5.7 + Ubuntu 14.04 eating up my RAM
I've recently installed MySQL 5.7.11 in my Ubuntu 14.04.3 system following these instructions: http://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/
Being totally empty and not being called by any ...
- 63
0
votes
1
answer
83
views
MySQL - design help for scale
I will be using Amazon Web Services RDS service to host a MySQL 5.7 server (Currently AWS do not support 5.7, but they have announced they are working on implementing this version and it will be out ...
- 305
2
votes
1
answer
783
views
MySQL best performance settings [closed]
I am going to do some performance tests on MySQL server as I want to evaluate how MySQL behaves in some situations. MySQL is the only (additional) software installed on my server (Windows Server 2012),...
- 21
1
vote
1
answer
3k
views
MySQL: Enabling innodb_undo_tablespaces
We recently tried setting innodb_undo_tablespaces=2 for our mysql 5.7 server. But during the restart the server returned with:
[ERROR] InnoDB: Expected to open 2 undo tablespaces but was able to ...
- 609
0
votes
1
answer
553
views
MySQL 5.7 not accepting values of innodb_buffer_pool_instances greater than 1
I've been tweaking the values of the buffer pool size (innodb_buffer_pool_size) and the number of buffer pool instances (innodb_buffer_pool_instances) in the my.ini initialization file to optimize ...
- 1
0
votes
1
answer
3k
views
What is the best way to store SSH fingerprints and public keys?
I'm building a virtual Keyring in our DB to allow users to store PGP/GPG public keys with relation to email addresses so that they can optionally encrypt all communications our system sends them. I'm ...
- 506
0
votes
3
answers
2k
views
show variables - Unknown column 'value' in 'where clause'
In mysql I ran the below:
mysql> SHOW VARIABLES where variable_name = 'character_set_database';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-----...
- 119
4
votes
1
answer
1k
views
How do MySQL 5.7 virtual columns differ from views?
Starting reading point: https://www.percona.com/blog/2015/04/29/generated-virtual-columns-in-mysql-5-7-labs/
Running some tests with the most recent percona 5.7 they seem to work well. Explain plans ...
- 5,253
0
votes
1
answer
117
views
First Insert is skipped by the trigger
I am facing a very strange issue as i have implemented a trigger on tableA which does encrypt data and insert data to another tableB and update column to 4 digit.
The issue is First insert is somehow ...
- 1,440
2
votes
1
answer
3k
views
How can I get the MySQL super_read_only setting to work?
I can't seem to get the new super_read_only configuration option to work. Logged in as root or a user with SUPER privileges, I can still insert a row. If the user doesn't have super privileges, I get ...
- 121
3
votes
2
answers
3k
views
Release MySQL Memory and Performance Tunning
I am new to the MySQL database. I have recently installed MySQL 5.7 and configured the my.ini file. Please find the below copy of the file.
The server is a dedicated server for MySQL database and the ...
- 31
4
votes
1
answer
4k
views
Migrating/Upgrading a MySQL 5.1 schema to MySQL 5.7 schema
I'm bit green on MySQL upgrades, but my question has to do with single schemas (dbs). I have some hosted databases on a server using MySQL 5.1 Community, and I currently use mysqldump to back those ...
- 41
1
vote
0
answers
3k
views
MySQL 5.7 InnoDB is extremely slow on spatial data compared to MySQL 5.6
I have a table area which contains ~300,000 rows. It is defined as follows:
CREATE TABLE `area` (
`area_id` bigint(20) NOT NULL AUTO_INCREMENT,
`boundary` geometry NOT NULL,
`name` varchar(255) ...
- 111
1
vote
0
answers
80
views
how to migrate seemlessly from information_schema to sys/performance_schema
I am migrating my mysql 5.5 application to 5.7.9.
One thing that I'm picking my head about, is mapping the new performance_schema to the old information_schema, specifically for the following queries:...
- 266
3
votes
1
answer
8k
views
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 ...
- 701
5
votes
2
answers
5k
views
What's the difference between mysql-community-server and mysql-community-server-minimal?
I just downloaded the first GA release of MySQL 5.7, and noticed that the RPM bundle comes with two versions of the MySQL server package:
mysql-community-server-5.7.9-1.el7.x86_64.rpm
mysql-community-...
- 698
8
votes
1
answer
5k
views
Install MySQL for Windows from .zip and reset root password
I wanted to have on my PC (with Windows 8.1 x64) the MySQL server only, without Workbench or something. So I downloaded .zip archive from dev.mysql.com/downloads. It's a download for Win64 on x86_64 ...
- 427
6
votes
4
answers
38k
views
"Your password has expired" after restart mysql when updated mysql 5.7.8-rc(debian)
echo time login in mysql shell it shows:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
and error log shows:
Your password has expired. ...
- 71
4
votes
2
answers
6k
views
Connection to MySQL fails via PHP while command-line works fine
I have a script to install MySQL 5.7 and run tests on Travis CI (running Ubuntu 12).
The script contains these lines, to install MySQL in non-interactive mode, with no password:
add-apt-repository '...
- 698
2
votes
1
answer
795
views
MySQL 5.7 upgrade
I'm currently running a system with a 5.6 MySQL database and I'm considering upgrading it to 5.7.
Do you think that upgrading it will be a good step? I do want to keep my software as up to date as ...
- 157
2
votes
1
answer
4k
views
session sql mode + default sql mode
I am testing my application in mysql 5.7 and have some code that doesn't work with ONLY_FULL_GROUP_BY ON. I will fix this in a later release. I found a way to turn this off for just my application by ...
- 701
14
votes
1
answer
74k
views
invalid default value (mysql 5.7) for timestamp field
EDIT:
When updating an existing database from mysql 5.6 and executing:
UPDATE phppos_register_log SET shift_end = '2015-01-01 00:00:00' WHERE shift_end = '0000-00-00 00:00:00';
This produces:
#1292 ...
- 701
1
vote
3
answers
2k
views
MySQL 5.7 - Where is the mysql_secret file on Windows 7?
I've just installed a copy of MySQL 5.7 for testing, and I love the fact that it now only creates a single root account, and puts the password into a file called .mysql_secret.
There's just one ...
- 2,086
1
vote
1
answer
459
views
mysql multi-source replication to single slave from Debian repo's?
I've been experimenting with mysql 5.7's feature to backup multiple sources to a single slave, but have legacy db's on source servers where I'm not sure if upgrading to 5.7 will break things, and also ...
- 111