July 2012

MySQL: Incorrect key file error AND InnoDB: Error: unable to create temporary file; errno: 2

When I encounter the incorrect key file for table error, it’s almost certainly because the disk is full and MySQL can’t write to the tmpdir. The solution is simple, just move tmpdir to another partition with enough disk space. Open my.ini and change tmpdir to another directory with enough disk space. Restart MySQL and that …

MySQL: Incorrect key file error AND InnoDB: Error: unable to create temporary file; errno: 2 Read More »

Make phpMyAdmin Show Exact Number of Records for InnoDB Tables

By default, phpMyAdmin shows an estimated number of records for InnoDB tables that have more than 20,000 rows. It can vary by every fresh as much as 50% or even more. Makes it hard to get an exact number of records for the tables as we have to explicitly run an SQL query to do …

Make phpMyAdmin Show Exact Number of Records for InnoDB Tables Read More »

Amazing Science – Photons and Optical Fiber Cable

Today, most of our online data transmissions pass through fiber-optic cables. And as most of us know, fiber-optic cables are simply long, thin strands of glass which allow light to bounce and refract from one-end to the other without leaving the cable. It’s a bit like shining a flashlight down a long, mirrored tube. One …

Amazing Science – Photons and Optical Fiber Cable Read More »

How to Free C:\ Drive Disk Space in Windows 7 and Reduce System Size?

Windows 7 is a beast in consuming hard drive disk spaces, especially the system drive, C, which is constantly being filled up. After a while it will keep annoying you with low disk space warnings because C drive is running out of space and almost full. So how can I safely free up all the …

How to Free C:\ Drive Disk Space in Windows 7 and Reduce System Size? Read More »

New LHC Data Hints Strongly at Higgs Boson

What gives matter mass? This seemingly simple question has had physicists around the world working to detect and identify the Higgs boson, known in popular media as the “God particle,” the physical constituent that has long been thought to interact with other forms of matter, giving it mass. The search has lasted since 1964, the …

New LHC Data Hints Strongly at Higgs Boson Read More »

Scroll to Top