Everytime you do optimize MySQL, by using mysqlcheck -A -o or using ./mysql_optimize from here. You may see the output Table does not support optimize, doing recreate + analyze instead. It is because the table that you are using is InnoDB. You can optimize the InnoDB tables by using this. ALTER TABLE table.name ENGINE=’InnoDB’;
Monthly Archives: September 2010
Optimize only fragmented tables in MySQL
Normally I use myqlcheck -A –optimize to optimize my MySQL database tables. But this will load your whole database and use more time than optimize only fragment tables. I always use the MySQLTuner 1.1.1 – Major Hayden to check and optimize my database, and I found a lot of fragmented tables in my database. I Continue reading “Optimize only fragmented tables in MySQL”
I’ve submit to Digg.com
I’ve submit to Digg.com, all my feeds will be appear in Digg.com soon. Please digg me. Actually I just need this post to verify my import feeds in Digg.com.
How to import rss feed to facebook page.
I found a better way to transfer your rss feed to facebook, and I’m using it now for my website. Here is the step for all of it. Register and use feedburner.com to load your RSS / Feed / Atom. Inside feedburner, use the Publicize … Socialize … Add Twitter Account … And then add Continue reading “How to import rss feed to facebook page.”
How to make facebook short url for your page ?
How to make facebook short url for your page ? After you register a page in facebook.com normally it will become like this http://www.facebook.com/pages/Perakorg/229244596258
Install QFarm for PhpWind 8.0
Install QFarm for PhpWind 8.0 Install QQFarm for PhpWind 8.0 怎样安装 QFarm 于 PhpWind 8.0 The author of phpYe.QFarm 4.9 Final Build 20100906.1600（PW）is from phpYe. If you want to download the source code of files, you have to be a register member, but they allow for invite only. But you can download from here. http://u.115.com/file/f3d8d4540d
PHP Warning: Division by zero in ~/public_html/forums/cn/template/wind/thread.htm on line 14
[04-Sep-2010 13:46:24] PHP Warning: Division by zero in ~/public_html/forums/cn/template/wind/thread.htm on line 14 I’ve received this bug. Just make sure the value is not equal to zero, then it won’t be divided by it. <!– EOT; $tmpCount=0; $idp = 100/$db_txtadnum; foreach ($arrayAdvert as $value) { if ($tmpCount==0) {print <<<EOT –> change to.
Problem with index.php/archives and index.php/category
We know that WordPress is most famous blog in the world, and the default link for WordPress is using /archives and /category. But this make problems to those sites that are not using WordPress, like my site is using Phpwind. Most of the search engine in the world will search for example.com/archives/… example.com/category/… sometimes search Continue reading “Problem with index.php/archives and index.php/category”
Find files containing text in Linux
grep -lir “text you want to find” * You could put it as background if it is longer time search grep -lir “text you want to find” * > searchresult.txt & example.
[Solved]Locked table in MySQL
InnoDB Supports transactions, row-level locking, and foreign keys MyISAM Default engine as of MySQL 3.23 with great performance