Re: Wrong PID

Marcin Polewski wrote: On my machine, I start the following command: /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/zigzu.bixbots.com.pid For some reason my PID file does not contain the parent PID, inst

Queues on MySQL?

Hey, I'm looking to write a queue backed by MySQL to enable batch updates of a system I'm writing. Essentially what I wanted to do was every time I want to enqueue, I just INSERT a new row into a table. Then I have a cron job that runs every X minutes, selects all the existing rows and does the

Anybody can tell me why our data couldn't be saved incorrect character set in the database?

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 **

Re: Anybody can tell me why our data couldn't be saved incorrect character set in the database?

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/bi

Re: trouble with group by and similar tables

Eben, all, I'm very sorry this got out of sight for so long :-( When I first read your mail, I had no idea, and then it was hidden. Just now, I check it again and detect what may explain this. I quote nearly the full mail leading to this, so that you readers need not scan your archives. Ebe

RE: convertion to utf-8

>-Original Message- >From: Pooly [mailto:[EMAIL PROTECTED] >Sent: Sunday, June 29, 2008 5:52 PM >To: mysql@lists.mysql.com >Subject: convertion to utf-8 > >Hi, > >I'm trying to convert my tables to UTF8 but I'm getting the following >error: >ERROR 1062 (23000): Duplicate entry 'Zorglüb' fo

RE: Queues on MySQL?

>-Original Message- >From: Waynn Lue [mailto:[EMAIL PROTECTED] >Sent: Monday, June 30, 2008 6:04 AM >To: MySQL List >Subject: Queues on MySQL? > >Hey, > >I'm looking to write a queue backed by MySQL to enable batch updates >of a system I'm writing. Essentially what I wanted to do was every

MySQL University session on July 3: Advanced LUA Scripting

Hi, this Thursday, Giuseppe Maxia will give a MySQL University session: http://forge.mysql.com/wiki/Advanced_LUA_Scripting (topic: Advanced LUA Scripting) Please register for this session by filling in your name on the session Wiki page. Registering is not required but appreciated. That Wiki pa

Replication and procedures

Hi all, I am just getting started with replicating my servers and noticed that queries executed by procedures on the master are not replicated to my slaves. I need to know if this can be changed or if I have to get rid of my procedures? Thanks Olaf - Confi

Re: convertion to utf-8

Hi, 2008/6/30 Dan Nelson <[EMAIL PROTECTED]>: > In the last episode (Jun 29), Pooly said: >> Hi, >> >> I'm trying to convert my tables to UTF8 but I'm getting the following error: >> ERROR 1062 (23000): Duplicate entry 'Zorglüb' for key 1 >> >> Not too sure why I'm getting this error since the cur

RE: Very large temporary file(s)

Ananda, I tried your suggestion of adding "ORDER BY NULL" to the end of my query, but if anything it took up more disk space. I can see this becoming a critical problem for me. I just don't understand why this query, which is really not that crazy, is taking up 800mb of temporary space. >-Orig

Re: Queues on MySQL?

Thanks for the suggestion--is that essentially using http://www.php.net/posix_mkfifo within PHP? On Mon, Jun 30, 2008 at 7:11 AM, Jerry Schwartz <[EMAIL PROTECTED]> wrote: >>-Original Message- >>From: Waynn Lue [mailto:[EMAIL PROTECTED] >>Sent: Monday, June 30, 2008 6:04 AM >>To: MySQL Lis

Re: convertion to utf-8

In the last episode (Jun 30), Pooly said: > 2008/6/30 Dan Nelson <[EMAIL PROTECTED]>: > > In the last episode (Jun 29), Pooly said: > >> Hi, > >> > >> I'm trying to convert my tables to UTF8 but I'm getting the > >> following error: ERROR 1062 (23000): Duplicate entry 'Zorglüb' for > >> key 1 > >>

Re: Anybody can tell me why our data couldn't be saved incorrect character set in the database?

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

Re: Anybody can tell me why our data couldn't be saved incorrect character set in the database?

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 norm