11-14-2019
Seems like the bulk of this MySQL performance issue is solved (fingers crossed).
This User Gave Thanks to Neo For This Post:
4 More Discussions You Might Find Interesting
1. AIX
... a disk drive to be 100% busy?
hdisk0 100.0 1.3K 342.7 1.3K 22.0 PgspIn 651 % Noncomp 75.5
hdisk1 100.0 1.3K 320.2 1.2K 20.0 PgspOut 6 % Client 75.5
It's really slowing down performance on my system and I would like to know what is causing this.
... (2 Replies)
Discussion started by: bbbngowc
2 Replies
2. SCO
hi
We have migrated SCO 5.0.6 into ESX4, but the VM eats 100% of the virtual CPU.
Here is top print from the SCO VM:
last pid: 16773; load averages: 1.68, 1.25, 0.98 02:08:41
79 processes: 75 sleeping, 2 running, 1 zombie, 1 onproc
CPU states: 0.0% idle, 17.0% user,... (7 Replies)
Discussion started by: ccc
7 Replies
3. AIX
Hello,
I encounter some performance issues on my AIX 5.3 server running in a LPAR on a P520. How do I investigate performance issues in AIX. Is there any kind of procedure that takes me to the steps to investigate my server and find the sub systems that is causing the issues?
The performance... (1 Reply)
Discussion started by: petervg
1 Replies
4. Programming
I need to rotate a pixmap in XLib with some kind of interpolation to reduce the aliasing.
I came up with the following code, which uses bilinear interpolation. It works fine: the rotated image looks perfect, but unfortunately it takes 5 or 6 seconds for each rotation. (in a 300x300, 16 colours... (5 Replies)
Discussion started by: mghis
5 Replies
LEARN ABOUT PHP
mysql_get_proto_info
MYSQL_GET_PROTO_INFO(3) 1 MYSQL_GET_PROTO_INFO(3)
mysql_get_proto_info - Get MySQL protocol info
SYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_get_proto_info(3)
int mysql_get_proto_info ([resource $link_identifier = NULL])
DESCRIPTION
Retrieves the MySQL protocol.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
Returns the MySQL protocol on success or FALSE on failure.
Example #1
mysql_get_proto_info(3) example
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
printf("MySQL protocol version: %s
", mysql_get_proto_info());
?>
The above example will output something similar to:
MySQL protocol version: 10
mysql_get_client_info(3), mysql_get_host_info(3), mysql_get_server_info(3).
PHP Documentation Group MYSQL_GET_PROTO_INFO(3)