The Blog

Author: admin

MySQL Dealing with ibdata1

Posted on

As you may have noticed in your MySQL’s data directory (in Debian/Ubuntu – /var/lib/mysql) lies a file called ‘ibdata1′. It holds almost all the InnoDB data (it’s not a transaction log) of the MySQL instance and could get quite big. By default this file has a initial size of 10Mb and it automatically extends. Unfortunately, by design InnoDB data files cannot be shrinked. That’s why DELETEs, TRUNCATEs, DROPs, etc. can’t will not reclaim the space used by the file. Instead any freed regions are marked as unused and can be used later. Theoretically speaking the file could reach the maximum size allowed by the filesystem if no limit is set in the my.cnf file (in Debian/Ubuntu it’s located in /etc/mysql/my.cnf). Guess what ? It’s not set by default.

Read More

Posted in Uncategorized Leave a comment

Another version of this product is already installed. Installation of this version cannot continue. To configure or remove the existing version of this product, use Add/Remove Programs on the Control Panel

Posted on

http://blogs.msdn.com/b/astebner/archive/2005/09/13/465401.aspx

http://www.experimentalspace.com/index.php/2008/04/error-when-trying-to-install-full-visual-studio-you-must-uninstall-all-the-pre-release-products-in-a-specific-order-before-you-can-continue-with-setup/

I tried to install a new version of windows services that packed into 1 setup.msi and encounter the above mentioned error. To resolve it I tried google read lots of but then find the following article

Read More

Posted in Uncategorized Leave a comment
« Previous PageNext Page »