dba for beginners

regarded as a bedroom, the entire server is a house, server hardware resources can be regarded as the house of the bathroom, kitchen is the public resources of the house. It's like being in a house in the north, so be sure to share the resources. In fact, many services can be many instances such as Nginx,apache,redias.5.1.2 MySQL multiple instances of the role and problems.5.1.2.1 Efficient use of server resourcesWhen a single server resource is left, you can take advantage of the remaining res

experience and test, in order to more comprehensive test software deficiencies or existing problems.(3) RC versionRC version belongs to a production environment before the release of a small version or a candidate, is the beta version of the test results collected by the bug or defect of the collected information, to repair and improve the product after.(4) GA version:GA version belongs to the release of software products, also known as production version of the product, in general, the product

(); +---------------------+ | now() | +---------------------+ | 2018-01-18 20:14:43 | +---------------------+ 1 row in set (0.01 sec) 9.6 Viewing the table information contained in the current database Switch to the database to view [emailprotected] 08:1630->show tables; Empty set (0.00 sec) 空表，新库还没有建表 [emailprotected] 08:1742->show tables like ‘user‘; Empty set (0.00 sec) [emailprotected] 08:2016->show tables from zbf; 查询指定数据库的表 Empty set (0.00 sec) [emailprotected] 08:2030->show tables in

use this method to specify properties such as Ttc_server. For the C language, these properties can be directly written directly to the DSN file This method only supports C/s connection, performance is inferior to direct connection. It does make sense for Java. This method is extremely useful, and the auto client failover scenario can make the test more concise. This method does not indicate that the client can not install the TimesTen client program* ReferenceHowto:create a tim

