03-27-2014
- Define slow: Is the user sending SQL statements that take long to process/return? If yes, maybe check if the query uses indices or use a EXPLAIN PLAN, which will show what "costs" the query has and where improvements can be done. Use Google and you will find lots of helpful documents.
It can also be that there is another problem like a performance problem on the box, etc. Do other users/jobs have the same problem?
- The command you use will try to find associated processes for the directory /proc/21955180. This will not work the way you want it.
You should specify the correct switch for a PID, which is -p
This will most probably be the least thing to check why the connection or processing of queries is slow.
10 More Discussions You Might Find Interesting
1. AIX
hello
Sorry but i don't understand very well the lsof command with the man.
Can you explain to me what is the use of this command ?
thank you (2 Replies)
Discussion started by: pascalbout
2 Replies
2. UNIX for Dummies Questions & Answers
Using lsof command i can find out which process-id is associated with the port.
lsof -i :51000
. But as part of process i cant have lsof in the server.
I am using sun solaris 8 and only kshell. Is there a way to find out which process is using the above port. as of now i am gettn port... (1 Reply)
Discussion started by: logic0
1 Replies
3. Shell Programming and Scripting
Hi All,
i want the last login details along with year.
i tried below command but not giving me the year of last login.
last <$Userid> | head -1
i heard that if it is current year then it wont display the year else it will display the year. is it so?
if yes then , is there any way of... (1 Reply)
Discussion started by: ani_rvce
1 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
i want the last login details along with year.
i tried below command but not giving me the year of last login.
last <$Userid> | head -1
i heard that if it is current year then it wont display the year else it will display the year. is it so?
if yes then , is there any way of... (1 Reply)
Discussion started by: ani_rvce
1 Replies
5. Shell Programming and Scripting
Hello,
i am developing a simple shell script for simulation of wc command but it's not working.Please tell me what is the problem. I have commented the problematic line
if
then
echo "<Improper Usage>"
echo "wcassg <options> file"
else
eval file=\$$#
if
then
chars=0
words=0... (2 Replies)
Discussion started by: salman4u
2 Replies
6. Solaris
Hi,
Can anyone explain me the difference between fsuer and lsof commands. As per my knowledge both the commands are used to find the processes used by the current file system or user. Apart from that what is the major difference between these commands (3 Replies)
Discussion started by: rogerben
3 Replies
7. Shell Programming and Scripting
Hello,
I am running below command as root user
#nodetool cfstats tests | grep "Memtable switch count"
Memtable switch count: 12
Where as when I try to run same command as another user it gives different result.
#su -l zabbix -s /bin/bash -c "nodetool cfstats tests | grep "Memtable switch... (10 Replies)
Discussion started by: Pushpraj
10 Replies
8. Shell Programming and Scripting
#cat /tmp/input
old_array old_dev new_dev new_array
0577 008AB 01744 0125
0577 008AC 01745 0125
0577 008AD 005C8 0125
0577 008AE 005C9 0125
0577 008AF 005CA 0125
0577 008B0 005CB 0125
0577 008B1 005CC 0125
cat test.sh
#!/bin/ksh... (4 Replies)
Discussion started by: mbak
4 Replies
9. Shell Programming and Scripting
Hi,
i have a source file and have 3 columns and separated by "|" .i want to split this 3 columns in different variable.When i am executing this values indivisually giving correct result but when the same execute inside a for loop,it's giving issues.
Src file(jjj.txt)
-------... (8 Replies)
Discussion started by: raju2016
8 Replies
10. Shell Programming and Scripting
Hi,
I am trying to find the files in a specific directory that are currently in open state. I need this information to archive the old files that are not active in the directory.
I get the following output when I try the command $ lsof +d '/var/tmp/'|awk '{print $9}'|sort -u
NAME... (1 Reply)
Discussion started by: ryzen7
1 Replies
LEARN ABOUT PHP
cubrid_unbuffered_query
CUBRID_UNBUFFERED_QUERY(3) 1 CUBRID_UNBUFFERED_QUERY(3)
cubrid_unbuffered_query - Perform a query without fetching the results into memory
SYNOPSIS
resource cubrid_unbuffered_query (string $query, [resource $conn_identifier])
DESCRIPTION
This function performs a query without waiting for that all query results have been complete. It will return when the results are being
generated.
PARAMETERS
o $query
-A SQL query.
o $conn_identifier
-The CUBRID connection. If the connection identifier is not specified, the last connection opened by cubrid_connect(3) is assumed.
RETURN VALUES
For SELECT, SHOW, DESCRIBE or EXPLAIN statements returns a request identifier resource on success.
For other type of SQL statements, UPDATE, DELETE, DROP, etc, returns TRUE on success.
FALSE on failure.
NOTES
Note
The benefits of cubrid_unbuffered_query(3) come at a cost: you cannot use cubrid_num_rows(3) and cubrid_data_seek(3) on a result
set returned from cubrid_unbuffered_query(3).
EXAMPLES
Example #1
cubrid_unbuffered_query(3) example
<?php
$link = cubrid_connect("localhost", 30000, "demodb", "dba", "");
if (!$link)
{
die('Could not connect.');
}
$query = "select * from code";
$result = cubrid_unbuffered_query($query, $link);
while ($row = cubrid_fetch($result))
{
var_dump($row);
}
cubrid_close_request($result);
cubrid_disconnect($link);
?>
PHP Documentation Group CUBRID_UNBUFFERED_QUERY(3)