We've seen very similar behavior when there are very long SQL queries being
run that are disk intensive.. generally speaking, something is having to
traverse the table (or a temp table) line by line. If he has any logging
capability, see long each SQL query is taking to return to his app then
cle
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 11, 2002 10:03 AM
Subject: Re: license...
| Silmara,
| Monday, June 10, 2002, 10:19:28 PM, you wrote:
|
| SCB> I'm developing a program, that is not free software and i'm usi
Are you positive that you are running compatible versions of MySql on both
platforms?
- Original Message -
From: "Terry" <[EMAIL PROTECTED]>
To: "Luc Foisy" <[EMAIL PROTECTED]>; "MYSQL-List (E-mail)"
<[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 9:59 AM
Subject: RE: replication questio
Hi all,
Does anyone have any numbers on the speed of MySql replication? I am
concerned
with the transfer of up to 10 gigabytes to a master db... what state are
the slaves in during the replication catch up time? Is the delay primarily
related to the network bandwidth? I am assuming that all t
- Original Message -
From: "Keith C. Ivey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Jared Richardson" <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 5:24 PM
Subject: Re: Bug related to large tables and it's indexes on Win2k
| On 4
I replied below
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 3:24 PM
Subject: Re: Bug related to large tables and it's indexes on Win2k
| * Jared Richardson
| [...]
| > CREATE TABLE Ic
| Jared, I can't help solve your problem, but I'd be very interested if you
| got an answer!
|
| Two suggestions though that may be of use:
| 1) Make sure your indexes are healthy
| 2) Try using a MERGE table
Thanks! The indexes are the problem as I understand it... it appears that
MySql is
1) Add 1 or 2 gigs of ram
2) Adjust the my.ini (or my.cnf) settings to use it
This will get your data into memory and off the disk. This will make it run
an order of magnitude faster.
Also, you can buy a P4 from Dell for $599. You might want to throw more
hardware at the problem.
- Origi
we've tested InnoDB with our data (it's all meta data so it's a very
large number of very small bits of data) and found it to be slower than the
ISAM tables for our application.
- Original Message -
From: "Schneck Walter" <[EMAIL PROTECTED]>
To: "'Jar
The table type is the default, MYISAM
- Original Message -
From: "Schneck Walter" <[EMAIL PROTECTED]>
To: "'Jared Richardson '" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 10:11 AM
Subjec
Win2k (at least the version that we are on) does indeed support files much
larger than 2 gigs. Another db we use has index files that are 6.8 gigs and
4.7 gigs.
- Original Message -
From: "miguel solorzano" <[EMAIL PROTECTED]>
To: "Jared Richardson" &l
Hi all,
When large tables are being addressed, we seem to have encountered a bug
related to having large indexes on the table.
We have several tables in our system that have reached 4 gigs in size. We
altered the table definition to allow it to get larger... this is our
current table creation s
- Original Message -
From: "Tonu Samuel" <[EMAIL PROTECTED]>
To: "Manish Mehta" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 6:00 AM
Subject: Re: Windows Threads Support
> On Fri, 2001-10-05 at 08:35, Manish Mehta wrote:
> > Hello,
> >
> > Windows su
f you create the my.cnf
file in the locations indicated by the manual, it is ignored.
Jared Richardson
[EMAIL PROTECTED]
Incellico, Inc.
http://www.incellico.com
-
Before posting, please check:
http://www.mysql.com/manual
14 matches
Mail list logo
