User Gordan Bobić

5 votes

TRUNCATE TABLE statement sometimes hangs

answered Nov 27, 2021 at 12:14

4 votes

Mysql Database optimize suggestions

answered Apr 26, 2020 at 17:26

4 votes

Almost unique constraint in MySQL

answered Jun 11, 2020 at 9:16

3 votes

Accepted

MySQL: Queries limitations per host/user

answered Apr 29, 2020 at 11:26

3 votes

Accepted

Are newly inserted data automatically stored in InnoDB buffer pool

answered Apr 30, 2020 at 13:04

3 votes

Accepted

what files should I exclude/add/copy mysql dbs (without mysqldump)

answered May 10, 2020 at 15:39

2 votes

Large MySQL database dump/restore

answered May 2, 2020 at 11:58

2 votes

ZFS Tunings for PostgreSQL

answered Apr 29, 2020 at 16:30

2 votes

How can I use the same primary key across multiple tables as a foreign key?

answered Apr 26, 2020 at 23:41

2 votes

Accepted

MySQL replication master-slave

answered Apr 27, 2020 at 8:32

2 votes

Accepted

MyISAM around 5x slower than InnoDB

answered May 20, 2020 at 16:30

2 votes

How mysql database performance can impact by different types of disk[hard disks]

answered May 29, 2020 at 19:49

2 votes

Accepted

All queries waiting for query cache lock

answered Aug 21, 2022 at 11:57

2 votes

How do I find out what's causing processes to wait for table flush?

answered Sep 24, 2022 at 9:02

2 votes

How does Database Snapshots Work (MySQL)?

answered Jun 14, 2020 at 22:27

2 votes

How can I determinate the pc specs I need for my database?

answered Jun 20, 2020 at 21:15

2 votes

Accepted

Latest version to support MySQL 5.1.69 ib* files

answered Oct 25, 2020 at 14:36

1 vote

Is it a good practice to use index hints in production code?

answered Oct 28, 2020 at 14:18

1 vote

Accepted

Is it ok for MySQL to always use 18-25% of Memory (I have 2 GB Ram)?

answered Jun 14, 2020 at 21:06

1 vote

Accepted

Does MySQL use its index metadata to optimize COUNT(*) queries?

answered Oct 14, 2020 at 21:25

1 vote

Why MySQL tends to use more and more swap while there is enough RAM?

answered Oct 15, 2020 at 7:22

1 vote

MySQL High Memory / Threads - Ubuntu

answered Sep 19, 2020 at 7:56

1 vote

Swap Usage but high Freeable memory

answered Sep 19, 2020 at 18:53

1 vote

Large MySQL import stuck at "Waiting for table flush"

answered Sep 24, 2022 at 8:53

1 vote

Prometheus High Memory and CPU Usage in PMM

answered Jun 10, 2021 at 20:54

1 vote

Max allowed packet changed still replication not starting

answered May 22, 2022 at 11:22

1 vote

How to monitor slow queries time on Mariadb

answered Jul 29 at 20:07

1 vote

AWS iops vs disk iops?

answered May 30, 2020 at 10:51

1 vote

MySQL migration physical server VMware virtual server

answered May 23, 2020 at 21:01

1 vote

MySQL master to master race conditions, do I need to use transactions/locks for this code?

answered May 13, 2020 at 19:59

Stack Exchange Network

68 Answers

TRUNCATE TABLE statement sometimes hangs

Mysql Database optimize suggestions

Almost unique constraint in MySQL

MySQL: Queries limitations per host/user

Are newly inserted data automatically stored in InnoDB buffer pool

what files should I exclude/add/copy mysql dbs (without mysqldump)

Large MySQL database dump/restore

ZFS Tunings for PostgreSQL

How can I use the same primary key across multiple tables as a foreign key?

MySQL replication master-slave

MyISAM around 5x slower than InnoDB

How mysql database performance can impact by different types of disk[hard disks]

All queries waiting for query cache lock

How do I find out what's causing processes to wait for table flush?

How does Database Snapshots Work (MySQL)?

How can I determinate the pc specs I need for my database?

Latest version to support MySQL 5.1.69 ib* files

Is it a good practice to use index hints in production code?

Is it ok for MySQL to always use 18-25% of Memory (I have 2 GB Ram)?

Does MySQL use its index metadata to optimize COUNT(*) queries?

Why MySQL tends to use more and more swap while there is enough RAM?

MySQL High Memory / Threads - Ubuntu

Swap Usage but high Freeable memory

Large MySQL import stuck at "Waiting for table flush"

Prometheus High Memory and CPU Usage in PMM

Max allowed packet changed still replication not starting

How to monitor slow queries time on Mariadb

AWS iops vs disk iops?

MySQL migration physical server VMware virtual server

MySQL master to master race conditions, do I need to use transactions/locks for this code?