Archive for the 'MySQL' Category
- MySQL Performance Tuning tips and techniques
I am aware of few tips but this article summaries few more good tips and techniques that will optimize MySQL Server performance.
Although this article explains how to tune a MySQL database for use with eZ publish system. But most of things mentioned here will apply to other MySQL based software (such as Wordpress or phpbb).
This [...] - How to backup MySQL databases, web server files to a FTP server automatically
This is a simple backup solution for people who run their own web server and MySQL server on a dedicated box or VPS. Most dedicated hosting provider provides the backup service using NAS or FTP servers. These service providers will hook you to their redundant centralized storage array over private VLAN. Since I manage [...]
- Tutorial: MySQL Connection Management and caching in PHP
Jay Pipes writes about MySQL Connection Management and caching in PHP.
This small tutorial will help you understand the MySQL Connection Management and caching in PHP.
FTA, “This article is intended to highlight various basic topics concerning proper methods of handling connections to MySQL databases in PHP, guidelines for caching dynamic content, and a technique called [...] - Recover MySQL root password
You can recover MySQL database server password with following five easy steps.
Step # 1: Stop the MySQL server process.
Step # 2: Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password
Step # 3: Connect to mysql server as the root user
Step # 4: Setup new root password
Step [...] - How Do I Enable Remote Access To MySQL Database Server?
By default, MySQL database server remote access disabled for security reasons. However, some time you need to provide the remote access to database server from home or from web server.
- Enable the query cache in MySQL to improve performance
If you want to get optimized and speedy response from your MySQL server then you need to add following two configurations directive to your MySQL server:
query_cache_size=SIZE
The amount of memory (SIZE) allocated for caching query results. The default value is 0, which disables the query cache.
query_cache_type=OPTION
Set the query cache type. Possible options are as follows:
0 : [...] - Linux: Iptables Allow MYSQL server incoming request on port 3306
MySQL is popular for web applications and acts as the database component of the LAMP, MAMP, and WAMP platforms. Its popularity as a web application is closely tied to the popularity of PHP, which is often combined with MySQL.
MySQL is open source database server and by default it listen on TCP port 3306.
Task: [...] - MySql backup script
This mysql database shell (bash download link at the end of script) script can be used:
1) To backup databases file /backup dir and later pick up by your script
2) You can skip few databases from backup!
Download script from above url.
Open file backup.bash.txt and customize it:
MyUSER=”YOUR-MYSQL-USER” # mysql username
MyPASS=”YOUR-MYSQL-USER-PASSWORD” # mysql password
MyHOST=”localhost” [...]
Viewing 31-38 of 38 posts.
« Previous Page
Recent Comments
Today ~ 160 Comments
Today ~ 5 Comments
Yesterday ~ 6 Comments
Yesterday ~ 4 Comments
Yesterday ~ 1 Comment