Fabulous!
Well, it hasn't broken again yet, but If it does...
Hmmm.
At the same time, though, I'm getting the following error:
<snip>
Can't create a new thread (errno 11). If you are not out of available
memory, you can consult the manual for a possible OS-dependent bug
<snip>
The machine I'm running this on has 4G of virtual memory. I'm NOT out of
available memory. And it's solaris 2.6.
My my.cnf file contains the following:
[client]
port = 54000
socket = /tmp/mysql.sock
[mysqld]
port = 54000
socket = /tmp/mysql.sock
#set-variable = max_allowed_packet=4M
set-variable = wait_timeout=120
set-variable = flush_time=200
set-variable = key_buffer=124M
set-variable = table_cache=512
set-variable = sort_buffer=16M
set-variable = record_buffer=12M
[isamchk]
set-variable = key_buffer=16M
Am I missing something really obvious?
Thank-you very much,
Gary (=
> -----Original Message-----
> From: Shane Wegner [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 08, 2001 10:56 PM
> To: [EMAIL PROTECTED]
> Subject: patch: limit MySQL insert packets
>
> Hi,
>
> The default MySQL max packet length is 1mb. Often this
> length can be exceeded as Mnogosearch is now using extended
> inserts. This patch limits insert queries into dict tables
> to 512k. Applies against Mnogosearch 3.11.
>
> --- sql.c.orig Thu Mar 8 13:48:58 2001
> +++ sql.c Thu Mar 8 14:10:46 2001
> @@ -2251,6 +2251,18 @@
>
> sprintf(qe,"(%d,%d,%d)",url_id,UdmStrCRC32(Indexer->Word[i].word),Indexer-
> >Word[i].count);
> }
> qe=qe+strlen(qe);
> + /* Insert 512k packets max to stay *
> + * under MySQL's default limit. */
> + if (strlen(qb) >= 512000){
> + sql_query(Indexer,qb);
> +
> if(UdmDBErrorCode(Indexer->db))return(IND_ERROR);
> +
> if(Indexer->Conf->DBMode==UDM_DBMODE_MULTI)
> + sprintf(qb,"INSERT INTO %s
> (url_id,word,intag) VALUES ",tbl_nm);
> + else
> + sprintf(qb,"INSERT INTO %s
> (url_id,word_id,intag) VALUES ",tbl_nm);
> + qe=qb+strlen(qb);
> + have_words = 0;
> + }
> }
> }
> if(have_words){
>
>
> --
> Shane Wegner: [EMAIL PROTECTED]
> http://www.cm.nu/~shane/
> PGP: 1024D/FFE3035D
> A0ED DAC4 77EC D674 5487
> 5B5C 4F89 9A4E FFE3 035D
> ___________________________________________
> If you want to unsubscribe send "unsubscribe general"
> to [EMAIL PROTECTED]
>
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
