RolandoMySQLDBA

less info

network profile

41,735 reputation

528108

bio	website	logicworks.net/products
	location	New York, NY (USA)
	age	48
visits	member for	2 years, 3 months
	seen	8 mins ago
stats	profile views	4,586

One of JEHOVAH's Witnesses (Ex 6:2,3; 9:16; Isa 12:2,4,5)
Senior MySQL DBA (SCMDBA since 2007-08-11) with LogicWorks, provider of The Cloud Your Way (LinkedIn,Twitter,FaceBook). I currently support various MySQL Replication Topologies (Master/Slave, Master/Master, DRBD, Percona XtraDB Cluster) for Clients of Managed DB Services (Hardware and High Availability) in DB/Web/Cloud Hosting Environments (60+ MySQL Clients) since November 12, 2007.

summary answers questions tags badges favorites bounties reputation activity

98 Favorites

added views newest activity votes

42

50

votes

8

answers

23

kviews

What are the main differences between InnoDB and MyISAM?

mysql innodb myisam

dec 20 at 6:52 Max Webster 31

27

43

votes

7

answers

23

kviews

How can I optimize a mysqldump of a large database?

mysql performance innodb mysql-5 mysqldump

sep 9 '11 at 16:45 RolandoMySQLDBA 41.7k

20

41

votes

9

answers

9

kviews

Why is Database Administration so hard?

database-administration learning management

apr 11 at 17:53 RolandoMySQLDBA 41.7k

21

34

votes

14

answers

48

kviews

How can I move a database from one server to another?

mysql mysqldump migration

mar 28 at 6:19 Mat 3,340

18

31

votes

11

answers

2

kviews

How could DBAs be more 'programmer friendly'?

database-design best-practices database-administration

feb 26 at 21:57 HLGEM 2,281

13

22

votes

3

answers

22

kviews

How to safely change MySQL innodb variable 'innodb_log_file_size'?

mysql innodb

may 20 at 11:56 Sk8erPeter 103

8

20

votes

8

answers

3

kviews

Tool to generate large datasets of test data

mysql tools performance-testing

jul 3 at 15:59 Sean Thompson 21

11

17

votes

5

answers

12

kviews

How do you tune MySQL for a heavy InnoDB workload?

mysql performance innodb

jul 3 at 21:27 RolandoMySQLDBA 41.7k

14

16

votes

6

answers

10

kviews

About single threaded versus multithreaded databases performance

performance database-recommendation

sep 19 '11 at 4:13 RolandoMySQLDBA 41.7k

18

16

votes

3

answers

16

kviews

Possible to make MySQL use more than one core?

mysql performance innodb tuning

may 2 at 17:10 Neil McGuigan 949

10

15

votes

1

answer

477

views

What is the reasoning behind the CAP theorem?

database-design distributed-databases database-theory

aug 16 '11 at 20:45 Richard 2,660

10

14

votes

3

answers

8

kviews

How do you calculate mysql max_connections variable?

mysql config my.cnf max-connections

apr 26 at 13:14 Derek Downey 9,882

12

14

votes

2

answers

5

kviews

Find highest level of a hierarchical field: with vs without CTEs

mysql postgresql query hierarchical

mar 21 at 13:24 evan smith 1

4

12

votes

1

answer

687

views

MySQL : Why are there “test” entries in mysql.db?

mysql security

oct 26 at 19:22 RolandoMySQLDBA 41.7k

3

12

votes

2

answers

859

views

What can we do in MySQL 5.0 Replication to address bandwidth concerns?

mysql replication

jun 29 at 21:41 Rick James 1,519

4

11

votes

5

answers

594

views

Why do primary keys have names of their own?

sql primary-key

may 17 '11 at 2:29 RolandoMySQLDBA 41.7k

6

11

votes

3

answers

2

kviews

Is the CPU performance relevant for a database server?

mysql postgresql

apr 30 '12 at 18:21 RolandoMySQLDBA 41.7k

2

11

votes

2

answers

1

kviews

MySQL: Tree-Hierarchical query

mysql sql stored-procedures

dec 11 at 17:11 RolandoMySQLDBA 41.7k

7

10

votes

1

answer

10

kviews

Multi cores and MySQL Performance

mysql performance

dec 31 at 1:57 multibaterka 1

9

10

votes

2

answers

3

kviews

Rows missing after online conversion from MyISAM to InnoDB

mysql innodb myisam

jul 11 at 12:32 JNK♦ 8,715

6

8

votes

4

answers

5

kviews

Alternatives to MySQL Workbench

mysql tools mysql-workbench

apr 17 at 18:02 quantme 103

3

8

votes

2

answers

3

kviews

kill all queries - MySQL

mysql

may 2 '12 at 20:20 philfreo 141

3

8

votes

1

answer

3

kviews

Clarification on MySQL innodb_flush_method variable

mysql innodb

sep 10 at 15:13 RolandoMySQLDBA 41.7k

3

8

votes

4

answers

925

views

How can I optimize this MySQL query further?

mysql sql performance index optimization

aug 23 '11 at 4:24 RolandoMySQLDBA 41.7k

2

8

votes

3

answers

3

kviews

Where can I find example databases for MySQL, SQL Server and Oracle?

sql-server mysql oracle feature-comparison

mar 5 at 11:19 Mark Storey-Smith 18.9k

1

7

votes

6

answers

812

views

Alternative Database Tools for Web Admin

mysql tools

apr 27 '12 at 2:25 RolandoMySQLDBA 41.7k

2

6

votes

3

answers

14

kviews

MySQL error: Access denied for user 'a'@'localhost' (using password: YES)

mysql authentication

feb 6 at 19:26 msanford 127

2

6

votes

4

answers

4

kviews

How to improve InnoDB DELETE performance?

mysql innodb

mar 5 '12 at 7:50 Thanh Nguyen 16

1

6

votes

3

answers

946

views

Why doesn't InnoDB store the row count?

mysql innodb count

aug 11 at 22:24 RolandoMySQLDBA 41.7k

2

5

votes

2

answers

1

kviews

How can I improve my SQL statement with weekly results with week starting on Thursday or any other day of the week?

mysql sql mariadb

sep 22 '11 at 20:54 RolandoMySQLDBA 41.7k

Technology			Life / Arts	Culture / Recreation	Science	Other
Stack Overflow Server Fault Super User Web Applications Ask Ubuntu Webmasters Game Development TeX - LaTeX	Programmers Unix & Linux Ask Different (Apple) WordPress Answers Geographic Information Systems Electrical Engineering Android Enthusiasts IT Security	Database Administrators Drupal Answers SharePoint User Experience Mathematica more (14)	Photography Science Fiction & Fantasy Seasoned Advice (cooking) Home Improvement more (13)	English Language & Usage Skeptics Mi Yodeya (Judaism) Travel Arqade (gaming) Bicycles Role-playing Games more (22)	Mathematics Cross Validated (stats) Theoretical Computer Science Physics more (7)	Stack Apps Meta Stack Overflow Area 51 Stack Overflow Careers

site design / logo © 2013 stack exchange inc; user contributions licensed under cc-wiki with attribution required

rev 2013.5.24.702

Database Administrators Stack Exchange works best with JavaScript enabled