Course Intermediate 4570
Course Introduction:MySQL installation and configuration under Linux, database logical layering, parsing process, index, detailed analysis of SQL execution plan, principles to avoid index failure, optimization cases, common optimization strategies, slow SQL troubleshooting, simulation of massive data, lock mechanism, MySQL under windows and linux Master-slave replication.
Course Intermediate 10224
Course Introduction:"LNMP Production Environment Optimization and LVS Cluster Video Tutorial" LNMP refers to a one-click installation package for Nginx, PHP, MySQL, phpMyAdmin, and eAccelerator written based on CentOS/Debian. The LNMP production environment can be easily installed on VPS or independent hosts.
Course Intermediate 10917
Course Introduction:MySQL course ceiling: explanation of 6 major paradigms, 7 major log analysis, 7 major SQL performance analysis tools, 9 major storage engine analysis, 10 major categories and 30 sub-categories of optimization scenarios, 15 application explanations of different locks, 18 rules for creating indexes , 300+ high-definition and uncensored technical analysis pictures...
Course Intermediate 6942
Course Introduction:How to tune SQL according to execution plan under massive data? How does the mysql index system cope with massive data storage? How to design a mysql index with excellent performance under massive data Full analysis of clustered index and non-clustered index of mysql Must-ask nouns in mysql index interview: table return, index coverage, leftmost matching How to optimize indexes for specific SQL scenarios
Course Intermediate 11340
Course Introduction:"Self-study IT Network Linux Load Balancing Video Tutorial" mainly implements Linux load balancing by performing script operations on web, lvs and Linux under nagin.
php website speed optimization
2021-07-27 18:06:26 0 1 1131
mysql optimization - How to optimize mysql count(id) query speed?
2017-05-18 10:51:05 0 7 962
c# - mysql query optimization?
2017-05-18 10:51:56 0 5 756
mysql - sql statement optimization issues
2017-06-14 10:50:39 0 4 1052
Course Introduction:In embedded products, system startup speed is a key indicator. Optimizing system startup speed is usually called "quick start". To optimize the system startup speed, you must first know how to count the system startup time. The following introduces several methods for counting kernel startup time, as well as several methods for optimizing kernel startup speed.
2023-07-31 comment 0 1597
Course Introduction:The access and opening speed of a website is very important, especially the slow opening and loading of the homepage is fatal. This article introduces a practical case on php website performance optimization: Taobao homepage loading speed optimization practice.
2017-03-18 comment 5 5189
Course Introduction:Many friends have reported that their Internet speed is not enough or the Internet speed is limited when using win7 system. After eliminating problems with the router and network operator, you can optimize the Internet speed by disabling relevant settings. Let’s take a look at the specific methods below. Win7 network speed optimization tutorial 1. First, we open the "Control Panel" through the Start menu 2. Find the "Network and Sharing Center" 3. Click "Change Adapter Settings" on the left 4. Right-click the network you are connecting to and click "Properties" ” 5. Click “Configure”, as shown in the figure. 6. Find "Flow Control" in the property bar and change its value to "Disabled".
2024-01-08 comment 0 1150
Course Introduction:This time I bring you the InstantClick plug-in for optimizing page loading speed. What are the precautions for using the InstantClick plug-in for optimizing page loading speed? The following is a practical case, let’s take a look.
2018-04-17 comment 0 1835