NAV: SLTechnology News&Howtos > Database >

• 

  Start the installation-free version of mysql with configuration under Windows

  First, download the Zip version of the installation-free version of Mysql, and extract the installation directory below, add the Bin directory of Mysql to the Path of Windows, so that commands such as mysql can be accessed. * when you encounter a strange problem, add my to the path of win10

  2022-06-01 09:40:13 Views: 290
• 

  Mysql syntax specification

  1. Case insensitive 2. Some statements can indent newlines, such as select * from hello. 3. Single-line comments: + comment content-- + (space) + comment content 4. Multi-line comment: / /

  2022-06-01 09:40:13 Views: 203
• 

  Problems caused by mongodb indexing

  Indexing is a problem that can easily lead to long-term write locks. MongoDB needs to occupy a write lock when building indexes in the foreground (and will not give up temporarily). If the amount of data in the collection is large, indexing usually takes a long time, which is especially easy to cause problems. The solution is simple, Mong.

  2022-06-01 09:40:13 Views: 238
• 

  Practice of automatic read-write Separation of Database Middleware ProxySQL

  Reference documentation https://github.com/sysown/proxysqlhttp://www.fordba.com/mysql_proxysql_rw_split.htmlhttps://www.

  2022-06-01 09:40:12 Views: 279
• 

  Oracle expdp logic export and different machine recovery

  1. Environment platform version A: Linux RHEL 5.8 X64Oracle 11.2.0.3 x64 single instance OralB: Win2003 X32Oracle 11.2.0.1 X32 single instance oral belt only

  2022-06-01 09:40:06 Views: 291
• 

  Mysql rebuilds a user account (ERROR 1396 (HY00)

  Note: after deleting the user molewan in MariaDB, the business needs to re-establish a user named molewan. Check the database and find that there are no molewan users MariaDB [mysql] > select us.

  2022-06-01 09:40:06 Views: 268
• 

  Oracle online open course "Egg fried rice, the simplest and most difficult-- my understanding of Oracle addition, deletion, modification and query is different from yours."

  On April 18, 2014, when "Tip of the tongue 2" began to air (exactly three months before this online course), foodies prepared early, and even a certain Bing Bing posted this Weibo: "it is said that you can't turn on the TV until you have enough to eat tonight." China on the tip of the tongue, a major killer, is showing up. Hey, hey, I've got it.

  2022-06-01 09:40:03 Views: 219
• 

  Analysis of binlog and internal XA transaction commit process from an online problem

  1. A new order record is added to the problem business. After receiving the MySQL slave data message pulled by BinLake, the user will immediately query the same MySQL slave database according to the order number in the message, and find that sometimes the data cannot be found, waiting for about 500ms~1000m

  2022-06-01 09:39:59 Views: 264
• 

  The usage of between in the condition of sql statement

  There is a demand in today's re-development, and we need to investigate and deal with the data from a certain day in a certain year to a certain day in a certain year. Seeing that between was useful in the framework before, I used it decisively today! It works well! Implementation code: $where. = "start_time"

  2022-06-01 09:39:41 Views: 235
• 

  Backup and restore system database of SQL Server

  System database is a necessary database for managing and maintaining SQL Server, and it is very important for the operation of server instances. After a large number of updates, multiple system databases, including master, model and msdb, must be backed up. If you back up these system databases, you can

  2022-06-01 09:39:41 Views: 233
• 

  About the database client server

  The server, of course, provides oracle database services, as well as listening services, which are used to receive client connections. The client provides a set of tools, including library files and header files used for development, similar to client sdk in informix, or some practical workers.

  2022-06-01 09:39:41 Views: 287
• 

  Correctly understand the options related to SQL Server configuration timeout

  Correctly understand the settings of SQL Server configuration options "remote login timeout" and "remote query timeout" View configuration options sp_configure remote login timeout reference: https:/

  2022-06-01 09:39:35 Views: 234
• 

  The company's practical Replica Sets+Sharding solution

  The company's actual combat Replica Sets+Sharding solution company mongo cluster actual combat preparation of nine servers, slicing 172.16.0.124 11731 master 172.16.0.127.11731 standby 172.16.

  2022-06-01 09:39:18 Views: 212
• 

  Learn Redis Cluster and set up clusters manually

  Redis Cluster uses virtual slot partition, and all keys are mapped to the integer slot of 0,16383 according to the hash function. The calculation formula: slot=CRC16 (key) & 16383. Slot is the basic unit of data management and migration in the cluster. The main ones that use large-scale grooves

  2022-06-01 09:39:18 Views: 277
• 

  Mysql Learning Notes (4-General binary format installation MariaDB)

  Installation and use of MariaDB: installation method: (1) rpm package; (a) provided by the publisher of OS; (b) official provision of the program; (2) source package; (3) package in common binary format; installation in general binary format MariaDB: (1) number of preparations

  2022-06-01 09:39:18 Views: 275
• 

  MySQL-- stored procedure

  Define a complex logic for batch processing of SQL statements, create a delimiter / / modification Terminator through a name store-- the stored procedure does not return the value delimiter / /-put the Terminator; modify it to / / create pr

  2022-06-01 09:39:18 Views: 293
• 

  SQL Server 2017 AlwaysOn on Linux configuration and maintenance (11)

  2.4 AG failover in the context of AG, the exchange process between the primary and secondary roles of an available copy is called a failover. There are three forms of failover: automatic failover (no data loss) scheduled manual failover (no data loss) forced manual failover (may be lost

  2022-06-01 09:39:18 Views: 269
• 

  [MySQL] piecemeal knowledge collection

  Learning bits and pieces of knowledge always feels like a bear breaking sticks and forgetting one by one. Write a post and collect it, and wait until the outline is strung together. For the optimization of 1.limit paging, the simplest way can be used directly within 100. if it is too large, you can first find out the id and then associate it with Join.

  2022-06-01 09:39:17 Views: 264
• 

  Mysql multi-instance installation

  [root@mysqlserver] # rm-f / etc/init.d/mysqld [root@mysqlserver ~] # mkdir-p / data/ {3306 3307} / data [r

  2022-06-01 09:39:17 Views: 241
• 

  Instance and Thread thinking in the process of starting Database by Oracle

  In the early days of using Linux, I only glanced at the Oracle listening status and port. I didn't read the content carefully and it was also an English hint. After a few years, I picked up CMD again under Oracle,Windos to check the listening status and found a lot of interesting problems, Oracle instances and lines.

  2022-06-01 09:39:17 Views: 248