NAV: SLTechnology News&Howtos > Database >

• 

  MySQL-- character Encoding and character set

  Generally speaking, the occurrence of Chinese garbled code is the cause of the mismatch between the client character set and the server character set. (database tables created by default without a specified character set are all latinl character sets, and it is strongly recommended to use utf8 character sets.) the idea of ensuring that there is no garbled code: ensure that the client and server

  2022-06-01 18:50:35 Views: 221
• 

  How to modify MySQL storage engine types in batches

  The following is mainly about how to modify MySQL storage engine types in batches. I hope these contents can bring you practical use, which is also the main purpose of my article on how to modify MySQL storage engine types in batches. All right, don't talk too much nonsense, let's just read the following. View table usage

  2022-06-01 18:50:17 Views: 237
• 

  Connect MySQL and common commands by changing root password

  This article mainly introduces how to connect MySQL and common commands by changing the root password. The content of the article is carefully selected and edited by the author, which is of certain pertinence and is of great significance to everyone's reference. Let's learn about how to connect M by changing the root password.

  2022-06-01 18:50:16 Views: 295
• 

  Mysql modifies binlog log retention time

  The command line is temporarily valid and expires after restarting the mysqld service; # check show variables like "% expire_logs_days%"; # set to keep set global expire_logs_da for 7 days

  2022-06-01 18:50:16 Views: 223
• 

  Basic operation of database

  Database operation notes: come on! Skip authorization login: 1. Close mysql;mysqld-- skip-grant-tables restart client to log in to the remote login database without a password: select user () to view the current login

  2022-06-01 18:50:16 Views: 252
• 

  Mysql calculates the time affix between this month and the first of last month.

  This month: unix_timestamp (date_sub (curdate (), interval day (curdate ())-1 day)); last month: unix_timestamp (date_sub (

  2022-06-01 18:50:16 Views: 214
• 

  MySQL master-slave replication and read-write separation

  In the actual production environment, if the read and write of the database are all operated in the same database server, it can not meet the actual demand in terms of security, high availability, high concurrency and so on. Therefore, it is generally through master-slave replication (Master- Slave).

  2022-06-01 18:50:15 Views: 242
• 

  DATAGUARD of Oracle Learning (10) create DG using the new features of 11g rman on the same machine

  First set up a database, db_name=primary, using dbca. two。 Prepare static snooping for both databases. And the TNSNAME11gdg1- > cat listener.ora tnsnames.ora that connects each other

  2022-06-01 18:50:04 Views: 241
• 

  Installation and error handling of plug-ins needed for the combination of Cacti and nagios

  Cacti and Nagios installation will not be introduced here. What we are introducing here is the integration of nagios and cacti. First of all, we need to install the php json module and ndoutils. Ndoutils is a plug-in for nagios, which can be used.

  2022-06-01 18:50:04 Views: 250
• 

  Wiindows 2012R2+11gR2RAC (11204) installation of grid report ins-20802 error

  Install grid to 84% report the following error check the installation log has the following error message > ACFS-9340: unable to install the ADVM driver. > acfsinstall: ACFS-09420: no driver is currently installed on this node. >

  2022-06-01 18:50:00 Views: 296
• 

  What are the ways to start redis?

  Three startup modes of redis 1. Boot directly to the redis root directory and execute the command: # plus the'& 'sign to make redis run as a daemon. / redis-server & 2. Start by specifying the configuration file to specify the configuration for redis service startup

  2022-06-01 18:49:57 Views: 201
• 

  What are the common categories of log files in MySQL

  Let's talk about what are the common categories of log files in MySQL. The secret of the text is that it is close to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from reading this article on the classification of common log files in MySQL. Log to a system or

  2022-06-01 18:49:57 Views: 204
• 

  Command line interface for utilities mycli:MySQL, MariaDB, and Percona

  Mycli is a modern alternative to the default MySQL client, and mycli will automatically complete keywords, table names, columns, and functions as you type. The effects of HomePage: http://mycli.net are as follows: RHEL, Centos

  2022-06-01 18:49:57 Views: 250
• 

  Installation of Virtualbox for virtual machine software

  Virtualbox installation of virtual machine software part I. as an open source virtual machine software, virtualbox is currently a software owned by oracle, which supports the installation of mainstream systems such as windowos,dos,linux,mac.

  2022-06-01 18:49:27 Views: 211
• 

  ORACLE command line to delete the database, will you?

  First, the environment description will tell the customer 11g OCP on Friday. Do a test to delete the database in advance. Record it as follows. Let's get your own knowledge. There is really a big difference between work and lectures. we should not only know what it is about all kinds of knowledge, but also why it is much more demanding in theory. Come on! Second, specific

  2022-06-01 18:49:26 Views: 290
• 

  Deploy Oracle 12c Enterprise Edition database

  In the field of computer information security, database system undoubtedly plays an important role. For example, SQL Server, MySQL, DB2, Oracle, etc., are all well-known database management software. because of the security of Oracle database, it is heavy in some cases.

  2022-06-01 18:49:03 Views: 291
• 

  How does MySQL use sharding to solve the 50 billion data storage problem?

  This is a technical study of how we split data on multiple MySQL servers. We completed this sharding method in early 2012, and it is still the system we use to store core data today. Before we discuss how to split the data, let's take a look at our data.

  2022-06-01 18:48:51 Views: 261
• 

  Using shell programming to realize mysql backup under linux

  This article mainly gives you a brief talk about using shell programming to achieve mysql backup under linux. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic and hope to use shell programming under linux.

  2022-06-01 18:48:50 Views: 289
• 

  What is the difference between MySQL subquery and join

  The following mainly brings you the difference between MySQL subquery and join. I hope these contents can bring you practical use, which is also the main purpose of this article. All right, don't talk too much nonsense, let's just read the following. Bring the client into gbk

  2022-06-01 18:48:47 Views: 228
• 

  Workflow of AOF persistence mode in Redis

  Redis's RDB approach can't be persistent, but AOF can do it. If the data is important and the loss will have serious consequences, then the RDB approach is obviously not appropriate, and the AOF approach should be used. Aof is similar to mysql's binlog log.

  2022-06-01 18:48:47 Views: 274