Can you be more descriptive? Try wrapping your inserts inside a single transaction. What's your innodb_buffer_pool_size set to? How much RAM do you have? Are you sure you should be using InnoDB for what you're doing?

On Mon, 26 Apr 2010, 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?

Thanks,
Nick

On Mon, Apr 26, 2010 at 12:00 PM, <talk-requ...@lists.nyphp.org> wrote:
      Send talk mailing list submissions to
             t...@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

Reply via email to