New answers tagged

0

For MySQL 8.0, you need the REPLICATION_SLAVE_ADMIN Privilege to run CHANGE MASTER TO. Please make sure you login as root@localhost on the Slave Server to run it.


1

You may find significant relief with these suggestions for your my.cnf [mysqld] section innodb_buffer_pool_size=32G # from 104G because you have 16.8G of data innodb_buffer_pool_instances=16 # from 64 should be adequate innodb_lru_scan_depth=100 # from 1024 to conserve 90% CPU cycles used for function. Posting to pastebin.com and sharing the links of ...


1

You will never be allowed to alter any tables used by RDS Services. They are managed by Amazon. I see you logged in as admin@'%' but Amazon has shielded their source-compiled version of mysqld from allowing anyone to change their managed tables. Even if SHOW GRANTS; says you have all privileges, you really don't. I have mentioned this years ago (See ...


4

GRANT has no option for password anymore in mysql 8 see manual CREATE USER 'username'@'localhost' IDENTIFIED BY 'strong password'; GRANT ALL ON *.* TO 'username'@'localhost';


0

innodb_buffer_pool_load_at_startup = ON Tells the server to reload the buffer_pool at startup. This causes a lot of I/O in a short period of time. Its goal is to make the subsequent queries a little faster, but that may or may not be worth it. If this is a cloud service, they probably do some regular maintenance, perhaps a backup, at the about the same ...


4

What you dump using mysqlbinlog --verbose MyPc-bin.000003 --database StackOverflow > C:\test\binlog.txt, that is, the file C:\test\binlog.txt, is not a binary log, so you cannot use it as the source for the binlog command. What you should do is this: mysqlbinlog MyPc-bin.000003 --start-position=89925 --stop-position=90568 | mysql -uroot That is, you need ...


0

One way to fix the warning is to make sure there are no indexes on columns that may be longer than 767 bytes. For example: VARCHAR(255) is a common choice for a string column, but if you use the utf8mb4 character set, this can be up to 255 * 4 or 1020 bytes. You would need to shorten this column to VARCHAR(191) so the max length of the string is 191 * 4 or ...


1

I have found out the problem. When MySQL 8.0 inverted latitude and longitude, it didn't invert the structure of the geometry itself, but only the representation in spatial functions. I suppose this information is available somewhere in the documentation, but I personally wasn't able to find anything that clearly states that the change from 5.7 to 8.0 only ...


2

An alternative method to that suggested above would be to do the following (fiddle here): CREATE TABLE user ( id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, email VARCHAR (256) NOT NULL ); The number of fields is irrelevant, since you won't be grouping by them. This is just a sample for demonstration purposes. Then: CREATE TABLE login_history ( lh_id ...


1

Rate Per Second = RPS Suggestions to consider in your my.cnf [mysqld] section, to help avoid OOM Killer. innodb_parallel_read_threads=0 # from 4 because you only have 2 CPU's today open_files_limit=35000 # from 40000 to allow OS to use other 5,000 reported by ulimit -a temptable_max_mmap=32M # from 1G since you only have 4G total temptable_max_ram=32M # ...


0

The problem was solved by transferring data to a partition table with the parameter ROW_FORMAT=COMPRESSED.


0

It's not possible to make a Percona MySQL server 8.0 join a Percona XtraDB Cluster, regardless of version. The 8.0 server has to be Percona XtraDB, otherwise it won't have the necessary Galera libraries and bindings.


0

change settings in my.ini or mysql.ini also there is a CPU command in kernel or core of server that lets you allocate CPU resource in the amount of percentage you want. UTF8 is a variable length encoding. If 4 bit per character isn't issue in terms of storagewise, you may consider; UTF8 to UTF8MB4 (supports emoji and more characters) Also Please move from ...


Top 50 recent answers are included