On Tuesday 14 February 2006 21:06, Magnus Hagander wrote:
> > > When I show the processlist several times in a row it is nearly
> > > always SELECTing some filename in the Filename table.
> >
> > That's expected - it selects to find out if the filename has
> > to be inserted. By the way - is there
> > If there was a way to do it in a stored proc, that would
> probably be
> > fine even if the syntax of the proc differed - because the
> proc would
> > be part of the schema, just like table and index
> definitions. As long
> > as the call syntax would be the same.
> >
> > However, I don'
Sebastian Stark wrote:
I noticed that when doing a backup mysql seems to be using most of
the time doing SELECTs:
SELECT FilenameId FROM Filename WHERE
Name='trainNeckarArray.sh.o1087190.27859' |
When I show the processlist several times in a row it is nearly
always SELECTing some filename in t
Hello,
On 2/14/2006 9:06 PM, Magnus Hagander wrote:
When I show the processlist several times in a row it is nearly
always SELECTing some filename in the Filename table.
That's expected - it selects to find out if the filename has
to be inserted. By the way - is there a portable way of
havi
> > When I show the processlist several times in a row it is nearly
> > always SELECTing some filename in the Filename table.
>
> That's expected - it selects to find out if the filename has
> to be inserted. By the way - is there a portable way of
> having unique file names, and, in case of i
Hi,
On 2/14/2006 7:25 PM, Sebastian Stark wrote:
On 14.02.2006, at 19:12, Arno Lehmann wrote:
Mysql is using ~100% CPU so this seems to be the bottleneck in this
case. An index in the Name column does exist. The Filename table is
not extremely big, roughly at ~500MB with ~1 million ro
On 14.02.2006, at 19:12, Arno Lehmann wrote:
Mysql is using ~100% CPU so this seems to be the bottleneck in
this case. An index in the Name column does exist. The Filename
table is not extremely big, roughly at ~500MB with ~1 million rows.
I'm getting backup rates at ~15M/s but I would e
Hi,
On 2/14/2006 6:50 PM, Sebastian Stark wrote:
I noticed that when doing a backup mysql seems to be using most of the
time doing SELECTs:
yangtse ~ % /usr/local/mysql/bin/mysqladmin -u root processlist
+--+--+---++-+--+--
+---
