Re: set "DEC" as a column name : forbidden

2006-05-30 Thread Chenzhou CUI
noying ; I add to name the column as "DECL" which is much less meaning full in the astronomy community. thanks, =_==_==_==_==_==_= =¯==¯==¯==¯==¯==¯= Gilles Missonnier IAP - [EMAIL PROTECTED] -------- -- ===

character set in MySQL 4.1

2005-07-11 Thread Chenzhou Cui
Dear all, I am a Chinese and using Chinese in my MySQL databases. On my old server, the version of MySQL is 3.23.58. And my new MySQL is 4.1.7. On my old server, the MySQL works well with my Chinese contents. However, after I transfer tables to the new server using: mysqldump --opt database | m

Re: max Mysql database size

2005-09-14 Thread Chenzhou Cui
I have a database, which is more than 120GB with about 500 million records. MySQL works well. Andrew stolarz wrote: Hello Everyone, Hopefully easy question, What is the Max size of a MySQL server database? -- Chenzhou Cui

MySQL upgrade from 3.x to 4.1 for Chinese databases

2005-09-22 Thread Chenzhou Cui
ork. Is it possible to directly use the binary db files, "*.frm", "*.MYI", "*.MYD", and keep the Chinese support? This is a very big and important problem facing many Chinese users. cheers, Chenzhou -- ======== Chen

MySQL upgrade from 3.x to 4.1 for Chinese databases

2005-09-22 Thread Chenzhou Cui
ork. Is it possible to directly use the binary db files, "*.frm", "*.MYI", "*.MYD", and keep the Chinese support? This is a very big and important problem facing many Chinese users. cheers, Chenzhou -- ======== Chen

Re: MySQL upgrade from 3.x to 4.1 for Chinese databases

2005-09-23 Thread Chenzhou Cui
large system, I feel. - Original Message - From: "Chenzhou Cui" <[EMAIL PROTECTED]> To: Sent: Friday, September 23, 2005 12:40 AM Subject: MySQL upgrade from 3.x to 4.1 for Chinese databases Dear all, On my server there are thousands of database files contenting

Re: MySQL upgrade from 3.x to 4.1 for Chinese databases

2005-09-25 Thread Chenzhou Cui
at database level. So the problem seems in 3.* to 4.*. If mysqldump worded for you. My suggestion is to write a script to automat this data conversion. - Original Message - From: "Chenzhou Cui" <[EMAIL PROTECTED]> To: Cc: "YL" <[EMAIL PROTECTED]> Sent: Fr

MySQL 5 is 25% slower then 4.1

2005-12-04 Thread Chenzhou Cui
. Regards, Chenzhou CUI -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 5 is 25% slower then 4.1

2005-12-05 Thread Chenzhou Cui
o RAIDs link to the server by Ultra SCSI 320 interface. Gary Richardson wrote: Are you doing single insert statements, multiple insert statements or LOAD DATA INFILE statements? On 12/4/05, Chenzhou Cui <[EMAIL PROTECTED]> wrote: Dear MySQL fans, I have a 260 GB huge file with

Re: MySQL 5 is 25% slower then 4.1

2005-12-05 Thread Chenzhou Cui
ww.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Chenzhou Cui (China-VO Project) National Astronomical Observatory | Tel: (8610)64841695 Chinese Academy

Re: MySQL 5.0 25% slower

2005-12-25 Thread Chenzhou Cui
improve the performence at that time. :) -- ==== Chenzhou Cui (China-VO Project) National Astronomical Observatory | Tel: (8610)64841695 Chinese Academy of Sciences | FAX: (8610)64878240 Datun Road 20A, Chaoyang District | Email:

Is it the time to upgrade my server?

2005-05-01 Thread Chenzhou Cui
I upgrade my hardware now? At present, the hardware system inclodes: 2.0GHz(Intel XEON)*2, 2GB DDR RAM, (Intel 1000Mbps NIC)*2, 73GB SCSI HD (RAID 1+0) and 36GB SCSI system disk. All kinds of comments are welcome, cheers, -- Chenzhou

Re: mysql.host: 3.23 to 4.0.2

2005-05-02 Thread Chenzhou Cui
ppreciated. Thanks tim -- ==== Chenzhou Cui (China-VO Project) National Astronomical Observatory | Tel: (8610)64841695 Chinese Academy of Sciences | FAX: (8610)64878240 Datun Road 20A, Chaoyang District | Email: [EMAIL PROTECTED] Beij