User jynus

58 votes

Accepted

MySQL - varchar length and performance

answered Sep 13, 2014 at 13:42

46 votes

Accepted

What is mysql_native_password?

answered Jun 13, 2018 at 11:54

29 votes

Accepted

MySQL: Which join is better between left outer join and inner join

answered Aug 4, 2014 at 8:43

25 votes

Accepted

Difference between transaction log and redo log in MySQL

answered Aug 1, 2014 at 7:58

20 votes

Accepted

What's the difference between MySQL Fabric and MySQL Cluster

answered Oct 11, 2014 at 18:49

15 votes

Accepted

What is InnoDB Buffer Usage and how to clear it?

answered Mar 5, 2015 at 14:43

15 votes

Accepted

Using mysql's load infile to only populate certain columns

answered Jul 4, 2014 at 7:59

15 votes

Accepted

Benefits of Barracuda and Compression

answered Jul 5, 2014 at 20:28

15 votes

Accepted

How to set MySQL binlog retention in hours?

answered May 13, 2018 at 18:10

12 votes

Accepted

MariaDB - "ERROR 1205 ... Lock wait timeout exceeded; ..." when doing multiple parallel UPDATEs affecting different rows

answered May 9, 2018 at 18:50

12 votes

Can't default date to CURRENT_TIMESTAMP in MySQL 5.5

answered Mar 22, 2016 at 8:33

11 votes

MySQL Explain has different row count than slow query log

answered Aug 8, 2014 at 16:12

11 votes

Accepted

Best way to implement concurrent table based queue

answered Apr 20, 2015 at 19:44

10 votes

Accepted

Alias using "AS" and without using "AS"

answered Mar 20, 2015 at 10:02

10 votes

mysql replication on windows server

answered Aug 8, 2014 at 7:40

9 votes

Difference between On Delete Cascade & On Update Cascade in mysql

answered Aug 22, 2014 at 8:02

9 votes

Mysql enable remote connection in centos,my.cnf does not have bind-address to comment out

answered Sep 15, 2014 at 6:58

9 votes

Accepted

Multiple concurrent connections to same large SQLite file on a network share

answered Apr 10, 2019 at 14:38

8 votes

Accepted

Why do so many queries have aliases?

answered May 17, 2015 at 10:55

8 votes

How does MySQL/InnoDB caching work internally when you perform two similar, but not identical, select requests?

answered Dec 29, 2016 at 16:03

8 votes

Accepted

MATCH AGAINST one character words returns empty rows with ft_min_word_len = 1

answered Sep 16, 2014 at 8:32

8 votes

Accepted

Is there any performance difference in using a unique index on primary key?

answered Sep 2, 2014 at 16:28

8 votes

Appropriate use of mysql Optimize Table

answered Sep 17, 2014 at 15:13

8 votes

Accepted

Simple query is slow on 4M-rows table

answered Nov 14, 2014 at 14:04

8 votes

InnoDB import performance

answered Jul 30, 2014 at 15:20

8 votes

Accepted

Are there benefits to using more than 4 CPUs for MySQL?

answered Jul 10, 2014 at 22:21

8 votes

Accepted

how to change mysql table auto_increment primary key

answered Jul 13, 2014 at 1:32

8 votes

Master-master Replication with 3 Nodes

answered Jul 22, 2014 at 13:19

7 votes

Disable MySQL binary logging with log_bin variable

answered Jul 30, 2014 at 16:24

7 votes

Accepted

UPDATE query with JOIN taking forever

answered Aug 7, 2014 at 12:09

Stack Exchange Network

421 Answers

MySQL - varchar length and performance

What is mysql_native_password?

MySQL: Which join is better between left outer join and inner join

Difference between transaction log and redo log in MySQL

What's the difference between MySQL Fabric and MySQL Cluster

What is InnoDB Buffer Usage and how to clear it?

Using mysql's load infile to only populate certain columns

Benefits of Barracuda and Compression

How to set MySQL binlog retention in hours?

MariaDB - "ERROR 1205 ... Lock wait timeout exceeded; ..." when doing multiple parallel UPDATEs affecting different rows

Can't default date to CURRENT_TIMESTAMP in MySQL 5.5

MySQL Explain has different row count than slow query log

Best way to implement concurrent table based queue

Alias using "AS" and without using "AS"

mysql replication on windows server

Difference between On Delete Cascade & On Update Cascade in mysql

Mysql enable remote connection in centos,my.cnf does not have bind-address to comment out

Multiple concurrent connections to same large SQLite file on a network share

Why do so many queries have aliases?

How does MySQL/InnoDB caching work internally when you perform two similar, but not identical, select requests?

MATCH AGAINST one character words returns empty rows with ft_min_word_len = 1

Is there any performance difference in using a unique index on primary key?

Appropriate use of mysql Optimize Table

Simple query is slow on 4M-rows table

InnoDB import performance

Are there benefits to using more than 4 CPUs for MySQL?

how to change mysql table auto_increment primary key

Master-master Replication with 3 Nodes

Disable MySQL binary logging with log_bin variable

UPDATE query with JOIN taking forever