Binary Log EventsStatement based: statementRow based: RowsMix: Mixed
Binary log operationsMysql>show binary logs; View the log directoryMysql>show Master status; View the log that is currently in useMysql>show binlog events in ' mysql-bin.000001
Issue: Access denied for user ' * ' @ ' localhost ' using password YesMethod 1: Use the Set password commandMysql-u Rootmysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass '); (solved in this way)Method 2: Use Mysqladminmysqladmin-
Http://blog.chinaunix.net/uid-8581780-id-347984.htmlFor a fast web development task, I usually choose Karrigell as a tool. Karrigell is intuitive and makes you feel that it's so convenient to develop a Web application. She's a bit like PHP or JSP,
MySQL Single-Table restrictionsOne, the MySQL database MyISAM storage engine single table size limit has not been the MySQL database itself to decide (limit to 64PB), but by the host's OS above the file system to determine.Before the mysql5.0
Operating system:Red Hat Enterprise Linux 6.6 x86_64Note:A PXE server (Rhel 6.6 x86_64 + http + dhcp + TFTP + Kickstart + DNS) is deployed on the physical machine, the package selected in Rhel 6.6 installed is @base, and the disc is configured as a
Updating data: Update table name set health name = "changed value" where built = ...Delete data: Delete from table name where ...Index: CREATE index name on table name (key name);Create the attempt: the Create View name (key, key) as SELECT
One, create the user:Command: CREATE USER ' username ' @ ' host ' identified by ' password ';Description: Username-the user name that you will create, host-Specifies which host the user can log on to, if localhost is available to local users, you
Chengdu MySQL Server disk space cleanup2.7.1 Project NameChengdu Project2.7.2 Problem DescriptionDisk space 90%2.7.3 Impact RangePlanned downtimeAnalysis of 2.7.4 problemsDatabase disk space is full, view is log file causes2.7.5 SolutionsFirst, the
When doing web site development, sometimes you need to restrict certain fields, and then return to the following requirementsWhen a field in the database is unique, when the same data is inserted again, the update operationSyntax: REPLACE into
MySQL View and new table partitioning1. View Table partitionSELECTPartition_name part,Partition_expression expr,Partition_description Descr,From_days (partition_description)
mysql-uroot-p Password//Logincreat database people; CreateDROP database name//deleteShow databases//view all databasesuse database name//using a database Show tables//Show all tables under the current databasedesc Table name//View the properties of
People old memory will fall, in order to avoid my old remember mysqldump this command, I'll just write this thing down- - - 10.132. 56.188 > table. sqlNote that this command will be followed by the path name if you want to change the path if the
Primary server (192.168.1.111) configuration:1. To set up authorized users from the server 2, modify the master server Profile MY.COF, open the Bin-log log, and set the Server-id value (each server-id is not the same) 3, set the read lock on the
First, install MySQLType the following command at the terminal: sudo apt-get install mysql-serverDuring the installation, a configuration interface will appear prompting the user to set the password for MySQL root user.if the installation is
1. Turn on MySQL remote access permission to allow remote connectionsMysql-uroot-pExecute the following command:Grant all privileges on * * to ' root ' @ ' 192.168.0.1 ' identified by ' Root-password ';Flush privileges;Exit192.168.0.1 is the IP of
Mysql optimization practice (explain & amp; index)Lab environment:
1. SQL tool: Navicat2 and SQL database. Use openstack database as an example.
I. mysql index Query
Show index from instances
Result field explanation:
Mysql fuzzy query optimization
First, create an index for the fields to be searched in the database (mysql index is unfamiliar, please refer to here ).
Secondly, use the following function for fuzzy search. If the position is greater than 0, it
Mysql foreign Key Usage
I. Basic Concepts
1. MySQL has the same definition of "key" and "Index", so foreign keys and primary keys are also an index. The difference is that MySQL will automatically index the primary keys of all tables, but the
Analysis of five cases of mysql index failure and mysql Index
Indexes do not always take effect. For example, the following situations may cause index failure:
If there is or in the condition, it will not be used even if there is a conditional
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