This article mainly introduces the summary of practical commands for using percona-toolkit to operate MySQL. percona-toolkit is a powerful MySQL auxiliary tool. For more information, see
1.pt-archiverFunction introduction:
Archive the records of tables in the mysql database to another table or file
Usage:
Pt-archiver [OPTION...] -- source DSN -- where WHERE
This tool only archives old data and does not significantly affect OLTP query of online data. y
click "OK ".7. Click "OK" to add the filter.
8. Restart iis.
9. After iis is restarted, right-click the site and choose properties. The Green Arrow shown below indicates that iis rewrite is successfully added and run.
Iis rewrite rule settings
In the decompressed iis rewrite component directory (such as c: rewrite), there is an httpd. ini file that writes the corresponding rules to this file.
1. Install the rewrite plug-in rewrite. dll
If your iis server has loaded rewrite. dll, you do not nee
*archiver = [[[Nskeyedarchiver Alloc] Initforwritingwithmutabledata:data] autorelease];
Starts archiving the object, and the archived data is stored in the Nsmutabledata
[archiver encodeobject:person1 forkey:@ "Person1"];
[Archiver encodeobject:person2 forkey:@ "Person2"];
Archive complete (make sure to call this method)
[Ar
file /usr/local/mysql/data/mysql/rh55.pid ended 150610 17:04:36 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/mysql /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist 150610 17:04:36 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 150610 17:04:36 InnoDB: The InnoDB memory heap is disabled 150610 17:04:36 InnoDB: Mutexes and rw_locks use InnoDB's own implementation 150610 17:04:36 InnoDB: Compressed tables use zl
I. SeagateSeagate Technology Corporation (Seagate Technology) is a veteran brand in the hard disk world, and the vast majority of users are already familiar with it. As the world's largest disk drive, disk and read-write head manufacturer, the company is always a ibm,compaq,sony and other industry major hard disk suppliers, the company's strength is evident! Seagate is one of the first hard drive brands to enter the Chinese market and has a significant role in the SCSI market. There are currentl
actual stored string length (bytes). If the maximum length of a column is less than 256 bytes, it is represented (identified) in a single byte. If the maximum length is greater than or equal to 256, two bytes are used.
When the character set selected is Latin1, a character occupies a byte
varchar (255) stores a character that stores the actual data length and data values of the data using a 2bytes physical space.
VARCHAR (256) stores a character and uses 2bytes to represent the actual data leng
dir settings may also cause 1067 system errors.
# Basic system directory
Basedir = C:/srv/mysql-5.5.19# User data directory
Datadir = E:/myWeb/mysql5data/data
E it.
Paste the error log:140707 11:37:55 InnoDB: Starting shutdown...140707 11:37:55 InnoDB: Shutdown completed; log sequence number 1595675140707 11:37:55 [Note] D: \ MySQL 5.5.38 \ bin \ mysqld: Shutdown complete140707 11:40:27 [Note] Plugin 'federated 'is disabled.140707 11:40:27 InnoDB: The InnoDB memory heap is disabled140707 11:
change the default storage engine to InnoDB and change the default file format to Barracuda. You also need to set innodb_file_per_table so that Barracuda works properly.In the terminal, enter:
sudo vim/etc/mysql/mysql.conf.d/mysqld.cnf # Use Vim to edit the MySQL configuration document, or you can open it with VI.
In the newly opened document, locate the "mysqld" summary and add the following
balancing (AD) and wide-area global server load Balancing (ad-global) for server load balancing applications. Its unit price is relatively inexpensive, and has a high level of scalability and intelligent services. It also has network monitoring and detection functions, global load balancing and mitigation of certain DDoS attacks.In addition, Radware equipment has some features is relatively easy to update and upgrade, can sense the application services, intelligent is one of its propaganda conc
less than 256 bytes, it is represented by a byte (identity). If the maximum length is greater than or equal to 256, use two bytes.
When the selected character set is Latin1, a character occupies a byte
varchar (255) stores one character, using a total of 2 bytes physical spaces to store the actual data length and data values of the data.
VARCHAR (256) stores one character, using 2 bytes to represent the actual data length, which requires 3 bytes physical storage space.
varchar for different RDB
-spam Solutions has become a security issue that TCL is anxious to solve.
Group has tried a lot of products, but the implementation of the group in the effect is not ideal. And the company is hesitant to use software or hardware solutions.
Way to solve:
The company is designed for large enterprises to provide spam solutions manufacturers, although the domestic anti-spam market recently emerged dark horse, but in the world, is already 20,000 users of the industry leader. Its anti-spam technology
redundant and compact two kinds of row_format. Starting from 5.5 or InnoDB1.1, a new file Format,barracuda can be used. The Barracuda is compatible with redundant and supports two row_format of dynamic and compressed.when innodb_file_format=antelope,row_format=redundant or compact. InnoDB's clustered index (cluster index) stores only the first 768 bytes of the varchar, text, and Blob fields, and the extra
Initializat
Ion of Buffer pool 150610 17:04:36 innodb:highest supported file format is Barracuda.
Innodb:log scan progressed past the checkpoint LSN 48961 150610 17:04:36 Innodb:database was wasn't shut down normally!
Innodb:starting crash recovery.
innodb:reading tablespace information from the. ibd files ... innodb:restoring possible Half-written data pAges from the Doublewrite innodb:buffer ... Innodb:doing recovery:scanned up to log sequence numb
innodb:completed Initializat
Ion of Buffer pool 150610 17:04:36 innodb:highest supported file format is Barracuda.
Innodb:log scan progressed past the checkpoint LSN 48961 150610 17:04:36 Innodb:database was wasn't shut down normally!
Innodb:starting crash recovery.
innodb:reading tablespace information from the. ibd files ... innodb:restoring possible Half-written data pAges from the Doublewrite innodb:buffer ... Innodb:doing recovery:scanned up to
Often some netizens send some high-end tens of thousands of tyrants Computer Configuration let the editor to see, many of them have a number of details or fatal problems, today for everyone to organize four sets of tens of thousands of dollars, can be counted on the tyrants level of user Computer Configuration comments, I hope that we can use the deficiencies, learn to extrapolate it.
10350 yuan Intel unique tyrants computer matching reviews
Machine Price "10350 yuan
Accessories name brand Mo
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.