3,382 reputation
1720
bio website karwin.com
location California
age 47
visits member for 3 years, 2 months
seen 8 hours ago

I'm Senior Knowledge Manager at Percona, a services company specializing in the MySQL database.

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.


Oct
16
revised 1 query using OR operator in where clause vs multiple query equal condition where clause in mysql
added 565 characters in body
Sep
26
revised Using an index for both asc and desc on a string column
added 498 characters in body
Sep
26
revised Using an index for both asc and desc on a string column
added 625 characters in body
Sep
25
revised Using an index for both asc and desc on a string column
added 4265 characters in body
Sep
24
revised Using an index for both asc and desc on a string column
added 148 characters in body
Sep
9
revised Which database technologies to consider for a data search application?
added 2344 characters in body
Sep
7
revised Which database technologies to consider for a data search application?
edited tags
Sep
4
revised MySQL does not start - Ubuntu 14.04 LTS after migration to new disk
added 175 characters in body
Aug
20
revised How to make MySQL log to 2 separate remote servers?
added 182 characters in body
Jul
31
revised MySQL replication issue when master gets restarted
added 12 characters in body
Jul
15
revised Percona MySQL 5.5 Unique key is duplicated
added 176 characters in body
Jul
15
revised Converting to MyISAM, `foreign_key_checks = 0` Not Working
added 13 characters in body
Jun
20
revised Converting MSSQL Stored Procedure to MySQL - Syntax Error
added 90 characters in body
Jun
4
revised Cannot execute statement: impossible to write to binary log?
edited tags
Jun
3
revised Is there a product to auto-build indexes based on slow queries?
edited tags
Jun
2
revised Why am I getting different results from a query vs. a view
edited tags
Jun
2
revised Why am I getting different results from a query vs. a view
added 459 characters in body
May
30
revised Why am I getting different results from a query vs. a view
edited tags
May
30
revised MySQL slave database wont start
edited body
May
23
revised update an id to max+1 in current table? (MySQL)
deleted 173 characters in body