command: show Processlist;if it is the root account, you can see the current connection for all users. If you are a normal account, you can only see the connection you are occupying. show Processlist; only the first 100 are listed, if you want to
I wrote an article about this before.Why does "original" use data indexing to improve efficiency? (This article provides an overview of MySQL) (update)This time, the main focus is on two common storage engines.We generally perform MySQL database
Remember a very long SQL, in order to facilitate reading, I have added the paragraph: SELECT * from ( (SELECT 1 asAcheck, S1.id, S1.plan_name, S1.cost_mode, S1.sta_type, S1.cost_type, S1.cost_period_time, S1.cost_period_value, S1. '
Create a test tablemysql> desc; +-------+-------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+-------+-------------+------+-----+---------+----------------+| ID int(one) | NO |
General SQL output specifies that the ID needs to be sorted, and the result output above has some uncertainty. Requirements by55,6,5,173,176,174,175,177Output results in the sequential order.The result is sometimes not just reverse order, the
For English, MySQL's Fulltext property is quite convenient and efficient to implement full-text retrieval, but there are some things to be aware of in the process of using.First, we add the Fulltext attribute to the field we need to retrieve
binlog_do_db;binlog_ignore_db;This two parameter is used to control which database changes to log; The following is an example of binlog_ignore_db.if Binlog_ignore_db=studio;Use studio; INSERT into t (x, Y) VALUES (2,2);--This is not a binary log,
LOADDATA LOCAL INFILE'C:/xampp/htdocs/test/file/sample.csv' into TABLESample1fields TERMINATED by ','Enclosed by '\"'LINES TERMINATED by '\ r \ n'IGNORE1LINES (Presidency, President,@x,@x,@x, Party,@x,@x,@x)You can insert the specified line,
Summary You have a error in your SQL syntax; Check the manual, corresponds to your MySQL server Versio This sentence for us is not unfamiliar, nothing more than "," and so on. But if you inadvertently add a reserved field in MySQL as the field name
Explore paging performance-mysql
Paging technology is very common in development. I used paging technology for the two projects I just joined the company, so I thought about in-depth exploration of paging technology.
Several common paging
MySQL obtains slow log information by time.
Handle a case today: the database is abnormal and the number of connections suddenly increases.I want to analyze the slow log, but I can see that the slow log is several GB, and it is a short log format.
Some Suggestions on using Perl DBI for MySQL operations, perldbi
Using perl to connect to mysql, there are many cases on the Internet. Generally, we use the DBD: MySQL module under DBI. Here we create a mask to get a TIPS:Perl DBI MySQL Character
Mysql common SQL statements (1)[1] Clear TABLE statement
truncate table fke_message;
[2] resetting the start value of the auto-increment Field
alter table fke_message auto_increment = 10001;
[3] common table creation statements
Drop table if
A simple paging Optimization Method for MySQL in Big Data scenarios.
Usually, an application needs to flip the data in a table. If the data volume is large, it may cause performance problems:
root@sns 07:16:25>select count(*) from reply_0004 where
Use an instance to understand the usage of the MySQL prefix index.
A warning was reported when I added an index in the test environment today.
root@test 07:57:52>alter table article drop index ind_article_url;Query OK, 144384 rows affected (16.29
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