NYCPHP Meetup

[Anthony Wlodarski]

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
mysql at 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 <nhart at 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-request at lists.nyphp.org> wrote:
>
>> Send talk mailing list submissions to
>>        talk at 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-request at lists.nyphp.org
>>
>> You can reach the person managing the list at
>>        talk-owner at 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 <jcampbell1 at gmail.com>
>> To: NYPHP Talk <talk at lists.nyphp.org>
>> Subject: Re: [nycphp-talk] MAMP or XAMPP ?
>> Message-ID:
>>        <h2l8f0676b41004251009x6af9ba23ofc406840f88523f2 at 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 <ajai at 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" <mmwaldman at nyc.rr.com>
>> To: "'NYPHP Talk'" <talk at lists.nyphp.org>
>> Subject: Re: [nycphp-talk] MAMP or XAMPP ?
>> Message-ID: <2A.13.29484.EC974DB4 at 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-bounces at lists.nyphp.org
>> > [mailto:talk-bounces at lists.nyphp.org] On Behalf Of John Campbell
>> > Sent: Sunday, April 25, 2010 1:09 PM
>> > To: NYPHP Talk
>> > Subject: Re: [nycphp-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
>> > <ajai at 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.pirtle at gmail.com>
>> To: NYPHP Talk <talk at lists.nyphp.org>
>> Subject: Re: [nycphp-talk] MAMP or XAMPP ?
>> Message-ID:
>>        <s2h330532b61004251025vf6c12869p221f7cbb2b9a9d8a at mail.gmail.com>
>> Content-Type: text/plain; charset=UTF-8
>>
>> On Sun, Apr 25, 2010 at 1:09 PM, John Campbell <jcampbell1 at 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 <ajai at bitblit.net>
>> To: NYPHP Talk <talk at lists.nyphp.org>
>> Subject: Re: [nycphp-talk] MAMP or XAMPP ?
>> Message-ID: <Pine.LNX.4.44.1004251346240.13111-100000 at 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" <mmwaldman at nyc.rr.com>
>> To: "'NYPHP Talk'" <talk at lists.nyphp.org>
>> Subject: Re: [nycphp-talk] MAMP or XAMPP ?
>> Message-ID: <E0.01.29484.B4184DB4 at 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-bounces at lists.nyphp.org
>> > [mailto:talk-bounces at lists.nyphp.org] On Behalf Of Ajai Khattri
>> > Sent: Sunday, April 25, 2010 1:47 PM
>> > To: NYPHP Talk
>> > Subject: Re: [nycphp-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_lists at o2group.com>
>> To: NYPHP Talk <talk at lists.nyphp.org>
>> Subject: Re: [nycphp-talk] MAMP or XAMPP ?
>> Message-ID: <E95E4BEF-8E1E-4A14-92F0-2FDE9DC25BF5 at 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
>> > <jcampbell1 at 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" <rich at 1webguru.com>
>> To: <talk at lists.nyphp.org>
>> Subject: [nycphp-talk] SimpleSAMLphp
>> Message-ID: <003401cae549$f7b2e470$e718ad50$@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 at 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.
ant92083 at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20100426/ff5f92b0/attachment.html>