performance mysql

I remember that I wrote MySQLvsNoSQL more than half a year ago, and I have always insisted on using a database to store KV data, because it not only guarantees data security, it is mainly found that the qps of most systems is not that high at all,

Talk about MySql transactions and MySql transactions I have been working on Order projects recently and used transactions. MySql is used for our database, and innoDB is used for the storage engine. innoDB has good support for transactions. In this

Topic: This is something that was recently recorded in high-performance MySqL version 2 ~ # Read locks (shared locks) and write locks (exclusive locks): Read locks are shared and are not blocked. Reading the same resource does not affect each other.

Optimize data batch processing performance and batch processing performance 2014-10-04 BaoXinjian I. Summary PLSQL _ performance optimization series 11_Oracle Bulk Collect There is an overhead for running SQL statements in PL/SQL programs, because

Detailed MySQL optimization solution in 8 GB memoryFor any database management system, memory allocation is definitely one of its core, so many people who want to know more about a database management system, I hope to have a look, and I am no

This configuration was used by the old boy on the production line. During the training, he gave it. Here, I added Chinese characters to the parameters, indicating that the configuration has been optimized, if your mysql has no special circumstances,

This is a piece of SQLselectid, title, and createdatefrom table name, orderbycreatedateasclimit334570, 10. I asked people over there to read the oldest news title and read 10 rows of data. This is a piece of SQLselectid, title, and createdatefrom

Recently, TokuDBv7 was released and the project is hosted on GitHub. TokuDBV7 has the following features: Fast Trickle load, fast batch load, fast query by clustered index range, no fragmentation, full compatibility with MySQLMariaDB, and easy to

Millions of SQL optimization Summary 1: Basic Environment 1: Database: Mysql2: Table Structure 3: data quantity: 500 + 2.1 2: Objective: original SQL statement selectzero_dateline, sum (item_amount) as 'sum' from c_log_item where item_id in (bytes, 1

RT. I want to learn these frameworks before, but after learning a little bit, I find that I cannot learn them. I always feel that I am missing some knowledge. I would like to ask, what kind of knowledge is required to learn these frameworks? How to

I would like to share several methods to improve MYSQL performance, which are not comprehensive enough. I hope you can add them! Please make a picture of the error! 1. database/table sharding Obviously, the unlimited growth of a primary table (that

There are four database isolation levels, as described in the high-performance mysql book: Then let's talk about how to modify the transaction isolation level: 1. Modify the global settings, modify the mysql. ini configuration file, and add Copy

MySql transaction isolation level and lock briefly describes the transaction feature ACID, namely atomicity, consistency, isolation, and durability. Atomicity ensures that a transaction is a minimum unit, and internal non-segmentation consistency

1. MySQL replication (replication) is an asynchronous replication process that replicates data from one MySQLinstace (called Master) to another MySQLinstance (called Slave ). The entire replication operation is mainly completed by three processes,

Introduction to MySQL global shared memory Preface The global shared memory is mainly used by MySQL Instance (mysqld process) and the underlying storage engine to store various global operations and shared temporary information, such as the Query

I mean, what is a connection? If a process connects to mysql and mysql assigns a process to connect to PHP, is this a connection? For example, the maximum number of connections in mysql is 50, does it mean that there are 50 waiters in the restaurant

Method 1: {code ...} method 2: {code ...} I am a beginner, but I still want to ask a question. I thought I did not discuss this case. But recently I found that someone used the second method, internal system, with a low access volume, so there is no

The following articles mainly describe the actual application code of MySQL cache query and the description of MySQL cache query size, fragmentation, cache clearing, and monitoring of MySQL cache query performance, the following is a description of

Basic questionsScene:You have entered a new company.On the first day of work, the receptionist arranged a seat for you and then pulled over a new computer that was not unpacked.After you have connected your computer, press the power ....Well, this

Lbmysqlping (LegendBaseMySQLPing) protocol. Ofcourse, itcouldbeusedtomonitorMySQLserversavailability. Ifsomeserverdown, LBMySQLpingwillrunDowncommandthat Lbmysqlping (LegendBase MySQL Ping) is a tool that does MySQL service availability check for