2014-02-12 12:32 GMT+01:00 Lukas Lehner :
> Hi Antonio
>
> all tables use InnoDB. The size is 27 GB (not yet in prod). I guess in prod
> it will be fast 80GB.
>
Depending on how your application is going to use MySQL resources you will
need to tweak some things (and not only MySQL).
If it is goin
Hi Lukas,
In that case, such as Adarsh has said, you can configure until 70% of your
RAM for innodb_buffer_pool_size.
In your case, with 3GB RAM, I suggest you to configure until 2GB for MySQL:
Minimal for MyISAM (Maybe 32MB), and the rest for InnoDB. Your problem will
be loading data. Maybe your
Hi
it's also a Tomcat application server. Not dedicated MySQL instance.
On Wed, Feb 12, 2014 at 11:28 AM, Adarsh Sharma wrote:
> Is it a standalone DB server or Application is also hosted on top of it.
>
> You can give 50-70% of RAM to memory parameters like
> Innodb_buffer_pool_size ( Innodb )
Hi Antonio
all tables use InnoDB. The size is 27 GB (not yet in prod). I guess in prod
it will be fast 80GB.
thanks
On Wed, Feb 12, 2014 at 10:28 AM, Antonio Fernández Pérez <
antoniofernan...@fabergames.com> wrote:
> Hi Lukas,
>
> What is your default engine? In MySQL there are a lot of param
Is it a standalone DB server or Application is also hosted on top of it.
You can give 50-70% of RAM to memory parameters like
Innodb_buffer_pool_size ( Innodb ) and key_cache ( Myisam ) for mysql
tables.
Below link : http://mysql.rjweb.org/doc.php/memory will give you a brief
idea.
Thanks
Hi Lukas,
What is your default engine? In MySQL there are a lot of parameters that
configure the engine behaviour. Depends on the engine, I suggest you to add
some parameters or others.
Also it's important to know the size of your data. Your configuration is
minimal and by default is not optimal.
Hi
We will use a Java application which uses Hibernate for DB calls. The
vendor didn't made recommendations howto configure MySQL. The application
is not yet in production.
MySQL is new to me, I previously used Oracle DB. The vendor provided a
guide howto configure Oracle.
This is our my.conf
$
Adarsh Sharma wrote:
Thanks for the suggestions.
Last thing to close this topic :-
I create new partitions & files for ibdata files as :-
log-bin=/hdd5-1/mysql-bin
innodb_data_file_path =
/hdd2-1/innodb_data1/ibdata1:250G;/hdd3-1/innodb_data2/ibdata2:250G;/hdd4-1/innodb_data3/ibd
- Original Message -
> From: "Adarsh Sharma"
> 1. I am planning to to fix one partition /hdd2-1 for my binary logs
> for HA, rotate them monthly to extra backups.
Keeping binary and other logs on separate disks from your datafiles is a very
good plan. For backup purposes, make sure you
. As a general rule, it's a good idea to have
one datafile per physical disk. Putting more datafiles on a single disk doesn't
magically increase parallellism.
- Original Message -
From: "Adarsh Sharma"
To: "mysql"
Sent: Monday, 23 January, 2012 10:50:
> Dear all,
>
> I have some doubts regarding the configuration of Innodb files structure.
> As we know all myisam tables are stored in database directory and innodb
> use tablespaces ( ibdata1 ).
> In My application , databases are the mixture of mysql & innodb storage
> engines.
> In my database
o: "mysql"
> Sent: Monday, 23 January, 2012 10:50:33 AM
> Subject: Suggestions for ibdata files structure
>
> Dear all,
>
> I have some doubts regarding the configuration of Innodb files
> structure.
> As we know all myisam tables are stored in database d
http://www.linkedin.com/in/rolandoedwards
-Original Message-
From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com]
Sent: Wednesday, March 16, 2011 5:33 AM
To: Johan De Meersman
Cc: mysql@lists.mysql.com
Subject: Re: Suggestions for InnoDB files
Johan De Meersman wrote:
>> From: &quo
- Original Message -
> From: "Adarsh Sharma"
> Johan De Meersman wrote:
> A Heartiest Thanks from my heart for explaining all these things in a
> fantastic manner. I agreed with your suggestions but one thing which
> isn't explained from your side , as you
disks into the wrong bays)
So, yes, my recommendation remains the same: switch the system to software
RAID; preferably 10, 5 or 0 if you really need all that space.
A Heartiest Thanks from my heart for explaining all these things in a
fantastic manner. I agreed with your suggestions but one t
> From: "Adarsh Sharma"
>
> Johan De Meersman wrote:
> > Interesting, but why like this instead of simply larger disks or raidsets ?
>
> It's the IT-Admin Issue , I can't question that and we have only disks of
> 300GB ( SAS ).
Your admin is supposed to provide services that benefit the applicat
- Original Message -
> From: "Adarsh Sharma"
>
> Dear all,
>
> I have doubt regarding the storage structure for Innodb files :
>
> Our database server has the following paths :
>
> /dev/sda5 69G 35G 32G52% /hdd1-1
> /dev/sdb1 274G 225G 36G 87% /hdd2
Dear all,
I have doubt regarding the storage structure for Innodb files :
Our database server has the following paths :
/dev/sda5 69G 35G 32G52% /hdd1-1
/dev/sdb1 274G 225G 36G 87% /hdd2-1
/dev/sdc5 274G 225G 36G 87% /hdd3-1
/dev/sdd5
A simple way to do this is to truncate the date and then GROUP BY it. So if
you have 2009-08-08, and you want a subset on month, then just truncate the
day-part: 2009-08-00 on the whole column, and SELECT DISTINCT so you have a
subset. You can use this subset then to join the dates, GROUP BY and
.
Baroda - 390007
Gujarat, India
Personally I'm always ready to learn, although I do not always like being taught
From: Gavin Towey
To: Sudhir N ; Mysql
Sent: Tue, 15 December, 2009 2:16:53 AM
Subject: RE: Optimization suggestions
Id should probably
y, December 14, 2009 10:31 AM
To: Mysql
Subject: Optimization suggestions
I have following table structure, I have to use merge storage engine.
Please have a look, and provide feedback if theres some thing wrong or if
there's space for optimization.
/*Table structure for table `messa
After one very quick look, the index on folderid alone is unnecessary since
you have another index in which that field is the high-order field.
On Mon, Dec 14, 2009 at 12:31 PM, Sudhir N wrote:
> I have following table structure, I have to use merge storage engine.
> Please have a look, and prov
I have following table structure, I have to use merge storage engine.
Please have a look, and provide feedback if theres some thing wrong or if
there's space for optimization.
/*Table structure for table `messages2009` */
CREATE TABLE `messages2009` (
`id` varchar(36) NOT NULL default '',
`
like this: one raid 1 for the system,
>> one raid 1 for logfiles, one raid 1+0/0+1 for the database.
>>
>> Any suggestions?
>
> I have a very similar HP box with 8 drives too - I've got it running one
> RAID1 (2x72Gb) for system and one RAID6 (6x146Gb) for da
reads.)
>
> What would be a good raid-Layout for the server?
>
> I was thinking of one large 1+0 or 0+1 as 1.2TB would be more than
> enought.
>
> Or may be I do split things up like this: one raid 1 for the system,
> one raid 1 for logfiles, one raid 1+0/0+1 for the dat
ne large 1+0 or 0+1 as 1.2TB would be more than enought.
Or may be I do split things up like this: one raid 1 for the system, one
raid 1 for logfiles, one raid 1+0/0+1 for the database.
Any suggestions?
Thanks and best regards,
Götz
--
Götz Reinicke
IT-Koordinator
Tel. +49 7141 9
Hi Götz,
On Dienstag, 9. Dezember 2008, Götz Reinicke wrote:
| My question is, what do you think about using e.g. one server as
| webserver, the other as mysql server ... so the database traffic will go
| across the network. So that I have only one service running on one
| server and not like now
tage from my point of view: I only have one mysql
> server to manage and not three or four. (Likewise the webserver)
>
> The disadvantage would be the delay accross the network I think.
>
>
> Thanks for any helpful suggestions and best regards
>
> Götz
> --
> Götz Re
and not like now the webserver bundled with the database.
The most obvious advantage from my point of view: I only have one mysql
server to manage and not three or four. (Likewise the webserver)
The disadvantage would be the delay accross the network I think.
Thanks for any helpful suggestions
some performance tuning suggestions/help from you.
At my job, I am going to build a Web Server with
1. FreeBSD 7.0-RELEASE amd64
2. Apache 2.2.8
3. PHP 4.4.8 (or may be PHP5, what do you suggest?)
Server's hardware configuration is as follow:
2 x Quad Core Xeon E5450 3.0GHz,2x6MB,1333FSB
Hi all !
VeeJay wrote:
[[...]]
At my job, I am going to build a Web Server with
1. FreeBSD 7.0-RELEASE amd64
2. Apache 2.2.8
3. PHP 4.4.8 (or may be PHP5, what do you suggest?)
Server's hardware configuration is as follow:
2 x Quad Core Xeon E5450 3.0GHz,2x6MB,1333FSB
16GB (8x2GB Dua
QL's
greatest bottleneck is disk I/O. I'm wondering if I would be better
off with just one processor to start with (are they easy to add later,
btw?), maybe add more RAM, and just save some cash.
Any thoughts or suggestions are much appreciated. I have to pull the
trigger on this soon
SELECT * FROM tablename PROCEDURE ANALYSE()
Anyone know of a way to get the size of a row in bytes?
-Original Message-
From: Benjamin Wiechman [mailto:[EMAIL PROTECTED]
Sent: 24 August 2007 16:18
To: mysql@lists.mysql.com
Subject: Column type suggestions
I recall there is a command
Search the manual and the web for PROCEDURE ANALYSE() and some examples
of how to use it. (It's not obvious how to get good results). I think
Ronald Bradford has a good blog post on it.
Benjamin Wiechman wrote:
I recall there is a command that will display suggested optimal columns
types for
I recall there is a command that will display suggested optimal columns
types for a given table based on the data stored in the table, but I haven't
been able to figure out what it is.
Help!
Thanks.
Ben Wiechman
Wisper High Speed Internet
[EMAIL PROTECTED]
nodb section from
my.cnf
As indicated in the my.cnf file below, My innodb data is all in its own
partition loaded with forcedirectio
Thanks for any suggestions!
Russell
=
060829 0:10:46 INNODB MONITOR OUTPUT
===
oes not help when I need to figure out which of the
suggestions are valid for current msgid.
Your ideas are very welcome ;)
[1] http://entrans.sourceforge.net/
[2] http://www.gnu.org/software/gettext/manual/html_node/gettext_9.html
Best regards,
Priit
--
MySQL General Mailing List
For
> I think it's listed by the corresponding SKU numbers - 17 digits. Is
> this what you're asking?
Err...no, I meant pretty much what Martijn said in his reply - the question is
very vague.
There are many ways of achieving...whatever it is you want to achieve.
If you need help with it you need t
> I'm still kind of new to this, so I'm looking for suggestions on how
> to do this one. I need to recode this site that was designed using
> the old WebCatalog program which we will be phasing out soon. Here's
> the link to a page I need help
> on: http://die-b
At 02:16 PM 6/15/2006 Thursday, Rob Desbois wrote:
> I'm still kind of new to this, so I'm looking for suggestions on how
> to do this one. I need to recode this site that was designed using
> the old WebCatalog program which we will be phasing out soon. Here's
> the
> I'm still kind of new to this, so I'm looking for suggestions on how
> to do this one. I need to recode this site that was designed using
> the old WebCatalog program which we will be phasing out soon. Here's
> the link to a page I need help
> on: http://d
Hi All,
I'm still kind of new to this, so I'm looking for suggestions on how
to do this one. I need to recode this site that was designed using
the old WebCatalog program which we will be phasing out soon. Here's
the link to a page I need help
on: http://die-broke.com/bo
Please see my comments below :
On Thu, 2005-12-01 at 14:06 -0600, Ross Anderson wrote:
> I have read the suggestions for optimization for innodb however I'm
> curious if anyone can help me understand which buffers are common (thus
> used by innodb action) and which are specific t
I have read the suggestions for optimization for innodb however I'm
curious if anyone can help me understand which buffers are common (thus
used by innodb action) and which are specific to myiasm. The server has
2GB of ram but runs multiple services. I have a number of different
typ
operation of the sites
that all of the servers stay in sync at all times.
Does anyone have any suggestions?
- check out http://www.ultramonkey.org/3/ It's not the perfect solution
to your problem(s), but it might help.
that all of the servers stay in
sync at all times.
Does anyone have any suggestions?
--
Ed Pauley II
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello all,
I have a problem on a development machine that somehow got every single
mysql program in the /usr/bin directory wiped out (which looks like it
was everthing but mysqld).
The server is actually up and running, and the datadir is intact, so it
looks like my data is okay. However, I ha
In the last episode (Jan 24), Larry Lowry said:
> Ok I changed my connection string to use the IP of the mySql box and
> added my workstation to the hosts file on the server. Same problem.
> The tests ran at the same slow pace.
>
> I am really curious, what was the logic of adding the workstatio
- Original Message -
From: "Donny Simonton" <[EMAIL PROTECTED]>
To: "'Larry Lowry'" <[EMAIL PROTECTED]>; "'Peter J Milanese'"
<[EMAIL PROTECTED]>;
Sent: Saturday, January 22, 2005 7:34 PM
Subject: RE: Connection performance, sugg
: Peter J Milanese; mysql@lists.mysql.com
Subject: Re: Connection performance, suggestions?
Actually I was just trying to see why the same code to mySql is
so much slower than SQL Server. I tried the same code using the
data provider from CoreLabs and found the connections occur
4 times faster than the
ssage -
From: "Peter J Milanese" <[EMAIL PROTECTED]>
To: "Larry Lowry" <[EMAIL PROTECTED]>
Sent: Saturday, January 22, 2005 10:22 AM
Subject: Re: Connection performance, suggestions?
You are not simulating. Your scripting produces 100 linear connections. You
a
:57 PM
Subject: Re: Connection performance, suggestions?
A single transaction logs into the db several times?
I assume its a browser based transaction, no?
Are you limiting connections (in my.conf)? Have you tuned the config, if
yes how so?
--Original Message--
From: Larry Lowry
To:
performance, suggestions?
Before I ask this question I must state I love mySql and want to use it
more.
But I work in a shop were we mostly use SQL Server 2000. In trying to use
mySql (4.12 and 4.19) we are seeing some performance issues. I hope
someone can help me with this. I am in a Windows 2003
Before I ask this question I must state I love mySql and want to use it more.
But I work in a shop were we mostly use SQL Server 2000. In trying to use
mySql (4.12 and 4.19) we are seeing some performance issues. I hope
someone can help me with this. I am in a Windows 2003 server environment an
Howdy,
I'm looking for ways to better enforce user password security through
MySQL. Currently, it does not appear that there are any restrictions on
minimum length, password expiration times or strong password checking.
Other than educating the users directly, is there a way to enforce any
or
I don't know yet but transactional activity could get
quite large.
I read a bit in the manual (well a page or two)
So I created a sql statement
relating t1-id = t2-id .
I'm imaging that could work ,maybe i'm wrong.
Thank you,
Stuart
--- Jeremy March <[EMAIL PROTECTED]> wrote:
>
> > I have two
> I have two tables that should be related by a customer
> id (established in the customer table). The second
> table is going to have documents in a "text" column.
> I want the ability (at least I think) to have full
> text search for this second table. Hence I chose a
> myIsam table type.
I have two tables that should be related by a customer
id (established in the customer table). The second
table is going to have documents in a "text" column.
I want the ability (at least I think) to have full
text search for this second table. Hence I chose a
myIsam table type.
So a few thin
There are three tables:
This stores just a cosmetic name and a user_id which is used to find all the
account holders campaigns...
CREATE TABLE `campaigns` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`campaign_name` varchar(24) NOT NULL default '',
`updat
other threads
until it completes. Any suggestions?
What type of select is this? Is the application and the database on the same
machine? Is this query build a large temp table?
-Original Message-
From: John Nairn
To: [EMAIL PROTECTED]
Sent: 7/14/04 7:11 PM
Subject: Any select with a large
completes. Any suggestions?
Hi,
I am testing mysql on a large database (10GB). When I post a large
select request via myodbc all other process threads lock until that
thread completes. I am not locking any tables.
How do I stop a read only select statement with a large result set from
locking all the
Hi,
I am testing mysql on a large database (10GB). When I post a large
select request via myodbc all other process threads lock until that
thread completes. I am not locking any tables.
How do I stop a read only select statement with a large result set from
locking all the other threads until i
Scott Haneda writes:
>My trouble is that the data file could be 100,000 lines in length, I have a
>few options:
Scott,
I have a 30 million record dataset that I load into MySQL every couple
of months. To do this propitiously I use the 'LOAD DATA INFILE' syntax.
>From your description it shou
on 05/20/2004 10:18 PM, David Griffiths at [EMAIL PROTECTED] wrote:
>>
>> I can use any I like, I wont have not even built the DB yet, so I am open to
>> any suggestions.
>>
>> I don't see how I can do it all in one transaction, what does that mean?
>&
about the integrity of your data.
I can use any I like, I wont have not even built the DB yet, so I am open to
any suggestions.
I don't see how I can do it all in one transaction, what does that mean?
What that means is you do 100,000 inserts, and then do one commit at the
end. If the co
ilure
> during the mass-insert will cause a rollback, so you don't have to worry
> about the integrity of your data.
I can use any I like, I wont have not even built the DB yet, so I am open to
any suggestions.
I don't see how I can do it all in one transaction, what does that mean?
Assuming you insert 100,000 rows, you also have to consider that any
indexes on the table will need to be re-analyzed to fix the statics.
Also, the inserts will be slower due to any indexes.
You didn't mention the table-type (storage-engine) you were planning on
using, but if you use InnoDB, an
Faced with some larger than usual for me data requirements, I thought I
would ask some others what they think about my logic.
MySql 4
In short, I will have a file upload on a web server that will digest a file,
I will be able to dictate the format of this file. There may be a few
formats, the mai
cs, or the many posts
to this list...]
> -Original Message-
> From: Brent Baisley [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 21, 2003 3:06 PM
> To: [EMAIL PROTECTED]
> Subject: Suggestions on querying parent/child records
>
>
> I'm trying to figu
to be
transfered.
Any other ideas or suggestions on optimizing these approaches? Thanks.
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archive
Hello,
one more idea, use something like this [ i hope it's correct :) ]
SELECT
content.row_id AS row_id,
content.app_id AS app_id,
CASE s1.field_id
when 69 then "niche",
when 70 then "type",
when 71 then "title",
when 72 then "descr
Thanks everyone for your input, I'll try the ramdisk idea, I read about
someone else who tried that and had some success. Beyond, that I'm gonna
take the long route and redesign the database to be a bit more
conventional.
Thanks!
Matt
On Thu, 2003-10-23 at 20:28, Peter Buri wrote:
> Hello,
>
> a
Hello,
as i see you use one table to store all the data, but the cohesive data are
split into 15! different rows.
I think to get the best performance you shoud redesign your tabel.
Use at last first normal form [1NF], if the app_id is uniq this can be the
primary key [which will speed up the quer
At 02:05 PM 10/23/2003, you wrote:
Hey All-
I am trying to improve the speed of a website and was wondering if
anyone had any ways I can rewrite these queries so that they actually
run with some descent speed.
Its a really nasty query and I'm not sure where to start, I'd like to
now have to redo t
ilto:[EMAIL PROTECTED]
-->Sent: Thursday, October 23, 2003 12:05 PM
-->To: [EMAIL PROTECTED]
-->Subject: Improving Query speed - any suggestions?
-->
-->Hey All-
-->
-->I am trying to improve the speed of a website and was wondering if
-->anyone had any ways I can rewrite these querie
Hey All-
I am trying to improve the speed of a website and was wondering if
anyone had any ways I can rewrite these queries so that they actually
run with some descent speed.
Its a really nasty query and I'm not sure where to start, I'd like to
now have to redo the tables and I already put some i
Hi!
On Sep 11, Matt W wrote:
> Hi Sergei!
>
> I'll try to keep my observations/ideas below as short and simple to
> understand as possible. :-)
Thanks :)
Here I reply very quickly to some questions.
Another reply will follow...
> Sure, boolean mode is faster in *some* cases, since, as you sai
Hi Sergei!
Thanks for your reply and taking time to read and consider my
suggestions. :-) I didn't reply sooner because I was deciding what to
say in this message. ;-)
I joined the list specifically for posting these suggestions, and, with
your reply, I wanted to say that it's gre
Dear All.
I hope all is well with you.
A projects requires that for the 1st time ever for me, install a bugzilla system with
MySQL and Apache
IWhat would you recommend when it comes to installing, designing, or tips about My
SQL? perhaps stuff I should know no matter what.
I am reading on
Hi!
First: thanks for ideas - I'm adding them to my todo :)
About dates - it's very difficult to say when a particular feature will
be implemented. Anyway, first I'm going to finish with this 2-level
index structure - to implement optimizations that rely on it.
> Any speed/optimization improveme
gt; see the performance and functionality and have some
> suggestions/questions.
>
> First, since a few of you may be wanting to know, here is a thread where
> I was doing some speed/optimization tests and stuff with 3 million
> posts: http://www.sitepointforums.com/showthread.php?thr
> Thanks for replying. Your posts that I've found when searching for
> FULLTEXT information have had great ideas. :-) Searching millions of
> posts efficiently and effectively isn't easy. :-( Heh.
FULLTEXT does not scale very well once the files get bigger than your
RAM.
The redesign of the index
My TODO List:
1. Speed
More speed in inserts, deletes and selects.
2. Stoplist
1 stoplist for each index
create fulltext index on x( y) stoplist 'mystop'
the stoplist could be divided in section like my.cfg:
[STOPWORD]
[VARIABLES]
ft_min_word_len=3
[CLASSES]
...
[SPECIAL CHARS]
...
The c
min_word_len value?
- Original Message -
From: "Steven Roussey"
Sent: Sunday, August 24, 2003 3:39 PM
Subject: RE: Lots of FULLTEXT stuff (suggestions)
> > And the FULLTEXT index shouldn't always be chosen
> > for non-const join types when another index would find l
> Lots of stuff
> STEMMING! (controlled more finely than server level I hope),
multi-byte
> character set support, proximity operators. Anything to get it closer
to
> Verity's full-text functionality. ;-)
Yes, all these things would be nice... :)
> And the FULLTEXT index shouldn't always be chose
Hi all,
I'm planning to use MySQL's full-text search for my forum system
(possibly 5+ million posts). I've been playing with it a lot lately to
see the performance and functionality and have some
suggestions/questions.
First, since a few of you may be wanting to know, here is a
Thanks to everybody for the nice discussion.
Just to let you know about my (not necessary final) decisions:
We will upgrade our SCSI -II controller to an Ultra SCSI 160 controller
(always a good idea).
Next we are looking into buying a RAID-5 system from RAIDking.
While we do this we hope for the
ECTED]>,
<[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
Subject: RE: suggestions - server options/mysql variables
Date: Thu, 19 Jun 2003 09:13:33 -0600
If you have queries that are only selects, in small tables, with few
rows, you should have very fast performance as is. Are you
ake a big difference.
Thanks
Eric
From: "Mike Hillyer" <[EMAIL PROTECTED]>
To: "Derick Smith"
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: suggestions - server options/mysql variables
Date: Thu, 19 Jun 2003 09:13:33 -0600
If y
; From: Derick Smith [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 9:08 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: suggestions - server options/mysql variables
>
>
> Hi!
> Does anyone know any mysql options I can change in the my.ini
> file or
database, I do not need recovery, raid or any other backup
mechanism
-queries generally return very little data
I will test any suggestions people have for me.
Thanks
Eric
_
MSN 8 with e-mail virus protection service: 2 months FREE
On Wed, Jun 18, 2003 at 03:20:17PM -0400, Adam Nelson wrote:
> Where'd you get it. I've had bad experiences with generic machines but
> I'll take a peak if you send the link?
>
> There are a couple of things I didn't mention
>
> 2U Form Factor with tool-less rails
> Redundant Power Supply
> Redu
> A lot of table scans do to bitmasked column values.
> Such that the above query will not utilize a key.
That statement gave me a cold shiver up my spine.
You could try an inverted index or match-cache technique, or
denormalization. These type of techniques are very app specific, but can
reduce
At 13:14 2003-06-17, Bernd Jagla wrote:
Sorry I forgot to mention:
We are using IRIS on an Origion2000, 7GB memory, 8 CPUs. I was thinking of
spending up to $10K.
I also wanted the redundant data for speeding up the seeks, I also need to
speed up the writes.
Bernd
I assume You mean "IRIX on O2k".
#x27;Mysql'
-->Subject: RE: RAID hardware suggestions/experience
-->
-->
-->2 x 2.8 GHZ Xeon
-->4 GB of RAM
-->5 15K SCSI Drives
-->ICP SCSCI RAID control card with 1 Gb of ram on it.
-->I just bought 30 of these boxes to build out my mysql farm for close
to
-->40
2 x 2.8 GHZ Xeon
4 GB of RAM
5 15K SCSI Drives
ICP SCSCI RAID control card with 1 Gb of ram on it.
I just bought 30 of these boxes to build out my mysql farm for close to
400-600 queries a second with 60 connections a second of mix read /
writes.
What kind of queries are you doing? Our s
June 18, 2003 2:39 PM
> To: 'Adam Nelson'; 'mysql'
> Subject: RE: RAID hardware suggestions/experience
>
>
>
>
> -->-Original Message-
> -->From: Adam Nelson [mailto:[EMAIL PROTECTED]
> -->Sent: Tuesday, June 17, 2003 11:56 AM
> -->
Wednesday, June 18, 2003, 2:38:53 PM, you wrote:
-->>-Original Message-
-->>From: Adam Nelson [mailto:[EMAIL PROTECTED]
-->>Sent: Tuesday, June 17, 2003 11:56 AM
-->>To: 'Bernd Jagla'; 'mysql'
-->>Subject: RE: RAID hardware suggest
-->-Original Message-
-->From: Adam Nelson [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, June 17, 2003 11:56 AM
-->To: 'Bernd Jagla'; 'mysql'
-->Subject: RE: RAID hardware suggestions/experience
-->
-->We recently bought a kick $%#%% machine for ~10
> What sort of throughput are you seeing in that setup?
God, I can't remember anymore. I can run a test again though. If you
have one you want me to run, just send it. We don't have other people's
money to spend, so all our disks are U160 18GB 15K IBM. They were less
than $100 each when we got the
1 - 100 of 184 matches
Mail list logo
