Sponsored Content
Operating Systems Solaris Solaris BigAdmin RSS Success with OpenSolaris + ZFS + MySQL in production! Post 302249555 by Linux Bot on Tuesday 21st of October 2008 03:00:03 PM
Old 10-21-2008
Success with OpenSolaris + ZFS + MySQL in production!

This tip provides information about using ZFS on a MySQL database box and OpenSolaris. The author explores two questions: Can a MySQL slave on OpenSolaris with ZFS keep up with the write load with no readers, and if yes, can the slave shoulder its fair share of the reads, too?

More...
 

We Also Found This Discussion For You

1. Shell Programming and Scripting

production issue - shell sqlplus processing sometime success sometime fail

Hi Expert, Below is a real production environment issue: we are using shell script to FTP to a remote server and fetch around 150 files every day, for each file we need to keep a entry inside ORACLE DB table, before insert into table, each file has a associated logid, which need to be... (2 Replies)
Discussion started by: summer_cherry
2 Replies
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)
All times are GMT -4. The time now is 11:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy