NAV: SLTechnology News&Howtos > Database >

• 

  MySQL 5.5Compiler and installation cmake parameter description

  -the home directory of DCMAKE_INSTALL_PREFIX=dir_name installation-DDEFAULT_CHARSET character set. The default character set is latin1-DDEFAULT_COLLATION=collatio.

  2022-06-01 06:34:27 Views: 275
• 

  Linux netstat combing at one point

  The preface linux communicates between processes in the same node or between processes in different nodes. The bottom layer uses socket socket, and the running status and related information of various protocols such as tcp,unix can be analyzed in real time through netstat. In-depth understanding of linux socket socket

  2022-06-01 06:34:12 Views: 226
• 

  New features of MySQL 5.7share temporary tablespaces and improve temporary tables

  0foreword: after MySQL 5.6referenced the stand-alone undo tablespace, MySQL 5.7made improvements on temporary tablespace. It has been implemented to change the temporary tablespace from

  2022-06-01 06:34:12 Views: 260
• 

  MySQL's charging policy

  From the communication with a lot of TX, there are still many people do not understand the charging policy of MySQL. Let me give you a brief introduction. First of all, MySQL sub-enterprise version and community version (community server) MySQL AB company only provides technical support to the enterprise version, to the community

  2022-06-01 06:34:12 Views: 224
• 

  Probing into the connection between Jsp and Mysql to check errors

  Before reading this document, you should have installed Apache, JDK, Tomcat, PHP, MySQL under your Win2000. If you have not successfully installed these software, you can refer to Apache1.3.20 at Window

  2022-06-01 06:34:11 Views: 218
• 

  About the Apple ID password, the most noteworthy use skills!

  What is Apple ID? You can use it to change your profile, buy goods from iTunes, log in to iCloud, sync your devices together, and so on. It can be said that the whole Apple domain revolves around Apple ID. You may often forget Apple

  2022-06-01 06:33:59 Views: 259
• 

  Implementation Scheme of replacing Network Card in oracle11gR2 RAC

  Environment: database version: oracle 11.2.0.4 whether RAC: RAC-- preparation for both nodes before replacement: 10.100.10.62 en110.100.10.200 en1 after replacement: 10.100.10.62 en

  2022-06-01 06:33:58 Views: 260
• 

  Oracle Rownum paging rewriting

  Oracle Rownum paging rewrite-note: the case comes from "harvest, not just SQL optimization" to create test data:-drop table test_rownum purge;SQL > create table te

  2022-06-01 06:33:54 Views: 296
• 

  On the processing of lost tablespace data files

  ORA-01116: error in opening database file 89ORA-01110: data file 89:'/ templv/osm/OSM_TABP_00.dbf'OR

  2022-06-01 06:33:54 Views: 230
• 

  Data processing method in rcv_transactions_interface table

  Look, if Transaction status summary finds that the receipt unit number is occupied but cannot be found when printing, you can first go to receiveing transaction summary to confirm that there is no receipt. It is best.

  2022-06-01 06:33:54 Views: 242
• 

  Slow slow logs split scripts by day

  #! / bin/bash####split mysql slow-query-log#LOG=/u01/mysql/5310/log/slowDATE= `date + "% Y-%m-%d" `u

  2022-06-01 06:33:54 Views: 211
• 

  Oracle10g/11g dynamic and static shutdown DRM feature method

  10g dynamic shutdown actually dynamic shutdown actually magnifies the condition of DRM, not really shuts down alter system set "_ gc_affinity_limit=1000000 scope=both;alter sys.

  2022-06-01 06:33:53 Views: 279
• 

  Technical skills: a diagnostic case of lock waiting phenomenon

  Author: Supo kangaroo cloud service department-DBA team database engineer communicated with a customer two days ago, the customer asked some questions about the mysql isolation level and locks, and then asked about the troubleshooting idea of lock waiting. It reminds me of long long ago, doing

  2022-06-01 06:33:50 Views: 278
• 

  Classification of problems that may be encountered in Linux installation of mysql 5.7.21

  1. Done with "file / usr/share/mysql/czech/errmsg.sys from install of mysql-community-common-5.7.9-1.e

  2022-06-01 06:33:49 Views: 245
• 

  Learning MySQL and MariaDB

  PART IIDatabase StructuresTo start, let's create a database that will contain information about bir

  2022-06-01 06:33:49 Views: 237
• 

  Make a new MySQL installation more secure (transfer)

  Make a new MySQL installation more secure [@ more@] after you install a new MySQL server yourself, you need to specify a directory for the root users of MySQL (no password by default), otherwise if you forget this, you will put your MySQL at the extreme

  2022-06-01 06:33:49 Views: 254
• 

  FLIQLO for Mac clock screensaver

  Https://mac.orsoon.com/Mac/148455.html is a very easy to use clock screen saver, the program takes the digital clock as the theme, when users do not use the computer for a long time, it can not only protect the screen security, but also provide time viewing function.

  2022-06-01 06:33:48 Views: 273
• 

  Mysql sysbench 1.0.X

  1. Install sysbenchyum install sysbench2.download source codesysbench-1.0.14\ src\ lua and upload all files to Linux / opt directory 3. Prepare for

  2022-06-01 06:33:44 Views: 210
• 

  System _ sql statement parsing execution steps

  I the client sends the statement to the server to execute 1 when we execute the SQL statement on the client, the client will send the SQL statement to the server through the service process process and let the server process process the statement. In PGA, it is divided into UGA and

  2022-06-01 06:33:44 Views: 255
• 

  ERROR 1114 (HY000): the solution of The table & # 039

  Today, the execution of sql encountered an error of 1114, as follows: mysql > insert into test1 select * from test;Query OK, 1778 rows affected.

  2022-06-01 06:33:43 Views: 288