-- The above two phrases will intercept the transaction records, as long as they are executed, the transaction record is not successful until the next complete preparation!-- subtract log the size of the file (LOG file name reduced by up to DBCC Shrinkfile (beedb_log,+)/******** The position of the DB ********/-- Check the location of DBSelectname,Physical_name fromSYS.master_fileswheredatabase_id=db_id(' Salepony ')-- swap out the location of the DBAlter Database Salemodify file

| UTF8 | =c/dgadmin : dgadmin=CTc/dgadmin template1 | dgadmin | UTF8 | =c/dgadmin : dgadmin=CTc/dgadmin tpch | dgadmin | UTF8 | tpch_1g | dgadmin | UTF8 | (5 rows)You can also use the following SQL to query for more detailed information:postgres=# select * from Pg_database; Datname | DATDBA | encoding | Datistemplate | Datallowconn | Datconnlimit | datlastsysoid | Datfrozenxid | Dattables

(2) Save Ipta Bles configuration Iptables-save >/etc/sysconfig/iptables #serverb: (1) Install software [[emailprotected] other]# rpm NGINX-1.8.0-1.EL7.NGX.X86_64.RPM (2) View software framework [[emailprotected] other]# rpm-ql nginx/etc/logrotate.d/nginx/etc/ Nginx/etc/nginx/conf.d/etc/nginx/conf.d/default.conf/etc/nginx/conf.d/example_ssl.conf/etc/nginx/fastcgi_ Params/etc/nginx/koi-utf/etc/nginx/koi-win/etc/nginx/mime.types/etc/nginx/nginx.conf/etc/nginx/scgi_params/etc /nginx/uwsgi_params/et

; Fastcgi_param Script_filename/usr/share/nginx/Yeliangcheng.com$fastcgi_script_name; Include Fastcgi_params; }}serverc{#迁移程序--Install the same package PHP PHP-mysql/mnt/item/nginx/epel/spawn-fcgi-1.6.3-5. el7.x86_64.rpm #启动服务并设置开机自启 systemctl start Spawn-fcgi; /sbin/chkconfig spawn-fcgi on #php相关文件Tar-jxf/usr/share/nginx/bbs.com/bbs.Tar. bz2}===================================================================================#测试serverb {#关闭数据库服务 systemctl stop mariadb #关闭spawn-f

variable that is only valid for code snippets within a function locally a=1title: Bash xxxx.SHInput-T5represents a triangle with 5 lines of paint-L7represents a draw slash 7 lines #!/bin/Bashtriangle () { forXinch$(seq 1$1) Do forYinch$(seq 1$(($1-$x))) Do Echo-N" " Done forZinch$(seq 1$((2* $x-1))) Do Echo-N"" DoneEcho Done}line () { forIinch$(seq 1$1) Do forXinch$(seq 1$i) Do Echo-N" " DoneEcho-

filesystem name (e.g. ext3) also lists-I: No hard disk capacity, and the number of inode to display du [-ahskm] file \ Directory name selection and parameters:-A: List all files and directory capacity, because the default is only the number of files in the directory underground-H: A more readable capacity format (g/M) Display-S: Lists the total, not the size of each directory-S: Do not include totals under sub-directories-K: List capacity display in Kbytes-m: Display du with MBytes listing capa

me comfort a lot, in addition to the child his father did a stupid thing to make me angry, all smooth. Well, this week's main content is probably summed up:1Introduction to Simple Linux commands2. Online Help for Linux systems3simple installation of Linux systems4management of users and Groups5. Management of files and directories6. Introduction to File Systems7. Compression \ Decompression and Packaging8Introduction to Remote control commands 0 Basic Learning Cloud computing and Big Data

1. Single-arm routing Switch:switch (config) #vlanTenSwitch (config-vlan) #vlan -Switch (config-VLAN) #exitSwitch (config) #intf0/1Switch (config-if) #switch Access VLANTenSwitch (config-if)#intf0/2Switch (config-if) #switch Access VLAN -Switch (config-if)#intf0/3Switch (config-if) #switch mode Trunkrouter:router (config) #intf0/0Router (config-if) #no shutdownrouter (config-if)#intf0/0.1Router (config-SUBIF) #encapsulation dot1qTenRouter (config-SUBIF) #ip Add10.0.0.1 255.0.0.0Router (config-SU

the growth of Blue-Chase DBA (3): antique operation, data import and export become a problemStatement ***************************************An individual's growth record on Oracle's path, with blue self-metaphor, to share growing emotions, horizons and technological changes and growth. Sensitive information is replaced in English, and will not disclose any corporate secrets, purely for technology sharing.Creation is inspired by self-reflection and re

Unix/linux topic: 1. How to view host CPU, memory, IP and disk space? cat /proc/cpuinfocat /proc/meminfoifconfig –afdisk–l2. What are your common process management and host Performance view commands?Ps–efIostat3. Set up DBA and reorganize user Oracle, default shell is bash.4. How to view the user Oracle's login history and command operation history?5, write crontab, let script/opt/test.sh at 8:00 every Sunday night to execute6. How to find all files

Tags: class tar get HTTP strong cSQL queries the database, you can take a series of ways to improve the speed and performance of queries. For example, use case instead of update, using temporary tables and batch updates, and so on. This article introduces 7 ways to improve the query speed, please refer to the reader.When SQL queries the database, proper adherence to some principles can make the job easier, and this article lists 7 principles that can be used flexibly to help you improve your SQL

xmlns:dc="http://purl.org/dc/elements/1.1/"xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/">rdf:about="http://www.blogjava.net/cymao/archive/2006/03/30/38289.html"dc:identifier="http://www.blogjava.net/cymao/archive/2006/03/30/38289.html"dc:title="DBA的职责和任务(转自oracle中文技术论坛)"trackback:ping="http://www.blogjava.net/cymao/services/trackbacks/38289.aspx" />--> It is from the Oracle Chinese technology forum. This section describes the

In Berkeley's BSD operating systems, there is a simple database structure, which uses several files to form an ultra-small database system and is structured as a DBA database with an abstract action layer. Currently, the DBA databases supported by PHP Include DBM: the earliest DBA database developed by Berkeley. Ndbm: a newer and more flexible

Differences between Oracle SYS and system users, sysdba and sysoper system permissions, and sysdba and DBA roles) Differences between sys and system users1) The most important difference is that the importance of stored data is different.Base tables and views of all ORACLE data dictionaries in SYS are stored in SYS users. These base tables and views are crucial for Oracle operation and are maintained by the database, no user can change it ma

I used to mix dba and sysdba. Today I am discussing the differences between them in the Forum. The special record is as follows: SYSDBA is not a permission. When a user logs on to the database as SYSDBA, the user will become SYS. You can log on as sysdba to open the database, close the database, create SPFILE, and restore the database, which cannot be implemented by the DBA role; Sysdba is the system p

The solution is as follows: 1-from the command prompt, stop ISQLPLUS: C: \> isqlplusctl stop 2-assuming that you install Oracle under C drive, run the following comands: C: \> set ORACLE_HOME = c: \ oracle \ product \ 10.2.0 \ db_1 C: \> set java_home = % ORACLE_HOME % \ JDK 3-Change directory: Cd % ORACLE_HOME % \ Solaris \ J2EE \ ISQLPLUS \ Application-deployments \ ISQLPLUS 4-Suppose you need to create a new user with user name 'yoyo 'and password 'ch51 *****', run the following co