Thank your for your answer (even though i only got it because you sent
it directly to me - somehow, the mailinglist-emails are not getting
through to me. weird).
1.) All that can have a UNIQUE index, have one, ut the ones i am using
here are not unique (except for movements.id, which is a PRIM
In the last episode (Nov 09), Moritz von Schweinitz said:
> Ok, i don't get it.
>
> I have the following query:
> SELECT
> SUM(quant)
> FROM
> movement_items
> LEFT OUTER JOIN movements ON movements.id = movement_items.movement_id
> WHERE
> item_id = 21311
> AND
> movements.type_id = 1
>
> where
Ok, i don't get it.
I have the following query:
SELECT
SUM(quant)
FROM
movement_items
LEFT OUTER JOIN movements ON movements.id = movement_items.movement_id
WHERE
item_id = 21311
AND
movements.type_id = 1
where 'movement_items' has about 1.3M rows, and 'movements' about 0.5M rows.
EXPLAIN gives
Hi,
An easier method may be to install mod_log_mysql on each of the Apache
servers and log directly to the central MySQL installation.
Regards
Ian
This however is not an option at all when you run Apache in prefork
mode. Because the sum of your MaxClients will be equal to the
connectio
On 9 Nov 2007 at 10:44, Shaun T. Erickson wrote:
> I pull Apache (combined format) logs, daily, from a number of mirrors,
> back to a central server for processing. I'd like to somehow load them
> in MySQL for analysis.
>
> 1) Does anyone know of a script that can parse the logs and load them?
>
On Fri, 2007-11-09 at 13:22 +0100, Pau Marc Munoz Torres wrote:
> Hi everybody
>
> I'm writing a function script in a flat file using vim, now i would like
> load it into my sql, there is some command to do it similar to "load data
> into" to fill tables?
>
> thanks
>
Sure,
>From command lin
I pull Apache (combined format) logs, daily, from a number of mirrors,
back to a central server for processing. I'd like to somehow load them
in MySQL for analysis.
1) Does anyone know of a script that can parse the logs and load them?
(I presume I can get the DB schema from it.)
2) Can MySQL han
You have basic instruction SELECT (for selection) and INSERT (for write in
table)
What case :
. Take data in one table and transfer it in other table ( select / insert )
. Take data in a file and insert it in a table ( tools of conversion)
2007/11/9, Pau Marc Munoz Torres <[EMAIL PROTECTED]>:
>
>
Hi everybody
I'm writing a function script in a flat file using vim, now i would like
load it into my sql, there is some command to do it similar to "load data
into" to fill tables?
thanks
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina
