InnoDB makes use of row locking as it is transactional. If the row is locked it will make it a little bit more interesting for inserts (last time I checked the storage engine doesn't do table locks any more). Also not to push this off into another thread/mail trail but I think my...@lists.nyphp.org would be a better place to send this question too. Look in your slow query log to see if you have any select queries which are running slow that would extend a lock on a row (no index or a index that is not left-prefixed). If you want use EXPLAIN on those slow queries and hit up the MySQL list and we can continue from there.
-Anthony On Mon, Apr 26, 2010 at 12:53 PM, Nicholas Hart <nh...@partsauthority.com>wrote: > Hi, > > I am troubleshooting problems with slow inserts with innodb. Anyone have > list of recommended config settings to reduce or eliminate these delays? > > 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 List > http://lists.nyphp.org/mailman/listinfo/talk > > http://www.nyphp.org/Show-Participation > -- Anthony W. ant92...@gmail.com
_______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
