Paul DuBois wrote:
At 1:12 +0100 3/14/03, Nico van Leeuwen wrote:
When I delete something how do I make sure there isn't a trace of it
left? I am looking for a linux shred type solution. There should be
absolutely no possibility of data recovery.
As far as I'm aware, there isn't
I need help. I am building a database for a small college that wants to be
able to update their program information for each department through an
web/gui program.
I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my
web page this way)
Here's my QUESTION! Because
It would be helpful to know how much data you are trying to pump across.
If you are having trouble finishing in under 30 seconds over a 100mb
connection, it must be a lot of data.
The first thing to check is to make sure you have your connections set
to full duplex. Even if there are only
I just got done playing with this same scenario.
If the task finishes locally OK, but totally dogs on the network, then you
may have a network issue, NOT a MySQL issue.
1) Make sure that the switch and boxes are set to full duplex operation.
This will eliminate collisions. Make sure
Hi,
I'm running MySQL 3.23.51 on a Debian Linux server, and I've got a
performance question.
I have a perl application which builds up data in memory (in a hash) and
every 30 seconds forks and writes the data to a database. When both perl
script and MySQL server are on the same machine, the
Hi,
I've got a problem with HEAP tables (undoubtedly the way
that I'm using them).
I'm running MySQL v.3.23.51 under Debian Linux with a
2.4.17 kernel.
I've got a perl script which creates a HELP table and
controls the maximum size via the 'max_rows=' option
to 'create table'.
When the script
Hi,
We're running MySQL 3.23.49 under Debian Linux with a 2.4.19
kernel.
I've got a 2-part question about tmp_table_size.
1) I've tried setting 'tmp_table_size' from the MySQL command
interpreter, and I keep getting told that I have an SQL syntax
error. The command is :
set
Yes, but, this advice does *not* go on to describe how you cope with the
deletion problem.
If you store data in records in the database a DELETE will delete *all* the
data for the set of rows. If some of the data is lying around in disk files
these obviously don't get deleted by DELETE. So
Steve Rapaport wrote:
Someone correctly pointed out today that it's not Mysql's job
to be Google, and I agree. But it seems to me that it would be
fair for mysql to be able to handle searches in under 1 second
for databases 1 millionth the size of Google. All I want here
is a decent
While any speed up with a full table fulltext search would be helpful
and useful, there are instances where the search is intersected with
another column and the problem of search is therefore more complex but
also leads to potential optimizations.
In our case we rarely do searches that
In my previous job supporting MSSQL at hospitals all across North America,
Europe and Australia, Critical Incident support from M$, ranged from 36
hours to 4 days for a resolution. Often we solved it ourselves long before
we had an answer from M$... Sad really... MySQL support is far
Well, dunno about that, but I've got a system here which I designed round
the fact that MySQL *doesn't* have RI.
When a customer gets deleted (or changes it's reference id), the data for
the old id has to remain in the system. I know that if I was using a
product which enforces RI I'd design it
Seth Northrop writes:
010624 19:44:23 Aborted connection 231 to db: 'unconnected' user: 'root'
host: `localhost' (Got timeout reading communication packets)
The above only implies that your program exited without calling
mysql_close(). Nothing to do with your problem.
OTOH, if you use mod_perl, *all* scripts are cached. That way you can have
a single script per function, which makes each smaller and simpler to debug.
Paul Wilson
iiNet Ltd
Cindy, read my reply to this. You are mistaken. There is actually a way
to make a single script do all kinds of
I found FULLTEXT (MATCH/AGAINST) indexes and the SOUNDEX function. Are
there other MySQL features that help with Fuzzy searching?
Soundex seems very useful, but I'm not sure how to apply it to multi-word
strings.
I'd also be interested in pointers to general info on writing fuzzy
Thanks, Fred. The delete job has been running for 21 hours
at this point, and now rather simple queries on other tables hang
(e.g. SELECT COUNT(*) FROM other_table WHERE index=3Dsome_value).
I'll let it run overnight to see what happens, but I'm not hopeful.
Here's some addition
How do you decide when a table should go into another database. For
example, I have a database with about 12 tables and growing. I keep
them in one database because I am doing joins that periodically involve
all of the tables. Is this the right way to do it?
Richard
Richard, I'm not
of my
production machines has 5), and they will all be available to PHP, subject,
obviously to permissions.
If you mean can you have more than one instance of MYSQL running, that's
different. You may be able to (I've no experience here), but why would
you want to?
The Hooker
--
"The more cra
enquiries that way than it will with a single complex
SQL query.
Hope this helps some.
The Hooker
--
"I've had a perfectly wonderful evening, but this wasn't it"
I am in the process of building a search engine on a database. I have two
tables that have a many-to-many relationship: A s
pment tree,
although I *do* understand that the MySQL development branch is perhaps
more stable than some commercial products !!
We're in the process of arranging comemrcial support, which also made me
look at 3.22.x in preference.
The Hooker
--
"Did the aliens forget to remove
20 matches
Mail list logo