3,457 reputation
1720
bio website karwin.com
location California
age 47
visits member for 3 years, 3 months
seen 2 days 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
answered 1 query using OR operator in where clause vs multiple query equal condition where clause in mysql
Oct
2
answered Upgrading to new cPanel Server with mySQL on SSD — What should I change in my.cnf?
Sep
28
answered What is the cost of adding a foreign key in mysql?
Sep
25
answered Speed Up Index Creation in MySQL
Sep
24
answered Using an index for both asc and desc on a string column
Sep
24
answered WARNING Error checking mysqldump version Error retrieving version from mysqldump.exe: mysqldump: unknown option '--no-beep' (exit 2)
Sep
7
answered Which database technologies to consider for a data search application?
Sep
4
answered MySQL does not start - Ubuntu 14.04 LTS after migration to new disk
Sep
3
answered How much memory will allocated for a mysql view
Aug
29
answered Row size error with MySQL
Aug
20
answered How to make MySQL log to 2 separate remote servers?
Aug
15
answered Why is MySQL ignoring my indexes?
Jul
25
answered Is my MySQL instance irretrievably dead?
Jul
25
answered credentials file for running mysql related jobs via script?
Jul
15
answered Percona MySQL 5.5 Unique key is duplicated
Jul
14
answered Converting to MyISAM, `foreign_key_checks = 0` Not Working
Jul
3
answered mysqld is not producing binary log
Jun
20
answered Converting MSSQL Stored Procedure to MySQL - Syntax Error
Jun
20
answered Database Normalization - Can one field point to another?
Jun
18
answered MySQL Foreign Key Prevents Deleting Table — But Table is Empty