Others

1. Prepare two servers to install the mysql5.7 version separately (previously installed)db1 11.0.0.51db2 11.0.0.52数据目录均为/data/mysql_data备份目录均为/db_all_backup2. Backing up the database using DB1#db1和db2安装以下备份软件：yum install perl-DBD-MySQL perl-devel

Table name Commentsdestoon_404 404 LogsDestoon_ad AdvertisingDestoon_ad_place AD bitDestoon_admin AdministratorDestoon_admin_log Management LogDestoon_alert Trade AlertDestoon_announce NoticeDestoon_area AreaDESTOON_ARTICLE_21

#查看每个数据库占用的空间:Select Table_schema "Database Name", sum (data_length + index_length)/1024/1024 "database Size in MB" from Informatio N_schema. TABLES GROUP by Table_schema;#查看数据库下每个表和索引占用的空间:Select table_name as "Tables", Round (((data_length + index_

First, the function　　1. Version () MySQL Edition2, User () database username3. Database name4, @ @datadir database path5, @ @version_compile_os operating system version6. Current_User () Current user name (viewable permissions)7, Load_file () read

Pictures uploaded to the databaseThe common.php under the appApply Public files * $name The name value for the form upload* $filePath the folder name below uploads/for saving in the Portal folder public, no words will be created automatically*

Differences between LEFT JOIN, right join, inner join in SQL　The LEFT join is returned, including　 Records of all records in the left table and the equivalent of the junction fields in the right table;Right join returns the include Records of

1. Add a piece of data to the database: Alter //Added a field to the table INSERT into table name values (' Bill ', ' Male ')//Add data to the Dspcode,dspsex field added to the table2. Database deletion:-- Deleting a database drop databases

Reference blog:Http://www.jb51.net/article/100211.htmHttps://www.cnblogs.com/wangbaobao/p/7087032.html1.vim /etc/my.cnf2. add in [mysqld]Skip-grant-tablesFor example:[Mysqld]Skip-grant-tablesDatadir=/var/lib/mysqlSocket=/var/lib/mysql/mysql.sock3.

PC configuration: GeForce GTX 1080Installing the GTX1080 DriveGo to the NVIDIA network, download the GTX1080 driver, start the search, and then download the required version. I downloaded the latest 384.130.can also be downloaded here.After the

View the total amount of space used by the current directory#du -h --max-depth=0217M .View the size of the total space used by the current directory and the total amount of files and folders used in the current directorydu -h --max-depth=1#du -h -

(1) Spring is a lightweight control inversion (IoC) and aspect-oriented (AOP) container framework that solves the complexities of enterprise application development and provides a full-fledged framework for Java EE applications, combining multiple

Statement: The material used in this column is written by the VIP students of the Kay Academy, who has the right to be anonymous and has the final right to interpret the article; The Edith Academy is designed to promote students to learn from each

Type of controller parameter binding　　　The controller has 6 types of binding parameters. No parameters (system default type), Simple Type (intager,double), Pojo Class (object), array, set, HashMap, etc.We use an example to express it in code:Users

What is a thread pool(1) When the blogger hears the thread pool three words the first idea is the database connection pool, recall, we are learning javaweb how to understand the database connection pool, the database to create the connection and

Process: A program in progress. is actually the memory allocation space when an application runs.Threads: A program execution control unit in a process, an execution path. The process is responsible for the identity of the space of the application,

If you create a Spring projectSpring MVC Framework in Java Web project should be no one knows, you do not build a Spring framework? As a just learning Java I will, if you do not, that is really sad.1. After you create a project in MyEclipse, you can

With the further development of JS and the requirement of real project performance, the simple implementation of the algorithm can not meet the need, and the time complexity is very important in different application scenarios.The first is to create

1. How to sell tickets classTicketrest {intTicket =1; intMax =0; PublicTicketrest (intmax) {Max=Max; } /// ///not locked/// /// Public voidSellticketnolock (intnum) { while(Ticket Max) {

As we all know, Rt.jar is a heavyweight file in the standard JRE, which not only contains the files on which the Java application is run, but is also very large, even if we just write an entry-level HelloWorld program, and still load the hunk

RSA typically has two scenarios:1, public key encryption, private key decryption: This is the most common situation in the field of data security communication;2, private key verification, public key check: This is mainly used for digital