Java single application - Architecture Mode - 03. Design mode - 16. Interpreter mode

Original address: http://www.work100.net/training/monolithic-architecture-design-patterns-interpreter-pattern.htmlMore tutorials: Beam cloud - free course Interpreter mode Serial number Chapter in text video 1 Summary - 2 Realization - Please refer to the navigation above for reading 1. overview Interpreter Pattern provides a way to ...

Posted by tlavelle on Fri, 13 Mar 2020 11:25:34 +0100

Spark SQL -- spark SQL performance optimization

Article directory 1. Cache table data in memory 2. Parameter optimization 1. Cache table data in memory Performance tuning is mainly about putting data into memory. Caching data in memory can improve performance by directly reading the value of memory. In RDD, use rdd.cache or rdd.persist to cac ...

Posted by abgoosht on Fri, 13 Mar 2020 08:27:46 +0100

Why not create a column with ANSI? Padding set to OFF?

SQL Prompt is a practical SQL syntax prompt tool. It searches automatically according to the object name, syntax and code fragment of the database, and provides users with appropriate code selection. Automatic script settings make code easy to read - especially useful when developers are not familiar with scripts. This article describes not to ...

Posted by MrXander on Thu, 12 Mar 2020 13:13:27 +0100

Read the summary of chapter 11.3.2 The CHAR and VARCHAR Types in the official MySQL 5.7 document

Author: Wei Xinping, the 5th MySQL practical class student of zhishutang, the 10th MySQL optimization class student, now works as a teaching assistant. Maximum length of varchar(n) and char(n) I believe that as a dba, it is often asked this question. What is the maximum length. How many bytes or how many characters. In fact, this is not very ...

Posted by Andre_Ng on Wed, 11 Mar 2020 12:59:35 +0100

Build mysql NDB cluster

NDB cluster installation introduce https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-basics.html NDBCLUSTER (also known as NDB )Is a memory storage engine that provides high availability and data persistence. Of NDBCLUSTER The storage engine can be configured with a range of failover and load balancing options, but the simplest is to start ...

Posted by al3x8730 on Wed, 11 Mar 2020 10:41:43 +0100

Module 3, week 2, assignment 2, bidding website

1 problem description Using the Scrapy framework, complete the collection of bidding information on the Internet. The collection fields are as follows: 2 Tips for problem solving Some pages of the Internet must be logged in to get response. You need to log in manually and get the Cookie value in t ...

Posted by redmonkey on Tue, 10 Mar 2020 11:21:39 +0100

Notes on mysql special commands

1, Connect to database Do not use database management software (such as Navicat, etc.), connect mysql server through dos, and then operate database General format for connecting to database: mysql -P port number - h mysql host name or ip address - u user name - p Explanation: (- P upper case P represe ...

Posted by Michael001 on Thu, 05 Mar 2020 07:45:26 +0100

The pit I stepped on when I learned Java in those years

All the way to learn Java is like stepping on a hole. Come and let's count my blood and tears over the years Rookie stage, spend almost every day on thunder... First: the database table field cannot use sql field, and a 500 error will be reported. For example, the order will report an error when select ing. Second: when using int type for ...

Posted by Fergusfer on Wed, 04 Mar 2020 10:51:00 +0100

8. Adding Paging Extensions to DAO

Why extend DAO?In the previous section, I mentioned that the DAO generated by jOOQ has some basic CRID methods, as well as some query methods for each field.However, these methods are relatively simple and based on a single field to query, which is not enough to face complex business scenarios. For ...

Posted by Adthegreat on Wed, 04 Mar 2020 02:30:17 +0100

shell script to export remote mysql database table data to local

Script function Brief 1. Export remote mysql database table data to local and save as file 2. Support the configuration of table information to be exported to the configuration file. The script will cycle the configuration file and parse the configuration file, and then complete the subsequent data export. 3. Incremental export by time is ...

Posted by DJP1986 on Tue, 03 Mar 2020 09:58:27 +0100