Database Administrator

MySQL 5.5.37 compilation and Installation Details Today we will introduce you to the MySQL 5.5.37 compilation and installation method, which is also a common method in our work. We hope that through the introduction of this article, we can provide

RHEL5.7 64-bit source code compilation and installation of MySQL-5.5.42 Problems Since MySQL is compiled and installed from source code Versions later than MySQL 5.5 using cmake, make, and make install, no. /Configure, make, make install, so check

EXP/IMP: An Example of exporting the specified data from the production database table to the Test Database In general, EXP/IMP is the export and import program of the previous generation, and EXPDP/IMPDP is the next-generation export and import

OGG-01028 and ORA-00308: failed to open archive 13:59:01 ERROR OGG-01028 Opening file + FRA/41513536_857160808.dbf in DBLOGREADER mode: (308) ORA-00308: cannot open archived log '+ FRA/41513536_857160808.dbf' ORA-17503: ksfdopn: 2 Failed to open

Oracle startup error ORA-03113 resolution Environment: RHEL6.4 + Oracle 11.2.0.4 Step summary:1. Start error ORA-031132. view the alert Log to find the cause3. Take reasonable measures according to the actual situation. Here we first increase the

Oracle Stored Procedure get time format for YYYY-MM-DD Environment: Oracle 10g, 11g Problem reproduction: in the Command window in PL/SQL, it is found that the time format obtained by the stored procedure does not meet the expected requirements. SQL>

SQL Server data encryption and decryption (1), SQL server encryption and decryption Are basic examples. For more information, see the official documentation: 1. Transact-SQL Functions2. Database key3. Certificate4. Asymmetric Key5. symmetric key --

ORA-12519: TNS: no appropriate service handler found solution, ora-12519tnsSelect count (*) from v $ process -- current number of connectionsSelect value from v $ parameter where name = 'processs' -- maximum number of connections allowed by the

[Translated from mos] the flashback primary database method in the dg Environment, Flashback primary database method in the dg Environment The intention of this article is: the flashback standby database method after flashback has primary database.  

Run oracle's aix and linux Hosts to change the ip specification, oracleaixRun the aix and linux Hosts of oracle to change the ip SpecificationChange the value in/etc/hostsFor linux:/etc/sysconfig/network-scripts/ifcfg-ethX,For aix: smitty tcpip->

Mysql simplifies INSERT and UPDATE through the stored procedure, and mysqlinsert Processing purpose: Execute UPDATE when the target record exists in the data table. When the target record does not exist in the data table, execute INSERT. This

SQL series, ultimate SeriesSQL statement Optimization Methods Some are general (for example, avoid Select *); Some different database management systems are different (such as Where clause order ); Then you must optimize the SQL statement based on

Redis expiration Policy, redis expired I. redis keys have six expiration policies 1. noeviction: Once the memory is full, an error is returned. 2. allkeys-lru: Perform LRU on all keys 3. volatile-lru: Only LRU is performed on expired keys

Notes for using AsyncTask: Use of asynctask AsyncTask is an asynchronous processing thread that comes with android. It carries many parameters Easy to use But there are some precautions 1: Official Website Description: AsyncTasks shocould ideally be

======== Use the source code to install the tar package, without installation -- MySQL-5.6.23 for CentOS6.5 _ 64bit ===@ guoyJoe, centos6.5mysql Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/44836547 I. On the

Mysql installation, mysql Install mysql source code Http://www.cnblogs.com/fly1988happy/archive/2011/11/21/2257682.htmlHttp://www.cnblogs.com/wuhou/archive/2008/09/28/1301071.html Problems During mysql Installation You must install the ncurse

Modify and reset the MySQL password under WampServer, wampservermysql After WampServer is installed, the password is blank, ModifyThere are two methods: One is to directly modify it through phpMyAdmin; Second, use the MySql console of WAMP to modify.

MySQL tuning and mysql Performance Tuning Prerequisites: a normal two-Table connection is required to query the detailed information. Table A contains A large table with tens of thousands of test data records. Table B contains about 1000 million

ADO. NET and Oracle (1): Get multi-row record set, ado. netoracle I recently came into contact with ADO. NET and Oracle to share some of my common problems with you. I think the most basic requirement for getting started with ADO. NET to operate

Atitit. spring hibernate transaction mechanism spring cannot save the solution of objects, springhibernate transactions Atitit. spring hibernate transaction mechanism spring cannot save the solution of Objects   SessionFactory. openSession () No ..