Database Administrator

After MySql is installed, there is only one ROOT user with super management permissions, and ROOT restrictions can only be used on the local database. What if we want to remotely manage MySql? In fact, we need to add a Super User with super

I have been plagued by a problem when I was studying the LAMP environment. That is, if a website contains a database installation page, it must be installed on the host, that is, it must be installed using localhost. My current environment is

How to use mysql in vc, delphi, vb and other programs (use of mysql odbc driver) We often encounter this problem. How can we use mysql Databases in non-web programs or asp programs? There are two solutions to this problem: 1. Use the api function

I encountered many problems when installing MYSQL in the past two days. I found a lot of materials and wrote out the summary. 1. select an appropriate mysql version. Go http://www.mysql.com The latest mysql version At the same time, a version has

1 Overview The monitoring and management of the Oracle SGA area is an important part of routine database maintenance. This article describes the basic concepts of SGA, the SGA running status check, and the parameter setting principles of SGA. 2

PhpMyAdmin is a PHP-based MySQL database management tool based on the Web-Base architecture on the website host.You can manage the entire MySQL Server (requires a Super User) or a single database. To implement the latter, You need to properly set

If Oracle 11G reports that Enterprise Manager cannot connect to the database instance, You Can troubleshoot the problem as follows: 1. Use SQL PLUS. Run SQL PLUS in DOS mode. SQL> conn Enter the User name: sys as sysdba Enter the

Notes for MySQL Master/Slave 1. Try not to use stored procedures and triggers. Stored procedures can behave strangely with statement based replication 2. Try not to use temporary tables. For example, a memory table. Some programs prefer to

Oracle 11g allows the index to be marked as invisible. oracle maintains the invisible index like other indexes, but the default invisible index cannot be used by the optimizer unless OPTIMIZER_USE_INVISIBLE_INDEXES = TRUE is explicitly set (you can

Today, I received a requirement to establish a replication mechanism for MySQL internationally. This is actually nothing, and the network environment is worse, MySQL can also cope with it. However, a time zone error occurs! The error is as follows:

Use the meb Enterprise Backup Tool to automatically record binary informationThis backup method requires the installation of a software meb, which is installed in the/opt directory by default. The installation process is omitted. Add the following

1. Shut down the databaseShutdown 2. Use the OS command to copy redo log files to a new location.Mv/u01/app/Oracle/oradata/MYNEWDB/onlinelog/o1_mf_1_89y70t1b _. log/home/o1_mf_1_89y70t1b_test.log 3. Start the database, load only, do not open.CONNECT/

MySQL numeric data types can be roughly divided into two categories: one is an integer, and the other is a floating point or decimal. Many different subtypes are available for each of these classes. Each subtype supports data of different sizes.

Oracle 11g parallel DML (PDML) Parallel DML applications have significant scalability and performance when accessing large objects in the demo-support system DSS environment. PDML cannot be used as a feature to speed up OLTP applications. PDML is

I. Software Used1. Fedora linux SystemHttp://torrent.fedoraproject.org/There are a lot of installation methods on the Internet, so I won't talk about them here, but some may not be able to use them. These are all self-organized,2.

Today, we will briefly introduce how to set up SGA. 1. sga_target ParameterAlter system set sga_target = 40000 m scope = both;Features:1). ASMM automatic shared memory managementA: ASMM (automatic shared memory management) is a new feature of Oracle.

Record:Upgrade Oracle11g to version 11.2.0.3 and execute @? In the process of/rdbms/admin/catupgrd. SQL, the following error message is displayed:ORA-00604: error occurred at recursive SQL level 1ORA-01704: string literal too longORA-00932:

Prerequisites:   Two linux machines with Oracle installed. This is CentOS3_x86. Oracle service is installed on the master database and an instance named ora10g is added. The slave database only installs the oracle service For convenience, the

With autotrace, you can see the Predicate Information in some databases. Sometimes you cannot see it because the plan_table version is old. The solution is as follows: SQL> set autotrace traceonly SQL> select u. name2 from user u3 where u.

The binlog parsing tool is widely used. mysqlbinlog is the most commonly used tool.However, there are rivers and lakes where tools are available. Therefore, this article does not intend to argue that tools are superior or inferior to avoid immature