Re: Storing Apache logs in MySQL.

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 connections to your MySQL Server. You can use connection pooling eg SQLrelay -- Filip Krejci [EMAIL PROTECTED] Linux - und Spass dabei! -- MySQL General

Re: mysqldump --single-transaction causes database to become unusable

: sleeping Number of rows inserted 356882, updated 1963990, deleted 293832, read 875872021 2.05 inserts/s, 10.32 updates/s, 0.21 deletes/s, 48500.03 reads/s Thanks again, -- Filip Krejci [EMAIL PROTECTED] LINUX-for a better future -- MySQL General Mailing List For list archives: http

Re: mysqldump --single-transaction causes database to become unusable

? -- Filip Krejci [EMAIL PROTECTED] Vini, vidi, Linux! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump --single-transaction causes database to become unusable

. -- Filip Krejci [EMAIL PROTECTED] Linux - und Spass dabei! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: A simple 2 table query gets very slow when using ORDER BY

is extreamly low -- Filip Krejci [EMAIL PROTECTED] Vini, vidi, Linux! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: A simple 2 table query gets very slow when using ORDER BY

17:59:35 | 2 | Apple | |187 |1 | 2 | 2007-03-03 17:59:35 | 2 | Apple | ++--+---+-++---+ 5 rows in set (1.70 sec) On 3/3/07, Filip Krejci [EMAIL PROTECTED] wrote: Hi, if your selectivity is very low, try to use multiple index on e2s

Re: A simple 2 table query gets very slow when using ORDER BY

achieve limit, joining is stopped and result is send. -- Filip Krejci [EMAIL PROTECTED] LINUX-All you need -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Disk parition full

Nils [1] http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html -- Filip Krejci [EMAIL PROTECTED] Fatal Error: Found MS-Windows System - Repartitioning Disk for Linux... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Master - Slave/Master - Slave problem.

-do-db=clients replicate-do-db=data what can I do to fix this? Gary -- Filip Krejci [EMAIL PROTECTED] Q: How many Linux users does it take to change a lightbulb? A: Two. One to write the HOWTO-LIGHTBULB-CRONJOB, and another to read it. -- MySQL General Mailing List For list archives: http

Re: mysqldump

are put into place, so no create table statement errors because of FK's, and no editing the sql dump? Thanks and best regards Phil -- Filip Krejci [EMAIL PROTECTED] Vini, vidi, Linux! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http