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, <[email protected]
<mailto:[email protected]>> wrote:
Send talk mailing list submissions to
[email protected] <mailto:[email protected]>
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
[email protected] <mailto:[email protected]>
You can reach the person managing the list at
[email protected] <mailto:[email protected]>
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 <[email protected]
<mailto:[email protected]>>
To: NYPHP Talk <[email protected] <mailto:[email protected]>>
Subject: Re: [nyphp-talk] MAMP or XAMPP ?
Message-ID:
<[email protected]
<mailto:[email protected]>>
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 <[email protected]
<mailto:[email protected]>> 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" <[email protected] <mailto:[email protected]>>
To: "'NYPHP Talk'" <[email protected]
<mailto:[email protected]>>
Subject: Re: [nyphp-talk] MAMP or XAMPP ?
Message-ID: <[email protected]
<mailto:[email protected]>>
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: [email protected]
<mailto:[email protected]>
> [mailto:[email protected]
<mailto:[email protected]>] 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
> <[email protected] <mailto:[email protected]>> 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 <[email protected]
<mailto:[email protected]>>
To: NYPHP Talk <[email protected] <mailto:[email protected]>>
Subject: Re: [nyphp-talk] MAMP or XAMPP ?
Message-ID:
<[email protected]
<mailto:[email protected]>>
Content-Type: text/plain; charset=UTF-8
On Sun, Apr 25, 2010 at 1:09 PM, John Campbell
<[email protected] <mailto:[email protected]>> 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 <[email protected] <mailto:[email protected]>>
To: NYPHP Talk <[email protected] <mailto:[email protected]>>
Subject: Re: [nyphp-talk] MAMP or XAMPP ?
Message-ID: <[email protected]
<mailto:[email protected]>>
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" <[email protected] <mailto:[email protected]>>
To: "'NYPHP Talk'" <[email protected]
<mailto:[email protected]>>
Subject: Re: [nyphp-talk] MAMP or XAMPP ?
Message-ID: <[email protected]
<mailto:[email protected]>>
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: [email protected]
<mailto:[email protected]>
> [mailto:[email protected]
<mailto:[email protected]>] 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 <[email protected]
<mailto:[email protected]>>
To: NYPHP Talk <[email protected] <mailto:[email protected]>>
Subject: Re: [nyphp-talk] MAMP or XAMPP ?
Message-ID: <[email protected]
<mailto:[email protected]>>
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
> <[email protected] <mailto:[email protected]>> 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" <[email protected] <mailto:[email protected]>>
To: <[email protected] <mailto:[email protected]>>
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
[email protected] <mailto:[email protected]>
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
_______________________________________________
New York PHP Users Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
http://www.nyphp.org/Show-Participation
