php-general Digest 21 Jun 2011 03:22:07 -0000 Issue 7368
Topics (messages 313613 through 313625):
mysqlnd and LOAD DATA INFILE
313613 by: Marten Lehmann
313614 by: Shawn McKenzie
313616 by: Marten Lehmann
313617 by: Shawn McKenzie
313618 by: Marten Lehmann
Re: Doctrine madness!
313615 by: Nathan Nobbe
Updating to 5.3.6
313619 by: Bruno Coelho
313620 by: Sean Greenslade
313621 by: Bruno Coelho
php 5.3.6
313622 by: Fatih P.
313623 by: Daniel Brown
313624 by: Fatih P.
$B!Z(BN$B5i!"(B S$B5i!"(BAAA$B5i(B $B:bI[!"%P%C%0!*$B![!Z%V%i%s%I4[![
313625 by: $B"!AwNAL5NA"!%V%i%s%I7c0B;T>l
Administrivia:
To subscribe to the digest, e-mail:
php-general-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-general-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-gene...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
Hello,
we recently updated our mysql client libs to mysql-5.5.13 and since it
was impossible to rebuild PHP 5.2.x and PHP 5.3.x with this new mysql
release, we rebuilt PHP with --with-mysql=mysqlnd and
---with-mysqli=mysqlnd.
General mysql commands work fine, but one of our clients reported, that
the command "LOAD DATA INFILE" isn't working any longer.
As the setup of the mysql server hasn't changed and as on the webserver
only PHP was rebuilt, I assume that the problem is in mysqlnd?!
How does mysqlnd handle LOAD DATA INFILE? And if the problem is not in
mysqlnd, what else could it be?
Kind regards
Marten
--- End Message ---
--- Begin Message ---
On 06/20/2011 07:51 AM, Marten Lehmann wrote:
> isn't working any longer
What does that mean? It generates an error? It executes without error
but the data isn't loaded? Try a test on the command line and see what
you get.
--
Thanks!
-Shawn
http://www.spidean.com
--- End Message ---
--- Begin Message ---
Hello,
What does that mean? It generates an error? It executes without error
but the data isn't loaded? Try a test on the command line and see what
you get.
when calling mysql_error() the message "The used
command is not allowed with this MySQL version" is returned.
I thought maybe knows between this and mysqlnd? Because recompiling PHP
with --with-mysql=mysqlnd is the only difference to the previous PHP
build, where LOAD DATA INFILE worked.
Kind regards
Marten
--- End Message ---
--- Begin Message ---
On 06/20/2011 10:53 AM, Marten Lehmann wrote:
> Hello,
>
>> What does that mean? It generates an error? It executes without error
>> but the data isn't loaded? Try a test on the command line and see what
>> you get.
>
> when calling mysql_error() the message "The used
> command is not allowed with this MySQL version" is returned.
>
> I thought maybe knows between this and mysqlnd? Because recompiling PHP
> with --with-mysql=mysqlnd is the only difference to the previous PHP
> build, where LOAD DATA INFILE worked.
>
> Kind regards
> Marten
This is a PHP list, but most likely run: mysql_fix_privilege_tables and
then restart mysql.
--
Thanks!
-Shawn
http://www.spidean.com
--- End Message ---
--- Begin Message ---
This is a PHP list
Exactly. And it is the switch from --with-mysql=/usr to
--with-mysql=mysqlnd (the PHP native MySQL driver) during the build that
caused the problem. And there is no alternative to building current PHP
versions with mysql support than with mysqlnd, because the mysql 5.5.x
libraries don't work against PHP 5.2 and PHP 5.3, although they are out
for months.
but most likely run: mysql_fix_privilege_tables and then restart mysql.
As I said: The problem is not at the MySQL server, it must be at the
client side.
Kind regards
Marten
--- End Message ---
--- Begin Message ---
On Mon, Jun 20, 2011 at 5:16 AM, Ford, Mike <m.f...@leedsmet.ac.uk> wrote:
> > -----Original Message-----
> > From: Nathan Nobbe [mailto:quickshif...@gmail.com]
> > Sent: 16 June 2011 17:51
>
> [...]
>
> > Here's what's going on, I instantiate a model object for the product
> > table
> > from my application
> >
> > $newRecord = new Product();
> >
> > at this point memory usage goes up noticeably. I don't really care
> > though
> > because I figure I can delete it, but look at this madness I have
> > going
> > (which *fails* to free up the memory)
> >
> > $newRecord->clearRelated();
> > $newRecord->free();
> > unset($newRecord);
> > gc_collect_cycles();
> >
> > after all of this memory consumption is still dramatically higher
> > than prior
> > to the first call creating the object above. This I've verified
> > through
> > memory_get_usage().
> >
> > here's the output from the memory_get_usage() calls
> >
> > int(166461440) // before new Product()
> > int(169345024) // directly after new Product()
> > int(169345024) // after madness trying to free memory used by new
> > Product()
>
> I know nothing about Doctrine, but after all the unrelated
> discussion and your renewed plea for someone to address the issue,
> I decided to write conduct some simple tests.
>
> So I wrote a very simple class that basically just hogs some memory
> when instantiated, and tried some simple instantiations and
> releases.
>
> At each stage, I measured current and peak memory usage, and the
> results were:
>
> Initial
> Usage = 262,144
> Peak = 262,144
>
> After single instantiation ($a = new Hog();)
> Usage = 3,932,160
> Peak = 3,932,160
>
> After resetting that to NULL ($a = NULL;)
> Usage = 524,288
> Peak = 3,932,160
>
> After second single instantiation ($b = new Hog();)
> Usage = 3,932,160
> Peak = 3,932,160
>
> After instantiating 3 more
> Usage = 15,728,640
> Peak = 15,728,640
>
> After resetting all those to NULL
> Usage = 1,310,720
> Peak = 15,728,640
>
> After 4 instantiations again
> Usage = 15,728,640
> Peak = 15,728,640
>
> This seems to be pretty much what I (and you!) would expect,
> indicating that the memory used by objects can be recovered by PHP
> when the object is released. This being the case, I would suggest
> that something in your script is not freeing things up the way it
> should, the prime candidate being the clearRelated() method. Either
> that, or you have circular references that the gc_collect_cycles()
> function is unable to recover. But, bottom line, I'd say you're
> right that it's probably a Doctrine-related issue as the underlying
> PHP functionality seems to work reasonably well.
>
Mike, thanks for your time here. I have been able to develop a workaround
and it actually does run fast enough to work for now. Actually, I'd love to
pin down the issue w/ Doctrine, I just have a lot of clients right now and
can't justify the time, so the hacky solution will have to suffice.
I did just find a bug in PHPUnit about a week ago, but that was easy to
isolate. In order to isolate the issue with Doctrine it will take me a few
hours. So even though today is a rainy one, I won't be able to work on it
because I have too much other stuff going on that actually pays the bills,
lol.
-nathan
--- End Message ---
--- Begin Message ---
I realize this is a basic matter, but I've installed PHP 5.3.1 with XAMPP for
Mac OS.
How can I update my PHP version now?
Thanks.
--- End Message ---
--- Begin Message ---
How did you install it? Why can't you just uninstall it and reinstall with
the new version?
On Jun 20, 2011 12:52 PM, "Bruno Coelho" <brunocsncoe...@gmail.com> wrote:
>
> I realize this is a basic matter, but I've installed PHP 5.3.1 with XAMPP
for Mac OS.
> How can I update my PHP version now?
>
>
> Thanks.
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
I've installed through XAMPP. The latest version of XAMPP still has PHP 5.3.1
A 2011/06/20, às 18:50, Sean Greenslade escreveu:
> How did you install it? Why can't you just uninstall it and reinstall with
> the new version?
>
> On Jun 20, 2011 12:52 PM, "Bruno Coelho" <brunocsncoe...@gmail.com> wrote:
> >
> > I realize this is a basic matter, but I've installed PHP 5.3.1 with XAMPP
> > for Mac OS.
> > How can I update my PHP version now?
> >
> >
> > Thanks.
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
--- End Message ---
--- Begin Message ---
Hi Guys,
installed php 5.3.6 TS VC9 and apache 2.2.19 OpenSSL 1.0 compiled with VC9
on windows 2003 R2 but now having strange problem that post variables are
not parsed.
i have tried file_gets_contents("php://input"); this problems is there
especially when i post strings starting with capital letters containing
!@#$%&^&*
nothing logged that i can see as exception.
any ideas ?
Fatih
--- End Message ---
--- Begin Message ---
On Mon, Jun 20, 2011 at 15:09, Fatih P. <fatihpirist...@gmail.com> wrote:
> Hi Guys,
>
> installed php 5.3.6 TS VC9 and apache 2.2.19 OpenSSL 1.0 compiled with VC9
> on windows 2003 R2 but now having strange problem that post variables are
> not parsed.
>
> i have tried file_gets_contents("php://input"); this problems is there
> especially when i post strings starting with capital letters containing
> !@#$%&^&*
>
> nothing logged that i can see as exception.
>
> any ideas ?
Are you missing a P in variables_order in your php.ini? For
production systems, you'll probably want:
variables_order = "GPCS"
--
</Daniel P. Brown>
Network Infrastructure Manager
http://www.php.net/
--- End Message ---
--- Begin Message ---
P variable is there, i checked all the possible things that came to me. but
still nothing
the config file was used in 5.3.3 in production just applied changes for
5.3.6
variables_order = "GPCS"
request_order = "GP"
register_globals = Off ; tried with On nothing changed
post_max_size = 8M
On Mon, Jun 20, 2011 at 9:15 PM, Daniel Brown <danbr...@php.net> wrote:
> On Mon, Jun 20, 2011 at 15:09, Fatih P. <fatihpirist...@gmail.com> wrote:
> > Hi Guys,
> >
> > installed php 5.3.6 TS VC9 and apache 2.2.19 OpenSSL 1.0 compiled with
> VC9
> > on windows 2003 R2 but now having strange problem that post variables are
> > not parsed.
> >
> > i have tried file_gets_contents("php://input"); this problems is there
> > especially when i post strings starting with capital letters containing
> > !@#$%&^&*
> >
> > nothing logged that i can see as exception.
> >
> > any ideas ?
>
> Are you missing a P in variables_order in your php.ini? For
> production systems, you'll probably want:
>
> variables_order = "GPCS"
>
> --
> </Daniel P. Brown>
> Network Infrastructure Manager
> http://www.php.net/
>
--- End Message ---
--- Begin Message ---
【N級、 S級、AAA級 財布、バッグ！】【ブランド館】
日本最大級コピーブランド激安市場 ☆*.http://www.special-price.biz/ ☆*.
■主要取扱商品: バッグ、財布、腕時計、ベルト、ライタ！
≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡
海外ブランド品安心ショッピング バッグや財布等がお買得！
【新作入荷】●●●【超人気質屋】◆最新作 ヴィトン 財布新品、新素材入荷
① ★GUCCI 2011年新作バッグ大量入荷超人気 ★
http://www.special-price.biz/
② ★LOUIS VUITTON 2011年新作バッグ大量入荷超人気 ★
http://www.special-price.biz/
③ ★LOUIS VUITTON 2011年新作財布大量入荷 !!!
http://www.special-price.biz/
【Ｎews】★ROLEX -ロレックスN級最高等級時計大量入荷超人気 ★
http://www.special-price.biz/
■宜しくお願い申し上げます。
≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡
◆誠実な接待、長い間取引する友達(^o^)
■URL：http://www.special-price.biz/
■店長：『ブランド激安市場』 土田健一
≡≡≡≡≡≡≡≡≡≡≡≡≡◆送料無料◆≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡
--- End Message ---
