st, and do periodic "LOAD
DATA INFILE" commands, so as to bulk insert records.
Are there any websites/webpages or books that detail optimizing writes to
MySQL databases (aside from "more memory" or "faster CPU" or "faster hard
drive").
Thanx,
Jamie Beu
Loc
want to run some benchmark tests, but I need precision greater than 1 sec
(the automatic timing output from MySQL is to the hundredth of a second,
which will suffice).
Please help. I am not using PHP at all - just sourcing MySQL query scripts.
Jamie Beu
Lockheed-Martin Information Systems
Software
r/lib/mysql/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
---
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 08, 2002 3:45 PM
To: Jamie Beu
Cc: [EMAIL PROTECTED]
Subject: Re: Replication problem: slave can't lo
the
MySQL online manual.
Jamie Beu
Lockheed-Martin Information Systems
Software Engineer
CTIA
(407) 306-2484
"The true soldier fights not because he hates what is in
front of him, but because he loves what is behind him."
G. K. Chesterton - Illustrated London News, 1/14/11
-Origin
ue'
GROUP BY id
HAVING count(correct)=4
This should work (*although I have not tried it yet*).
Jamie Beu
Lockheed-Martin Information Systems
Software Engineer
CTIA
(407) 306-2484
"The true soldier fights not because he hates what is in
front of him, but because he loves what is behi
sh. I just can't seem to get
replication to work.
I even tried creating a Linux user account for "repl" on ctiadb1 (the master
server), in order to enable file
access for replication. This seemed to work for allowing "load data local
infile" commands, but it did nothin
[safe_mysqld]
err-log=/var/lib/mysql/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
---
Thank you.
Jamie Beu
Lockheed-Martin Information Systems
Software Engineer
CTIA
(407) 306-2484
"The true soldier fights not because he hates what is in
front of him
