How to Hide MySpace Comment and FriendsMay 14th, 2009 This is an exclusive stuff for your MySpace or friendster users. Frankly you are there to make friends.
Google Sports a New Table Based LookMarch 17th, 2006 Google appeared with a new look today for Indians (google.co.in). It sports a three column look with flexible center content column.
HSQLDB Cached Table Versus Memory Table Performance & ConversionAugust 13th, 2007 In short in HSQLDB cached table sucks in terms of performance. To elaborate I was running a program which takes around 9 hours running on two medium sized cached tables (bigger one 163 MB).
Fun With RoR TransactionsMarch 7th, 2006 RoR multi-table transaction appears to be a mess. You have to create transactions on each table.
Reparo WordPress MySQL Comment Table...Why?August 20th, 2007 Nowadays my WordPress comments table is frequently getting corrupted and I have to repair it. The MySQL table repair command does the trick.
How to increase MySQL MyISAM Table Size Beyond 4GBApril 10th, 2009 When you started using MySQL, I am sure you never considered that it might have some limits on the maximum size of a table, did you?
Soon you may be facing the prospect of having tables over 4GB, the default limit imposed by MySQL. Fortunately MySQL provides a simple, but time-consuming, way to store data way beyond 4GB.
MySQL SQL Delete NotesNovember 27th, 2007 To delete duplicates from a MySQL database table I normally copy the duplicate data first to a temporary table and then use the copied id's to delete from the original table. Delete using the temporary can take two forms.
How To: Autoexec.bat in LinuxOctober 14th, 2007 Autoexec.bat is a legacy file in Windows which is executed every time you start Windows. Commands you want to run with startup of windows, and applicable to all users, are added to autoexec.bat.
How To Cure Internet AddictionAugust 30th, 2007 He Ling from China has the best solution. Jiang Ming of Chengdu city promised his dear wife, He Ling, that he would not go on the Internet anymore and would spend more time at home to take care of their newborn son.
Test Driving Java Studio CreatorJuly 7th, 2005 An excellent article, with screenshots, describing in details the ease of use of Java Studio Creator and JSF (using Java Studio Creator). The author is pretty impressed with the product.
MySQL Tip: How To Check, Repair & Optimize All Tables in All DatabasesApril 20th, 2008 Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server:
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
mysqlcheck is available in MySQL 3.23.38 and later. mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the user.
Never Restart Network on Multi-ADSL Connection Machine...November 23rd, 2007 I learned it the hard way. Our gateway machine with firewall (shorewall) has multiple ADSL connections configured with load balancing for more bandwidth and transparent fail-over.
How To Export MS Access Database To MySQL DatabaseAugust 30th, 2008 Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL. Use mdbtools utilities as described below:
mdb-tables displays the list of tables in MS Access
mdb-scheme export the MS Access schema to MySQL database.
Latest results of Browser war from my microcosm of viewers (for the web)January 15th, 2005 In my microcosm of viewers (of this blog site) Firefox is rapidly gaining in popularity and accounts for ~24% of the market share. Mozilla & Netscape accounts for merely 6%.
How To Quickly Analyze All Tables in MySQL DatabaseJune 12th, 2007 ANALYZE TABLE analyzes and stores the key distribution for a table. The MySQL query optimizer is the magic inside MySQL that decides which keys, if any, to use to in the query.