2008 : MySQL client run out of memory
Hello, I have this error (2008 : MySQL client run out of memory) performing a request in a PHP script. However that request works perfectly under phpMyAdmin ! I tried to do a lot of mysql_free_result() in my script (because there are a lot of requests) but I doesn't work and I think It is useless. I looked on the PHP site to see if there's not a bug but I didn't configured my PHP with the --enable-memory-limit option. I have the version 4.0.6 with the mysql built-in support. Note that I first compiled PHP with the external mysql support and I had the same error. What's the problem ? How to find the cause ? I tried a debugger called Body but It is so slow that I could die before. Thank you Patrice - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 2008 : MySQL client run out of memory
Then It is not a memory problem for "ini_set()" didn't work.
It always crashes at the same point.
Mysql doc says :
ERROR 2008: MySQL client ran out of memory
note that the error refers to the MySQL client mysql. The reason for this
error is simply that the client does not have enough memory to store the
whole result.
But as I said the query works with phpMyAdmin and is performed several
times in the script with free_results() after each performing.
Patrice
Le jeu, 09 aoû 2001, vous avez écrit :
> If it is a memory problem, try for example
>
> ini_set("memory_limit", "16M");
>
> in your script. Otherwise, it may be a loop that keeps allocating
> memory until it crahes. It this is the case, you won't get it
> through allocating more memory.
>
> Patrice Garbe schrieb am Donnerstag, 9. August 2001, 12:43:42:
> > Hello,
> >
> > I have this error (2008 : MySQL client run out of memory) performing
> > a request in a PHP script.
> > However that request works perfectly under phpMyAdmin !
> >
> > I tried to do a lot of mysql_free_result() in my script (because there
> > are a lot of requests) but I doesn't work and I think It is useless.
> >
> > I looked on the PHP site to see if there's not a bug but I didn't
> > configured my PHP with the --enable-memory-limit option.
> > I have the version 4.0.6 with the mysql built-in support. Note that I
> > first compiled PHP with the external mysql support and I had the same
> > error.
> >
> > What's the problem ? How to find the cause ?
> > I tried a debugger called Body but It is so slow that I could die before.
> >
> > Thank you
> >
> > Patrice
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php (the manual)
> >http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]> Trouble
> > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 2008 : MySQL client run out of memory
Hello, I tried with unbuffered queries and It doesn't solve the problem at all I have an weird error performing "select id from categories where name = 'Hifi'". The error is now : '0 : ' (nothing). There's an error but it is not defined ?!? Note that only the crashing query is unbuffered so there's no problem with mysql_num_rows(). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table too large?
Normally the size can be 2G, 4G or more... You can check the maximum table size for a table with the myisamchk -dv table_name or table_file if It doesn't work. You should have run myisamchk or mysqlcheck (whick worked better for me) to check your table. Le jeu, 09 aoû 2001, vous avez écrit : > Hello, >I have a mysql db that contains a table to track visitors, Visitor > information is stored at the beginning of each page. The problem that I am > having is that a few days ago the pages just stopped loading and I had to > dump, drop and recreate the table with nothing in it to get the site going > again. The table is about 26 meg in size (dumped file) and I am running on > Red Hat 7.1 server with 90 Gig HDD with 512 Meg RAM. > >BTW - I have other servers running other sites with this dB and some of > them are much bigger with no problems. > > >Anyone have any thoughts ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SV: [PHP-DB] Empty error ? (HELP ME)
PhpMyAdmin writes : 3.23.40-log Why -log, don't know ?... Le jeu, 09 aoû 2001, vous avez écrit : > What version of Mysql is it? > > > -Opprinnelig melding- > > Fra: Patrice Garbe [mailto:[EMAIL PROTECTED]] > > Sendt: 9. august 2001 19:45 > > Til: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Emne: [PHP-DB] Empty error ? (HELP ME) > > > > > > Hello, > > > > Sorry to ask so much questions but I'm in real troubles. > > I have an error "0" performing a query that works with phpMyAdmin. > > This appear in a script that performs a lot of queries before. > > I have PHP 4.0.6 with the mysql built-in support. > > I use unbuffered queries because I had a "mysql client run out > > of memory" error. I had the same problem with the external > > support. > > > > What can be the cause of the problem ? A lack of memory I suppose > > but why and where ? > > > > Thank you. > > > > Patrice > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
2008 Mysql client run out of memory !?!
Hello, I use PHP 4.0.6 with mySQL 3.23.40 and I have the error 2008 (client run out of memory) performing this query : select i2f.item_id, i2f.value, f.id from features as f, item2feature as i2f, items as i where i.scat_id = '244d713abba5f2ffb8d0ba8c858111ef' and i.id = i2f.item_id and f.id = i2f.feat_id That query works perfectly with phpMyAdmin - It returns 2 rows - and is also performed several times in the program using loops. I tried unbuffered queries but I had an error 0 (?). I think It is not the query that goes wrong but I don't understant why the mysql client run out of memory like that ! How can I find the cause of the problem ? Is there a way to see what's in the mysql client memory ? Thank you ! PS : If you want to reply me directly remove the name between brackets from the subject.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
