Posted in MySQL on January 18th, 2008 2 Comments »
I believe one of the areas MySQL server need to improve when competing with other database software is that it needs to provide an easy way to release not used space of the innodb file. MS SQL server is far more superior in that regards.
In MySQL the default setting is to have only one […]
Posted in MySQL on January 17th, 2008 No Comments »
I mentioned in my previous post that MySQL server has replication feature. It is a very useful feature but from time to time I experience problems with it.
One problem I experienced with MySQL replication was that it stopped by
itself after replicating for a while. I could not re-start replication by running command “start […]
Posted in News & Comments on January 14th, 2008 No Comments »
A recent legal case drew a lot of public attention in China. The case involved a person named Xu Ting and it happened in 2006 in Guang Zhou.
Xu went to an ATM to withdraw cash. He noticed that after withdrawing 1000 Yuan his balance was only lower by 1 Yuan. He thought he was […]
Posted in Programming, SQL Server on January 12th, 2008 1 Comment »
Disk space arrangement is something that a database administrator needs to deal with when maintaining large database archiving historical data. Historical data consume huge amount of disk space. Every database table takes up different amount of disk space and sometimes the indexes of a table consume more disk space then its data. Not every database […]
Posted in News & Comments on January 11th, 2008 No Comments »
Who is Robin Li? He is the chairman, founder and CEO of the leading Chinese search engine Baidu.com (NASDAQ: BIDU).
He had an interview with one of the major Chinese internet media. The following is some notes of what he said.
Let’s look at the history of information technology in the pass few decades. There is […]