try to optimize the table and see if the error goes away
On 7/1/08, Moon's Father <[EMAIL PROTECTED]> wrote: > > > Yeah,they came from .net application and not using load data infile > statement. > > The character set of my db and columns is both utf8; > > Some wield thing is that the data is normal yesterday ,but they displayed > ???? today after the error happened. > On Mon, Jun 30, 2008 at 7:01 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > >> Is this data comming from application or loaded using LOAD DATA command. >> Can u please check the character set of the db and columns. >> >> >> On 6/30/08, Moon's Father <[EMAIL PROTECTED]> wrote: >>> >>> When the memory can not load our application,the error occurs. >>> 080630 17:32:38 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory >>> (Needed >>> 1651540 bytes) >>> And there are some data displayed ????? in my database. >>> For example. >>> mysql> select * from passport where name like '%??????%' limit 1\G >>> *************************** 1. row *************************** >>> id: 399502 >>> name: ?????? >>> email: [EMAIL PROTECTED] >>> password: 9e0fe63bb59388909d31e85d2b111216 >>> >>> Our front language is .net(C#) and the database is MySQL 5.0.45. >>> >>> Any help is appreciated. >>> >>> >>> -- >>> I'm a MySQL DBA in china. >>> More about me just visit here: >>> http://yueliangdao0608.cublog.cn >>> >> >> >> > > > > -- > I'm a MySQL DBA in china. > More about me just visit here: > http://yueliangdao0608.cublog.cn >