» mysql
-
MySQL Error: 1062 Duplicate entry ‘0′ for key 1
By vinu on June 18th, 2008 | 3 Comments
mySQL error: 1062 Duplicate entry '0' for key 1 After scratching our heads over this one, we tried to alter the table to set the autoincrement field to the next number and even that failed to fix the problem. Then hunti... -
MySQL Tip - Ordering by Date stored in a varchar field
By vinu on June 2nd, 2008 | 7 Comments
How do you sort a varchar field which has the dates stored in it? If you try the usual order by on the varchar fields you’ll have trouble with the sort order, since MySQL will order this field like a varchar and ... -
Amazon AWS S3 MySQL Storage Engine
By vinu on April 26th, 2007 | No Comments
Amazon’s S3 service seems to be getting into everything ‘online’ these days. Here’s an announcement by Mark Atwood of a S3 storage engine for MySQL 5. It allows one to view and manipulate Amazon&... -
Insert and Update in one query
Here’s a quick tip in MySQL. Let’s say you have a table called browsercount like the one below: id browser count 1 Internet Explorer 1 2 Opera 2 Let’s say you have a web-analytic application whi... -
Performance Tuning Best Practices for MySQL (Video)
By vinu on February 21st, 2007 | No Comments
This video is from one of Google’s Techtalk sessions by Jay Pipes ABSTRACT Learn where to best focus your attention when tuning the performance of your applications and database servers, and how to effectively fi... -
MySQL Activity Report
By vinu on January 29th, 2007 | No Comments
Here’s a cool utility for MySQL administrators which allows you to track the performance of your servers and also gives you performance enhancement tips. You can see a sample report from this tool over at: http://... -
Innodb locking and Foreign Keys
By vinu on January 17th, 2007 | No Comments
Here’s a MySQL tip from the MySQL Performance Blog which deals with possible lock situations while using InnoDB and foreign keys. Today I was working with application which uses Innodb and foreign keys and got into...





