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 G

Re: mysqldump

e FK's 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/mys

Re: Master -> Slave/Master -> Slave problem.

ry=60 replicate-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 Fo

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

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

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

| Apple | |186 |1 | 2 | 2007-03-03 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, i

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: mysqldump --single-transaction causes database to become unusable

ating writes on another box? -- 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

state of your server. -- 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: mysqldump --single-transaction causes database to become unusable

Main thread process no. 23228, id 2367634320, state: 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 futu