3 0/direct fixed
sd0: 237464MB, 512 bytes/sec, 486326272 sec total
Perc6 RAID controller in RAID1 ( i have even tried with one hard disk
and no raid controller and the results are not improved by much) They
are also SATA discs behind.
In fact.. I have also some ogther more sophisticated hardware then
M
Hi,
Your English is fine :) Your queries don't look too bad. It could be
there are no good indexes. Have you tried running EXPLAIN on them?
What version of MySQL are you using? You can also try profiling the
queries (by hand with SHOW STATUS, or more easily with MySQL Query
Profiler) to s
Hi all,
First sorry my bad english :)
I having a problem with a large join with 10 tables with 70Gb of text data,
some joins executed by index but some others not.
I´m work with HP SERVER (Proliant NL-150) a 2 Xeon 2 Duo with 3Gb Ram and
RAID 0.
When executed to a client with small datasets the
Hi Maurice,
You say the MySQL data wasn't on the stuck volume, but were the InnoDB logs?
What is the disk configuration?
It sounds to me like bad hardware/software, which, unfortunately MySQL
and InnoDB cannot protect you from...
Regards,
Jeremy
Maurice Volaski wrote:
Some processes
is corrupt.
InnoDB: Cannot continue operation.
Is it wrong to expect InnoDB to have avoided this or does it suggest
that it couldn't have, i.e., a hardware defect?
--
Maurice Volaski, [EMAIL PROTECTED]
Computing Support, Rose F. Kennedy Center
Albert Einstein College of Medicine of
Hello,
If you have not already done so, check out the Cluster Eval Guide which has some tips which may assist you in your process. Much
of the content was put together by the professional services group here at MySQL.
http://www.mysql.com/why-mysql/white-papers/mysql_cluster_eval_guide.php
Al
Hi,
As usual, everything is heavilly dependant on your specific scenario.
Anyway, as a rule of thumb, databases benefit a LOT from RAM, and storage nodes
benefit from I/O (more, faster disks).
Regards,
Ricardo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
That is not a question that can be answered directly... it come down
to exactly how much data you expect to be handling, how many nodes you
plan on using and what your proposed node configuration might be..
generally, a lot of RAM always helps and in a RAM-based solution like
NDB, of course it's li
all,
I am working on a budget proposal for next year to put in a MySQL cluster
but wanted to validate (or correct) a couple of assumptions:
1. do storage nodes benefit far more from additional RAM than they do from
faster CPUs/multiple cores?
2. do SQL nodes benefit more from faster CPUs/multi
2.5 billion rows. I'm
currently choosing the hardware i'll need. Does anybody know what the
minimum spec of machine is likely to be that I comfortably use? I
imagine the table will have to be Innodb split across a number of files.
It will also need careful indexing to be able to access
ransactions etc. then of course MyISAM is out.
HTH,
Dan
On 2/14/07, richard <[EMAIL PROTECTED]> wrote:
Hi,
I have a table (structure below) which will hold 2.5 billion rows. I'm
currently choosing the hardware i'll need. Does anybody know what the
minimum spec of machine is likely
Hi,
I have a table (structure below) which will hold 2.5 billion rows. I'm
currently choosing the hardware i'll need. Does anybody know what the
minimum spec of machine is likely to be that I comfortably use? I
imagine the table will have to be Innodb split across a number of files
On 12/17/06, Mike Duffy <[EMAIL PROTECTED]> wrote:
I am sure this question has probably been asked in this group before, but
I would like to get an
updated answer.
If you were building your own boxes to run clustered MySQL servers, how
would you configure the
boxes? (This would of course be for
On Sunday 17 December 2006 13:20, Mike Duffy wrote:
> My intuitive judgment is that we would be better having several smaller
> systems in a cluster rather than one huge powerful system and that we would
> be better off building rather than than buying. If you think I am wrong on
> either of these
I am sure this question has probably been asked in this group before, but I
would like to get an
updated answer.
If you were building your own boxes to run clustered MySQL servers, how would
you configure the
boxes? (This would of course be for an enterprise level database system.)
I am looking
Vahric,
There are so many variations between different hardware platforms
that can affect performance on your specific application that it's
better to run benchmarks on the actual hardware if you have it. If not
then Peter Zaitsev's performance blog is the next best reso
Hello ,
I want to test Mysql , on Dual Intel Xeon 2MB Cache CPU and Dual AMD Opteron
platforms for looking differents which one is better then other !
I found something but I want to asl to list , is there anybody have an
experiance about this type tests !
Regards
Vahric MUHTARYAN
Sistem M
Hi,
I'm just looking for any experiences that people might want to offer on this
subject. My project is in the process of selecting hardware to build out
our system, and we are considering getting a few of the new Sun Fire T1000's
to run mysql on.
We are expecting that the project w
I don't have any experience with dual core yet (my first dual dual
core box is scheduled to arrive this week!!). I don't think I'd opt
for a dual core in place of 2 single cores. I'm hoping (expecting?) to
see an advantage in 2 DC over 2 SC.
As far as SCSI over SATA goes, I exclusively use SATA. I
Thanks for all the feedback on this.
Is there any received wisdom on whether 1 dual core processor is better than 2
'normal' processors?
Also, is there any advantage to SCSI over SATA?
TIA,
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
does it absolutely HAVE to be 1u?
if you can go 2u we've been really happy w/HP DL385s lately. 2u form (which
is still pretty small for a DB server), redundant power supplies (a good
thing for DB server), six drive bays (so you can RAID5 or three mirror
pairs), remote management card and Opteron
eb middleware) with an
> ISP, so I have no experience of choosing hardware configurations or sourcing
> them.
>
> My current client's application involves a very large amount of data which I
> have split into a number of tables. These tables (data files) are currently
> bet
James Harvard <[EMAIL PROTECTED]> wrote on 12/12/2005
10:26:42 AM:
> [Apologies for my first post here being semi-off-topic!]
>
> I normally deploys apps I develop (MySQL with Lasso web middleware)
> with an ISP, so I have no experience of choosing hardware
> configurat
[Apologies for my first post here being semi-off-topic!]
I normally deploys apps I develop (MySQL with Lasso web middleware) with an
ISP, so I have no experience of choosing hardware configurations or sourcing
them.
My current client's application involves a very large amount of data wh
Yes... OS X 10.4 with a 32 but MySQL binary is stable... it is the
combination of 64 bit OS (Tiger), and the 64 bit MySQL binary, and
accessing more than 2Gbytes of memory within the mysqld process that
blows up the machine. You can also run the 64 bit binary but keep the
memory allocation
our experiences there too.
Ok, you are almost selling me on getting an Xserve, can you tell
me a bit
about the 64bit issues and how they affect me? I have someone who
may just
donate my a xserve, one of the older ones, but still, not a bad
piece of
hardware at all.
--
on 9/7/05 8:42 PM, Bruce Dembecki at [EMAIL PROTECTED] wrote:
> Yeah, 64 bit isn't working... we can set the memory partition for
> InnoDB to some big number, like say 10G or more (on the 16G Xserves),
> and it will launch, so it has 64 bit OS and 64 bit MySQL Binaries...
> We get past the first h
ng an Xserve, can you tell me
a bit
about the 64bit issues and how they affect me? I have someone who
may just
donate my a xserve, one of the older ones, but still, not a bad
piece of
hardware at all.
--
-
Scott Haneda
For hardware we are just assembling generic Athlon 64 boxes.
I just put together two Dual core A64 4400+ boxes as web
servers, running them as a two node cluster.
My new DB box is a Dual core 4400+ with 4gigs of memory
and 10k sata drives. I know some folks have had trouble with
the 10k
similar to OS X. However, if
someone can tell me a good Linux distro to go with, I will use that.
Mainly, I would like to know what hardware to be looking at, something in
the rack mount style, a 1U would be nice. Bigger if need be.
I just set up a LAMP system on a SunFire V20z dual 248 Opte
me a bit
about the 64bit issues and how they affect me? I have someone who may just
donate my a xserve, one of the older ones, but still, not a bad piece of
hardware at all.
--
-
Scott HanedaTel: 415.898.26
on 9/7/05 11:11 AM, Chris Martin at [EMAIL PROTECTED] wrote:
> I'd definitely try those first before forking out 2 grand.
Its not that I really have a choice, I do not have a spare mac around, so I
need new hardware no matter what. To move OS's on a live mysql server and
then get t
plies. One solution
(the one they are seemingly presenting) may be to change the database
server's hardware platform. But it's not the only solution, and you
should look beyond this one issue to make sure you are choosing
something appropriate to your actual needs.
We're
On 9/7/05, Brent Baisley <[EMAIL PROTECTED]> wrote:
> As you've probably read in the article, the hardware isn't too bad,
> it's OS X that is slowing things down.
Interesting article. Helped me make my decision between OS X, and
Debian on our xServes. It appears bypas
On Wed, 2005-09-07 at 08:30 -0600, Cory Robin wrote:
> Brent Baisley wrote:
>
> > If you do go the new hardware route, I wouldn't go with SCSI is you
> > only have $2K to spend. S-ATA2 based drives would give you similar
> > performance to SCSI, but at a
Brent Baisley wrote:
If you do go the new hardware route, I wouldn't go with SCSI is you
only have $2K to spend. S-ATA2 based drives would give you similar
performance to SCSI, but at a big cost savings. SCSI's big
performance advantage was in command queueing which SATA2 drives
As you've probably read in the article, the hardware isn't too bad,
it's OS X that is slowing things down.
I would first go the free route. Download YellowDog Linux and install
that on your current Mac hardware. That will give you a big boost
when the load starts to climb.
However, if
someone can tell me a good Linux distro to go with, I will use that.
Mainly, I would like to know what hardware to be looking at, something in
the rack mount style, a 1U would be nice. Bigger if need be.
I probably will have two hard drives, set as a mirror, or just use psync or
rsync to c
From: "d2clon"
> im very interested about the limitations and hardware features support.
> for example:
>
> software limitation:
> how much rows does a table can to have?
> how much size of a database does mysql support?
These depend on the version of MySQL and
hello people:
im very interested about the limitations and hardware features support.
for example:
software limitation:
how much rows does a table can to have?
how much size of a database does mysql support?
...
hardware features support:
has mysql multi-processor support? how much processors
as an interesting article
(http://www.anandtech.com/IT/showdoc.aspx?i=2447) on hardware for
Linux database servers.
Some very interesting conclusions:
1) Moving to 64-bit MySQL on a 64-bit Xeon actually decreases
performance by about 12% on average, while an Opteron running 64-bit
MySQL gets
On 18/06/2005, at 4:28 AM, David Griffiths wrote:
Anandtech has an interesting article
(http://www.anandtech.com/IT/showdoc.aspx?i=2447) on hardware for
Linux database servers.
Some very interesting conclusions:
1) Moving to 64-bit MySQL on a 64-bit Xeon actually decreases
performance by
Anandtech has an interesting article
(http://www.anandtech.com/IT/showdoc.aspx?i=2447) on hardware for Linux
database servers.
Some very interesting conclusions:
1) Moving to 64-bit MySQL on a 64-bit Xeon actually decreases
performance by about 12% on average, while an Opteron running 64-bit
day and only
5 days a week. Very different software and hardware requirements and
probably traffic patterns. Amazon and eBay would both require
clustering and load balancing, Woot would probably only require
automatic failover.
Many is a relative term and so is high performance and high
av
to find as much information as possible about the hardware
requirements like number of processors, necessary memory, cache, HD... to
use in a high performance MySQL server
With an open-ended question like yours, your going to get open-ended answers.
I am running MySQL on several machines. One of tho
Hello,
I'm doing an University project and I need to "buy" a server for a business.
I have to simulate an enterprise that sells by Internet. There are many
clients and products in the Data Base and we use MySQL in a Linux OS.
I need to find as much information as possible abo
database.
Can anybody help us by recomending a suitable hardware and architectural
configuration for the the database.
With Regards,
Suryya
We won't be serving concurrent queries.
On Sun, 2004-11-07 at 10:41, Michael J. Pawlowsky wrote:
> Another thing to consider is how many transactions per minute/second you
> will need to serve.
>
> Mark Maunder wrote:
> > I'm busy building an application that will have 10 million records, each
Another thing to consider is how many transactions per minute/second you
will need to serve.
Mark Maunder wrote:
I'm busy building an application that will have 10 million records, each
with a chunk of text - about 500 words each, on average. Does anyone
have any benchmarks they can share with my
I'm busy building an application that will have 10 million records, each
with a chunk of text - about 500 words each, on average. Does anyone
have any benchmarks they can share with mysql's fulltext search
performance on indexes of this size?
What I'd like to know is what size server I need to run
> 1) would it be better to go brandnew with a single processor or like a quad
> p4 that's a year or two old.
Depends on how your application runs. BTW, I don't think they made
quad p4's. You can't run p4 chips in SMP -- they must be Xeon's.
>
> 2) I am going to running raid 5, so I assume that I
Hello,
I am building a new linux box , just to be an mysql server
I have a couple of questions.
1) would it be better to go brandnew with a single processor or like a quad
p4 that's a year or two old.
2) I am going to running raid 5, so I assume that I should run scsi drives?
3) my database i
David Griffiths wrote:
We just put a new dual-Opteron server into our production environment.
We ordered a Megaraid SCSI card and five 10k drives, and a 3Ware
Escalade SATA card with six 7200 RPM drives (Maxtor) to see which ones
were best.
Our network guy did a bunch of benchmarking on the dri
On Mon, 19 Jul 2004 18:13:36 +0200, Jan Kirchhoff <[EMAIL PROTECTED]> wrote:
> Hi,
>
> We are currently using a 4.0.16-replication-setup (debian-linux, kernel
> 2.4.21, xfs) of two 2.4ghz Intel-Pentium4 systems with 3gig RAM each
> and SCSI-Hardware-Raid, connected via gig
course we don't want to waste it
for scsi-hardware if we can reach almost the same speed with
hardware sata-raids.
'Almost' is a key word. Some SCSI disk are working at 15k RPM, which
will give
you a HUGE MySQL performance growth compared to 10k disks.
AFAIR, there are
shouldn't it be possible to reach the
speed of fast scsi-discs by simply taking 2-3 fast sata-discs in a
hardware raid0?
Our goal is a raid10, so reading should be even faster.
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Envi
Egor Egorov wrote:
Money is not really an issue but of course we don't want to waste it for
scsi-hardware if we can reach almost the same speed with hardware
sata-raids.
'Almost' is a key word. Some SCSI disk are working at 15k RPM, which will give
you a HUGE MySQL per
Jan Kirchhoff <[EMAIL PROTECTED]> wrote:
> Money is not really an issue but of course we don't want to waste it for
> scsi-hardware if we can reach almost the same speed with hardware
> sata-raids.
'Almost' is a key word. Some SCSI disk are working at 15k RPM, wh
Hi,
We are currently using a 4.0.16-replication-setup (debian-linux, kernel
2.4.21, xfs) of two 2.4ghz Intel-Pentium4 systems with 3gig RAM each
and SCSI-Hardware-Raid, connected via gigabit-ethernet. We are reaching
the limit of those systems and are going to buy new hardware as well as
Currently running MySQl on AIX 5.1, F40
-Original Message-
From: Zak Greant [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 3:10 PM
To: [EMAIL PROTECTED]
Subject: Any MySQL + IBM Power CPU Hardware (pSeries, iSeries, JS20,
Blade) Users?
Greetings All!
MySQL AB is interested in
Greetings All!
MySQL AB is interested in talking to MySQL users who running MySQL on
IBM Power CPU server hardware (pSeries, iSeries, JS20
Blade).
If you (or someone you know) are willing to chat with us, please let me
know at [EMAIL PROTECTED]
Thank you for your help!
Cheers!
--
Zak Greant
ics.co.uk
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
Sent: 26 May 2004 14:10
To: [EMAIL PROTECTED]
Subject: RE: Running MySQL and PostgreSQL on the same hardware
Thanks Kevin,
I am comfortable with the software installs etc.. I was more concerned
with hardware bottlenec
Thanks Kevin,
I am comfortable with the software installs etc.. I was more concerned
with hardware bottlenecks and OS (linux 2.4) problems etc..
Any pointers would be great..
Cheers,
Andrew
-Original Message-
From: Kevin Cowley [mailto:[EMAIL PROTECTED]
Sent: Wednesday 26 May 2004
or over a
month.
Kevin Cowley
R&D
Tel: 0118 902 9099 (direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
Sent: 26 May 2004 10:47
To: [EMAIL PROTECTED]
Subject: Running MySQL and PostgreSQL o
Hi All,
Does anyone have any experience of running MySQL and PostgreSQL on the
same hardware?
At the moment we have several reasonable fast servers (dual Xeon GHz,
1GB ram, 15,000rpm scsi disk) running MySQL in a replicated environment
with high volumes of queries (high read:write ratio) and I
only these "GROUP BY" type operations are
slower on the new box! They must use the hardware in a different way?
Here is a summary of what I see regarding the CPU cache (from dmesg). Do you think
these figures support your theory? (I'm not sure how Athlons compare to Xeons?) Note
that
Kevin Cowley wrote:
Don't tell me - you upgraded a PIII server to a PIV server?
The cache on the PIV is les than half the size of a PIII.
We've hit this problem with our own apps that by the way they operate cache
a lot of data. A PIII 1.4GHz will match a 2.4 GHz PIV.
Yes, MySQL code is written wit
IL PROTECTED]
> Subject: upgraded hardware: new server is faster, but "GROUP BY"
> operations are slower???
>
>
> Hi all,
>
> Just bought a new server, which was supposed to improve the performance of
> our app.
>
> The new machine has the same OS (Redhat 8), same
2 9099 (direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
-Original Message-
From: Charles, Tony (Exchange) [mailto:[EMAIL PROTECTED]
Sent: 21 May 2004 18:47
To: [EMAIL PROTECTED]
Subject: upgraded hardware: new server is faster, but "GROUP BY" operation
Hi all,
Just bought a new server, which was supposed to improve the performance of our app.
The new machine has the same OS (Redhat 8), same MySQL (4.0.18), and same my.cnf.
The problem is that this (frequently run) query, actually runs 41% slower!
select * from LEG L, LEG_DETAIL D, DEAL
--- "PARTHA DUTTA, BLOOMBERG/ 499 PARK"
<[EMAIL PROTECTED]> wrote:
> Hello all, I would like to find out if anyone has
> implemented an architecture
> where a hardware load balancer is placed in front of
> some MySQL servers in a
> Multi-master replication sc
Sounds like you might be interested in Emic Networks' Application
Cluster 2.0 for MySQL. We've begun taking a look at it ourselves --
without arriving at any conclusions at this point.
(However, it is not strictly a hardware solution.)
General Info:
http://www.emicnetworks.co
On Thu, May 13, 2004 at 06:49:01AM -0400, PARTHA DUTTA, BLOOMBERG/ 499 PARK wrote:
> Hello all, I would like to find out if anyone has implemented an architecture
> where a hardware load balancer is placed in front of some MySQL servers in a
> Multi-master replication scheme. I want t
Hello all, I would like to find out if anyone has implemented an architecture
where a hardware load balancer is placed in front of some MySQL servers in a
Multi-master replication scheme. I want to use the load balancer more for high
availability, than for load balancing. All connections to
Tim Cutts wrote:
On 30 Mar 2004, at 09:05, Tim Cutts wrote:
SATA RAID devices aren't that bad, you know, and they are a lot
cheaper than equivalent amounts of SCSI storage. We've used NexSan
ATABoy devices, which are relatively cheap, and get you a lot of
storage in very little space (10GB in
On 30 Mar 2004, at 09:05, Tim Cutts wrote:
SATA RAID devices aren't that bad, you know, and they are a lot
cheaper than equivalent amounts of SCSI storage. We've used NexSan
ATABoy devices, which are relatively cheap, and get you a lot of
storage in very little space (10GB in a 3U box).
I did
First off, thanks so far for the valuable input.
I have a few tables that are relatively large (approx. 18 mil records and
8GB of data in one) and growing so I will be looking more toward higher end
hardware. However without infintely deep pockets, I'm wondering where the
best place is to
On 29 Mar 2004, at 23:55, Donny Simonton wrote:
SCSI, 15,000 RPM drives and a decent amount of memory 2-16 gigs. Dual
procs
definitely do help; we have tried it with dual procs with
hyperthreading and
without and with hyperthreading seems to be much faster.
Besides that, you can run it on any
and have always run MySQL on
older generation Sun servers running Solaris 8. I now seem to be
outgrowing my setup and I (and I'm sure others on the list) would
appreciate input from the MySQL community as to which hardware, OS, and
MySQL flavor/version combinations are best for running MySQL. I expect
x27;s our choice.
But just say no to IDE drives!
Donny
> -Original Message-
> From: Chad Attermann [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 29, 2004 3:56 PM
> To: [EMAIL PROTECTED]
> Subject: Best Performing Hardware/OS/MySQL?
>
> Hello All,
>
> I have
Hello All,
I have been a MySQL user for some time and have always run MySQL on older generation
Sun servers running Solaris 8. I now seem to be outgrowing my setup and I (and I'm
sure others on the list) would appreciate input from the MySQL community as to which
hardware, OS, and
Thanks to all who helped me out. It seems I missed an essential AND
statement in my query. Including it brought me from 32 seconds to about 1-2
seconds and all seems to be doing fairly well. I'm a little concerned at
this point for the work I'm asking the hardware to do.
The server
Response
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ping
> a number of databases or are there some guidelines I can use?
The best solution I've found, aside from intimate knowledge of the
application and db server software, is testing. Do some stress
testing on whatever hardware you can get your hands on. That'll often
provide so
Greetings.
Does anyone have any suggestions besides trial and error for determining how
resource intensive my database is going to be?
Is this just something the a developer just gets a feel for after developing
a number of databases or are there some guidelines I can use?
Thanks for any help!
THanks everyone for all your help!
Steve
- Original Message -
From: "Pete Harlan" <[EMAIL PROTECTED]>
To: "David T-G" <[EMAIL PROTECTED]>
Cc: "mysql users" <[EMAIL PROTECTED]>; "Steve Vernon"
<[EMAIL PROTECTED]>
Sent: Frida
on and
% backups at the moment. So I plan to stop MySQL. Copy the database files to a
How on earth do you have 10G of data to handle without any budget for
replication or backups? What happens when your hardware breaks, or even
someone fat-fingers a delete command?
% temp directory. THen download
On Fri, Oct 31, 2003 at 05:44:02AM -0500, David T-G wrote:
> %
> % Does the 2 Gig file size limit on Linux get broken when I have a hardware
> % raid controller?
>
> The limit applies only to ext2 filesystems, and not all of them at that;
> ext3 and reiserfs (and others) can
---
-Original Message-
From: Steve Vernon [mailto:[EMAIL PROTECTED]
Sent: 31 October 2003 14:19
To: Peter Lovatt; Mysql List
Subject: Re: Hardware Raid and 2 Gig Limit
Hiya!
Thanks for the help!!!
Do RSync like big files? Or does it prefer smaller
ovatt" <[EMAIL PROTECTED]>
To: "Steve Vernon" <[EMAIL PROTECTED]>; "Mysql List"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, October 31, 2003 12:17 PM
Subject: RE: Hardware Raid and 2 Gig Limit
> Hi
>
> We have a similar challenge
Don't confuse hardware RAID with MySQL RAID. The 2GB file size limit is
a function of the operating system and the file system in use, it has
nothing to do with the disk hardware you have installed.
Your ISP may say you don't need the raid option activated because the
system they
[mailto:[EMAIL PROTECTED]
Sent: 31 October 2003 12:00
To: Mysql List
Cc: [EMAIL PROTECTED]
Subject: Re: Hardware Raid and 2 Gig Limit
Hiya!
Thanks for the quick reply!!!
But dosen't it make more sense to have 20 0.5 Gig files rather than one 10
Gig file?
I know you can split files, but basi
I looked into big tables for myself and everyone said
you need the raid option in MySQL. Now I'm not sure!
Thanks,
Steve
- Original Message -
From: "David T-G" <[EMAIL PROTECTED]>
To: "mysql users" <[EMAIL PROTECTED]>
Cc: "Steve Vernon" <
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steve --
...and then Steve Vernon said...
%
% Hello,
Hi!
%
% Does the 2 Gig file size limit on Linux get broken when I have a hardware
% raid controller?
The limit applies only to ext2 filesystems, and not all of them at that;
ext3 and reiserfs
Hello,
Does the 2 Gig file size limit on Linux get broken when I have a hardware
raid controller?
My ISP says I don't need the raid option activated on MySQL.
Thanks,
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi all,
I am a novice in mySQL and would like to use it to embark a Ecommerce
project. I have the following OS/Hardware issues that I hope to know:
1. I plan to install in Red Hat Linux Advanced Server. What version is
certified, any pre-reqs?
2. I will use Intel server. What chip is
Hi all,
I am a novice in mySQL and would like to use it to embark a Ecommerce project. I have
the following OS/Hardware issues that I hope to know:
1. I plan to install in Red Hat Linux Advanced Server. What version is certified, any
pre-reqs?
2. I will use Intel server. What chip is
Well I probably can tweak the queries, but there are a LOT of them. It
is for http://www.ecommstats.com so we get a TON of requests that have
to processed with probably ~20 queries (selects, inserts, updates), then
there is a maintenance program that runs every few minutes to clean
things up a
On Tue, Oct 21, 2003 at 08:59:31PM -0600, 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.
So MySQL is using 99% of the CPU?
Any idea why? Are you doing
1 - 100 of 208 matches
Mail list logo
