re: run out of memory

2007-08-14 Thread Gu Lei(Tech)
try: uname -a to see if your OS is 64bit or not. Gu Lei -原始邮件- 发件人: Jen mlists [mailto:[EMAIL PROTECTED] 发送时间: 2007年8月15日 9:46 收件人: mysql@lists.mysql.com 主题: Re: run out of memory 2007/8/15, B. Keith Murphy <[EMAIL PROTECTED]>: > What operating system are you running and is it

deadlock with autocommit=1

2006-11-27 Thread Gu Lei
ULL | NULL | | BTREE | | | dbmail_messages | 1 | mailbox_status | 2 | status | A | 22850 | NULL | NULL | | BTREE | | +-++--+--++---+-+--++--++-+ 8 rows in set (0.01 sec) DBMAIL uses INNODB tables with autocommit=1. How could deadlocks happen?

Chinese order by with utf8

2005-11-22 Thread Gu Lei
ATION. What can I do? Thanks. Regards, gu lei -- 祝 事业有成,家庭和睦,身体健康,一切吉祥 古雷 --- 中企动力科技集团 技术事业发展部___技术架构部 \__企业IP通讯部 电话:010 58022278-302 地址:北京亦庄经济技术开发区北工大软件园

Re: Problems (URGENT)

2005-08-22 Thread Gu Lei
Try mysql -uroot On 2005年08月23日 12时09分25秒, tai huijia wrote: > Greetings, > > I'm a new user for MYSQL and I face problem adding > mysql database. > > After typing: > > SHOW DATABASES; > I got this: > +--+ > | Database | > +--+ > | test | > +--+ > 1 row in set (0.0

re: ADDING MYSQL DATABASE

2005-08-22 Thread Gu Lei
Hi That's a problem about privileges. Try mysql -uroot. Please have a look at http://dev.mysql.com/doc/mysql/en/privilege-system.html and http://dev.mysql.com/doc/mysql/en/user-account-management.html regards On 2005年08月20日 14时46分26秒, tai huijia wrote: > Greetings, > > I'm a new user for MYSQL

Why can't I revoke usage from user?

2005-08-15 Thread Gu Lei
Hello everyone: Why can't I revoke usage from user? mysql> show grants for ''@'172.20.16.110'; +--+ | Grants for @172.20.16.110| +--+ | GRANT USAGE ON *.* TO ''@'172.20.16.110' | +--

Re: Does the kernel options MAXSSIZ affect the MySQL max connections on FreeBSD

2005-06-17 Thread Gu Lei
ws in set (0.00 sec) You can see max_connections=100. Change that variable to get max connections you want. Regards, Gu Lei -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump : Character set '#33' is not a compiled character set

2005-06-02 Thread Gu Lei
Gu Lei 写道: >Hello Gleb Paharenko > >Version is 4.1.10-max > >Regards > >Gu Lei > >Gleb Paharenko 写道: > > > >>Hello. >> >>What version of MySQL do you use? Complete support for utf8 >>exists only in 4.1.xx and 5.x versions. >> &

Re: mysqldump : Character set '#33' is not a compiled character set

2005-06-02 Thread Gu Lei
Gu Lei ??: [EMAIL PROTECTED] ??: hi, look at : usr/bin/mysqldump --defaults-extra-file=/.../backup-credentials.cnf in http://dev.mysql.com/doc/mysql/en/mysqldump.html add the port, protocol,password mathias Selon Gu Lei <[EMAIL PROTECTED]>: Hi It's my first time usin

Re: mysqldump : Character set '#33' is not a compiled character set

2005-06-02 Thread Gu Lei
[EMAIL PROTECTED] 写道: hi, look at : usr/bin/mysqldump --defaults-extra-file=/.../backup-credentials.cnf in http://dev.mysql.com/doc/mysql/en/mysqldump.html add the port, protocol,password mathias Selon Gu Lei <[EMAIL PROTECTED]>: Hi It's my first time usin

Re: mysqldump : Character set '#33' is not a compiled character set

2005-06-02 Thread Gu Lei
Hello Gleb Paharenko Version is 4.1.10-max Regards Gu Lei Gleb Paharenko 写道: >Hello. > >What version of MySQL do you use? Complete support for utf8 >exists only in 4.1.xx and 5.x versions. > > >Gu Lei <[EMAIL PROTECTED]> wrote: > > >>[-- text/plai

mysqldump : Character set '#33' is not a compiled character set

2005-06-01 Thread Gu Lei
f8' is not a compiled character set and is not specified in the '/usr/local/mysql/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ What can I do? Thanks Regards, Gu Lei --

Re: multi-thread insert into innodb table with auto_increment column cause deadlock

2005-05-30 Thread Gu Lei
Gu Lei 写道: Description:  SQL state: HYT00  Native error: 1213  SQL Errortext: Deadlock found when trying to get lock; try restarting transaction SQL STATEMENT: insert into OCHARTORGANIZATION (CORPID,MODIFIED,MODIFIER,ORGIID,PARENTIID) values(?,?,?,?,?) mysql> d

multi-thread insert into innodb table with auto_increment column cause deadlock

2005-05-29 Thread Gu Lei
ET AUTOCOMMIT=0";     rc = SQLExecDirect(hstmtset,(SQLCHAR*)autocommit,sizeof(autocommit)-1); I really need some solution. Best regards, Gu Lei --

MyODBC SQLDescribeCol can't get ColumnSize of any String types column

2005-03-01 Thread Gu Lei
Hello: MyODBC3.51 MYSQL4.1.10-max MyODBC SQLDescribeCol can't get ColumnSize of any String types column. SQLDescribeCol can get ColumnSize of numeric column. Why ? Regards, Gu Lei -- <>-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Does MyODBC support SQLDescribeParam ?

2005-03-01 Thread Gu Lei
Hello: I need SQLDescribeParam to get parameters' type information. But with MyODBC3.51 and MYSQL 4.1.10max I got wrong type and wrong number of parameters. Does MyODBC support SQLDescribeParam ? When will MyODBC support SQLDescribeParam ? Thanks. Regards, Gu Lei -- <>-- My