MySQL table defragmentation
MySQL table defragmentation
1. Calculate fragment size
2. Defragment
2.1 use the alter table table_name engine = innodb command to organize.
2.2 the PT online schema change tool can also be used to organize table structure and collect fragments online.
2.3 use the optimize table command to defragment.
1. Calculate fragment size
To defra ...
Added by fert on Sun, 05 Jan 2020 02:11:37 +0200
Personal record EventBus
EventBus can transfer data between Activity Fragment Service threads instead of Intent Broadcast Handler
Related knowledge
Four threadmodes
POSTING: the thread in which the post is published and the event processing function is located
MAIN: event handler runs in UI thread
BACKGROUND: if the event is published in the UI th ...
Added by amitvedak on Thu, 02 Jan 2020 05:21:55 +0200
A simple way to realize Android bottom navigation RadioGroup+Fragment
Please indicate: https://mp.csdn.net/mdeditor/82504849
Bottom navigation bar radiogroup + fragemt
1. First, create a new selector file in drawable, right-click new - > drawable resource file in drawable, and create a text color selector [u text] and four other picture selectors [u home] drawable, selector [u phone] drawab ...
Added by kanika on Wed, 01 Jan 2020 08:11:53 +0200
Android uses MVP mode (I)
I studied MVP before, but it didn't work for a long time. Today I watched it again. In fact, MVP is the upgraded version of MVC. MVP includes M-Model-model, V-View-view and C-Controller-controller.
Make a simple example, simple login. First, create a new project and create a layout.
<?xml version="1.0" encoding="utf-8"?> ...
Added by Stickdragon on Tue, 31 Dec 2019 06:19:49 +0200
Android Studio uses ViewPager + Fragment to achieve the effect of sliding menu Tab -- simple version
Description:
I have done a bookkeeping APP before. It is easy to practice. It is developed with Eclipse;
Recently, I want to improve this APP, add some new functions, and choose Android Studio to develop it;
APP has improved a part of it. Now I want to sort out and record the functions that have been done.
Design sketch:
You can slide the men ...
Added by zeth369 on Wed, 25 Dec 2019 18:48:14 +0200
Add toolbar menu to Fragment
This kind of demand is often met in the application:
There are different fragments in an Activity, such as MainActivity. Two different fragments require different toolbar s and menu s.
How to customize Fragment's toolbar?
1. Add toolbar to the xml of fragment;
2. Add setHasOptionsMenu(true) to onCreate method of fragment;
...
Added by amarquis on Tue, 24 Dec 2019 21:17:23 +0200
Hardcore explains Jetpack's life cycle source code
Previous Hard core explains the use of life cycle of Jetpack This paper mainly introduces the significance of life cycle, basic and advanced use methods. Today, I don't want to talk much about it, just start rolling source code.
This article is based on the android_9.0.0_r45 Source code, all relevant source code including comments have been upl ...
Added by jeffwhite on Mon, 23 Dec 2019 23:58:25 +0200
Function operation of Frida usage
Frida interface function introduction
Frida is a so level hook framework, which can help developers and security personnel analyze the so module of the specified process. It mainly provides a Python interface with simple functions and a JS interface with rich functions, which makes hook functions and modified so programmable. The interface incl ...
Added by russ8 on Tue, 10 Dec 2019 19:27:37 +0200
Dry goods, record the troubleshooting process of frequent fgc caused by Metaspace
Recently, a machine on the line gave an alarm after running for more than 10 days, and fgc frequently appeared. After cutting off the traffic, it took the application heapdump file from the operation and maintenance side. At the beginning of fgc, I went to the container platform to check the gc logs, which are as follows:
It can be seen from ...
Added by noisenet on Sun, 08 Dec 2019 20:51:27 +0200
Get started with React 0x014: Fragment
0x001 lead to problems
Let's start with a chestnut:
class App extends React.Component {
render() {
return (
<h1></h1>
<h1></h1>
)
}
}
ReactDom.render(
<App theme='dark'/>,
document.getElementById('app')
)
The render in the chestnut above returns two siblings ...
Added by munuindra on Fri, 06 Dec 2019 06:29:22 +0200