PHP Full Stack Learning Notes 4
PHP and JavaScript, master JavaScript foundation, custom functions, process control statements, events, call JavaScript scripts, use JavaScript in PHP.
JavaScript, developed by Netscape, is an interpreted scripting language based on object and event driven and with security performance.
JavaScript Foundation, Data Types, Variables, Annotatio ...
Added by wiggly81 on Thu, 16 May 2019 00:18:55 +0300
Internet Lightweight Framework SSM - Day 8 (MyBatis Plug-in Plug-in Use and Principles)
Brief: The eighth day was recorded today (only eight days were written).Sometimes I see more, sometimes I see less, and then I save a few days to write together.Today, I wrote this plugin for an afternoon yesterday. I went back after work. I ended it today and added a process diagram to help understand the following principles.I have been readi ...
Added by tmaiden on Wed, 15 May 2019 23:32:20 +0300
General database role privilege handling in SQL Server
General database role privilege handling in SQL Server Recently, we have been doing database privilege cleanup with colleagues, mainly by deleting some accounts, removing the larger privileges of some accounts, etc. For example, some have db_owner privileges, we remove the database role db_owner of the accounts and grant the minimum required ...
Added by Karpathos on Wed, 15 May 2019 18:59:55 +0300
Learn JAVA 20th day, contact exception handling, customize exception
1.java.lang.NullPointerException (Runtime Exception) is a runtime exception that the compiler cannot predict, such as when you define a Reference variable String a, but you did not instantiate the variable with the new keyword.
There are two solutions to this null pointer exception, because you call this a's method againif(null!=a) this variabl ...
Added by ypirc on Wed, 15 May 2019 13:47:55 +0300
PostgreSQL page inspect diagnoses and optimizes the query performance degradation caused by the delay of GIN (inverted) index merging
Label
PostgreSQL, brin index, gin index, merge delay, gin_pending_list_limit, query performance degradation
background
GIN index is an inverted index of PostgreSQL database with multi-value type. A record may involve KEY in multiple GIN indexes. So if index is merged in real time when writing, IO will increase sharply and RT will increase in ...
Added by hatching on Wed, 15 May 2019 09:30:25 +0300
InnoDB Engine B+Tree Index Usage and New Features
We've already talked about it Principle and algorithm of MySQL InnoDB index Here's how to manage and use B+tree indexes and some new features.
Management of B+Tree Index
The basic indexes we use in the InnoDB engine are B+tree indexes.
Create and delete indexes
It can be created and deleted in two ways:
# Mode 1: alter table, in which case bot ...
Added by ehhwan on Wed, 15 May 2019 05:12:03 +0300
Competition for Cache Buffers Chain Latch
Oracle Kernel Technology Disclosure_Lv Haibo's Learning Notes
When Cache Buffers Chain(CBC) Latch is competing, there are two main situations:
1. Multiple incompatible processes apply for the same CBC Latch to access different Buffer Headers (BH) of different chain lists protected by this CBC Latch, which is called hot chain c ...
Added by PHP Monkeh on Tue, 14 May 2019 18:13:35 +0300
MySql and Pytnon Interaction
Introducing modules into files
import Mysqldb
Connection object
Used to establish connection with database
Create object: call connect() method
Conn = connect (parameter list)
Parameter host: connected mysql host, if the local host is'localhost'
Parametric port: The port of the mysql host connected by default is 330 ...
Added by jwoo on Tue, 14 May 2019 16:37:38 +0300
PostgreSQL 11.1 trillion tpcb performance test on Aliyun ECS + ESSD + zfs/lvm2 strip + block_size=32K
Label
PostgreSQL, pgbench, tpcb, tpcc, tpch, lvm2, zfs, bands
background
Several recent PostgreSQL OLTP and OLAP tests:
PostgreSQL 11 tpcc Test (103,000 tpmC on ECS) - use sysbench-tpcc by Percona-Lab
(TPC-H test SF=10,SF=200) PostgreSQL 11 vs 10 vs Deepgreen
PostgreSQL 10 billion tpcb performance on ECS
PostgreSQL on Aliyun ECS + ESSD - 100 ...
Added by stanleycwb on Tue, 14 May 2019 14:43:51 +0300
Database System Experiment 4: SQL-SELECT Query Operation
Database System Experiment 4: SQL Language-SELECT Query Operation
Database System Experiment 4: SQL Language-SELECT Query Operation
Experimental environment
Experimental content
Steps and processes
First create the jxgl database for testing by following SQL statements
Use SQL statements to express the following queries
...
Added by nalleyp23 on Sun, 12 May 2019 13:43:12 +0300