Tag：data base
-
Navicat connects to MySQL server8 Client does not support authentication protocol requested by server in version 0; The solution is as follows
Navicat connects to MySQL server8 Client does not support authentication protocol requested by server in version 0; The solution is as follows: The command is as follows: 1、use mysql; 2、alter user ‘root’@’localhost’ identified with mysql_native_password by ‘root’; 3、flush privileges; 4、fhadmin.org; ————————————-(www.fhadmin.org)————————————————-Database management29. Database backup: it can backup single table and whole database, and support local […]
-
Introduction to redis Chapter 1 – Introduction to redis
1. General The bottleneck of server software project is generally caused by massive users and high concurrency, and the culprit is relational database. The disadvantages of relational database are as follows: Performance bottleneck: low disk IO performance Expansion bottleneck: complex data relationship, poor scalability, inconvenient and large-scale cluster To solve the bottleneck of disk IO, […]
-
Mysql database reinitialization
preface In our daily development process, we may encounter the situation that various MySQL services cannot be started. When various MySQL services still cannot be solved after Baidu and Google, we can consider reinitializing mysql. Simply put, reset “restore factory settings”. After reset, all data will be cleared and lost, so you must back up […]
-
Operations required for operation and maintenance, introduction to tcaplusdb tcapsvr expansion and contraction
For a game, with the growth of users, the increasing amount of data is inevitable. At this time, the database needs to be expanded. For tcaplusdb, the expansion and contraction of its storage layer tcapsvr is the only way for operation and maintenance, and tcaplusdb provides OMS to facilitate operation and maintenance personnel. Tcapsvr expansion […]
-
Ent ORM note 2 – Schema usage (Part 1)
In the last note about using ent ORM quickly, we started using it againentc init UserCreate a schema. The schema in ENT ORM is actually a database model. In the schema, we can define the field information of the table in the database through fields; Define the relationship information between tables through edges; Define the […]
-
The simple encapsulation of SQL Server batch insert data scheme sqlbulkcopy makes batch insert more convenient
1、 Introduction to SQL Server insertion scheme aboutSqlServerThere are three common insertion methods for batch insertion,Insert、BatchInsert、SqlBulkCopy, let’s compare the speed of the following three schemes 1. OrdinaryInsertInsertion method public static void Insert(IEnumerable persons) { using (var con = new SqlConnection(“Server=.;Database=DemoDataBase;User ID=sa;Password=8888;”)) { con.Open(); foreach (var person in persons) { using (var com = new SqlCommand( […]
-
Technology sharing | how does MySQL shell operate relational tables?
Author: Yang Taotao Senior database expert, specializing in MySQL for more than ten years. He is good at backup and recovery, SQL tuning, monitoring, operation and maintenance, high availability architecture design related to MySQL, PostgreSQL, mongodb and other open source databases. At present, he works in aikesheng, providing MySQL related technical support and MySQL related […]
-
MySQL operation principle [transaction]
The article is “inside MySQL Technology: InnoDB storage engine (Second Edition)”Nuggets brochure “how MySQL works: understanding MySQL from the root”My notes Transaction overview In real life, we all have the following experiences (which is also one of the classic scenes of business): I have no money recently. I need to go to the bank to […]
-
Redis application practice – second kill scenario (node. JS version)
Write in front With the increase of business volume, the company has fully accessed the project in recent monthsRedis, during the development process, it is found that there is a lack of specific practical data on the market, especially inNode.jsIn this environment, the information that can be found is either too simple to get started […]
-
What do you know about MySQL database optimization?
preface On the one hand, database optimization is to find out the bottleneck of the system and improve the efficiencyMysql databaseOn the other hand, reasonable structural design and parameter adjustment are needed to improve the corresponding speed of users, and save system resources as much as possible so that the system can provide greater load […]
-
Django 1.8 official document translation: 2-6-2 integrate the legacy database into Django
Consolidate legacy databases into Django Although Django is best suited for developing new applications, it can also be integrated into legacy databases. Django includes many tools to solve such problems as automatically as possible. This article assumes that you understand the basics of Django, which are mentioned in the tutorial. Once your Django environment is […]
-
Real time data engine series (V): about SQL server and SQL Server CDC
Abstract: among enterprise customers, SQL Server still exudes lasting vitality in the traditional manufacturing industry. The CDC complexity of SQL server is lower than that of Oracle. Therefore, the standard official practice is to directly use this CDC interface for synchronization, but there are also people in the Jianghu who directly read database changes by […]