Record what you see on the Internet
Http://www.mysqlperformanceblog.com/2009/04/15/how-to-decrease-innodb-shutdown-times/
The general method is:
First, reduce the innodb_max_dirty_pages_pct parameter value, so that data in the memory can be
Installing the MySQL driver
First, check the missing related packages:
$ Apt-cache search libmysqlclient
Libcrypt-mysql-perl module to emulate the MySQL password () function.Libglpk0-linear programming kit with integer (MIP)
Author: zhangguozhongDate: 2007-5-12
MySQL version: 5.0.27
1. Start the database.Command: Net start MySQLNet stop MySQL2. Connect to the database:CMD --> mysql-uusername-ppassword
3. Show:Show databases;Show tables;
4. Create a database,
Import the query result File
Select * from table into OUTFILE 'C:/aaa.txt ';
One statement imports multiple data records
Insert into web_menu (unitid, menu, ext1, ext2, ext3) Select ID, 'Resource integration website> key fields ', 0, '',''
In MySQL InnoDB, there is still a long time-consuming problem after the recovery fault. The original reasons are as follows:
When a fault occurs and the service is restarted, the recovery operation is automatically completed to restore the database
Even in Win2000, MySQL 4 databases are always worried about upgrading to 4. 1. If there is a problem, phpMyAdmin 2 is used. 7. Export and import the dataMySQL 4. 1, Chinese characters are garbled, so I had to put MySQL 4.1. Change the INI encoding
Summary of Permissions
1. Create an accountGrant all privileges on *. * To Z1 @ localhost;*. * Indicates that you have permissions on all the local databases and tables. You can change the permission to on test. user, and you have permissions on
The high-performance MySQL book has been downloaded from the computer for almost half a year and has no time to read it. In the end, I decided to spend some time reading this book every day in March. Here I will record some knowledge points in this
Unique query for a single table: distinct
Unique query for multiple tables: group
When distinct queries multiple tables, left join is still valid and full join is invalid,
When using MySQL, you sometimes need to query records with unique fields.
Mysqli in mysql5 is indeed worth using and learning carefully. Today I will look at some of the new
Features. For example, the preparestament support is added. The example is as follows (from the apress book)
// Create a new server connection
$
In some cases, MySQL can directly use indexes to meetORDER BYOrGROUP BYClause without additional sorting.
AlthoughORDER BYThe index is not exactly matched with the order of the index, but can still be used, as long as the unused index part and all
1. MySQL Common commands
Show databases; list all databases
Create Database Name; Create a database
Use databasename; select database
Drop database name directly deletes the database, no reminder
Show tables; displays tables
Describe tablename;
Recently, many problems have been encountered with the use of MySQL. Who asked the old man to have a bunch of DBAs? I didn't care about it. I just used gepi myself. Please advise.
1. Potholes repair
For online machines, the configuration should be
Install PHP + MySQL + phpMyAdmin Apache in Windows (post)
PHP installation (directly decompress the version)
1. decompress the file to the disk you want to install,
Generally, we install it in the system disk directory. Change the directory name to
Background
The InnoDB Storage engine of MySQL (5.0) is used to store two tables. The data size of one table is about 20 million rows, and that of the other table is less than 10 million rows. Select and update operations are mostly performed, and
Returns the week index of date (0 = Monday, 1 = Tuesday ,...... 6 = Sunday ). Mysql> select weekday ('2017-10-04 22:23:00 ');-> 5 mysql> select weekday ('2017-11-05');-> 2 dayofmonth (date) returns the date of a month in the range of 1 to 31. Mysql>
Someone in the Group raised the following question today:"Table T (A, B, C, D), how to display the-30 records after sorting by C. (A, B, C, D) may not have attributes similar to ID"
The answer I gave at the time was:Select * from t order by c Where
MySQL replication is a simple and common database load balancing method.
Here we record the specific process of Environment setup:
Environment: Two Ubuntu instances, one master instance and one slave instance.
MASTER: ubuntub (192.168.1.101)
SLAVE:
According to a lot of information on the Internet, replacing glibc's malloc with tcmalloc in Google-perftools can greatly improve the performance of MySQL in high concurrency. As mentioned in these documents, there are two ways to make tcmalloc take
The following example uses the specified value starting from 1000.
1. Set it when creating a table:
Create Table 'test '(
'Id' int (11) not null auto_increment,
'Class' varchar (2) not null,
'Name' varchar (50) not null,
'Sex 'varchar (2) not
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