Articles by Month
- July 2010 (2)
- June 2010 (3)
- May 2010 (5)
- February 2010 (4)
- September 2009 (1)
- July 2009 (2)
- June 2009 (2)
- April 2009 (8)
- January 2009 (3)
- November 2008 (6)
- June 2008 (1)
- May 2008 (5)
- April 2008 (1)
- March 2008 (3)
- February 2008 (5)
- January 2008 (10)
- June 2007 (1)
- May 2007 (1)
- April 2007 (2)
- October 2006 (2)
- September 2006 (4)
- August 2006 (2)
- February 2006 (1)
- December 2005 (1)
- September 2005 (4)
- August 2005 (5)
- July 2005 (2)
- June 2005 (2)
- May 2005 (5)
Links
-
Monthly Archives: November 2008
tar pipe ssh
I always have to look this up when I need it, so storing on my blog, so I can look it up faster. This is way faster than “scp”, for deep directories or directories with lots of files. tar cf … Continue reading
Posted in Uncategorized
Leave a comment
Using tmpfs for MySQL tmpdir setting
This is incredible, by the way. Any time MySQL needs to use a tmp table on disk, you can make it use RAM disk instead. WARNING: if the tmpfs partition you make isn’t big enough, MySQL will not be able … Continue reading
Posted in Uncategorized
1 Comment
DbTable and all its glory
The example: http://www.koopman.me/dbtable/ I got the concept of the class, DbTable, from a book called PHP5 Professional. The idea is we have a class, this abstract class, that allows us to quickly make a new class out of any database … Continue reading
Posted in Code
Leave a comment
Scaling MySQL Vertically, The Sun Way
This is a response to a response to an article about Scaling MySQL with a Sun server with a 256-thread count. With x86 based processors, you get high speed threads, but only a couple (up to four) per processor. With … Continue reading
Posted in Uncategorized
Leave a comment
Internet Video, Not Taking Off As Fast As….
Silverlight seems to be taking off a lot slower than I anticipated. One problem is it doesn’t work on Linux. There is Moonlight, but, its not so obvious. Here I am browsing my blog on my Xubuntu desktop, and I … Continue reading
Posted in Uncategorized
1 Comment
MySQL 4.1 “WHERE … OR … ” results in full table scan
This is a real life example. Case study is, we had performance problems that was narrowed down to a large number of the following query: SELECT sg.gid FROM Scheduleable_Group sg WHERE sg.domain=’domain.com’ OR sg.sid=’555′; The database engine is InnoDB on … Continue reading
Posted in Uncategorized
1 Comment





















