Monday, August 11, 2008

How to fix SP3 installation on Intel MACs with Boot Camp.

1. Click Start, click Run, type regedit, and then click OK.
2. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Setup
3. On the Edit menu, point to New, and click String Value.
4. In the text box under the Name column, type BootDir and press ENTER.
5. Right-click the name BootDir, and then click Modify.
6. In the Edit String Value dialog box, type the drive letter for your system drive, and then click OK. For example, if your system drive is C:, type C:\.
7. Close Registry Editor.

After you have created this registry key (or if you created this key when you installed a previous version of this Service Pack), you can proceed with the installation.

1. Click Start - Run - Type “regedit” and press enter.
2. Navigate to
[HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Setup]

HKEY_LOCAL_MACHINE
\Software
\Microsoft
\Windows
\CurrentVersion
\Setup

3. In the right pane, Right-click and select New - String value
4. Name it as “BootDir” and set its value to “C:\”

Wednesday, June 18, 2008

一点方便的笔记。资料来源:
http://www.headphoneclub.com/html/84/20084-572.html

常用电压放大级即前级放大胆管代换表
      6N1 ECC85,6AQ8,6H1л
      6N4 12AX7,ECC83,E83CC,7729,CV4004,B759,CV492
      6N10 12AU7,ECC82,E82CC,7316,CV4003,5814,B749,6189
      6N11 6DJ8,E88CC,ECC88,6922,ECC189,6J5,6H11N,7308,El88CC
      6N8P 6SN7,B65,5692,33S30,CV1988,6H8C,6HM,6F8G,1633
      6H8C 6HM,6F8G,1633,9002,6C8G
      6J8P 6SJ7,6267,EF86,12AT7 ,
         ECC81,CV4024,6201,B739,A2900,2025,ECC8015
      6N9P 6SL7,5691,33S29,VT229
      6F2 ECF82,6U8
      6N2 6H2л
   6N3 2C51/5670/6Н3П

  功率用管代换表
      
6p1 5763
6P3P  6L6GC,5881
      6P6P  6V6GT,5S2,KT63
      EL34  6CA7,KT66,7027A
      6P14  EL84,6BQ5,6П14П
      6N5P  6080,6AS7,6H5C
      FU-5  805
      FU-7  807,1625
      FU-13 813
      FU-46 06146B
          FU-17
      FU-605 6T51
      7092  6T50
      FU811 811A
      FU812 812A
      GL-211 211
      300B  WE300B,NL50,4300B
      KT88  6550,NT99,KT100
      2A3  2A3S
      845  845A
          6360,TY-7
  
  整流电子管代换及特性表
   型号  代换型号   Bb2V  UfV/I   I2L(mA)最大  型式
   5U4G  5Z3P,U52   500V  5V/3A   2500      直热式
   5Y3GT  522P     350V  5V/2A   125      直热式
   5R4GY  22S2C    900V  5V/2A   150      直热式
   5T4         450V  5V/3A   250A      直热式
   6Z4         350V  6.3V/0.5A 50       直热式
   6Z5   6X5     230V  6.3V/0.8A 60       旁热式
   6X4         325V  6.3V/0.5A 70       旁热式
   5Z4P  5Z4     400V  5V/2A   125      旁热式
   5AR4  GZ34     450V  5V/1.9A  250      旁热式

Tuesday, February 26, 2008

名言绝句:
皇帝胡搞是游龙戏凤,巡抚胡搞是深入群众,知府胡搞是娱乐活动,知县胡搞是体育运动,小吏胡搞是胡乱打洞,草民胡搞是流氓活动。二奶左右王侯,妓院胜于官衙,风月影响政治。

Tuesday, February 05, 2008

MySQL storage engine comparsion: InnoDB vs MyISAM

While doing INSERT with MySQL, and where the table has key with AUTO_INCREMENT fields and the table uses InnoDB as storage engine. The problem is the record of insert is not showing as fast as you would expect. Sometimes have to wait for a while in order for the new record to show up.

This problem can be solved by tuning the InnoDB engine, presumably. But the best is to use MyISAM engine because

[url]http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html[/url]
* Internal handling of one AUTO_INCREMENT column per table is supported. MyISAM automatically updates this column for INSERT and UPDATE operations. This makes AUTO_INCREMENT columns faster (at least 10%). Values at the top of the sequence are not reused after being deleted. (When an AUTO_INCREMENT column is defined as the last column of a multiple-column index, reuse of values deleted from the top of a sequence does occur.) The AUTO_INCREMENT value can be reset with ALTER TABLE or myisamchk.

[b]Reason[/b]
The reason is because InnoDB has internal buffer that will cache the data in memory first before doing a bulk write to the hdd, which, supposing to increase the performance of the database. However, in many development scenario, in order to show the change of db in real time manual commit is required:
mysql>commit;

Wednesday, July 11, 2007

As a backup:
Source: http://dotnet.org.za/thea/archive/2005/02/22/14715.aspx
SQL SELECT TOP N equivalent in ORACLE and MySQL

Something I needed today... I wish this was standarized, but it is not, so here are some examples:

SQL Server:
SELECT TOP 10 product, descr, email
FROM products

ORACLE:
SELECT product, descr, email
FROM products
WHERE ROWNUM <= 10

MySQL:
SELECT product, descr, email
FROM products
LIMIT 10

Sunday, May 27, 2007

How to solve the 500 Internal Server Error on phpMyAdmin.

Yesterday I freshly installed my LAMP box, with mod_python. Everything was fine, but this morning while started to use phpMyAdmin, it generated the "500 Internal Server Error on phpMyAdmin", states the server is overloaded, blah blah blah.
My solution was to remove the ".htaccess" files under the phpMyAdmin directory.


To solve the remote login problem of MySQL.
Today, I cannot login to the MySQL server from remote computer, it said something like "cannot connect to remote host". The reason was the "skip-networking" was set to ON in the /etc/my.cnf file.

Comment the line to "#skip-networking" and restart the mysqld will solve the problem.
How to setup Django with Apache.

1. Ensure Apache / Mod_python is working by following the link below:
http://www.djangoproject.com/documentation/modpython/

2. Install djano

3. Config apache:
Suppose, the document root is "/home/httpd/html", the Django site is in "/home/httpd/html/django",
add the following section into apache's config file (for arch linux: /etc/httpd/conf/httpd.conf)

SetHandler python-program
PythonPath "['/home/httpd/html/'] + sys.path"
PythonHandler django.core.handlers.modpython
SetEnv DJANGO_SETTINGS_MODULE django.settings
PythonDebug On


4. Finally, restart apache (/etc/rc.d/httpd restart)
5. check if it is working by visiting localhost/django
"It Worked" will show up if it is successful.

Wednesday, May 09, 2007

真是故事,
几年前,大一的时候,我和love u(大泡)放假去南岳衡山。

到了那个据说全中国最大的菩萨和道士一家子的庙,被人喋喋不休地找我们烧香。
厌烦中,我love u忽然神秘D问卖香人:“观音会写C吗?他能帮我把C考过,我就烧......”
卖香人不解,不知道Y是不是神经了,就跑来问我......拜拜观音,就能x,y,z.....
俺一句话,说得他没话说了.......

“本人只拜金...”

lolol