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

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] -------- -- ===

Re: MySQL 5.0 25% slower

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:

Re: MySQL 5 is 25% slower then 4.1

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 is 25% slower then 4.1

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

MySQL 5 is 25% slower then 4.1

. 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 upgrade from 3.x to 4.1 for Chinese databases

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

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

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

MySQL upgrade from 3.x to 4.1 for Chinese databases

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

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: max Mysql database size

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

character set in MySQL 4.1

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: mysql.host: 3.23 to 4.0.2

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

Is it the time to upgrade my server?

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