experiment. try The Cloud. at this point, really looking at zillions of records, you should have close to zero wait access times. everything is so ^%$^%&* fast these days. by the time you finger comes off the keys, you should see your data.
186,00 miles/second. or something like that. :-) On Mon, Apr 26, 2010 at 3:30 PM, Max Gribov <m...@neuropunks.org> wrote: > On 04/26/2010 12:53 PM, Nicholas Hart wrote: > > Hi, > > I am troubleshooting problems with slow inserts with innodb. Anyone have > list of recommended config settings to reduce or eliminate these delays? > > > When you insert in innodb, it will check foreign keys, and like any insert > it will update indexes, so those are probably THE bottlenecks.. > > What kind of inserts are they? Are you doing INSERT ... SELECT type stuff? > If so, you can try this in my.cnf: > (from: > http://harrison-fisk.blogspot.com/2009/02/my-favorite-new-feature-of-mysql-51.html > ) > innodb_autoinc_lock_mode=2 > binlog_format=row > > If you have inserts with LOCK TABLES you can use this to disable that, > which can be dangerous under high load: > innodb_table_locks = false > > You can also try this (also from > http://harrison-fisk.blogspot.com/2009/02/my-favorite-new-feature-of-mysql-51.html > ) > transaction-isolation=READ-COMMITTED > > You can also package your inserts into the same statement like: > insert into tablename (field1, field2) values(1,2), (2,3), (4,5); > this makes inserts faster, and you can make that command as long as > max_allowed_packet setting. > > You can also use this: > innodb_flush_log_at_trx_commit = 2 > (from: > http://www.mysqlperformanceblog.com/2007/11/01/innodb-performance-optimization-basics/ > ) > > Also innodb_thread_concurrency should be set to 2 * (num_cpu + num_dsk) > > When all else fails, see if you can change the tables in question to myisam > or even move them into something like mongo, which does way more inserts per > second than mysql. > > > > Thanks, > Nick > > On Mon, Apr 26, 2010 at 12:00 PM, <talk-requ...@lists.nyphp.org> wrote: > >> Send talk mailing list submissions to >> talk@lists.nyphp.org >> >> To subscribe or unsubscribe via the World Wide Web, visit >> http://lists.nyphp.org/mailman/listinfo/talk >> or, via email, send a message with subject or body 'help' to >> talk-requ...@lists.nyphp.org >> >> You can reach the person managing the list at >> talk-ow...@lists.nyphp.org >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of talk digest..." >> >> >> Today's Topics: >> >> 1. Re: MAMP or XAMPP ? (John Campbell) >> 2. Re: MAMP or XAMPP ? (mmw) >> 3. Re: MAMP or XAMPP ? (Mitch Pirtle) >> 4. Re: MAMP or XAMPP ? (Ajai Khattri) >> 5. Re: MAMP or XAMPP ? (mmw) >> 6. Re: MAMP or XAMPP ? (Tim Lieberman) >> 7. SimpleSAMLphp (Rich Bark) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Sun, 25 Apr 2010 13:09:10 -0400 >> From: John Campbell <jcampbe...@gmail.com> >> To: NYPHP Talk <talk@lists.nyphp.org> >> Subject: Re: [nyphp-talk] MAMP or XAMPP ? >> Message-ID: >> <h2l8f0676b41004251009x6af9ba23ofc406840f8852...@mail.gmail.com> >> Content-Type: text/plain; charset=ISO-8859-1 >> >> I think MAMP is a pain in the ass, and prefer to get the stack from >> MacPorts. The default MAMP install leaves you with stuff like a >> different version of PHP for cli vs Apache, and it is a pain to >> install additional modules. >> >> >> >> On Sat, Apr 24, 2010 at 11:58 PM, Ajai Khattri <a...@bitblit.net> wrote: >> > >> > Which is better ? >> > >> > -- >> > Aj. >> > >> > _______________________________________________ >> > New York PHP Users Group Community Talk Mailing List >> > http://lists.nyphp.org/mailman/listinfo/talk >> > >> > http://www.nyphp.org/Show-Participation >> > >> >> >> ------------------------------ >> >> Message: 2 >> Date: Sun, 25 Apr 2010 13:20:14 -0400 >> From: "mmw" <mmwald...@nyc.rr.com> >> To: "'NYPHP Talk'" <talk@lists.nyphp.org> >> Subject: Re: [nyphp-talk] MAMP or XAMPP ? >> Message-ID: <2a.13.29484.ec974...@hrndva-omtalb.mail.rr.com> >> Content-Type: text/plain; charset="US-ASCII" >> >> I did have trouble installing xampp the first time around. I had to >> modify >> some file. Don't ask me which one. >> >> Last time I installed, it went well. >> >> I use WEBuilder, instead of DreamWeaver or whatever, so with a little help >> from the tech folks, I got it all setup to preview php files in my editor. >> >> WEBuilder was like $60 or something. I've encountered one minor problem >> which I have not reported. >> >> Xampp with WEBuilder cuts down on development time quite a bit. >> >> Michele >> >> > -----Original Message----- >> > From: talk-boun...@lists.nyphp.org >> > [mailto:talk-boun...@lists.nyphp.org] On Behalf Of John Campbell >> > Sent: Sunday, April 25, 2010 1:09 PM >> > To: NYPHP Talk >> > Subject: Re: [nyphp-talk] MAMP or XAMPP ? >> > >> > I think MAMP is a pain in the ass, and prefer to get the stack from >> > MacPorts. The default MAMP install leaves you with stuff like a >> > different version of PHP for cli vs Apache, and it is a pain to >> > install additional modules. >> > >> > >> > >> > On Sat, Apr 24, 2010 at 11:58 PM, Ajai Khattri >> > <a...@bitblit.net> wrote: >> > > >> > > Which is better ? >> > > >> > > -- >> > > Aj. >> > > >> > > _______________________________________________ >> > > New York PHP Users Group Community Talk Mailing List >> > > http://lists.nyphp.org/mailman/listinfo/talk >> > > >> > > http://www.nyphp.org/Show-Participation >> > > >> > _______________________________________________ >> > New York PHP Users Group Community Talk Mailing List >> > http://lists.nyphp.org/mailman/listinfo/talk >> > >> > http://www.nyphp.org/Show-Participation >> >> >> >> ------------------------------ >> >> Message: 3 >> Date: Sun, 25 Apr 2010 13:25:44 -0400 >> From: Mitch Pirtle <mitch.pir...@gmail.com> >> To: NYPHP Talk <talk@lists.nyphp.org> >> Subject: Re: [nyphp-talk] MAMP or XAMPP ? >> Message-ID: >> <s2h330532b61004251025vf6c12869p221f7cbb2b9a9...@mail.gmail.com> >> Content-Type: text/plain; charset=UTF-8 >> >> On Sun, Apr 25, 2010 at 1:09 PM, John Campbell <jcampbe...@gmail.com> >> wrote: >> > I think MAMP is a pain in the ass, and prefer to get the stack from >> > MacPorts. ? The default MAMP install leaves you with stuff like a >> > different version of PHP for cli vs Apache, and it is a pain to >> > install additional modules. >> >> ++ on this one. I also use rails apps, memcache, and a bunch of other >> non-standard stuff like LightTPD and macports makes use of all these >> things a snap. >> >> -- Mitch >> >> >> ------------------------------ >> >> Message: 4 >> Date: Sun, 25 Apr 2010 13:46:50 -0400 (EDT) >> From: Ajai Khattri <a...@bitblit.net> >> To: NYPHP Talk <talk@lists.nyphp.org> >> Subject: Re: [nyphp-talk] MAMP or XAMPP ? >> Message-ID: <pine.lnx.4.44.1004251346240.13111-100...@bitblit.net> >> Content-Type: TEXT/PLAIN; charset=US-ASCII >> >> On Sun, 25 Apr 2010, mmw wrote: >> >> > Huh? One's for mac one's for pcs. >> >> Err, nope: >> http://www.apachefriends.org/en/xampp-macosx.html >> >> >> -- >> Aj. >> >> >> >> ------------------------------ >> >> Message: 5 >> Date: Sun, 25 Apr 2010 13:52:12 -0400 >> From: "mmw" <mmwald...@nyc.rr.com> >> To: "'NYPHP Talk'" <talk@lists.nyphp.org> >> Subject: Re: [nyphp-talk] MAMP or XAMPP ? >> Message-ID: <e0.01.29484.b4184...@hrndva-omtalb.mail.rr.com> >> Content-Type: text/plain; charset="US-ASCII" >> >> Didn't know xampp made a mac version. >> >> But when I looked up mamp or whatever, it was specifically for mac. >> >> Michele >> >> > -----Original Message----- >> > From: talk-boun...@lists.nyphp.org >> > [mailto:talk-boun...@lists.nyphp.org] On Behalf Of Ajai Khattri >> > Sent: Sunday, April 25, 2010 1:47 PM >> > To: NYPHP Talk >> > Subject: Re: [nyphp-talk] MAMP or XAMPP ? >> > >> > On Sun, 25 Apr 2010, mmw wrote: >> > >> > > Huh? One's for mac one's for pcs. >> > >> > Err, nope: >> > http://www.apachefriends.org/en/xampp-macosx.html >> > >> > >> > -- >> > Aj. >> > >> > _______________________________________________ >> > New York PHP Users Group Community Talk Mailing List >> > http://lists.nyphp.org/mailman/listinfo/talk >> > >> > http://www.nyphp.org/Show-Participation >> >> >> >> ------------------------------ >> >> Message: 6 >> Date: Sun, 25 Apr 2010 15:03:42 -0400 >> From: Tim Lieberman <tim_li...@o2group.com> >> To: NYPHP Talk <talk@lists.nyphp.org> >> Subject: Re: [nyphp-talk] MAMP or XAMPP ? >> Message-ID: <e95e4bef-8e1e-4a14-92f0-2fde9dc25...@o2group.com> >> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes >> >> On Apr 25, 2010, at 1:25 PM, Mitch Pirtle wrote: >> >> > On Sun, Apr 25, 2010 at 1:09 PM, John Campbell >> > <jcampbe...@gmail.com> wrote: >> >> I think MAMP is a pain in the ass, and prefer to get the stack from >> >> MacPorts. The default MAMP install leaves you with stuff like a >> >> different version of PHP for cli vs Apache, and it is a pain to >> >> install additional modules. >> > >> > ++ on this one. I also use rails apps, memcache, and a bunch of other >> > non-standard stuff like LightTPD and macports makes use of all these >> > things a snap. >> >> If you've got some time to experiment, it's not all that hard to build >> an AMP stack from source on MacOS. >> >> It is more work than using MAMP/XAMMP or MacPorts/Fink, but IMO, the >> flexibility is worth it in the long run. >> >> I try to maintain a set of shell scripts so I can tweak/recompile as >> needed. >> >> I tend to stick everything under some non-standard directory, so I can >> have multiple stacks for testing. For example, if I needed it, I'd >> have no problems setting up 4 stacks for 5.2/5.3 under mod_php/ >> fastcgi. This way, I can keep my local environment very close to >> whatever the production environment is for any particular project. >> >> -Tim >> >> >> >> ------------------------------ >> >> Message: 7 >> Date: Mon, 26 Apr 2010 10:08:31 -0400 >> From: "Rich Bark" <r...@1webguru.com> >> To: <talk@lists.nyphp.org> >> Subject: [nyphp-talk] SimpleSAMLphp >> Message-ID: <003401cae549$f7b2e470$e718ad...@com> >> Content-Type: text/plain; charset="us-ascii" >> >> Anyone here have experience with simpleSAMLphp? I cannot get it to work. >> >> >> >> Thanks, >> >> Rich >> >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> URL: < >> http://lists.nyphp.org/pipermail/talk/attachments/20100426/6cbb0ae8/attachment-0001.html >> > >> >> ------------------------------ >> >> _______________________________________________ >> talk mailing list >> talk@lists.nyphp.org >> http://lists.nyphp.org/mailman/listinfo/talk >> >> End of talk Digest, Vol 42, Issue 17 >> ************************************ >> > > > > -- > > -Nicholas Hart > Parts Authority IT > 516-678-3900 X3242 > > > _______________________________________________ > New York PHP Users Group Community Talk Mailing > Listhttp://lists.nyphp.org/mailman/listinfo/talk > http://www.nyphp.org/Show-Participation > > > > _______________________________________________ > New York PHP Users Group Community Talk Mailing List > http://lists.nyphp.org/mailman/listinfo/talk > > http://www.nyphp.org/Show-Participation > -- IM/iChat: ejpusa Links: http://del.icio.us/ejpusa Follow me: http://www.twitter.com/ejpusa Karma: http://www.coderswithconscience.com
_______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
