01-26-2010
The heap size is in the php.ini if you want to increase it.
It's pretty common to need to bump it up a bit higher for some applications.
7 More Discussions You Might Find Interesting
1. AIX
Hi,
I have migrated some processing from true64 --> AIX 5.3. my problem is to process large files in memory by diff or awk program. I need to load app. 1.3 GB of data into memory but it fails that there is not enough memory.
I need following:
diff file1 file2
orig. aix diff err... (2 Replies)
Discussion started by: Petr
2 Replies
2. Shell Programming and Scripting
Dear All,
I have executed a awk script in linux box which consists of 21 Million records.And i have two mapping files of 500 and 5200 records.To my surprise i found an error
awk: cmd. line:19: (FILENAME=/home/FILE FNR=21031272) fatal: Memory exhausted.
Is there any limitation for records... (3 Replies)
Discussion started by: cskumar
3 Replies
3. Shell Programming and Scripting
Hi,
Could someone please help me with the best approach to compare lines from one file to another? Here is how I have entries -
File 1
a1
a2
a3
a4
a9
a10
a15
File2
a5
a6
a15 (5 Replies)
Discussion started by: sncoupons
5 Replies
4. Solaris
I'm trying to install PHP 5.3 on Solaris 10 .
I'm using etc/apache2
and installed mysql 5.1.39.
When I tried to compile PHP 5.3, with the following configure text,
./configure --with-mysql=/usr/local/mysql \
--with-mysqli=/usr/local/mysql/bin/mysql_config --with-zlib-dir=/usr/local \... (21 Replies)
Discussion started by: ppa108
21 Replies
5. UNIX for Advanced & Expert Users
I was running a program and it stopped and showed "Out of Memory!". at that time, the RAM used by this process is around 4G and the free memory size of the machine is around 30G. Does anybody know what maybe the reason? this program is written with Perl. the OS of the machine is Solaris U8. And I... (1 Reply)
Discussion started by: lilili07
1 Replies
6. Shell Programming and Scripting
While running script I am getting an error like
Few lines in data are not being processed.
After googling it I came to know that adding such line would give some memory to it
ini_set("memory_limit","64M");
my input file size is 1 GB.
Is that memory limit is based on RAM we have on... (1 Reply)
Discussion started by: elamurugu
1 Replies
7. What is on Your Mind?
Today, I noticed some errors in our SSL cert renewal log files, mostly related to domains where the IP address had changed. Concerned about this, rebuilt out SSL cert, which normally goes well without a hiccup.
However, for today, for some reason which I cannot explain, there was a PHP error... (0 Replies)
Discussion started by: Neo
0 Replies
LEARN ABOUT PHP
pg_last_notice
PG_LAST_NOTICE(3) PG_LAST_NOTICE(3)
pg_last_notice - Returns the last notice message from PostgreSQL server
SYNOPSIS
string pg_last_notice (resource $connection)
DESCRIPTION
pg_last_notice(3) returns the last notice message from the PostgreSQL server on the specified $connection. The PostgreSQL server sends
notice messages in several cases, for instance when creating a SERIAL column in a table.
With pg_last_notice(3), you can avoid issuing useless queries by checking whether or not the notice is related to your transaction.
Notice message tracking can be set to optional by setting 1 for pgsql.ignore_notice in php.ini.
Notice message logging can be set to optional by setting 0 for pgsql.log_notice in php.ini. Unless pgsql.ignore_notice is set to 0, notice
message cannot be logged.
PARAMETERS
o $connection
- PostgreSQL database connection resource.
RETURN VALUES
A string containing the last notice on the given $connection, or FALSE on error.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 4.3.0 | |
| | |
| | This function is now fully implemented. Earlier |
| | versions ignores database connection parameter. |
| | |
| 4.3.0 | |
| | |
| | The pgsql.ignore_notice and pgsql.log_notice |
| | php.ini directives were added. |
| | |
| 4.0.6 | |
| | |
| | PHP 4.0.6 has problem with notice message han- |
| | dling. Use of the PostgreSQL module with PHP |
| | 4.0.6 is not recommended even if you are not |
| | using pg_last_notice(3). |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
pg_last_notice(3) example
<?php
$pgsql_conn = pg_connect("dbname=mark host=localhost");
$res = pg_query("CREATE TABLE test (id SERIAL)");
$notice = pg_last_notice($pgsql_conn);
echo $notice;
?>
The above example will output:
CREATE TABLE will create implicit sequence "test_id_seq" for "serial" column "test.id"
SEE ALSO
pg_query(3), pg_last_error(3).
PHP Documentation Group PG_LAST_NOTICE(3)