We have started using http://www.datahive.ca/ and they've been great and
can't beat the prices.
Travis
EP wrote:
is it just me, or do hosts underestimate how much data we might want
to put in a MySQL database? For instance, 250MB, the largest plan
from that host would not come close to holdi
I have a brand new fresh install of SUSE 9, 64 bit and am trying to
install mysql 64 bit, but I get the following output: I've bolded the
important lines (or at least what i think is important). Has anybody
experienced this?
linux:~ # rpm -i --force MySQL-server-4.0.17-0.x86_64.rpm
warning: M
Very much so. That's why I'm trying to get as much juice out of the cpu
as possible.
Travis
Dan Nelson wrote:
In the last episode (Jan 05), Travis Reeder said:
I'm sure this has been asked before, but I cannot find solid evidence
as to whether switching would provide us wi
Hi,
I'm sure this has been asked before, but I cannot find solid evidence as
to whether switching would provide us with any benefits.
We currently run MyIsam tables on 4.1.x and we are continuously
processing 24 hours/day and using about 20 tables heavily. The process
is generally doing Updat
Here's a little how to on using cron and scp to do automated backups of
your data:
http://www.spaceprogram.com/knowledge/cron_scp.html
Only thing you need to add is the a mysqldump line to your cron script
before calling the scp.
Travis
A. Clausen wrote:
avenger wrote:
but if my table is so
out how to best handle it.
> Any idea why? Are you doing too many table scans? Too much
> computation in the queries? Lots of LIKE "%foo%" queries?
There is maybe 1 LIKE query and I'm sure that's not causing any issues.
Travis
Jeremy Zawodny wrote:
On Tue, Oct 21
I'm sure this has been asked before, but after seeing some benchmarks,
it looks like using innodb is a no brainer. Just want to know why you
wouldn't use innodb?
Travis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
Would innodb tables help?
Travis
Daniel Kasak wrote:
Travis Reeder wrote:
It seems mostly to be mysql pinned, not the app. like 99% mysql until
all data is processed and keeps going up when data coming in is more
than can be processed.
What could I change in my.cnf to get better
:
Travis Reeder wrote:
So I think these are the only options, but if someone has another idea
I'd be glad to hear it. Our current server just isn't handling the
load anymore so, it has single processor
Option 1:
Single server with dual processor and change from IDE to SCSI
Opti
So I think these are the only options, but if someone has another idea
I'd be glad to hear it. Our current server just isn't handling the load
anymore so, it has single processor
Option 1:
Single server with dual processor and change from IDE to SCSI
Option 2:
One server with mysql on it
Are there any gurus out there that can help with optimizing queries /
mysql database, little freelance work? Maybe if I can get the
processing time down, this won't be as much of an issue.
Travis
David Brodbeck wrote:
-Original Message-
From: Travis Reeder [mailto:[EMAIL PROT
It's running on Redhat 9.
Travis
Jeremy Zawodny wrote:
On Thu, Oct 16, 2003 at 02:45:26PM -0600, Travis Reeder wrote:
Is there a way to give mysql a lower priority? I have an app that is
constantly using the database and it is pinning the processor constantly
which makes it hard for
Is there a way to give mysql a lower priority? I have an app that is
constantly using the database and it is pinning the processor constantly
which makes it hard for other applications to run.
Travis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
I am trying to do an aggregate query, but having some problems and here
they are simplified:
Table1
date1
grouper1
x
Table2
date2
grouper2
y
Query is something like this:
SELECT SUM(x) as sum_x, SUM(y) as sum_y
FROM Table1
LEFT OUTER JOIN Table2 on grouper2 = grouper1
(date2 >= '2003-07-01 00:00
14 matches
Mail list logo
