Posts Tagged "mysql"

  • mysqlind_qc: Client Side Caching for MySQL extensions for PHP

    Databases
    mysqlind_qc: Client Side Caching for MySQL extensions for PHP

    Here’s something in the making, a PHP extension which caches MySQL queries irrespective of the extension being used. It’s a plugin for mysqlind, the native MySQL driver for PHP called mysqlind_qc. This currently requires PHP 5.3.3-dev which is still in development.

    Read More...

  • Generate data for Database testing

    Databases
    Generate data for Database testing

    Image by lilit via Flickr How often have you tested your application on your local machine and had it run properly, but when you deploy it and the database starts getting filled up, you start noticing performance problems? Here’s something you can use to test out your application with databases which are not empty – [...]

    Read More...

  • MySQL Error: 1062 Duplicate entry ’0′ for key 1

    Databases
    MySQL Error: 1062 Duplicate entry ’0′ for key 1

    Here’s a problem we had come across today. Whenever we tried inserting data into a certain table, MySQL kept throwing up the following error: 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 [...]

    Read More...

  • MySQL Tip – Ordering by Date stored in a varchar field

    Databases
    MySQL Tip – Ordering by Date stored in a varchar field

    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 you will surely have problems with dates being sorted this way. Take the [...]

    Read More...

  • Amazon AWS S3 MySQL Storage Engine

    Databases

    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’s S3 storage service as tables and items by MySQL. You can keep your blobs or large varchars or truely huge datasets [...]

    Read More...

  • Insert and Update in one query

    Databases

    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 which has to add a browser into the table if it doesn’t exist, but update the count for the browser [...]

    Read More...

  • Performance Tuning Best Practices for MySQL (Video)

    Databases

    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 find the “low hanging fruit” on the tree of bottlenecks. It’s not rocket science, but with a bit of acquired skill [...]

    Read More...

  • MySQL Activity Report

    Databases

    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://gert.sos.be/demo/mysqlar/ The MySQL Activity Report package is a tool to help MySQL database administrators to collect several database parameters and [...]

    Read More...

  • Innodb locking and Foreign Keys

    Databases

    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 locking problems possibly due to foreign keys, so I did a little investigation on that matter. Peter Zaitsev goes [...]

    Read More...