hi,
I've been using mysql-5.1.22 in my project, which processes a lot of
read operations but little write operations. I got the idea from some
of my coworkers that binlog has a chance to be corrputed so that
mysqlbinlog can't process it correctly.
Is there any usable plain text SQL log in mysq
Brent Baisley wrote:
> It's actually a very simple solution, and you should do it all in a
> single INSERT. Putting INSERTs in a loop will kill your performance
> when you try to scale.
>
> $sql4 = 'INSERT INTO test (example) VALUES (' . implode('),(',
> $_POST["categoriesIN"]) . ')';
> $result4 =
>-Original Message-
>From: Hagen Finley [mailto:finha...@comcast.net]
>Sent: Monday, February 23, 2009 11:41 AM
>To: 'MySql'
>Subject: Record IDs
>
>I have a number of duplicate records in my table which are identical
>hence,
>I can't do a delete on the columns without deleting both recor
Here's my test page and, so far, nothing works...
Choose categories...
History
Temples
Cleopatra
Mummies
Brent Baisley wrote:
> It's actually a very simple solution, and you should do it all in a
> single INSERT. Putting INSERTs i
SCSI isn't necessarily faster now. The big difference used to be
SCSI's support for command queueing, which is why it was faster in
multi-user environments. Command queueing is now fairly common in SATA
drives.
The highest end SCSI is probably still faster than the highest end
SATA, but you will ha
On Mon, Feb 23, 2009 at 11:40 AM, Hagen Finley wrote:
> I have a number of duplicate records in my table which are identical hence,
> I can't do a delete on the columns without deleting both records. One
> deletion strategy I have considered is identifying the records by their
> table record id -
You're looking for something like:
This gets called 10 times from another function, but this is sort of
what you're looking for. This gives me a combo-box.
function qselect($mysql_link, $i)
{
$driverquery = "select car_no, drv_name from cars order by car_no
+ 0";
$driverresult =
2009/2/23 Hagen Finley :
> I have a number of duplicate records in my table which are identical hence,
> I can't do a delete on the columns without deleting both records. One
> deletion strategy I have considered is identifying the records by their
> table record id - but I don't know for certain t
I have a number of duplicate records in my table which are identical hence,
I can't do a delete on the columns without deleting both records. One
deletion strategy I have considered is identifying the records by their
table record id - but I don't know for certain that such an identifier
exists or
It's actually a very simple solution, and you should do it all in a
single INSERT. Putting INSERTs in a loop will kill your performance
when you try to scale.
$sql4 = 'INSERT INTO temp (example) VALUES (' . implode('),(',
$_POST["categoriesIN"]) . ')';
$result4 = mysql_query($sql4, $db);
That exa
PJ wrote:
I think this is a tough one... and way above my head:
PLEASE READ ALL OF THE ABOVE TO UNDERSTAND WHAT I AM TRYING TO DO.
Having a bit of a rough time figuring out how to formulate php-mysql to insert
data into fields using a multiple dropdown box in a form.
to post I am using the fo
Hi,
It will never work this way. MySQL has no knowledge of the php variable
$categoriesIN
you can try something like this:
And you should always sanitize the input from forms - the above example is
just to show you how this works. You should check all the values in
$categoriesIN whether they
>-Original Message-
>From: PJ [mailto:af.gour...@videotron.ca]
>Sent: Sunday, February 22, 2009 2:39 PM
>To: MySql
>Subject: book categories
>
>Here's a tough one...
>In my library I have some 62 categories where a number of books can be
>in several categories.
>Now, to relate the "catego
I think this is a tough one... and way above my head:
PLEASE READ ALL OF THE ABOVE TO UNDERSTAND WHAT I AM TRYING TO DO.
Having a bit of a rough time figuring out how to formulate php-mysql to insert
data into fields using a multiple dropdown box in a form.
to post I am using the following:
snip.
What RAID level to use, whether to use SCSI or SATA etc are all pretty
much "how long is a piece of string?" questions. If you have a really
high end hardware array RAID 5 may be faster than RAID1+0 is on a
cheaper system.
Basically
RAID 5 = slower
SATA = slower
RAID 1+0 = faster
SCSI = fa
Backing up MySQL using file system snapshots
http://forge.mysql.com/wiki/Backing_up_MySQL_using_file_system_snapshots
This Thursday (February 26th, 14:00 UTC), Lenz Grimmer will give a MySQL
University session on Backing up MySQL using file system snapshots. Lenz
is a member of the MySQL Community
16 matches
Mail list logo
