User Abdul Manaf

58

68

votes

1

answer

130k

views

What is the best way to reduce the size of ibdata in mysql?

mysql innodb

Nov 4 '16 at 7:16 Community♦ 1

29

35

votes

5

answers

58k

views

How to estimate/predict data size and index size of a table in MySQL

mysql innodb

Nov 12 '19 at 6:44 Rick James 61.6k

21

22

votes

2

answers

31k

views

What to set innodb_buffer_pool and why..?

mysql innodb

Jun 28 '18 at 3:32 Ajay Gupta 1

7

16

votes

2

answers

19k

views

Difference between row-based and statement-based replication in MySQL?

mysql replication

Aug 10 '17 at 8:10 John K. N. 13.5k

24

15

votes

2

answers

26k

views

What is the Best Way to create MySQL Master-Slave Replication Setup and Troubleshoot it?

mysql replication mysql-5

Aug 4 '15 at 19:00 oNare 2,974

15

14

votes

2

answers

36k

views

How do you remove fragmentation from InnoDB tables?

mysql innodb mysql-5.5

Aug 27 '12 at 17:25 Community♦ 1

2

8

votes

1

answer

15k

views

Getting Error : [Err] 1615 - Prepared statement needs to be re-prepared with MySQL 5.6.30

mysql mysql-5.6 view dynamic-sql prepared-statement

May 11 '20 at 7:33 Community♦ 1

11

8

votes

4

answers

39k

views

MySQL Replication Error

mysql replication

Apr 5 '20 at 12:13 Paul White♦ 60.9k

2

7

votes

2

answers

9k

views

Setting Circular Replication in mysql

mysql replication

May 8 '12 at 1:35 Aaron Brown 4,822

5

6

votes

1

answer

11k

views

What memory should be given to the variables of my.cnf ?

mysql database-recommendation mysql-5.1

Dec 5 '11 at 8:22 Kris 103

2

5

votes

1

answer

22k

views

statistics State in MySQL Processlist

mysql performance transaction mysql-5.1 query-performance

Jun 29 '20 at 16:00 Rick James 61.6k

1

5

votes

3

answers

11k

views

Changing a variable using SET GLOBAL doesn't impacts sessions variable?

mysql mysql-5.6

Jul 15 '18 at 8:03 Wilson Hauck 1,456

5

votes

2

answers

1k

views

Optimize queries from MySQL SP/Triggers/Functions

mysql stored-procedures trigger functions

Dec 31 '13 at 7:32 Abdul Manaf 8,921

1

5

votes

2

answers

6k

views

Ibdata usage and Recommendations?

mysql innodb ibdata

Feb 22 '12 at 18:00 Community♦ 1

4

votes

1

answer

5k

views

How to improve MySQL Server Performance..?

mysql performance index mysql-5.5 optimization

Oct 22 at 15:31 carloslozada 21

4

votes

2

answers

18k

views

Partitioning a table will boost the performance?

mysql innodb

Mar 21 '18 at 16:53 Jens 103

1

4

votes

3

answers

11k

views

“Could NOT find Curses” error when installing MySQL from source

mysql mysql-5.5

Feb 26 '16 at 11:16 Menuka Ishan 121

1

4

votes

1

answer

3k

views

Does `Seconds_Behind_Master` show exact Slave Lag from Master?

mysql replication mysql-5.1

Oct 30 '14 at 19:30 Eric Leschinski 1,311

4

votes

4

answers

294

views

Optimize MySQL Query using LEFT JOIN

mysql optimization

Dec 20 '13 at 7:15 Community♦ 1

2

4

votes

4

answers

9k

views

Creating Archiving database for old data in MySQL

mysql replication mysql-5.5

Mar 23 '12 at 17:00 Mark D 1,031

2

4

votes

2

answers

3k

views

Problem with InnoDB “per table” file sizes

mysql innodb

Jan 18 '12 at 19:10 RolandoMySQLDBA 167k

4

votes

1

answer

4k

views

Master and Slave having same id's

mysql replication mysql-5

Dec 7 '11 at 17:34 RolandoMySQLDBA 167k

2

3

votes

1

answer

6k

views

Delete data from huge InnoDB table from MySQL Master and Slaves

mysql replication performance innodb delete

Jul 8 '17 at 20:01 Community♦ 1

3

votes

1

answer

601

views

MySQL Stress testing issues?

mysql mysql-5.5 mysqlslap

Apr 11 '13 at 5:44 Community♦ 1

1

3

votes

1

answer

7k

views

How to recover a crashed innodb table…?

mysql innodb

Feb 8 '12 at 10:02 Abdul Manaf 8,921

2

votes

2

answers

7k

views

MySQL Server is Restarting automatically after some minutes

mysql

May 1 '18 at 19:17 Community♦ 1

2

votes

1

answer

637

views

How we can enable `index_condition_pushdown`?

mysql optimization configuration mysql-5

Apr 12 '18 at 22:12 I Support The Boycott 51k

1

2

votes

2

answers

1k

views

MySQL Full Text index issue

mysql myisam full-text-search

Sep 6 '17 at 2:55 RolandoMySQLDBA 167k

1

2

votes

3

answers

579

views

MySQL Cluster Installation

mysql mysql-cluster

Feb 2 '14 at 2:45 Community♦ 1

2

votes

1

answer

3k

views

Optimize MySQL Self JOIN Query

mysql performance optimization query-performance

Nov 7 '13 at 14:35 Community♦ 1

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

49 Questions

What is the best way to reduce the size of ibdata in mysql?

How to estimate/predict data size and index size of a table in MySQL

What to set innodb_buffer_pool and why..?

Difference between row-based and statement-based replication in MySQL?

What is the Best Way to create MySQL Master-Slave Replication Setup and Troubleshoot it?

How do you remove fragmentation from InnoDB tables?

Getting Error : [Err] 1615 - Prepared statement needs to be re-prepared with MySQL 5.6.30

MySQL Replication Error

Setting Circular Replication in mysql

What memory should be given to the variables of my.cnf ?

statistics State in MySQL Processlist

Changing a variable using SET GLOBAL doesn't impacts sessions variable?

Optimize queries from MySQL SP/Triggers/Functions

Ibdata usage and Recommendations?

How to improve MySQL Server Performance..?

Partitioning a table will boost the performance?

“Could NOT find Curses” error when installing MySQL from source

Does `Seconds_Behind_Master` show exact Slave Lag from Master?

Optimize MySQL Query using LEFT JOIN

Creating Archiving database for old data in MySQL

Problem with InnoDB “per table” file sizes

Master and Slave having same id's

Delete data from huge InnoDB table from MySQL Master and Slaves

MySQL Stress testing issues?

How to recover a crashed innodb table…?

MySQL Server is Restarting automatically after some minutes

How we can enable `index_condition_pushdown`?

MySQL Full Text index issue

MySQL Cluster Installation

Optimize MySQL Self JOIN Query