NAV: SLTechnology News&Howtos > Database >

• 

  Database mariadb of [basic part]

  1. Database installation yum install mariadb.x86_64 mariadb-server.x86_64-y turn off the firewall and close the network port (no outsiders are allowed to access) netstat-antlpe | grep

  2022-06-01 17:05:09 Views: 246
• 

  Common operations of zset

  XVIII. Zset common operation 127.0.0.1 abc 6379 > zadd zset1 1 abc # create ordered set (integer) 1127.0.1 abc 6379 > zadd zset1 10 creation

  2022-06-01 17:05:09 Views: 204
• 

  A probe into the reasons for the continuous restart of the Evmd process

  Customer site environment, national 7-hour 24-hour online system, HP-ux B11.31 for Oracle 10.2.0.4 RAC two-node cluster. The customer made hardware changes at the host level on June 7, and no parameter changes were made to the database. After starting up, I found that

  2022-06-01 17:04:57 Views: 223
• 

  Mysql's method of using regular matching query keywords

  When we query a certain field, sometimes we just want to match a certain piece of data, for example, if we want to query whether all the keywords in this article have a certain keyword, we often need to match. Let's explain how to match a key value SQL fuzzy query syntax is "SELECT c"

  2022-06-01 17:04:51 Views: 229
• 

  Mysql looks at locked tables

  Mysql check locked tables to query whether to lock table show OPEN TABLES where In_use > 0; view all processes MySQL:show processlist;mariabd:show full p

  2022-06-01 17:04:51 Views: 224
• 

  OEL 7.6 RPM installation of oracle atabase19c

  Prepare the installation media: OS: https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/index.htmldatabase:https://www.o

  2022-06-01 17:04:51 Views: 273
• 

  Docker Rapid deployment of sql server 2017 Development Edition

  Is it too troublesome for docker to quickly deploy sql server 2017 Development Edition and install sql server development environment? It can also be built quickly through docker, with a series of instructions. Download SQL Server Managem

  2022-06-01 17:04:51 Views: 211
• 

  Insufficient privileges appears in oracle

  Recently came into contact with ORACLE, the concept of this database is still quite good, in the learning process, encountered a lot of small problems. Perhaps the same hint means different solutions at different levels. When I use create table chem_dict_hell

  2022-06-01 17:04:50 Views: 249
• 

  The case of Oracle Study-- viewing the "strange phenomenon" of shared memory through IPCS

  The case of Oracle Study-looking at the "strange phenomenon" of shared memory through IPCS. In the Oracle 11gR2 environment, when you check the shared memory through the ipcs command, it is found that only 4096Bytes is allocated to Oracle, but in Ora.

  2022-06-01 17:04:47 Views: 273
• 

  Oracle TNS Listener Remote Poisoning test

  The remote data poisoning vulnerability (CVE-2012-1675) allows a user to poison data processed by a remote "TNS Listener" component without providing a username / password. COST is class of secure tran.

  2022-06-01 17:04:47 Views: 295
• 

  Location of warning logs for each version of Oracle

  The name of the warning log for each version of Oracle is: alert_.log in ORACLE10g and before, the BACKGROUND_DUMP_DEST parameter determines the location of the warning log, SQL > show parame

  2022-06-01 17:04:38 Views: 268
• 

  ORA-01045: user ICCS lacks CREATE SESSION privilege; logon denied

  One of the problems encountered when creating oracle users today is to report the following error when connecting to users after creating the user and default tablespace: SQL > conn iccs enter password: ERROR:ORA-01045: user I

  2022-06-01 17:04:38 Views: 248
• 

  Mysql5.6.20 binary installation

  1 copy the 105s / usr/local/mysql to 2. Copy / etc/my.cnf to 3. Mkdir / data/mysql/ {data,tmp,binlog,log}-p4. Initialize rpm

  2022-06-01 17:04:38 Views: 293
• 

  Simultaneous improvement of Postgresql and Elasticsearch data

  Generally speaking, there are two biggest performance problems affecting the database, one is the read and write operation of the database, and the other is the slow operation caused by the large data in the database. For the former, we can reduce some read operations with the help of cache, and some complex report analysis and search can be handed over to hadoo.

  2022-06-01 17:04:38 Views: 259
• 

  Summary of Oracle11gR2 study notes

  Lu Chunli's work notes, who said that programmers should not have literary style? In 2009, I came into contact with Oracle9i. In 2010, I used Oracle10g for my work, and I spent a lot of time seriously using and learning Oracle11g;. It was also due to fate.

  2022-06-01 17:04:37 Views: 242
• 

  Oracle problems with other people using PL\ SQL to connect to your computer

  Today, my colleague could not even connect my computer to life or death, and asked me if the monitoring was on. Finally, it was because the monitoring was not matched. Modify the file G:\ app\ eric\ product\ 11.2.0\ dbhome_1\ NETWORK\ ADMIN\ liste

  2022-06-01 17:04:37 Views: 251
• 

  Redis Notes-String types and Operations (2)

  String type and operation String is a simple type, one Key corresponds to one Value. The String type is binary safe. Redis's String can contain any data, such as jpg pictures or serialized objects Set setting K.

  2022-06-01 17:04:37 Views: 232
• 

  Mongodb Replica Set read-write separation

  Environment: mongodb version: 2.4.6 Magi replica Set requirements: primary is too stressful, expect secondary to share the reading pressure preface from an application point of view, using Replica Set is very similar to using a single mongo.

  2022-06-01 17:04:25 Views: 233
• 

  LAMP Quick installation

  LAMP Quick installation 1. Version introduction linux:CentOS release 6.6 (Final) apache: httpd-2.2.31mysql:mysql-5.5.48php:php-5.3.272

  2022-06-01 17:04:24 Views: 282
• 

  Mysql (4) installation and use of Mysql

  It is constantly updated.

  2022-06-01 17:04:17 Views: 241