Posts Tagged database
mysql.sock path in Mac OS X
In my last post I discuss how to enable PHP over Apache in Mac OS X lion and today I bumped into a new problem. The problem is that when you install MySQL on Mac OS X and try to connect it via PHP, you will get an error. This error is thrown due to the fact that the path of the MySQL sockets are dif
Read Full PostDifference between InnoDB and MyISAM in MySQL
MyISAM and InnoDB are two most commonly used storage engines of MySQL database. However, MyISAM is the default storage engine chosen by MySQL database, when creating a new table. The major differences between these two storage engines are : InnoDB supports transactions which is not supported by
Read Full PostEnable query cache in MySQL to improve performance
There are lot many solutions to cache your database queries. Some use client level cache, some server side cache. However, MySQL itself provides a cache mechanism which is called “Query Cache” in which the queries being fired at the database are cached. Clearly saying, the result sets are cached
Read Full PostMemory(heap) Storage engine in MySQL
Lately, I have been doing a lot of database stuff and during my odyssey I found lots of exciting stuff in MySQL. Memory storage in engine is one of those exciting stuff, which can be really useful at times, if used on right time at right place. Memory (heap) for the name itself signifies what I a
Read Full PostNew php framework PalDB, supports MVC and Database ORM
Well PalDB is yet another framework for PHP. PalDb is a fast and powerful database abstraction layer and ORM. While it is not as full-featured as Doctrine or Propel, it comes quite close when you use it with MySQL. It shares Pal's paradigms of simplicity and elegance. Features You can use PalDb in t
Read Full Post