Profile Activity

Abdul Manaf

Meta user

Network profile

Reputation

8,011

8k
6.5k
5k

2016
2017
2018
2019

Top tag

mysql

Next privilege

10,000 Rep.

Access moderator tools

Badges

Newest

Yearling

Next badge

0/1

Impact

69 posts edited

0 helpful flags

251 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

49 Questions

Views Newest Activity Votes

votes

answer

112k

views

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

mysql innodb

Nov 4 '16 at 7:16 Community♦ 1

votes

answers

46k

views

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

mysql innodb

Nov 12 at 6:44 Rick James 49.6k

votes

answers

26k

views

What to set innodb_buffer_pool and why..?

mysql innodb

Jun 28 '18 at 3:32 Ajay Gupta 1

votes

answers

25k

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,837

votes

answers

35k

views

How do you remove fragmentation from InnoDB tables?

mysql innodb mysql-5.5

Aug 27 '12 at 17:25 Community♦ 1

votes

answers

15k

views

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

mysql replication

Aug 10 '17 at 8:10 John aka hot2use 10.1k

votes

answer

10k

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

Oct 25 '16 at 19:31 gdolenc 1

votes

answers

30k

views

MySQL Replication Error

mysql replication

Oct 21 at 10:24 sepideh nejat 11

votes

answers

views

Setting Circular Replication in mysql

mysql replication

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

votes

answer

10k

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

votes

answers

views

Optimize queries from MySQL SP/Triggers/Functions

mysql stored-procedures trigger functions

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

votes

answers

views

Ibdata usage and Recommendations?

mysql innodb ibdata

Feb 22 '12 at 18:00 Community♦ 1

votes

answers

views

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

mysql mysql-5.6

Jul 15 '18 at 8:03 Wilson Hauck 920

votes

answers

views

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

mysql mysql-5.5

Feb 26 '16 at 11:16 Menuka Ishan 121

votes

answer

18k

views

statistics State in MySQL Processlist

mysql query-performance transaction mysql-5.1

Mar 19 '15 at 0:01 Community♦ 1

votes

answer

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,261

votes

answers

269

views

Optimize MySQL Query using LEFT JOIN

mysql optimization

Dec 20 '13 at 7:15 Community♦ 1

votes

answer

views

Master and Slave having same id's

mysql replication mysql-5

Dec 7 '11 at 17:34 RolandoMySQLDBA 152k

votes

answers

14k

views

Partitioning a table will boost the performance?

mysql innodb

Mar 21 '18 at 16:53 Jens 103

votes

answer

views

How to improve MySQL Server Performance..?

mysql performance index mysql-5.5 optimization

Aug 4 '17 at 21:35 RolandoMySQLDBA 152k

votes

answer

views

Delete data from huge InnoDB table from MySQL Master and Slaves

mysql replication performance innodb delete

Jul 8 '17 at 20:01 RolandoMySQLDBA 152k

votes

answer

499

views

MySQL Stress testing issues?

mysql mysql-5.5 mysqlslap

Apr 11 '13 at 5:44 Community♦ 1

votes

answers

views

Creating Archiving database for old data in MySQL

mysql replication mysql-5.5

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

votes

answer

views

How to recover a crashed innodb table…?

mysql innodb

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

votes

answers

views

Problem with InnoDB “per table” file sizes

mysql innodb

Jan 18 '12 at 19:10 RolandoMySQLDBA 152k

votes

answers

views

MySQL Server is Restarting automatically after some minutes

mysql

May 1 '18 at 19:17 Community♦ 1

votes

answer

545

views

How we can enable `index_condition_pushdown`?

mysql optimization configuration mysql-5

Apr 12 '18 at 22:12 Evan Carroll 41.4k

votes

answers

views

MySQL Full Text index issue

mysql myisam full-text-search

Sep 6 '17 at 2:55 RolandoMySQLDBA 152k

votes

answers

549

views

MySQL Cluster Installation

mysql mysql-cluster

Feb 2 '14 at 2:45 Joarder Kamal 113

votes

answers

154

views

Convert to Self JOIN

mysql query-performance optimization

Nov 7 '13 at 14:30 ypercubeᵀᴹ 83.3k

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..?

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

How do you remove fragmentation from InnoDB tables?

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

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 ?

Optimize queries from MySQL SP/Triggers/Functions

Ibdata usage and Recommendations?

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

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

statistics State in MySQL Processlist

Does `Seconds_Behind_Master` show exact Slave Lag from Master?

Optimize MySQL Query using LEFT JOIN

Master and Slave having same id's

Partitioning a table will boost the performance?

How to improve MySQL Server Performance..?

Delete data from huge InnoDB table from MySQL Master and Slaves

MySQL Stress testing issues?

Creating Archiving database for old data in MySQL

How to recover a crashed innodb table…?

Problem with InnoDB “per table” file sizes

MySQL Server is Restarting automatically after some minutes

How we can enable `index_condition_pushdown`?

MySQL Full Text index issue

MySQL Cluster Installation

Convert to Self JOIN