Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 1201 10 Older Entries

Displaying posts with tag: Linux (reset)

linux swap and mysql memory
+0 Vote Up -0Vote Down

After mysql installation, To make mysql server production ready we have to tune default mysql variables considering the hardware, production load, performance, durability etc.

But What about the optimizing  Linux OS settings  with mysql ?

Here it is, i encountered  an issue once when i was checking TOP output for mysqld process and found that the mysqld  memory continuously increasing. Also there was one more thing  that it was using swap memory even if there was enough RAM memory available. we have monitored …

  [Read more...]
How to install sysbench 0.5 on Debian 7
+2 Vote Up -0Vote Down

Normally, sysbench 0.4.12 version can be installed from repositories like “apt-get install sysbench” but the newer version 0.5 is not added in any repo yet (AFAIK) so, it’s bit difficult to install it. 1. Install bzr package if it’s not Continue reading How to install sysbench 0.5 on Debian 7→

  [Read more...]
How to use and get output arguments in stored procedure using OUT parameter mode?
+1 Vote Up -0Vote Down

It is sometimes required to get the result of a stored procedure in a variable which can be used later or to output the result.

To do so, we can use the "OUT" parameter mode while defining stored procedures.

In the below section, we will be writing a stored procedure to get the square root of a number returned in an output variable provided by us.



Stored Procedure Definition:

Store the below stored procedure in a file named …









  [Read more...]
libssl.so.6: cannot open shared object file with Debian/CentOS
+0 Vote Up -0Vote Down

Actually, I found this error many times, while installing MySQL/Percona servers with MySQL Sandbox. To resolve this issue, first, you have to make sure that, SSL is installed /update properly. sudo apt-get update sudo apt-get install libssl1.0.0 libssl-dev After installing Continue reading libssl.so.6: cannot open shared object file with Debian/CentOS→

  [Read more...]
FATAL: failed to initialize database driver! with Sysnbech 0.4.X
+0 Vote Up -0Vote Down

Recently, I came through with this error. It was weird because I have never seen this error earlier. [root@percona-pxc55-1 nilnandan]# sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=dbtest --mysql-user=msandbox --mysql-password=msandbox --mysql-socket=/tmp/mysql_sandbox5537.sock prepare sysbench 0.4.12: multi-threaded system evaluation benchmark FATAL: no database driver specified FATAL: Continue reading FATAL: failed to initialize database driver! with Sysnbech 0.4.X→

  [Read more...]
How To Install Nginx With PHP And MySQL (LEMP Stack) On CentOS 7
+0 Vote Up -0Vote Down

How To Install Nginx With PHP And MySQL (LEMP Stack) On CentOS 7

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a CentOS 6.5 server with PHP support (through PHP-FPM) and MySQL (Mariadb) support.

How to execute mysql query from a file in your mysql client terminal?
+0 Vote Up -0Vote Down

Being a terminal fan myself, I usually find myself running queries in the mysql client instead of a UI interface as it is much faster. You get to see the results instantaneously.

One thing which is pretty tedious is editing a big query again after once running it as the whole multi-line formatted query now appears on a single line, thus reducing its readability.

But no problems, you can edit your query from a file and run the file from your mysql client terminal as many times as you want with as many edits.

To do so, follow the below steps:

1. Open your terminal and cd into the …







  [Read more...]
How to install Phalcon PHP framework in Ubuntu linux?
+0 Vote Up -0Vote Down

Well, we have all heard about the fastest php framework out there. But how do we install it in a Ubuntu Linux machine.

Default process for any linux setup.

Steps:

1. First, we need  a few packages previously installed. To install them, issue the distro specific command in your linux terminal.

For Ubuntu:

sudo apt-get install php5-dev php5-mysql gcc libpcre3-dev

For Fedora:

sudo yum install php-devel php-mysqlnd gcc libtool

For RHEL:

sudo yum install php-devel php-mysql …

















  [Read more...]
How To Install Nginx With PHP5 (And PHP-FPM) And MySQL Support On CentOS 6.5
+0 Vote Up -0Vote Down

How To Install Nginx With PHP5 (And PHP-FPM) And MySQL Support On CentOS 6.5

Nginx(pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a CentOS 6.5 server with PHP5 support (through PHP-FPM) and MySQL support.

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 14.04LTS (LAMP)
+0 Vote Up -0Vote Down

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 14.04LTS (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on anUbuntu 13.04 server with PHP5 support (mod_php) and MySQL support.

10 Newer Entries Showing entries 61 to 70 of 1201 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.