User mysql_user

0 votes

Speedup DROP huge MySQL replicated table

answered Sep 19, 2022 at 6:21

0 votes

How to find which transaction is being rolled back

answered Nov 12, 2021 at 7:02

1 vote

Accepted

Redundant argument in printf at /usr/bin/pt-table-checksum

answered Aug 8, 2017 at 19:15

2 votes

Does innodb_flush_log_at_trx_commit = 1 wear out SSDs more than innodb_flush_log_at_trx_commit = 2?

answered Nov 25, 2016 at 6:02

0 votes

Is there a slave configuration that stops replication of mysql.mysql and grants?

answered Nov 22, 2016 at 2:06

0 votes

file sql.gz give error 1064 when import in phpmyadmin

answered Nov 15, 2016 at 12:27

1 vote

Mysql database offline-online synchronization

answered Nov 8, 2016 at 5:24

0 votes

Backing up Master-Master replicated MySQL databases

answered Oct 12, 2016 at 13:33

1 vote

Unable to change innodb_buffer_pool_size MySQL 5.6 in CentOS 6.7

answered Oct 8, 2016 at 16:34

3 votes

Accepted

How password can be prompted in percona xtrabackup

answered May 3, 2016 at 6:09

0 votes

commit statement missing for a dml statement in binary log

answered Mar 30, 2016 at 16:49

1 vote

mysql large number of opened tables -- what does this mean and how can I reduce?

answered Mar 30, 2016 at 8:23

0 votes

Accepted

Alter table add column like another column syntax

answered Mar 29, 2016 at 6:39

1 vote

Accepted

at the moment mysqldump (22 minutes exec time, 5 GB Dump), when to use xtrabackup?

answered Feb 25, 2016 at 8:58

5 votes

Is it safe to "FLUSH STATUS" in mysql?

answered Feb 22, 2016 at 5:23

0 votes

Accepted

Accidentally executed reset master on the live server

answered Jan 26, 2016 at 7:56

1 vote

Accepted

Mysqldump.exe Unknown option --no-beep

answered Dec 21, 2015 at 10:50

1 vote

Optimizing a simple query on a large table

answered Dec 20, 2015 at 16:00

1 vote

Why do innodb tables get corrupted so easily?

answered Dec 19, 2015 at 13:29

0 votes

Accepted

How to handle temporal datatype columns when doing upgrade from 5.5 to 5.6

answered Dec 18, 2015 at 14:54

2 votes

Is there any danger in granting SUPER privileges to a user?

answered Dec 18, 2015 at 13:25

4 votes

Accepted

Slave can not handle replication events with the checksum that master is configured to log

answered Dec 18, 2015 at 11:02

0 votes

MySQL Database Archive

answered Dec 17, 2015 at 17:28

0 votes

master-master replication or master slave replication?

answered Dec 17, 2015 at 11:41

2 votes

Join two SELECT results with the same post_id value

answered Dec 17, 2015 at 11:14

2 votes

How to reset slave without over write of master dump in mysql

answered Dec 17, 2015 at 11:12

1 vote

Accepted

Master Slave database syncronization

answered Dec 17, 2015 at 7:10

0 votes

I have following two MySQL queries and i want to execute it inside one procedure

answered Dec 7, 2015 at 6:44

1 vote

Automatically purging binlogs after successful replication

answered Dec 6, 2015 at 4:30

0 votes

mysql replication master - slave

answered Dec 4, 2015 at 14:16

Stack Exchange Network

111 Answers

Speedup DROP huge MySQL replicated table

How to find which transaction is being rolled back

Redundant argument in printf at /usr/bin/pt-table-checksum

Does innodb_flush_log_at_trx_commit = 1 wear out SSDs more than innodb_flush_log_at_trx_commit = 2?

Is there a slave configuration that stops replication of mysql.mysql and grants?

file sql.gz give error 1064 when import in phpmyadmin

Mysql database offline-online synchronization

Backing up Master-Master replicated MySQL databases

Unable to change innodb_buffer_pool_size MySQL 5.6 in CentOS 6.7

How password can be prompted in percona xtrabackup

commit statement missing for a dml statement in binary log

mysql large number of opened tables -- what does this mean and how can I reduce?

Alter table add column like another column syntax

at the moment mysqldump (22 minutes exec time, 5 GB Dump), when to use xtrabackup?

Is it safe to "FLUSH STATUS" in mysql?

Accidentally executed reset master on the live server

Mysqldump.exe Unknown option --no-beep

Optimizing a simple query on a large table

Why do innodb tables get corrupted so easily?

How to handle temporal datatype columns when doing upgrade from 5.5 to 5.6

Is there any danger in granting SUPER privileges to a user?

Slave can not handle replication events with the checksum that master is configured to log

MySQL Database Archive

master-master replication or master slave replication?

Join two SELECT results with the same post_id value

How to reset slave without over write of master dump in mysql

Master Slave database syncronization

I have following two MySQL queries and i want to execute it inside one procedure

Automatically purging binlogs after successful replication

mysql replication master - slave