Thanks both Devanada and Peter, your replies helped me resolve it.
/Jon
On 7/30/06, Peter Brawley <[EMAIL PROTECTED]> wrote:
*>I'm trying to make stored procedures use parameters for limit and
tables, I
>guess this is either me using the wrong datatype or it's not possible.
I'm
>having the sa
On Saturday, 29 July 2006 at 9:53:29 -0700, Abdullah Ibn Hamad Al-Marri wrote:
> Jim Winstead wrote:
>> On Sat, Jul 29, 2006 at 08:35:41AM -0700, Abdullah Ibn Hamad Al-Marri wrote:
>>> Why MySQL 5.0.23 while it has serious bug?
>>>
>>> I thought you guys will release 5.0.24 instead.
>>
>> This is
[snip]
Was wondering if I could get a conversation started on the pros/cons of
database storage verse filesystem
[/snip]
There is additional overhead in saving and retrieving images from a
database typically. Most folks benchmark to see which is faster and more
efficient on their systems. YMMV.
B
Asif Lodhi wrote:
Hi Chris,
On 7/28/06, Chris <[EMAIL PROTECTED]> wrote:
> i'm trying to figure out how to allow all users on machines within my
> network access to a mysql db...
>
> with no luck..
...
Have you got mysql listening for ne
--On July 30, 2006 10:42:16 AM -0500 Chris McKeever <[EMAIL PROTECTED]>
wrote:
Starting to build a new schema, and one of the items is image storage
In the past I have always used filesystem storage.
Was wondering if I could get a conversation started on the pros/cons
of database storage ve
Chris
I'm sure that many of the experienced list members may well correct me
however I started saving images in my databases and found it much simpler to
simply store the image name and the path if required.
Regards
John Berman
-Original Message-
From: Chris McKeever [mailto:[EMAIL
At 12:40 PM 7/30/2006, you wrote:
Hello!
Am 30.07.2006 um 18:40 schrieb mos:
The Cayenne framework is using a a single table to keep the primary
keys (PK) for its objects. The method accessing this table is
surrounded by lock / unlock commands, so no other thread can read the
same PK from the
Hello!
Am 30.07.2006 um 18:40 schrieb mos:
The Cayenne framework is using a a single table to keep the primary
keys (PK) for its objects. The method accessing this table is
surrounded by lock / unlock commands, so no other thread can read the
same PK from the table while another thread is curre
Jørn Dahl-Stamnes wrote:
> I got the following query:
>
> select s.id,s.name,sum(p.fee) as fee from serie as s inner join race_serie as
> rs on (rs.serie_id=s.id) inner join races as r on (r.id=rs.race_id) inner
> join participants as p on (p.race_id=r.id) where s.receipt=1 and
> p.rider_id=236 an
Chris,
At 10:42 AM 7/30/2006, you wrote:
Starting to build a new schema, and one of the items is image storage
In the past I have always used filesystem storage.
Was wondering if I could get a conversation started on the pros/cons
of database storage verse filesystem
Thanks!
It takes a lot m
I was able to speed it up somewhat by increasing the Key_buffer_size to
512M and its down to 4 hours to load 30 million rows. Still I find that's
pretty slow. Is there anything else I can do to speed it up? TIA
Mike
At 10:50 PM 7/28/2006, mos wrote:
I ran a file monitor and it appears MySQL ha
At 05:43 AM 7/29/2006, you wrote:
Dear list,
we are running a Mysql 5.0.22 server that is accessed by a number of
java web applications (jdbc driver 3.1) over the network. The
database layer was realized using the Cayenne framework and InnoDB
was chosen as the table type. All applications share
Thanks for your reply. I repeated your test with the same results on 4.1.21
(database in question is on 4.1). I'll give the ISP another kick and see what
they have to say.
So there's no other reason why an ISP might not want to grant LOCK TABLES in a
shared hosting environment?
Thanks,
James
>I'm trying to make stored procedures use parameters for limit
and tables, I
>guess this is either me using the wrong datatype or it's not
possible. I'm
>having the same issue with seting the table for the query:
SET @sql = CONCAT( 'select * from some_table limit ', some_limit );
PREPARE s
Starting to build a new schema, and one of the items is image storage
In the past I have always used filesystem storage.
Was wondering if I could get a conversation started on the pros/cons
of database storage verse filesystem
Thanks!
--
--
please respond to the
Jon wrote:
Hi list
I'm trying to make stored procedures use parameters for limit and tables, I
guess this is either me using the wrong datatype or it's not possible. I'm
having the same issue with seting the table for the query:
CREATE PROCEDURE sp_test1 (IN some_limit int)
select * from some
Do the right thing(TM) and don't use an alias that is the same as a
field that exists (this was mentioned before by someone else).
Since there is a field in your join named "fee", using "fee" as an
alias, is bound to cause your trouble.
Also, trying to call sum(p.fee) twice is a waste of cputime.
On Sunday 30 July 2006 12:37, Gabriel PREDA wrote:
> You must specify explicitly what 'fee' to use... so if you wand every
> p.fee to be greater than zero then you must do:
>
> SELECT s.id, s.name, SUM(p.fee) AS fee
> FROM serie AS s
> INNER JOIN race_serie AS rs ON rs.serie_id = s.id
>
You must specify explicitly what 'fee' to use... so if you wand every
p.fee to be greater than zero then you must do:
SELECT s.id, s.name, SUM(p.fee) AS fee
FROM serie AS s
INNER JOIN race_serie AS rs ON rs.serie_id = s.id
INNER JOIN races AS r ON r.id = rs.race_id
INNER JOIN particip
Hello Jørn Dahl-Stamnes,
The column 'fee' is existing in more than one table . To overcome this
problem use the correct instance name of the table for the column "fee" In
WHERE clause
select
s.id,
s.name,
sum(p.fee) as fee
from serie as s
inner join race_serie as rs
on (rs
At 11:10 +0200 30/7/06, Jørn Dahl-Stamnes wrote:
select s.id,s.name,sum(p.fee) as fee from serie as s inner join race_serie as
rs on (rs.serie_id=s.id) inner join races as r on (r.id=rs.race_id) inner
join participants as p on (p.race_id=r.id) where s.receipt=1 and
p.rider_id=236 and fee > 0 grou
I got the following query:
select s.id,s.name,sum(p.fee) as fee from serie as s inner join race_serie as
rs on (rs.serie_id=s.id) inner join races as r on (r.id=rs.race_id) inner
join participants as p on (p.race_id=r.id) where s.receipt=1 and
p.rider_id=236 and fee > 0 group by s.id order by s
The default charset of c is utf8, and that of a and b is latin1.
Maybe charset cause size of table increased?
--
Thanks & Regards
Chylli
Of course this is it !
Latin1 needss one byte per character ... while utf needs from 1 to 3
bytes per character.
Still the rate of growing 1,9 can only be ex
I guess MySQL should make binary for NetBSD too.
- Original Message
From: Clay R White <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Sunday, July 30, 2006 2:01:58 AM
Subject: MySQL 5.0.22 install problem with NetBSD
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: MySQL 5
24 matches
Mail list logo
