Bill Karwin

less info
stack exchange network profile network profile
831 reputation
158
bio website karwin.com
location California
age 45
visits member for 1 year, 9 months
seen May 10 at 13:54
stats profile views 157

I'm a MySQL Performance Consultant working at Percona, Inc. I've been a software engineer since 1987, and my specialty is as an SQL maven. I also have experience programming in Java, PHP, Perl, C, JavaScript, and I have many other coding skills.

I've written a book, SQL Antipatterns: Avoiding the Pitfalls of Database Programming from Pragmatic Bookshelf, based on the most common SQL problems I've answered on Stack Overflow and other forums, mailing lists, and newsgroups over the past 15 years.


24 Actions

suggestions reviews revisions comments badges posts accepts all
Feb
5
 answered How do I dump only the data for all tables using mysqldump
Jan
29
 awarded  Good Answer
Nov
29
 comment mysqldump not escaping single quotes properly
If you name a database when you create the dump, or if you use --all-databases, it should include the "use" commands.
Nov
29
 answered mysqldump not escaping single quotes properly
Aug
5
 awarded  Yearling
Apr
9
 awarded  Necromancer
Feb
13
 awarded  Nice Answer
Jan
1
 awarded  Great Answer
Dec
28
 awarded  Nice Answer
Dec
28
 awarded  Guru
Dec
28
 awarded  Good Answer
Nov
28
 awarded  Nice Answer
Nov
28
 awarded  Editor
Nov
28
 revised Is the concept of a clustered index in a DB design sensical when using SSDs?
added 708 characters in body
Nov
28
 comment Is the concept of a clustered index in a DB design sensical when using SSDs?
Right, by memory I mean RAM. Disks are storage, not memory.
Nov
28
 answered Is the concept of a clustered index in a DB design sensical when using SSDs?
Oct
20
 answered indexes, foreign keys and optimization
Oct
7
 awarded  Revival
Oct
7
 awarded  Teacher
Oct
6
 answered InnoDB create table error: “Row size too large”
1 2