Questions tagged [mysqlnd]

The MySQL native driver for PHP (mysqlnd) is a drop-in replacement for the MySQL Client Library (libmysql) for the PHP script language.

Because MySQL Native Driver is written as a PHP extension, it is tightly coupled to the workings of PHP.

This leads to gains in efficiency, especially when it comes to memory usage, as the driver uses the PHP memory management system. It also supports the PHP memory limit. Using MySQL Native Driver leads to comparable or better performance than using MySQL Client Library, it always ensures the most efficient use of memory. One example of the memory efficiency is the fact that when using the MySQL Client Library, each row is stored in memory twice, whereas with the MySQL Native Driver each row is only stored once in memory.

126 questions
5
votes
2 answers

Instal mysqlnd in a hosted website

I am developing a web-site in PHP - MySQL. Here are some points to note: I am using MySQLi API for database access. In my local installation of XAMPP (a Windows 7 machine), the PHP version is 5.3.8, MySQL version is mysqlnd 5.0.8-dev - 20102224 I…
Kumar Kush
  • 2,495
  • 11
  • 32
  • 42
5
votes
1 answer

MAMP with MySQL natural driver

So I've been working with MAMP to develop a site locally on my computer, but one of the things that has been really bugging me is that MAMP doesn't come with the MySQL Natural Driver for PHP. So I can't use the lovely get_result() function. I even…
Puzzler3141
  • 1,682
  • 2
  • 14
  • 21
5
votes
2 answers

MySQL/PDO truncates the data

$book is a 7kb string. If this query is executed using PHP PDO exec, the monograph column (LONGTEXT) data gets truncated at 6765 character: echo strlen($book); // output 7157 $db->exec("UPDATE `chemicals` SET `monograph` = {$db->quote($book)} WHERE…
Gajus
  • 69,002
  • 70
  • 275
  • 438
4
votes
1 answer

Not able to install and run mysqlnd_ms in ubuntu

I have hard time installing mysqlnd_ms on my ubuntu machine. Steps followed: Updated my local machine to run php 7 Followed https://github.com/sergiotabanelli/mysqlnd_ms and installed required libraries sudo apt-get install libxml2-dev sudo…
Saikiran
  • 756
  • 2
  • 11
  • 29
4
votes
2 answers

Error Installing PECL Package: Mysql_xdevapi

I'm getting the following error when i run this command sudo pecl install mysql_xdevapi Error: /private/tmp/pear/temp/pear-build-nabilashahidhnTBCl/mysql_xdevapi-8.0.12/libtool: line 1280: xmysqlnd/proto_gen/mysqlx_connection.loT: No such file or…
Nabila Shahid
  • 419
  • 1
  • 6
  • 13
4
votes
0 answers

Call to undefined method mysqli_stmt::get_result() with mysqlnd enabled

Initially I had this error saying Call to undefined method mysqli_stmt::get_result() Then after searching I found out that I have to enable mysqlnd driver for that. I using godaddy hosting site and I have enabled the mysqlnd driver but I am still…
user7360646
4
votes
1 answer

Cannot find OpenSSL's when installing mysqlnd on PHP 7.0.13

I'm getting the following error when trying to install mysqlnd extension on PHP 7.0.13. My openssl files are located on /usr/include/openssl/ according to locate evp.h. Already tried…
Felipe Francisco
  • 1,064
  • 2
  • 21
  • 45
4
votes
1 answer

configure: error: Cannot find OpenSSL's

I've installed the php7 on my redhat server,while i want to use the mysql extension.I cd the php7 source ext dir,and configured many times but all result that "configure: error: Cannot find OpenSSL's ".It's awfal! 1.I had the openssl there. [root@xx…
Yong
  • 71
  • 2
  • 9
4
votes
1 answer

PHP mysqlnd sha256_password plugin "Access denied", user works from cli mysql

I'm trying to secure a mysql connection with SSL and password encryption by sha256. My setup works as expected from the cli mysql and when using native mysql password. When trying to connect as a user with sha256 pasword i get "HY000/1045): Access…
Samuel Åslund
  • 2,814
  • 2
  • 18
  • 23
4
votes
0 answers

How to enable mysqlnd in PHP on a MAMP environment

Hi I am running a MAMP dev environment and do not have alot of experience re-configuring PHP. However, I see that I need to utilize mysqlnd instead of mysql. How exactly does one do this from terminal in UNIX? Link to php install source
Ryan Salmons
  • 1,429
  • 10
  • 21
  • 42
4
votes
1 answer

Mysqlnd unable to connect to MySQL 5.5 server

I'm trying to get a site running locally that is currently running on a dev server running PHP 5.3.10. It connects to a MySQL server that is version 5.5, but has old_passwords set to ON. The site works on the dev server. On my local, I am running…
nwalke
  • 3,170
  • 6
  • 35
  • 60
4
votes
1 answer

mysqlnd_ms error - getaddrinfo failed, mysqlnd_global_stats in Unknown

I'm trying to set up mysqlnd_ms so that it serves its purpose of doing the reads on the slave db and writes on the master db. However, I'm getting this error when httpd is restarted. PHP Warning: PHP Startup: Unable to load dynamic library…
MisRoy
  • 131
  • 2
  • 5
3
votes
1 answer

Fixing a PHP database connection failure with updated MySQL library

I spent some hours trying to solve a migration from CentOS 5.5 to 7 in which everything worked except PHP-based sites connecting to the MySQL server for a Web site. Perl worked fine. CLI commands worked fine. I tried every solution listed on Stack…
3
votes
1 answer

mysqlnd noticeable slower than libmysql using PDO

I'm just switching to mysqlnd to be able to use http://php.net/manual/en/book.mysqlnd-ms.php but I see some serious performance degradation compared to libmysql. NewRewlic shows more 100ms spend in PHP after switching to mysqlnd…
Tuner
  • 69
  • 7
3
votes
1 answer

Is possible to enable MySQL Native Driver (mysqlnd)?

Possible Duplicate: Call to undefined method mysqli_stmt::get_result My web host has PHP 5.3.10 and I'm using mysqli, but some functions like get_result() doesn't work because it needs mysqlnd. I made some tests and appears that mysqlnd isn't…
Renato Dinhani
  • 35,057
  • 55
  • 139
  • 199
1
2
3
8 9