User Ran - Database Administrators Stack Exchange

bio	website	Commun.it
	location
	age
visits	member for	1 year, 9 months
	seen	Feb 18 at 14:44
stats	profile views	16

	409 reputation	bio	website	Commun.it	visits	member for	1 year, 9 months
416 badges		location			seen	Feb 18 at 14:44

4

votes

1

answer

3

kviews

What can cause TRUNCATE TABLE to take a really long time?

jul 9 '12 at 22:48 RolandoMySQLDBA 42.9k

4

votes

2

answers

332

views

MySQL - Changing DB CHARACTER SET

mysql character-set

dec 3 '11 at 20:22 Community♦ 1

3

votes

3

answers

515

views

What are the limits on the amount of slaves per master?

mysql replication mysql-5.5

jul 24 '12 at 0:24 Rick James 1,529

1

3

votes

2

answers

2

kviews

MySql recommended hardware

mysql

mar 15 '12 at 18:30 RolandoMySQLDBA 42.9k

3

votes

1

answer

2

kviews

MySql - ERROR 1071 Specified key was too long; max key length is 1000 bytes while restoring dump

mysql mysqldump

jan 23 '12 at 16:52 RolandoMySQLDBA 42.9k

1

3

votes

2

answers

2

kviews

MySql - How can I speed up this query

mysql performance query index query-performance

jan 6 '12 at 20:11 RolandoMySQLDBA 42.9k

1

2

votes

2

answers

2

kviews

MySql - changing innodb_file_per_table for a live db

mysql innodb

jun 10 at 21:59 RolandoMySQLDBA 42.9k

2

votes

1

answer

227

views

MySQL - Installing InnoDB Plugin

mysql innodb

may 2 at 15:07 Nick Chammas 5,958

2

votes

1

answer

795

views

MySql - Changing expire_logs_days without restarting the server

mysql replication mysql-5.5

nov 11 at 14:00 Community♦ 1

2

votes

2

answers

153

views

MySQL - How much physical space will be reduced by changing the column type?

mysql mysql-5.5 mysql-5

aug 23 at 16:59 RolandoMySQLDBA 42.9k

2

votes

3

answers

757

views

MySQL backup with no downtime

mysql backup mysql-5.5

jul 17 '12 at 11:45 Lena Weber 51

2

votes

3

answers

213

views

MySQL - Master/Slave Replication with different server specs

mysql replication innodb database-administration

may 17 '12 at 23:15 Rick James 1,529

2

votes

2

answers

2

kviews

MySql - Read only on slave

mysql replication

mar 7 '12 at 16:15 RolandoMySQLDBA 42.9k

1

2

votes

2

answers

160

views

MySql - find redundant indexes

mysql index

jan 26 '12 at 21:21 Baron Schwartz 667

2

votes

2

answers

3

kviews

MySQL - fastest way to ALTER TABLE for InnoDB

mysql innodb alter-table

dec 27 '11 at 17:42 RolandoMySQLDBA 42.9k

1

vote

2

answers

573

views

MySql - partition by range and unique key

mysql partitioning unique-key

feb 18 at 9:21 sudhanshu sirohia 1

1

vote

1

answer

38

views

MySql include partition key in index?

mysql index index-tuning

feb 3 at 7:09 Shlomi Noach 2,300

1

vote

2

answers

102

views

How can I improve this query

mysql query query-performance

oct 31 at 20:06 Ross Smith II 136

1

vote

1

answer

92

views

MySql - selecting into file and re-loading it with special characters

mysql mysql-5.5

oct 23 at 12:44 Shlomi Noach 2,300

1

vote

1

answer

153

views

MySql - How can I improve this query?

mysql query query-performance

apr 30 '12 at 16:10 RolandoMySQLDBA 42.9k

2

1

vote

2

answers

3

kviews

MySql - Clean ibdata1

mysql innodb ibdata

apr 19 '12 at 13:11 RolandoMySQLDBA 42.9k

1

vote

1

answer

288

views

MySQL Replication: Slave with Different Column From Master

mysql replication

dec 30 '11 at 2:53 RolandoMySQLDBA 42.9k

1

vote

5

answers

548

views

MySQL Replication monitoring [closed]

mysql replication tools monitoring

dec 27 '11 at 23:37 tarnfeld 144

0

votes

1

answer

163

views

MySql - Global index

mysql index partitioning

feb 12 '12 at 22:10 Jonathan 689

0

votes

0

answers

388

views

MySql shell command not replicated to slave - “LOAD DATA INFILE”

mysql replication

jan 16 '12 at 16:22 Ran 409

0

votes

4

answers

321

views

MySQL - speed up execution of ALTER TABLE

mysql character-set

dec 3 '11 at 17:15 Craig Efrein 1,613

Ran

26 Questions