List:General Discussion« Previous MessageNext Message »
From:grok Date:September 11 2006 9:30pm
Subject:Re: INNODB my.cnf
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> I need some inputs regarding my.cnf  :
> 
> We are using INNODB in our application.We have around 10
> million records in the database. This will size up to
> around 10GB of data.
> 
> Could you please suggest a sample my.cnf for this
> configuration.
> 
> Machine used :
> 
> Sun netra 240 , dual processor machine with 2 GB ram
> 
> Mysql version :
> 
> 5.1.11

You know, a lot of packages -- not just MySQL -- would
probably benefit their userbase by developing a suite of
wiki pages, etc., detailing case studies of typical uses,
applications and hardware/software configurations.
Obviously, every possible scenario would be impossible to
model -- but that's not an issue. The point would be that a
lot of people would be able to get a clue, by even rough
comparison with their own situations. 

This also doesn't seem like a lot of work for the
knowledgeable to set up either. It can be done at any
comfortable pace too. And it might save a bit of repetitive
advice-giving on the eLists.


- -- grok.


- -- 
*** SOCIALISM OR BARBARISM ? ***************************************
* Capitalism wraps itself in flags of convenience   * Critical     *
* The latest one is religious obscurantism          * Support only *
************   STEM THE ASSAULT ON MATERIALIST SCIENCE  ************
* http://www.world-of-dawkins.com         World of Richard Dawkins *
* http://www.atheistnetwork.com              Atheist Radio Network *
* http://kpfa.org/archives/archives.php?id=33 Explorations archive *
* http://www.secularism.org.uk         UK National Secular Society *
* http://njhn.org                      New Jersey Humanist Network *
* http://palaeo.gly.bris.ac.uk/dinobase/dinopage.html     DINOBASE *
* http://www.dinosaur.net.cn/default_en.htm  Dinosaur Museum China *
***** "HUMAN RIGHTS" IMPERIALISM: NEW FACE OF OLD EXPLOITATION *****
GPG fingerprint = 2E7F 2D69 4B0B C8D5 07E3  09C3 5E8D C4B4 461B B771
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFFBdWFXo3EtEYbt3ERAgmLAJ4qshFlWV8opukKKM8ICAzPf5NPwQCfWi3+
cQf4D4MMQYkk8/7Hey6I1Os=
=lYR8
-----END PGP SIGNATURE-----
Thread
INNODB my.cnfprasad.ramisetti8 Sep
  • Re: INNODB my.cnfVisolve DB Team11 Sep
    • Re: INNODB my.cnfgrok11 Sep