LAMP installation ConfigurationConfiguring the EnvironmentOperating system: Redhat Enterprise as 4Packages installed: httpd2.0.4, mysql4.1,libxml2.6.16, zlib1.2.1.2,gd2.0.28, libpng1.2.7Description: The various installation instructions on the
mysql| Reference | Reference manual | Chinese MySQL 4.1.0 chinese reference manual---dog (heart sail) Translate MySQL Reference Manual for version 4.1.0-alpha.
6 MySQL Language Reference
MySQL has a complex, but intuitive, and easy to learn SQL
Three ways to monitor MySQL with Zabbix 1. Just install Agent2. Enable template monitoring 3. Enable template monitoring for custom scriptsMySQL is the default monitor template in Zabbix. The default is already in the zabbix2.2 and above versions.
1. Full backup and incremental backup 1.1 full-scale backupFull-volume data is all the data in the database, and a full backup is the backup of all the data in the database.Back Up all libraries:mysqldump -uroot -p123456 -S /data/3306/mysql.sock -F -
Error (below), but using mysqld direct boot is not a problem.[SQL]View plain copy
150718 00:03:38 mysqld_safe Logging to '/var/log/mysqld.log '.
150718 00:03:38 Mysqld_safe The file/usr/local/mysql/bin/mysqld
Does not exist or was not
First, the cmd common MySQL related commandsmysql-d,--database=name//Open Database--delimiter=name//Specify delimiter-H,--host=name//server name-P,--password[=name]//password-P,--Port[=name]//Port number--prompt==name//Setup
MySQL itself provides command line export tool mysqldump and MySQL source Import command for SQL data import and export work, through the MySQL command line export tool mysqldump command to export MySQL data into text Format (TXT) SQL file, The
MYSQL gets the current date and date formatGet system Date: Now ()Formatted Date: date_format (date, format)Note: Date: Time fieldFormat: Date formatsReturns the system date, output 2009-12-25 14:38:59Select Now ();Output 09-12-25Select Date_format (
In the previous version, adjust the innodb_buffer_pool_size size must restart the MySQL process to take effect, now in the MySQL5.7, can be directly dynamic settings, convenient a lot.This feature applies to the scenario:First, the machine increased
Configuration text for PHP environmentPrepare the software first:Apache official:apache_2.0.55-win32-x86-no_ssl.msi, more versions here ;PHP Official:php-5.0.5-win32.zip, more images , more version download ;MySQL official:mysql-4.1.14-win32.zip,
Error when recovering MySQL data using xtrabackup: Original Data directory is not empty! At/usr/bin/innobackupex Line 568.There are only two reasons for this imagination to be said on the Internet, and there is a third reason I have encountered:1.
MYSQL gets the current date and date formatGet system Date: Now ()Formatted Date: date_format (date, format)Note: Date: Time fieldFormat: Date formatsReturns the system date, output 2009-12-25 14:38:59Select Now ();Output 09-12-25Select Date_format (
Why cannot I start MySql in windows?1. the MySQL configuration file is set incorrectly.A. First, find the MySQL configuration file my. ini.If the service is started using the specified configuration file, modify it to the corresponding file (the
Welcome to Mac OS X of XAMPPXAMPP for Mac OS x is the simplest, most practical, and most complete network server solution on Mac OS X. This release includes Apache 2 servers integrated with the latest MySQL, PHP, and Perl. It is released in the form
Create a stored procedure for MySQL
Mysql stored procedure details
1. Introduction to stored procedures
The commonly used operating database language SQL statements must be compiled and then executed before execution. The Stored Procedure
A basic tutorial on querying logs and slow query logs in MySQL,
I. query logs
Query all the queries in MySQL by using "-- log [= file_name. Because all the queries, including all the select statements, are recorded, and the size is relatively large,
Comparison with MSSQL to learn about MYSQL (8) -- insert, update, delete, and mssqlmysql
Similarly, it will only explain the difference between SQL Server and SQL Server.
Insert
Insert multi-row query results into the table
Syntax
INSERT INTO
Directory
I. Optimization Overview
Ii. query and index optimization Analysis
1. performance bottleneck locating
Show command
Slow query log
Explain analysis Query
Profiling Analysis Query
2 Index and Query Optimization
Iii. Configuration
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service