1,972 reputation
1614
bio website karwin.com
location California
age 46
visits member for 2 years, 8 months
seen 2 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.


1d
comment Fan-In replication 4 Master -> 1 slave
@Anil, MariaDB is based on MySQL 5.5, which is very mature. On the other hand, they add a lot of their own original code, which may have fresh bugs. Tungsten is much younger, but a lot of sites are using it successfully in production. Any assurance I give about maturity is meaningless, it only matters whether it works for you or not. And only you can test that.
2d
comment Fan-In replication 4 Master -> 1 slave
@Anil, All software has bugs.
2d
answered Is it faster to load several small files, or one big file?
2d
comment Fan-In replication 4 Master -> 1 slave
@Anil, you need at least 15 rep to upvote. stackoverflow.com/help/privileges/vote-up
2d
answered Fan-In replication 4 Master -> 1 slave
Apr
14
comment MySQL Slave not updated
@Ravi, there's always a mysql database, and usually a test database by default. There are also the system databases information_schema and performance_schema, but these are never replicated anyway.
Apr
14
revised MySQL Slave not updated
added 245 characters in body
Apr
14
answered MySQL Slave not updated
Apr
12
awarded  mysql
Apr
11
answered How to Recover truncate table in MySQL?
Apr
10
revised Is it possible to remove useless GRANTS in MySQL
added 831 characters in body
Apr
10
comment MySQL silly query plan
With MySQL 5.6, they default to use persistent table stats, which don't get updated as often as we are used to in earlier versions of MySQL. So if you get crazy optimization, first try ANALYZE TABLE to force the stats to refresh. That fixes queries in many cases.
Apr
10
revised Is it possible to remove useless GRANTS in MySQL
add percona-tools tag
Apr
10
suggested suggested edit on Is it possible to remove useless GRANTS in MySQL
Apr
10
answered Is it possible to remove useless GRANTS in MySQL
Apr
10
awarded  Revival
Mar
29
answered How Many Nodes For MySQL Cluster Setup?
Mar
26
comment MySQL 5.1: Upgrade innodb plugin
If MySQL does not start, you should investigate the cause or specific error message in the MySQL error log. I did say that there was no guarantee that a plugin from another version would work. Why don't you want to just upgrade MySQL fully to 5.1.73?
Mar
25
comment Does a MyISAM table locks if I copy it while MySQL is running? (READ DISCLAIMER)
Nope, the binary log records changes to any table, regardless of storage engine. How else would replication work?
Mar
25
comment Does a MyISAM table locks if I copy it while MySQL is running? (READ DISCLAIMER)
@Hito_kun, you should read about point-in-time recovery with binary logs.