NAV: SLTechnology News&Howtos > Database >

• 

  [MongoDB] ReadPreference reading preference

  The setting of ReadPreference is only involved in the replica set Replica Set. By default, both reads and writes are executed by Primary nodes, but in the case of write less and read more, we want to separate read and write to share the pressure, so we want to use Sec

  2022-06-01 13:47:37 Views: 238
• 

  Mysqldump backup specifies the mysql database script

  A few days ago, a friend asked to help write a mysql data backup script, so there is the following script to back up the database through the mysqldump command, posted to communicate with you, if you have any questions, please correct, thank you. Realize the function: 1 backup the specified database 2 delete the preparation before the specified number of days

  2022-06-01 13:47:34 Views: 237
• 

  Processing method of erroneous deletion of mysql

  Check whether the binary log function is enabled: show variables like'% bin%';. If log-bin shows that off is not open, add log-bin under [mysqld] in / etc/my.cnf if it is not opened.

  2022-06-01 13:47:34 Views: 237
• 

  The growth path of DBA-the Foundation of mysql Database Service (3)

  Mysql password recovery and setting [root@mysql ~] # grep password / var/log/mysqld.log#mysql initial password randomly generated after startup 2017-12-20T02:36:18

  2022-06-01 13:47:33 Views: 274
• 

  Oracle_RAC downtime and hang analysis process

  Objective: to share the company's db fault handling process, mainly ideas. Description and impact of the incident: at 04: 43 on September 30, 2018, zabbix warned odsdb2 that the database was suspected to be down, and the staff on duty in the engine room could not log in to the database server through the fortress machine, from other machines.

  2022-06-01 13:47:19 Views: 265
• 

  UNDO tablespace usage is too high

  A library maintained recently found that the utilization of undo tablespaces has reached 95%. Automatic extension of undo tablespaces, or new undo tablespaces for switching, can solve this problem. Automatic expansion of undo tablespaces may cause undo not to be freed, undo tablespaces

  2022-06-01 13:47:18 Views: 249
• 

  Get the user table name in the Access database

  The SQL statement is SELECT Name FROM MSysObjects WHERE Type=1 AND Flags=0;, which is not a problem, but execution in the code may cause an error due to permissions: ('42000 permissions, "[420)

  2022-06-01 13:47:12 Views: 242
• 

  The usage of Oracle NVL function

  Today, I studied the process in the database and found that when I used the function NVL, I had a poor memory. I used it before, but I didn't have to forget it for a long time. So I went to check the official usage explanation: http://docs.oracle.com/cd/E11882_01/se

  2022-06-01 13:47:11 Views: 255
• 

  Regular backup and import of oracle database

  PLM project has been officially launched for testing, data management is the top priority, to facilitate fault recovery processing, to avoid data loss. Idea: data export + scheduled backup + data cycle cleaning 1. Copy the exp.exe under the Oracle installation directory bin (you can also set the exp.exe environment

  2022-06-01 13:46:56 Views: 283
• 

  MongoDB monitoring second mongotop

  Mongotop can see how much time the MongoDB instance spends reading or writing data, which provides collection-level statistics, while mongostat provides database-level statistics. Mongotop displays data-related parameters once per second by default. Options are as follows:

  2022-06-01 13:46:55 Views: 287
• 

  Installation and use of SonarQube Code quality Management platform

  About Sonar Sonar is an open source platform for code quality management to manage the quality of source code. Code quality can be detected from seven dimensions in the form of plug-ins, including java,C#,C/C++,PL/SQL,Cobol,JavaScr.

  2022-06-01 13:46:53 Views: 260
• 

  The solution to forgetting the Mysql password

  For the operation and maintenance staff, they are responsible for more and more applications and more databases to manage, so how to solve the problem of forgetting the password of the Mysql Super Admin? We can do this by adding the-- skip-grant-tables parameter to skip the permission table. View Mysq

  2022-06-01 13:46:39 Views: 212
• 

  Ecs uses scripts to install oracle

  ECS minimum configuration: CPU: 2 core memory: 2G data disk: 20g installation script is divided into 4 small versions of oracle11g, download address: http://zy-res.oss-cn-hangzhou-internal.aliy

  2022-06-01 13:46:39 Views: 248
• 

  Database fundamentals-SQL statements

  1. Basic 1. Description: create database Create DATABASE database-name2, description: delete database drop database dbname3, description: backup sql server--- create backup number

  2022-06-01 13:46:38 Views: 279
• 

  Gitlab migration encountered problems with inconsistent versions and unable to import

  At this point, you need to uninstall the gitlab version installed on the current server, download the backup version of gitlab and reinstall it (Tsinghua tuna project has all gitlab versions backed up, download address: https://mirrors.tuna.tsi

  2022-06-01 13:46:38 Views: 281
• 

  My article: JDBC and database

  JDBCJDBC series: (1) connect to the database through JDBC http://lsieun.blog.51cto.com/9210464/1772359JDBC series: (2) use Statement to execute sql statement htt

  2022-06-01 13:46:38 Views: 251
• 

  Uninstall mysql under Linux

  It is relatively easy to uninstall MySQL. First of all, you can check the native MySql installation information and type the following command: rpm-qa | grep-I mysql. If the installation is successful, then the relevant installed MySQL package will appear, of course, in my tortured

  2022-06-01 13:46:37 Views: 212
• 

  The method of connecting Oracle with LINQPad

  The method for LINQPad to connect to Oracle, provided that the project uses Entity Framework to connect to Oracle1. Open LINQPad and select Add connection2. Choose to use Entity Framewo

  2022-06-01 13:46:22 Views: 220
• 

  Mysql query database size

  Check the database size by MariaDB [mysql] > show databases;MariaDB [mysql] > use information_schema; query all database sizes: MariaDB

  2022-06-01 13:45:52 Views: 351
• 

  SqlServer Series Notes-date function

  GETDATE (): gets the current date time DATEADD (datepart, number, date) and calculates the date after the increment. Parameter date is the date to be calculated; parameter number is increment; parameter datepart

  2022-06-01 13:45:52 Views: 248