Warning: mysqli_query(): MySQL server has gone away in /home/wwwroot/syntaxbug.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): Error reading result set's header in /home/wwwroot/syntaxbug.com/wp-includes/wp-db.php on line 1924
performance – SyntaxBug

Linux performance optimization using Tuned configuration optimization solution

Write in front Organizing notes related to exams The blog post covers a simple understanding of Linux tuned tuning tools A brief description of tuning configuration files and an introduction to custom tuning solutions If you don’t understand enough, please help me correct it. There is only one true responsibility for everyone: to find themselves. […]

Thoughts on MySQL optimization two [Performance analysis tools, optimization principles]

In actual work, we inevitably need to analyze and optimize SQL predictions. Today we will take a look at the relevant content: SQL performance analysis SQL optimization principles 1 SQL performance analysis Performance analysis of SQL mainly includes: View slow SQL View through profile details explain execution plan 1.1 View slow SQL SQL execution frequency […]

Explosive performance! Python multi-process mode implements multi-core CPU parallel computing

Article directory Preface 1. Multi-process mode in Python 2. Methods to improve program execution efficiency 1. Multiple processes execute tasks concurrently 2. Process pool 3.Message queue 4. Shared memory 5.Asynchronous IO Summarize About Python technical reserves 1. Learning routes in all directions of Python 2. Python basic learning video 3. Excellent Python learning books 4. […]

Android performance optimization – startup optimization improved by 60%

Application startup speed The startup speed of an application can affect the user’s first experience. An application with a slow startup speed (perceptually) may cause the user to decrease the intention to open the app again, or uninstall and abandon the application. This article will optimize the application startup speed from two directions: 1. Visual […]

Storage structure and query performance optimization of ClickHouse primary key index

Table of Contents Storage structure and query performance optimization of ClickHouse primary key index 1. Storage structure of primary key index 2. Query performance optimization methods 2.1. Use primary key index table 2.2. Column storage and data compression 2.3. Merge engine (MergeTree) 2.4. Data copy in conclusion Sample code: Use ClickHouse for e-commerce sales data […]

Android Performance Optimization Series App Startup Optimization

The slow startup speed of applications is a problem we often encounter during the development process, such as black screen and white screen problems caused by slow startup. This blog will introduce the relevant knowledge of App startup optimization. How to launch the app Generally speaking, there are two starting methods: cold start and hot […]

A front-end performance optimization – performance score from 56 to 96

Big factory technology advanced front-end Node advanced Click above for Programmer Growth Guide and follow the official account Reply 1, join the advanced Node communication group Author:NewName https://juejin.cn/post/7273072756156235834 I recently read an article on front-end performance optimization. I had never done any performance optimization before, so I just studied it. If you want to optimize […]