NAV: SLTechnology News&Howtos > Database >

• 

  How to deal with the problem of full mysql / tmp directory

  I suddenly received a zabbix alarm saying that the / directory disk space of the mysql server was insufficient. Log in to the server, look at the root directory where you found 100GB, and use almost 90GB. There is only one MySQL running on this server, which should not be caused by other reasons such as the log not being cleaned up.

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

  Deploy MariaDB server

  This example requires that the MariaDB database server be deployed on the CentOS 7 virtual machine to complete the following tasks: 1) install the mariadb-server and mariadb software packages; 2) start the mariadb service, and set the boot self-boot, confirm the service status 3) set the

  2022-06-01 13:36:22 Views: 290
• 

  Figure introduction of database Neo4j and installation and deployment

  Neo4j is the leader of today's market graph database. It has enterprise-level functions such as scalability and high availability, and is the best choice to meet our needs. What kind of problems does the graph database solve? Why choose Neo4j? Relational database can not handle relational NoSQL database very well.

  2022-06-01 13:36:08 Views: 211
• 

  Kubernetes 1.5 deploy sonarqube

  In the previous blog posts, we have been talking about the installation and deployment of the basic environment of kubernetes. After the deployment of the underlying environment, we began to try to use kubernetes to manage our application. This blog post uses a simple example to show you how to use depl

  2022-06-01 13:36:04 Views: 264
• 

  Centos6.5 + Oracle 11g R2 + nfs to build RAC environment II

  Enter the scan name in hosts: rac-scan adds the hostname of the rac2 node, the virtual ip name defaults after the next step until the installation pop-up prompt is completed, press the prompt to run the script, and press OK to ignore the last item.

  2022-06-01 13:35:45 Views: 228
• 

  02 oracle create users and authorizations

  1.Oracle default users can access the Oracle database only with legitimate user accounts. Oracle has several default database users 2. 0. To connect to the Oracle database, you need to create a user account and each user has one

  2022-06-01 13:35:34 Views: 228
• 

  Oracle11g startup error ORA-00845: MEMORY_TARGET not supported on this system error resolution

  ORA-00845: MEMORY_TARGET not supported on this system error reporting solution Oracle startup error reporting ORA-00845: MEMORY_TARGET not supp

  2022-06-01 13:35:27 Views: 251
• 

  View comments for a table or row

  There are many tables in the database, and each table has comments, but if it is a bit troublesome to look at one by one, you might as well try the following table. Select * from user_tab_comments;select * from user_col

  2022-06-01 13:35:27 Views: 210
• 

  Kali rolling's metasploit opens a database connection!

  The latest version of kali rolling has been released, using the debian kernel, with timely updates! But its built-in metasploit uses the metasploit-framework version! It's not the same as before. "bt5.

  2022-06-01 13:35:18 Views: 227
• 

  Experience of first contact with oracle database and suse system

  It took two days to build oracle for the first time. Experienced too many difficulties, so make some summary, experience: because the installation was not successful many times yesterday, so today, before deployment, we first summarized the problems that occurred yesterday, and made some corresponding measures in advance.

  2022-06-01 13:35:18 Views: 290
• 

  Oracle 12c turn off statistics collection and enable statistics collection

  Oracle 12c turn off statistics collection and enable statistics collection-- turn off statistics col client_name for a60select client_name,status from DBA_AUTOTA

  2022-06-01 13:35:17 Views: 298
• 

  Oracle series: (4) Oracle preparatory knowledge 2

  1. Ordinary users use the password command to change the new password for the scott username, starting with a letter, but advocate the use of the old tigerpassword password: tiger new password: abc123 re-enter the new password: abc1232,

  2022-06-01 13:35:09 Views: 217
• 

  [monitoring] Grafana panel modification record

  Modify the host board update dashboard set data = replace (data,'$host','$ip') update dashboard set data = replace (dat

  2022-06-01 13:35:09 Views: 233
• 

  Mysql master-slave replication skips replication error

  Skip replication error mysql because of binlog mechanism problems, sometimes there will be failures to replay sql from the library, especially in the old STATEMENT schema (because of functions and stored procedures, etc.), which is why the emphasis is placed on the use of mixe

  2022-06-01 13:35:08 Views: 204
• 

  Oracle 10g silent installation

  # yum-y install autoconf automake binutils-devel bison cpp dos2unix ftp gcc gcc-c++ lrzsz python-dev

  2022-06-01 13:35:08 Views: 277
• 

  Installation of walle Automation deployment platform

  The blog address is http://www.gergw.topWalle-Wall-E is an online deployment system that supports svn, git, multi-user, multi-project and multi-environment deployment at the same time. Compared with jenkins, its project configuration is simpler, rollback is faster, and permissions are divided.

  2022-06-01 13:35:08 Views: 275
• 

  How to download and install the latest version of OPatch

  1. Log in to the mos site to download the latest version of the OPatch patch. Here, take the p6880880_102000_Linux-x86-64.zip patch as an example. Https://updates.oracle.com/downloa

  2022-06-01 13:35:05 Views: 229
• 

  Redis transaction parsing

  The 1.redis transaction related command MULTI:MULTI command is used to open a redis transaction. MULTI changes the client executing the command from a non-transactional state to a transactional state, and the return value of this command is always OK. The EXEC:EXEC command is used to execute a transaction

  2022-06-01 13:35:04 Views: 272
• 

  Data dictionary

  SYS@newtest > alter pluggable database clonepdb_plug open; plug-in database has changed. SYS@newtest > show pdbsCON_ID CON_NA

  2022-06-01 13:34:45 Views: 229
• 

  Memcached walkthrough (4) using apache+memcached-session-manager+tomcat clustering (continued)

  Memcached walkthrough (4) uses apache+memcached-session-manager+tomcat clustering, and there are some problems. List of questions 1:2 tomcat nodes, apache,memcache

  2022-06-01 13:34:41 Views: 255