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:
Notes
- Quoted lines have been omitted from some messages.
View the message alone to see the lines that have been omitted