SQL, driver or me? (was: Re: Re: [ANN] (but whatshould I call it?))
[1/5] from: dockimbel::free::fr at: 25-Jun-2003 1:24
Hi, Hallvard Ystad wrote: [...]
> URL Parse: root none localhost none none rebindex > Net-log: ["Opening" "tcp" "for" "mySQL"]
<<quoted lines omitted: 22>>> Net-log: ["low level read of " 1341 "bytes"] > Net-log: ["low level read of " 0 "bytes"]
[...] Looks like the driver is expecting more data that never come. You're using a MySQL v4. I've never tested the driver with v4. The protocol may have changed slighly in v4 which may be the cause of your problem. You can generate a more useful report (for me) by doing the following modification in the driver source : 1) Find the following line in mysql-protocol.r : net-log ["low level read of " len "bytes"] 2) Insert just before the following code : probe data net-log ["low level read of " len "bytes"] 3) Relaunch your test. 4) Send me the output by email. HTH, -DocKimbel
[2/5] from: tim:johnsons-web at: 24-Jun-2003 19:54
* Nenad Rakocevic <[dockimbel--free--fr]> [030624 15:33]:
> Hi, > Hallvard Ystad wrote:
<<quoted lines omitted: 40>>> 3) Relaunch your test. > 4) Send me the output by email.
Hello ~H: Could you please post your output to the list, or CC to me. I'm very interested in following this. thanks ~tj~ -- Tim Johnson <[tim--johnsons-web--com]> http://www.alaska-internet-solutions.com http://www.johnsons-web.com
[3/5] from: g:santilli:tiscalinet:it at: 25-Jun-2003 10:23
Hi Nenad, On Wednesday, June 25, 2003, 1:24:19 AM, you wrote: NR> You're using a MySQL v4. I've never tested the driver with v4. The protocol may NR> have changed slighly in v4 which may be the cause of your problem. I've been using it with v4 for a few days now, didn't get any problems yet. So I doubt it's because of the protocol... unless the difference is so little to be visible only on a couple of specific situations. Regards, Gabriele. -- Gabriele Santilli <[g--santilli--tiscalinet--it]> -- REBOL Programmer Amigan -- AGI L'Aquila -- REB: http://web.tiscali.it/rebol/index.r
[4/5] from: mat:plothatching at: 25-Jun-2003 10:15
Hello Gabriele, GS> I've been using it with v4 for a few days now, didn't get any GS> problems yet. So I doubt it's because of the protocol... unless GS> the difference is so little to be visible only on a couple of GS> specific situations. I've been using it with v4 for some time. Quite large databases as well. It's worked brilliantly. IE hundreds of times faster than REBOL/command :) Regards, Mat Bettinson - +44-(0)20-83401514.
[5/5] from: amicom:sonic at: 25-Jun-2003 7:17
I've been using the MySQL protocol with v4 for months in a production environment on tables as large as 500,000 records and haven't had any major problems. You do need to make sure that you specify the correct parameters in the MySQL configuration files if you are using tables of that size. Also, I've found that if you have a Rebol process that connects to MySQL on demand but it sits idle for several hours, there can be similar problems to what you are having. The way I solve this is to send MySQL a ping of sorts after an hour of inactivity (i.e. "use test;" or whatever database name you have). Bohdan "Bo" Lechnowsky Lechnowsky Technical Consulting At 10:15 AM 6/25/03 +0100, you wrote:
- Quoted lines have been omitted from some messages.
View the message alone to see the lines that have been omitted