We don't cache connections, either, and the connection overhead appears to
be trivial, connecting to a remote MySQL server over the local Ethernet.
50,000 to 100,000 Apache::ASP pages served per day, some with many rather
complex queries.
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
Try Apache::ASP -- ASP syntax with mod_perl on Apache.
http://www.nodeworks.com/asp/
We run a pretty busy database-driven web site with Apache::ASP and MySQL.
I'm quite happy with it, as it gives us access to the massive collection of
Perl modules, and enables us to use a single language for scrip
[Sorry about the early send on the previous one ...]
I just upgraded our web server from 3.23.47 to 4.02 -- and I must say that
4.02 performance rocks! :-)
I was planning to wait for the beta builds, but the thing that triggered my
decision was the discovery of the query cache. Our database se
I just upgraded our web server from 3.23.47 to 4.02 -- and I must say that
4.02 performance rocks! :-)
I was planning to wait for the beta builds, but the thing that triggered my
decision was the discovery of the query cache. Our database server (1.4 GHz
Athlon on FreeBSD) typically runs betwee
Jens,
You need to select on the games on the left, to ensure that you don't end up
with years on the left with no corresponding game records. Try this:
SELECT years.year AS yearlist, count(years.year) AS gamecount
FROM games
LEFT JOIN years
ON games.release_year = years.year
GROUP BY years.y
Fred,
You could use something like daemontools (http://cr.yp.to/daemontools.html)
or safetynet (http://www.unixpimps.org/software/safetynet/).
All assuming you are using a UNIX-type platform, of course.
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Fred Taurus [mailto:[EMAIL
Greg,
Your best bet is to feed the data into Perl -- relatively simple Perl script
can deal with variances you indicate, and feed the data into MySQL using
DBI.
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Greg Peretti [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 03 January, 2
And, alas, by the time MySQL finishes building my 500 MB fulltext index
(more than 12 hours) the table is throroughly corrupted, and myisamchk can't
even recover it with -o.
I'm waiting for 4.01 to go beta, and will then give it a try to see if
things are happier there.
Tom Haapanen
[EMAIL PROTE
Is this too simple?
select distinct p.symbol, i.name from portfolio p, stockinfo i
where p.symbol = i.symbol
and p.type = '401k'
and p.owner='jim'
order by p.symbol
-
Tom Haapanen -- Software Metrics/Equitrac Corp.
Advanced Printing Solutions -- http://www.metrics.com/
-Original Me
Matthew,
Without any more information, I would put money on this being either a
database design issue or a query design issue. I really expect that
database optimization would buy you a lot of performance.
But without knowing what kind of database structure you have, what kind of
queries you ru
Hank,
I suspect some of the NetBSD threading comments you found in the archives
may be mine.
We run NetBSD/Alpha for our site (motorsport.com) on the web server, our
"work" server, plus several other boxes. We originally did the same for the
database server, but, at the time (this being early
This might work ... but I don't have a suitable database to test with ...
select * from students,grades
where students.id=grades.id
and min(grades.grade - students.average_grade) > 0
group by students.id
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: David Hugh-Jones [mailt
select hour(ts), count(ts) from dundeefw
where date=$date and action=1
group by hour(ts)
Assuming "ts" is your timestamp column ...
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Leon Noble [mailto:[EMAIL PROTECTED]]
Sent: 23 October 2001 05:45
To: [EMAIL PROTECTED]
Subject:
educe the amount of indexing in order to speed up
your inserts...
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Priya Ramkumar [mailto:[EMAIL PROTECTED]]
Sent: 22 October 2001 06:26
To: Haapanen, Tom
Cc: [EMAIL PROTECTED]
Subject: Re: faster inserts & updates
Hi Tom,
T
Priya,
Need more information ... how long does it take to insert 28,000 records?
On what kind of platform? How much data do the records contain? What kind
of primary keys and indices do you have?
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Priya Ramkumar [mailto:[EMAIL P
Joe,
It's possible to create a table for each image. However, as others have
suggested, in most cases, it makes more sense to have an images table, with
all the images, and with a unique image ID for each image (you can create
your own or use autoincrement). You can then have tables like review
25M tables in one database -- wow. How big were the tables?
Was this with MySQL? Which OS and filesystem did you run this on?
Given that MySQL stores each table in three separate files in the database
directory, that would imply 75,000, files in the directory containing
the database -- and
Jamie,
This is likely a client software issue. We use Perl and DBI, and we have no
trouble storing or retrieving non-USASCII characters.
What are you using to access the MySQL database?
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Jamie Smith [mailto:[EMAIL PROTECTED]]
Sent
A piece of cake for MySQL.
Our news/photo database is growing by nearly 10,000 records per month, with
no noticeable performance impact. As long as you design your database
structure and queries right ...
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Paul Murphy [mailto:[EMA
Bruce,
Why not just determine this number when you do a query? Why do you need to
have it be stored in the database?
It's easy to create a Perl (or probably PHP, but I really don't know PHP)
script to fill in such a column, too, but you would need to manually
maintain that. And right now I don
This helps you convert the data to a MySQL database (a much faster and more
robust datastore than JET).
If you need to access the data from both platforms, including existing
Access applications, install MyODBC on NT, create a suitable ODBC DSN and,
then, in Access, use File > Get External Data
MySQL is not Oracle ... and that's a good thing, too! :-)
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Joe Kaiping [mailto:[EMAIL PROTECTED]]
Sent: 30 September 2001 19:37
To: [EMAIL PROTECTED]
Subject: RE: why would LOWER
Thanks to all for your responses. I had missed t
MAIL PROTECTED]]
Sent: 29 September 2001 21:31
To: [EMAIL PROTECTED]
Cc: Haapanen, Tom
Subject: RE: Powered by MySQL?
True you did email, but look at the email address you send your request;
Quote" I have sent email to [EMAIL PROTECTED], but I have received no
response."
So, you
What hostname are you providing JSP? If you want to replicate the behaviour
of your mysql command, it needs to be "localhost" or 127.0.0.1, not the
network name of your server.
If you are using the server name, then you need to use mysql command the
same way, too:
./mysql -u root -h servername -
Michael,
MySQL worked beatifully for us on a vanilla FreeBSD system -- I simply
installed the binary (precompiled) package from the FreeBSD ports
collection. I recommend you get the binary rather than playing with the
configuration yourself ...
-
Tom Haapanen -- Software Metrics/Equitrac Co
n
[EMAIL PROTECTED] (nights)
[EMAIL PROTECTED] (days)
-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 18 July, 2001 10:51
To: Haapanen, Tom;
Subject: Re: MySQL loves FreeBSD (but not NetBSD) ...
Hi Tom,
As another user of MySQL on FreeBSD, I can tell
... or should that be "FreeBSD loves MySQL"?
I finally caved in after a year of increasing (and unexplained) MySQL
crashes, despite numerous updates to more recent versions of NetBSD and
MySQL, and dozens of experiments with different configuration options.
MySQL would die (and restart automatica
Our normally reliable back-end server for our web site has now gone
completely crazy ... it's falling over every few seconds. Automatic
restarts are nice, but it really makes the web site unusable.
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack t
28 matches
Mail list logo
