caller can executeCOMMENT ' String ' is a comment message To view stored procedures under a database:SHOW PROCEDURE STATUS WHERE db= ' database name '; View the list of stored procedures under the current database:SELECT specific_name from Mysql.proc; To view the contents of a stored procedure:SELECT specific_name,body from Mysql.procwhere specific_name = stored procedure name;Or: SHOW CREATE PROCEDURE Stored procedure name. To delete a store
Fsync command can also back up real-time data in the case of MongoDB, and its implementation is actually locked. Prevents write operations to the database, and then writes the data for the buffer to disk. Back up before unlocking. During this time, no matter what the write operation to the database will be blocked. Until the lock is released. > Db.runcommand ({"Fsync": 1, "Lock": 1})
{
"info": "Now locked against writes, use Db.fsyncunlock () to Unloc K ",
" seealso ":" Http://
...Recycling is revoke ... from ...For example revoke CREATE table from Arwen;Why do I have create session permissionsThere is a lot of controversy about this privilege. Because without this permission is actually possible, and it is easy to mislead people. For example, creating a user should not be able to login a bit of a common sense. There is no such permission in SQL Server. What does it do in Oracle?I think the create session has a pretty important role to play the role of lock. For examp
to the logical address space of the kernel through Kmap ().L No continuous Physical address required: vmalloc virtual address continuous Physical address may be discontinuous, relative performance lossL frequently create and destroy many large data structures: establish slab buffers to improve object allocation and recovery performance.Linux high-end memory:http://ilinuxkernel.com/?p=1013Analysis of Linux Slab allocator:https://www.ibm.com/developerworks/cn/linux/l-linux-slab-allocator/ (note)
requested, if the size of the free list is larger than the requested space, the corresponding memory interval is returned, otherwise the application is unsuccessful.When memory is freed through free () and delete in the code, the corresponding memory is returned to the idle list, and the idle list is organized again to wait for the next request.Heap area memory
The db2 tutorial is: DB2 UDB V8.1 management learning notes (3 ). Force disconnect an existing connection, stop the instance, and delete it.
$ Db2idrop-f instance_name
Migrate instances in UNIX.
$ Db2imigr instance_name
Update an instance to obtain access to some new product options or revision packages.
$ Db2iupdt instance_name
Obtain the current instance.
$ Db2 get instance
When you update instance-level
Rpm-qi
Querying for information about a specified package
Rpm-ql
Query the list of all files generated by the specified package installation
Rpm-v
Verifies whether the current file has been changed
4. Package Check:1, local key address:/ETC/PKI/RPM-GPG[Email protected] yum.repos.d]# ll/etc/pki/rpm-gpg/-rw-r--r--.1 root root 1706 October rpm-gpg-key-centos-6-rw-r--r--.1 root root 1730 O
| XargsScreenInstallation via Yum install-y screenAllows the program to log logs in the backgroundUse screen to start a shell, even if the current link is closed, the program can run the end of theEquivalent to a child shellScreen-ls: can see ID numberScreen-r ID/Name: can be counted into a screenScreen-s (UPPERCASE) Name: You can customize a nameCurl: You can access a website in the command window, out of an HTML source-I: Can look at head-X: You can specify a proxy/etc/hosts can set the host-
> query file belongs to package#rpm-qf/usr/share/pixmaps/xplns.pngTo query the package that a file belongs to> Query the list of files included in the package#rpm-QL xplus-3.3.1-lglibc213Query the list of all files included in the installed package> Query Package summary information#rpm-qi xplus-clm-3.3.1.1> Query all installed Packages#rpm-qa |grep ____ Package name#rpm-IVH xplus-elm-3.3.1-l.i386.rpmInstal
, if you delete the extended partition, the following sub-partition, the logical partition, is deleted. after the partition is complete, enter W to save the exit. 3: Formatting partitionsMKE2FS- t Specifies the file system typemke2fs-t EXT4/DEV/SDB5 Specifies that the file system has a default block size of 4KB for EXT4 format. A Linux write file is a block of write, such as writing 1 5k files, there will be 2 blocks. -l Specifies that the label-p specifies a block size of 1024 integer times as:
the AT–C task IDAbove, only the most core information is displayed, you can see our command is LL.The time format of the AT command can beMinute??? At now + 5 minutes?? The task runs after 5 minutesHour????? At now + 1 hour????? The task runs after 1 hoursDays????? At now + 3 days????? The task runs after 3 daysWeeks???? At now + 2 weeks???? The task runs after two weeksFixed???? At midnight????????? Task runs at midnightFixed???? At 10:30pm?????????? Task at 10:30 in the eveningFixed???? At 23
, T, equal to this permission does not workRights Management: Rights Management: Chmod Affiliation Management: Chown, Chgrp file Matte code: Umask Modify file permissions: chmodchmod [OPTION] ... Mode[,mode] ... FILE ...chmod [OPTION] ... Octal-mode FILE ...chmod [OPTION] ...--reference=rfilefile. where the meaning of Ugoa:U:ownerG:groupO:otherA:all There are t
|false default to False--tail= "All"Production See container processDocker Top Container NameStart a new process within a running container:Docker exec [-d][-i][-t] container name [Command][arg ...]Container Port mappings:Run [-p][-p]Docker run-p-i-t Centos/bin/bash Map All portsDocker run-p 80-i-T centos/bin/bash map single port1, only specify the container port, host port randomDocker run-p 80-i-T Centos/bin/bash2. Specify host-to-container port mappingsDocker run-p 8088:80-i-T Centos/bin/bash
commit to commit C.C~1: Equivalent to c~, which represents the first parent commit to commit C.C~2: Represents the submission of the first grandfather of C.C~3: Represents the submission of the first great-grandfather of C.c~3^2^2^: Represents the first great-grandfather commit of C----the second parent commits----the second parent commits.Here are the GIT commands to use: [[email protected] my_website]# git rev-parse Mastere4db73549d3e9289b8ec9c5ec325e1a672942f28[[email protected] my_website]#
BtrfsBtrfs (b-tree file system, commonly read as Butter Fs,better FS or B-tree FS), a file system that supports write-time replication (COW), can consist of multiple underlying physical volumes. In addition, the file system supports RAID, data and meta-data check code (checksum), sub-volume, snapshot and transparent compression function.File system creationDisk partitions are formatted after the partition is created# mkfs.btrfs/dev/sda5 # mkdir/btrfsdisk # mount-t Btrfs/dev/sda5/btrfsdiskSuch a
is only one task in the background, you can not specify Jobnumber.The BG command can move the background paused task to the foreground to continue running , with the following syntax:$BG%jobnumberJobnumber is also the serial number of the background task obtained through the jobs command, note that it is not PID. If the foreground has only one task, you can not specify Jobnumber.If you want to move the current task to the background, you can pause the task with Ctrl + Z and then use the BG com
from the kernel to the switch between the user state and the kernel state.Kernel mode should not consume too much time to switch too muchCPU-intensive batch processing time slices with low priorityIO Interactive time slice short priority highReal-time process real-timeLinux Priority proorityReal-time priority 1-99 number smaller priority lessStatic priority 100-139 number lower priority higherReal-time priority higher than static priorityKernel processes often have real-time priority RT Priorit
can use to switch alt+f1-f7.6. CP file1 file2 : means to assign file1 to file2 and place it in the background. The can throw work into the background without affecting the work to be opened. , when thrown into the background, Bash will be based on this instruction a work number, throw in the background of the biggest advantage is not afraid to be the CTRL + C interrupt.7. Ctrl + Z is temporarily throwing work into the background.Jobs-l: Observe all the current work and PID in bashFG: Take back
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.