Profile Activity

Derek Downey

Meta user

Network profile

Reputation

19,265

19.3k
16.2k
13.2k

2016
2017
2018
2019

Top tag

mysql

Next privilege

20,000 Rep.

Access 'trusted user' tools

Badges

Newest

Good Answer

Next badge

39/50

Impact

262 posts edited

120 helpful flags

1,354 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

19 Questions

Views Newest Activity Votes

104

votes

answers

169k

views

How to safely change MySQL innodb variable 'innodb_log_file_size'?

May 17 at 22:02 Rick James 46.9k

votes

answers

31k

views

Function Performance

postgresql best-practices plpgsql

Jul 24 at 13:28 Erwin Brandstetter 102k

votes

answers

15k

views

Is it common practice to mix InnoDB and MyISAM tables on same server?

mysql innodb myisam storage-engine

Apr 7 '14 at 18:08 Community♦ 1

votes

answer

12k

views

Clarification on MySQL innodb_flush_method variable

mysql innodb

Sep 10 '12 at 15:13 RolandoMySQLDBA 148k

votes

answers

36k

views

What is the difference between MySQL VARCHAR and TEXT data types?

mysql database-design datatypes

Oct 7 '13 at 6:36 Community♦ 1

votes

answers

views

What is the purpose of SET NULL in Delete/Update Foreign Keys constraints?

foreign-key null

Sep 22 '11 at 12:23 Jonas 12k

votes

answers

views

Speeding up conversion of MyISAM to InnoDB

mysql-5 storage-engine

Aug 16 '11 at 5:13 RolandoMySQLDBA 148k

votes

answers

views

Is it unwise to run replication on same physical server?

mysql replication myisam

Sep 7 '17 at 18:40 RolandoMySQLDBA 148k

votes

answer

views

How to setup local database development process for small web team?

best-practices development

Feb 9 '12 at 17:48 ConcernedOfTunbridgeWells 16.2k

votes

answers

views

Dynamic SQL in MySQL stored routines

mysql stored-procedures trigger

Aug 11 '17 at 21:18 RolandoMySQLDBA 148k

votes

answers

12k

views

How to improve InnoDB DELETE performance?

mysql performance innodb delete

Aug 7 '17 at 16:51 Paul White♦ 58.5k

votes

answers

views

How can you stop MySQL slave from replicating changes to the 'mysql' database?

mysql replication

Oct 13 '12 at 8:32 Community♦ 1

votes

answers

views

How to convert control characters in MySQL from latin1 to UTF-8?

mysql character-set

Jan 10 '12 at 21:12 atxdba 3,948

votes

answer

788

views

PostgreSQL partition hierarchy design for centralized logging

postgresql partitioning

Dec 16 '11 at 9:37 Jack Douglas♦ 29.6k

votes

answers

views

When to use MySQL query_cache?

mysql performance

Aug 31 '11 at 15:27 Sam Brightman 201

votes

answer

views

What are some important MySQL status variables to keep an eye on? [closed]

mysql monitoring

Jan 7 '11 at 6:40 Brian Ballsun-Stanton 4,223

votes

answers

views

Is there a way to have MySQL GROUP BY utilize trailing whitespace?

mysql

Mar 8 '11 at 2:26 Brad Mace 284

votes

answers

views

How does Oracle handle composite index lookups?

oracle index

Oct 6 '11 at 15:37 Community♦ 1

votes

answers

389

views

Is there any reason not to use Percona 'innodb_fast_checksum'?

innodb percona-server

Feb 16 '12 at 16:50 Derek Downey 19.3k

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

19 Questions

How to safely change MySQL innodb variable 'innodb_log_file_size'?

Function Performance

Is it common practice to mix InnoDB and MyISAM tables on same server?

Clarification on MySQL innodb_flush_method variable

What is the difference between MySQL VARCHAR and TEXT data types?

What is the purpose of SET NULL in Delete/Update Foreign Keys constraints?

Speeding up conversion of MyISAM to InnoDB

Is it unwise to run replication on same physical server?

How to setup local database development process for small web team?

Dynamic SQL in MySQL stored routines

How to improve InnoDB DELETE performance?

How can you stop MySQL slave from replicating changes to the 'mysql' database?

How to convert control characters in MySQL from latin1 to UTF-8?

PostgreSQL partition hierarchy design for centralized logging

When to use MySQL query_cache?

What are some important MySQL status variables to keep an eye on? [closed]

Is there a way to have MySQL GROUP BY utilize trailing whitespace?

How does Oracle handle composite index lookups?

Is there any reason not to use Percona 'innodb_fast_checksum'?