> 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 aw
> 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! Bec
> 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 o
> 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 s
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 scrip
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 tmp_table
> 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 DELET
> 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 th
> 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
>
> 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 su
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 d
>
> 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
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 d
>
> 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 f
>
> Hi,
>
> I've got a couple a questions concerning the speed of insert queries when
> using the C API from MySQL. I've written an application that receives
> data through a CORBA event channel and stores it in a MySQL database. The
> problem is that a lot of events are dropped. I think (I'm qu
> On Wed, Apr 04, 2001 at 05:35:52PM -0600, Mat Murdock wrote:
> >If I understand the manual correctly when I do a "select blah from blah where
>blah = blah order by blah limit 10" Mysql finds the first 10 matching records and
>then sorts those records. How do I have it first sort the dat
> 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 info
days and move the
oldest table(s) into the historical database, merging the records into
a monthly table on the way. I keep 60 days of data in the current database,
and all the rest in historical.
Historical queries tend to run a bit slower, but that's life, and people
making such requests are
>
> 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'
then yes, no problem (one 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?
ar
more simultaneous 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 h
g
all invalid records except for the one with the highest auto_increment
field. A bit messy, but it does work.
The Hooker
--
"I've had a perfectly wonderful evening, but this wasn't it"
-
Before posting, please
gly) that the latest supported
release was a better bet than using something from the development 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
ut there's no mention of problems explicitly related
to the kind of setup that I've got here.
Is there an issue with bulk inserts coming over a network whilst
(different) records are being deleted by local scripts? I can't
imagine it, but who knows?
Any other ideas are,
25 matches
Mail list logo
