:meta-keywords: cubrid create, cubrid add volume, cubrid backup, cubrid online backup, cubrid restore, cubrid unload, cubrid load, cubrid space, cubrid compact, cubrid optimize, cubrid plan dump, cubrid stat dump, cubrid check, cubrid diag, cubrid commands :meta-description: CUBRID comprehensive list of utilities and commands. Utilities: createdb, deletedb, backupdb, restoredb, compactdb, statdump, diagdb, checkdb, genlocale, gen_tz and many others. CUBRID commands for HA, Locale and Timezone. .. _cubrid-utilities: cubrid Utilities ================ The following shows how to use the cubrid management utilities. :: cubrid utility_name utility_name: createdb [option] --- Creating a database deletedb [option] --- Deleting a database installdb [option] --- Installing a database renamedb [option] --- Renaming a database copydb [option] --- Copying a database backupdb [option] --- Backing up a database restoredb [option] --- Restoring a database addvoldb [option] --- Adding a database volume file spacedb [option] --- Displaying details of database space lockdb [option] --- Displaying details of database lock tranlist [option] --- Checking transactions killtran [option] --- Removing transactions optimizedb [option] --- Updating database statistics statdump [option] --- Dumping statistic information of database server execution compactdb [option] --- Optimizing space by freeing unused space diagdb [option] --- Displaying internal information checkdb [option] --- Checking database consistency alterdbhost [option] --- Altering database host plandump [option] --- Displaying details of the query plan loaddb [option] --- Loading data and schema unloaddb [option] --- Unloading data and schema paramdump [option] --- Checking out the parameter values configured in a database changemode [option] --- Displaying or changing the server HA mode applyinfo [option] --- Displaying the status of being applied transaction log to the other node in HA replication environment synccolldb [option] --- Synchronizing the DB collation with the system collation genlocale [option] --- Compiling the locale information to use dumplocale [option] --- Printing human readable text for the compiled binary locale information gen_tz [option] [] --- Generates C source file containing timezone data ready to be compiled into a shared library dump_tz [option] --- Displaying timezone related information tde [option] --- Managing Transparent Data Encryption (TDE) cubrid Utility Logging ---------------------- CUBRID supports logging feature for the execution result of **cubrid** utilities; for details, see :ref:`cubrid-utility-logging`. .. _creating-database: .. _createdb: createdb -------- The **cubrid createdb** utility creates databases and initializes them with the built-in CUBRID system tables. It can also define initial users to be authorized in the database and specify the locations of the logs and databases. In general, the **cubrid createdb** utility is used only by DBA. .. warning:: When you create database, a locale name and a charset name after a DB name must be specified(e.g. ko_KR.utf8). It affects the length of string type, string comparison operation, etc. The specified charset when creating database cannot be changed later, so you should be careful when specifying it. For charset, locale and collation setting, see :doc:`/sql/i18n`. :: cubrid createdb [options] database_name locale_name.charset * **cubrid**: An integrated utility for the CUBRID service and database management. * **createdb**: A command used to create a new database. * *database_name*: Specifies a unique name for the database to be created, without including the path name to the directory where the database will be created. If the specified database name is the same as that of an existing database name, CUBRID halts creation of the database to protect existing files. * *locale_name*: A locale name to use in the database should be input. For a locale name which can be used in CUBRID, refer to :ref:`locale-selection`. * *charset*: A characterset to use in the database should be input. A character set which can be used in CUBRID is iso88591, euckr or utf8. * If *locale_name* is en_US and *charset* is omitted, a character set will be iso88591. * If *locale_name* is ko_KR and *charset* is omitted, a character set will be utf8. * All locale names except en_US and ko_KR cannot omit *charset*, and a *charset* can be specified only with utf8. The maximum length of database name is 17 in English. The following shows [options] available with the **cubrid** **createdb** utility. .. program:: createdb .. option:: --db-volume-size=SIZE This option specifies the size of the database volume that will be created first. The default value is the value of the system parameter **db_volume_size**. You can set units as K, M, G and T, which stand for kilobytes (KB), megabytes (MB), gigabytes (GB), and terabytes (TB) respectively; if you omit the unit, bytes will be applied. The size of the database is always rounded up to 64 disk sectors, which depends on the size of a page and can be 16M, 32M or 64M for page size 4k, 8k and 16k respectively. The following example shows how to create a database named *testdb* and assign 512 MB to its first volume. :: cubrid createdb --db-volume-size=512M testdb en_US .. option:: --db-page-size=SIZE This option specifies the size of the database page; the minimum value is 4K and the maximum value is **16K** (default). K stands for kilobytes (KB). The value of page size is one of the following: 4K, 8K, or 16K. If a value between 4K and 16K is specified, system rounds up the number. If a value greater than 16K or less than 4K, the specified number is used. The following example shows how to create a database named *testdb* and configure its page size 16K. :: cubrid createdb --db-page-size=16K testdb en_US .. option:: --log-volume-size=SIZE This option specifies the size of the database log volume. The default value is the same as database volume size, and the minimum value is 20M. You can set units as K, M, G and T, which stand for kilobytes (KB), megabytes (MB), gigabytes (GB), and terabytes (TB) respectively. If you omit the unit, bytes will be applied. The following example shows how to create a database named *testdb* and assign 256 MB to its log volume. :: cubrid createdb --log-volume-size=256M testdb en_US .. option:: --log-page-size=SIZE This option specifies the size of the log volume page. The default value is the same as data page size. The minimum value is 4K and the maximum value is 16K. K stands for kilobytes (KB). The value of page size is one of the following: 4K, 8K, or 16K. If a value between 4K and 16K is specified, system rounds up the number. If a value greater than 16K or less than 4K, the specified number is used. The following example shows how to create a database named *testdb* and configure its log volume page size 8K. :: cubrid createdb --log-page-size=8K testdb en_US .. option:: --comment=COMMENT This option specifies a comment to be included in the database volume header. If the character string contains spaces, the comment must be enclosed in double quotes. The following example shows how to create a database named *testdb* and add a comment to the database volume. :: cubrid createdb --comment "a new database for study" testdb en_US .. option:: -F, --file-path=PATH The **-F** option specifies an absolute path to a directory where the new database will be created. If the **-F** option is not specified, the new database is created in the current working directory. The following example shows how to create a database named *testdb* in the directory /dbtemp/new_db. :: cubrid createdb -F "/dbtemp/new_db/" testdb en_US .. option:: -L, --log-path=PATH The **-L** option specifies an absolute path to the directory where database log files are created. If the **-L** option is not specified, log files are created in the directory specified by the **-F** option. If neither **-F** nor **-L** option is specified, database log files are created in the current working directory. The following example shows how to create a database named *testdb* in the directory /dbtemp/newdb and log files in the directory /dbtemp/db_log. :: cubrid createdb -F "/dbtemp/new_db/" -L "/dbtemp/db_log/" testdb en_US .. option:: -B, --lob-base-path=PATH This option specifies a directory where **LOB** data files are stored when **BLOB/CLOB** data is used. If the **--lob-base-path** option is not specified, LOB data files are store in <*location of database volumes created*>/**lob** directory. The following example shows how to create a database named *testdb* in the working directory and specify /home/data1 of local file system as a location of LOB data files. :: cubrid createdb --lob-base-path "file:/home1/data1" testdb en_US .. option:: --server-name=HOST This option enables the server of a specific database to run in the specified host when CUBRID client/server is used. The information of a host specified is stored in the **databases.txt** file. If this option is not specified, the current localhost is specified by default. The following example shows how to create a database named *testdb* and register it on the host *aa_host*. :: cubrid createdb --server-name aa_host testdb en_US .. option:: -r, --replace This option creates a new database and overwrites an existing database if one with the same name exists. The following example shows how to create a new database named *testdb* and overwrite the existing database with the same name. :: cubrid createdb -r testdb en_US .. option:: --more-volume-file=FILE This option creates an additional volume based on the specification contained in the file specified by the option. The volume is created in the same directory where the database is created. Instead of using this option, you can add a volume by using the **cubrid addvoldb** utility. The following example shows how to create a database named *testdb* as well as an additional volume based on the specification stored in the **vol_info.txt** file. :: cubrid createdb --more-volume-file vol_info.txt testdb en_US The following is a specification of the additional volume contained in the **vol_info.txt** file. The specification of each volume must be written on a single line. :: #xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx # NAME volname COMMENTS volcmnts PURPOSE volpurp NPAGES volnpgs NAME data_v1 COMMENTS "data information volume" PURPOSE data NPAGES 1000 NAME data_v2 COMMENTS "data information volume" NPAGES 1000 NAME temp_v1 COMMENTS "temporary information volume" PURPOSE temp NPAGES 500 #xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx As shown in the example, the specification of each volume consists following. :: [NAME volname] [COMMENTS volcmnts] [PURPOSE volpurp] NPAGES volnpgs * *volname*: The name of the volume to be created. It must follow the UNIX file name conventions and be a simple name not including the directory path. The specification of a volume name can be omitted. If it is, the "database name to be created by the system_volume identifier" becomes the volume name. * *volcmnts*: Comment to be written in the volume header. It contains information on the additional volume to be created. The specification of the comment on a volume can also be omitted. * *volpurp*: The purpose for which the volume will be used. It can be either permanent data (default option) or temporary. .. note:: For backward compatibility, all old keywords, **data**, **index**, **temp**, or **generic** are accepted. **temp** stands for temporary data purpose, while the rest stand for permanent data purpose. * *volnpgs*: The number of pages of the additional volume to be created. The specification of the number of pages of the volume cannot be omitted; it must be specified. The actual volume size is rounded up to the next multiple of **64 sectors**. .. option:: --user-definition-file=FILE This option adds users who have access to the database to be created. It adds a user based on the specification contained in the user information file specified by the parameter. Instead of using the **--user-definition-file** option, you can add a user by using the **CREATE USER** statement (for details, see :ref:`create-user`). The following example shows how to create a database named *testdb* and add users to *testdb* based on the user information defined in the **user_info.txt** file. :: cubrid createdb --user-definition-file=user_info.txt testdb en_US The syntax of a user information file is as follows: :: USER user_name [ | ] : [ GROUPS [ { }... ] ] : [ MEMBERS [ { }... ] ] * The *user_name* is the name of the user who has access to the database. It must not include spaces. * The **GROUPS** clause is optional. The *group_name* is the upper level group that contains the *user_name* . Here, the *group_name* can be multiply specified and must be defined as **USER** in advance. * The **MEMBERS** clause is optional. The *member_name* is the name of the lower level member that belongs to the *user_name* . Here, the *member_name* can be multiply specified and must be defined as **USER** in advance. Comments can be used in a user information file. A comment line must begin with a consecutive hyphen lines (--). Blank lines are ignored. The following example shows a user information in which *grandeur* and *sonata* are included in *sedan* group, *tuscan* is included in *suv* group, and *i30* is included in *hatchback* group. The name of the user information file is **user_info.txt**. :: -- -- Example 1 of a user information file -- USER sedan USER suv USER hatchback USER grandeur GROUPS sedan USER sonata GROUPS sedan USER tuscan GROUPS suv USER i30 GROUPS hatchback The following example shows a file that has the same user relationship information as the file above. The difference is that the **MEMBERS** statement is used in the file below. :: -- -- Example 2 of a user information file -- USER grandeur USER sonata USER tuscan USER i30 USER sedan MEMBERS sonata grandeur USER suv MEMBERS tuscan USER hatchback MEMBERS i30 .. option:: --csql-initialization-file=FILE This option executes an SQL statement on the database to be created by using the CSQL Interpreter. A schema can be created based on the SQL statement contained in the file specified by the parameter. The following example shows how to create a database named *testdb* and execute the SQL statement defined in table_schema.sql through the CSQL Interpreter. :: cubrid createdb --csql-initialization-file table_schema.sql testdb en_US .. option:: -o, --output-file=FILE This option stores messages related to the database creation to the file given as a parameter. The file is created in the same directory where the database was created. If the **-o** option is not specified, messages are displayed on the console screen. The **-o** option allows you to use information on the creation of a certain database by storing messages, generated during the database creation, to a specified file. The following example shows how to create a database named *testdb* and store the output of the utility to the **db_output** file instead of displaying it on the console screen. :: cubrid createdb -o db_output testdb en_US .. option:: -v, --verbose This option displays all information on the database creation operation onto the screen. Like the **-o** option, this option is useful in checking information related to the creation of a specific database. Therefore, if you specify the **-v** option together with the **-o** option, you can store the output messages in the file given as a parameter; the messages contain the operation information about the **cubrid createdb** utility and database creation process. The following example shows how to create a database named *testdb* and display detailed information on the operation onto the screen. :: cubrid createdb -v testdb en_US .. note:: * **temp_file_max_size_in_pages** is a parameter used to configure the maximum size of temporary volumes - used for complicated queries or storing arrays - on the disk. With the default value **-1**, the temporary volumes size is only limited by the capacity of the disk specified by the **temp_volume_path** parameter. If the value is 0, no temporary volumes can be created. In this case, a permanent volume with temporary data purpose should be added by using the :ref:`cubrid addvoldb ` utility. For an efficient storage management, it is recommended to use the latter approach. * By using the :ref:`cubrid spacedb ` utility, you can check the remaining space of each volume. By using the :ref:`cubrid addvoldb ` utility, you can add more volumes as needed while managing the database. You are advised to add more volumes when there is less system load. When all preassigned volumes are completely in use, the database system automatically creates new volumes. The following example shows how to create a database, with additional volumes, including one for temporary data purpose. :: cubrid createdb --db-volume-size=512M --log-volume-size=256M cubriddb en_US cubrid addvoldb -S -n cubriddb_DATA01 --db-volume-size=512M cubriddb cubrid addvoldb -S -p temp -n cubriddb_TEMP01 --db-volume-size=512M cubriddb .. note:: **Creating a database using an existing key file** When the database is created, a key file is created together by default. If you want to use an existing key file when creating a database: #. Copy the key file with the name **_keys**. #. Specify the directory path of the copied key file by the system parameter **tde_keys_file_path**. #. Create a database by using the **createdb utility**. For more information on the TDE key file, see :ref:`tde-file-based-key`. .. _adding-database-volume: .. _addvoldb: addvoldb -------- If you want to micromanage CUBRID storage volumes, addvoldb is the tool for you. You can finely tune each file name, path, purpose, and size. The database system can handle all storage by itself, but it uses default values to configure each new volume. The command for manually adding a database volume is as follows. :: cubrid addvoldb [options] database_name * **cubrid**: An integrated utility for CUBRID service and database management. * **addvoldb**: A command that adds a specified number of pages of the new volume to a specified database. * *database_name*: Specifies the name of the database to which a volume is to be added without including the path name to the directory where the database is to be created. The following example shows how to create a database, with additional multi-purpose volumes. :: cubrid createdb --db-volume-size=512M --log-volume-size=256M cubriddb en_US cubrid addvoldb -S -n cubriddb_DATA01 --db-volume-size=512M cubriddb cubrid addvoldb -S -p temp -n cubriddb_TEMP01 --db-volume-size=512M cubriddb The following shows [options] available with the **cubrid addvoldb** utility. .. program:: addvoldb .. option:: --db-volume-size=SIZE **--db-volume-size** is an option that specifies the size of the volume to be added to a specified database. If the **--db-volume-size** option is omitted, the value of the system parameter **db_volume_size** is used by default. You can set units as K, M, G and T, which stand for kilobytes (KB), megabytes (MB), gigabytes (GB), and terabytes (TB) respectively. If you omit the unit, bytes will be applied. The size of the database is always rounded up to 64 disk sectors, which depends on the size of a page and can be 16M, 32M or 64M for page size 4k, 8k and 16k respectively. The following example shows how to add a volume for which 256 MB are assigned to the *testdb* database. :: cubrid addvoldb --db-volume-size=256M testdb .. option:: -n, --volume-name=NAME This option specifies the name of the volume to be added to a specified database. The volume name must follow the file name protocol of the operating system and be a simple one without including the directory path or spaces. If the **-n** option is omitted, the name of the volume to be added is configured by the system automatically as "database name_volume identifier". For example, if the database name is *testdb*, the volume name *testdb_x001* is automatically configured. The following example shows how to specify a different name, *testdb_v1*, to newly added volume. :: cubrid addvoldb -n testdb_v1 testdb .. option:: -F, --file-path=PATH This option specifies the directory path where the volume to be added will be stored. If the **-F** option is omitted, the value of the system parameter **volume_extension_path** is used by default. The following example shows how to add a volume in the */dbtemp/addvol* directory. Since the **-n** option is not specified for the volume name, the volume name *testdb_x001* will be created. :: cubrid addvoldb -F /dbtemp/addvol/ testdb .. option:: --comment COMMENT This option facilitates to retrieve information on the added volume by adding such information in the form of comments. It is recommended that the contents of a comment include the name of **DBA** who adds the volume, or the purpose of adding the volume. The comment must be enclosed in double quotes. The following example shows how to add a volume and inserts a comment with additional information. :: cubrid addvoldb --comment "Data volume added by cheolsoo kim because permanent data space was almost depleted." testdb .. option:: -p, --purpose=PURPOSE This option specifies the purpose of the volume to be added. The purpose defines the type of files that will be stored in added volume: * **PERMANENT DATA** to store table rows, indexes and system files. * **TEMPORARY DATA** to store intermediate and final results of query processing and sorting. If not specified, the purpose of the volume is by default considered **PERMANENT DATA**. The following example shows how to change it to temporary. :: cubrid addvoldb -p temp testdb .. note:: PERMANENT DATA volumes used to be classified as generic, data and index. The design of volumes has been changed, and since then the classification no longer exists. In order to avoid invalidating your old scripts, we chose to keep the keywords as valid options, but their effect will be the same. The only remaining option value with a real effect is temp. For detailed information on each purpose, see :ref:`database-volume-structure`. .. option:: -S, --SA-mode This option accesses the database in standalone mode without running the server process. This option has no parameter. If the **-S** option is not specified, the system assumes to be in client/server mode. :: cubrid addvoldb -S --db-volume-size=256M testdb .. option:: -C, --CS-mode This option accesses the database in client/server mode by running the server and the client separately. There is no parameter. Even when the **-C** option is not specified, the system assumes to be in client/server mode by default. :: cubrid addvoldb -C --db-volume-size=256M testdb .. option:: --max-writesize-in-sec=SIZE The **--max-writesize-in-sec** is used to limit the impact of system operating when you add a volume to the database. This can limit the maximum writing size per second. The unit of this option is K(kilobytes) and M(megabytes). The minimum value is 160K. If you set this value as less than 160K, it is changed as 160K. It can be used only in client/server mode. The below is an example to limit the writing size of the 2GB volume as 1MB. Consuming time will be about 35 minutes(= (2048MB/1MB) /60 sec.). :: cubrid addvoldb -C --db-volume-size=2G --max-writesize-in-sec=1M testdb .. _deleting-database: .. _deletedb: deletedb -------- The **cubrid deletedb** utility is used to delete a database. You must use the **cubrid deletedb** utility to delete a database, instead of using the file deletion commands of the operating system; a database consists of a few interdependent files. The **cubrid deletedb** utility also deletes the information on the database from the database location file (**databases.txt**). The **cubrid deletedb** utility must be run offline, that is, in standalone mode when nobody is using the database. :: cubrid deletedb [options] database_name * **cubrid**: An integrated utility for the CUBRID service and database management. * **deletedb**: A command to delete a database, its related data, logs and all backup files. It can be executed successfully only when the database is in a stopped state. * *database_name*: Specifies the name of the database to be deleted without including the path name. The following shows [options] available with the **cubrid deletedb** utility. .. program:: deletedb .. option:: -o, --output-file=FILE This option specifies the file name for writing messages:: cubrid deletedb -o deleted_db.out testdb The **cubrid** **deletedb** utility also deletes the database information contained in the database location file (**databases.txt**). The following message is returned if you enter a utility that tries to delete a non-existing database. :: cubrid deletedb testdb Database "testdb" is unknown, or the file "databases.txt" cannot be accessed. .. option:: -d, --delete-backup This option deletes database volumes, backup volumes and backup information files simultaneously. If the -**d** option is not specified, backup volume and backup information files are not deleted. :: cubrid deletedb -d testdb .. _renamedb: renamedb -------- The **cubrid renamedb** utility renames a database. The names of information volumes, log volumes and control files are also renamed to conform to the new database one. In contrast, the **cubrid alterdbhost** utility configures or changes the host name of the specified database. In other words, it changes the host name configuration in the **databases.txt** file. :: cubrid renamedb [options] src_database_name dest_database_name * **cubrid**: An integrated utility for the CUBRID service and database management. * **renamedb**: A command that changes the existing name of a database to a new one. It executes successfully only when the database is in a stopped state. The names of related information volumes, log volumes and control files are also changed to new ones accordingly. * *src_database_name*: The name of the existing database to be renamed. The path name to the directory where the database is to be created must not be included. * *dest_database_name*: The new name of the database. It must not be the same as that of an existing database. The path name to the directory where the database is to be created must not be included. The following shows [options] available with the **cubrid renamedb** utility. .. program:: renamedb .. option:: -E, --extended-volume-path=PATH This option renames an extended volume created in a specific directory path (e.g. /dbtemp/addvol/), and then moves the volume to a new directory. This specifies a new directory path (e.g. /dbtemp/newaddvols/) where the renamed extended volume will be moved. If it is not specified, the extended volume is only renamed in the existing path without being moved. If a directory path outside the disk partition of the existing database volume or an invalid one is specified, the rename operation is not executed. This option cannot be used together with the **-i** option. :: cubrid renamedb -E /dbtemp/newaddvols/ testdb testdb_1 .. option:: -i, --control-file=FILE The option specifies an input file in which directory information is stored to change all database name of volumes or files and assign different directory at once. To perform this work, the **-i** option is used. The **-i** option cannot be used together with the **-E** option. :: cubrid renamedb -i rename_path testdb testdb_1 The following are the syntax and example of a file that contains the name of each volume, the current directory path and the directory path where renamed volumes will be stored. :: volid source_fullvolname dest_fullvolname * *volid*: An integer that is used to identify each volume. It can be checked in the database volume control file (database_name_vinf). * *source_fullvolname*: The current directory path to each volume. * *dest_fullvolname*: The target directory path where renamed volumes will be moved. If the target directory path is invalid, the database rename operation is not executed. :: -5 /home1/user/testdb_vinf /home1/CUBRID/databases/testdb_1_vinf -4 /home1/user/testdb_lginf /home1/CUBRID/databases/testdb_1_lginf -3 /home1/user/testdb_bkvinf /home1/CUBRID/databases/testdb_1_bkvinf -2 /home1/user/testdb_lgat /home1/CUBRID/databases/testdb_1_lgat 0 /home1/user/testdb /home1/CUBRID/databases/testdb_1 1 /home1/user/backup/testdb_x001/home1/CUBRID/databases/backup/testdb_1_x001 .. option:: -d, --delete-backup This option renames the *testdb* database and at once forcefully delete all backup volumes and backup information files that are in the same location as *testdb*. Note that you cannot use the backup files with the old names once the database is renamed. If the **-d** option is not specified, backup volumes and backup information files are not deleted. :: cubrid renamedb -d testdb testdb_1 .. _alterdbhost: alterdbhost ----------- The **cubrid alterdbhost** utility sets or changes the host name of the specified database. It changes the host name set in the **databases.txt** file. :: cubrid alterdbhost [option] database_name * **cubrid**: An integrated utility for the CUBRID service and database management * **alterdbhost**: A command used to change the host name of the current database The following shows the option available with the **cubrid alterdbhost** utility. .. program:: alterdbhost .. option:: -h, --host=HOST The *-h* option specifies the host name to be changed. When this option is omitted, specifies the host name to localhost. .. _copydb: copydb ------ The **cubrid copydb** utility copy or move a database to another location. As arguments, source and target name of database must be given. A target database name must be different from a source database name. When the target name argument is specified, the location of target database name is registered in the **databases.txt** file. The **cubrid copydb** utility can be executed only offline (that is, state of a source database stop). :: cubrid copydb [options] src-database-name dest-database-name * **cubrid**: An integrated utility for the CUBRID service and database management. * **copydb**: A command that copy or move a database from one to another location. * *src-database-name*: The names of source and target databases to be copied or moved. * *dest-database-name*: A new (target) database name. If options are omitted, a target database is copied into the same directory of a source database. The following shows [options] available with the **cubrid copydb** utility. .. program:: copydb .. option:: --server-name=HOST The *--server-name* option specifies a host name of new database. The host name is registered in the **databases.txt** file. If this option is omitted, a local host is registered. :: cubrid copydb --server-name=cub_server1 demodb new_demodb .. option:: -F, --file-path=PATH The *-F* option specifies a specific directory path where a new database volume is stored with an **-F** option. It represents specifying an absolute path. If the specified directory does not exist, an error is displayed. If this option is omitted, a new database volume is created in the current working directory. And this information is specified in **vol-path** of the **databases.txt** file. :: cubrid copydb -F /home/usr/CUBRID/databases demodb new_demodb .. option:: -L, --log-path=PATH The *-L* option specifies a specific directory path where a new database volume is stored with an **-L** option. It represents specifying an absolute path. If the specified directory does not exist, an error is displayed. If this option is omitted, a new database volume is created in the current working directory. And this information is specified in **log-path** of the **databases.txt** file. :: cubrid copydb -L /home/usr/CUBRID/databases/logs demodb new_demodb .. option:: -E, --extended-volume-path=PATH The *-E* option specifies a specific directory path where a new database extended volume is stored with an **-E**. If this option is omitted, a new database extended volume is created in the location of a new database volume or in the registered path of controlling file. The **-i** option cannot be used with this option. :: cubrid copydb -E home/usr/CUBRID/databases/extvols demodb new_demodb .. option:: -i, --control-file=FILE The **-i** option specifies an input file where a new directory path information and a source volume are stored to copy or move multiple volumes into a different directory, respectively. This option cannot be used with the **-E** option. An input file named copy_path is specified in the example below. :: cubrid copydb -i copy_path demodb new_demodb The following is an example of input file that contains each volume name, current directory path, and new directory and volume names. :: # volid source_fullvolname dest_fullvolname 0 /usr/databases/demodb /drive1/usr/databases/new_demodb 1 /usr/databases/demodb_data1 /drive1/usr/databases/new_demodb_data1 2 /usr/databases/ext/demodb_ext1 /drive2//usr/databases/new_demodb_ext1 3 /usr/databases/ext/demodb_ext2 /drive2/usr/databases/new_demodb_ext2 * *volid*: An integer that is used to identify each volume. It can be checked in the database volume control file (**database_name_vinf**). * *source_fullvolname*: The current directory path to each source database volume. * *dest_fullvolname*: The target directory path where new volumes will be stored. You should specify a valid path. .. option:: -r, --replace If the **-r** option is specified, a new database name overwrites the existing database name if it is identical, instead of outputting an error. :: cubrid copydb -r -F /home/usr/CUBRID/databases demodb new_demodb .. option:: -d, --delete-source If the **-d** option is specified, a source database is deleted after the database is copied. This execution brings the same the result as executing **cubrid deletedb** utility after copying a database. Note that if a source database contains LOB data, LOB file directory path of a source database is copied into a new database and it is registered in the **lob-base-path** of the **databases.txt** file. :: cubrid copydb -d -F /home/usr/CUBRID/databases demodb new_demodb .. option:: --copy-lob-path=PATH If the **--copy-lob-path** option is specified, a new directory path for LOB files is created and a source database is copied into a new directory path. If this option is omitted, the directory path is not created. Therefore, the **lob-base-path** of the **databases.txt** file should be modified separately. This option cannot be used with the **-B** option. :: cubrid copydb --copy-lob-path demodb new_demodb .. option:: -B, --lob-base-path=PATH If the **-B** option is specified, a specified directory is specified as for LOB files of a new database and a source database is copied. This option cannot be used with the **--copy-lob-path** option. :: cubrid copydb -B /home/usr/CUBRID/databases/new_lob demodb new_demodb .. _installdb: installdb --------- The **cubrid installdb** utility is used to register the information of a newly installed database to **databases.txt**, which stores database location information. The execution of this utility does not affect the operation of the database to be registered. :: cubrid installdb [options] database_name * **cubrid**: An integrated utility for the CUBRID service and database management. * **installdb**: A command that registers the information of a moved or copied database to **databases.txt**. * *database_name*: The name of database to be registered to **databases.txt**. If no [options] are used, the command must be executed in the directory where the corresponding database exists. The following shows [options] available with the **cubrid installdb** utility. .. program:: installdb .. option:: --server-name=HOST This option registers the server host information of a database to **databases.txt** with a specific host name. If this is not specified, the current host information is registered. :: cubrid installdb --server-name=cub_server1 testdb .. option::-F, --file-path=PATH This option registers the absolute directory path of a database volume to **databases.txt** by using the **-F** option. If this option is not specified, the path of a current directory is registered as default. :: cubrid installdb -F /home/cubrid/CUBRID/databases/testdb testdb .. option:: -L, --log-path=PATH This option registers the absolute directory path of a database log volume to **databases.txt** by using the **-L** option. If this option is not specified, the directory path of a volume is registered. :: cubrid installdb -L /home/cubrid/CUBRID/databases/logs/testdb testdb .. include:: backup.inc .. include:: migration.inc .. _spacedb: spacedb ------- The **cubrid spacedb** utility is used to check how much space of database volumes is being used. The tool can show brief aggregated information on database space usage, or detailed descriptions of all volumes and files in use, based on its options. Information returned by the **cubrid spacedb** utility includes the volume ID's, names, purpose and total/free space of each volume. :: cubrid spacedb [options] database_name * **cubrid** : An integrated utility for the CUBRID service and database management. * **spacedb** : A command that checks the space in the database. It executes successfully only when the database is in a stopped state. * *database_name* : The name of the database whose space is to be checked. The path-name to the directory where the database is to be created must not be included. The following shows [options] available with the **cubrid spacedb** utility. .. program:: spacedb .. option:: -o FILE This option stores the result of checking the space information of *testdb* to a file named *db_output*. :: cubrid spacedb -o db_output testdb .. option:: -S, --SA-mode This option is used to access a database in standalone, which means it works without processing server; it does not have an argument. If **-S** is not specified, the system recognizes that a database is running in client/server mode. :: cubrid spacedb --SA-mode testdb .. option:: -C, --CS-mode This option is used to access a database in client/server mode, which means it works in client/server process respectively; it does not have an argument. If **-C** is not specified, the system recognize that a database is running in client/server mode by default. :: cubrid spacedb --CS-mode testdb .. option:: --size-unit={PAGE|M|G|T|H} This option specifies the size unit of the space information of the database to be one of PAGE, M(MB), G(GB), T(TB), H(print-friendly). The default value is **H**. If you set the value to H, the unit is automatically determined as follows: M if 1 MB = DB size < 1024 MB, G if 1 GB = DB size < 1024 GB. :: $ cubrid spacedb --size-unit=H testdb Space description for database 'testdb' with pagesize 16.0K. (log pagesize: 16.0K) type purpose volume_count used_size free_size total_size PERMANENT PERMANENT DATA 2 61.0 M 963.0 M 1.0 G PERMANENT TEMPORARY DATA 1 12.0 M 500.0 M 512.0 M TEMPORARY TEMPORARY DATA 1 40.0 M 88.0 M 128.0 M - - 4 113.0 M 1.5 G 1.6 G Space description for all volumes: volid type purpose used_size free_size total_size volume_name 0 PERMANENT PERMANENT DATA 60.0 M 452.0 M 512.0 M /home1/cubrid/testdb 1 PERMANENT PERMANENT DATA 1.0 M 511.0 M 512.0 M /home1/cubrid/testdb_x001 2 PERMANENT TEMPORARY DATA 12.0 M 500.0 M 512.0 M /home1/cubrid/testdb_x002 32766 TEMPORARY TEMPORARY DATA 40.0 M 88.0 M 128.0 M /home1/cubrid/testdb_t32766 LOB space description file:/home1/cubrid/lob .. option:: -s, --summarize This option aggregates volume count, used size, free size and total size by volume types and purposes. There are three classes of volumes: permanent volumes with permanent data, permanent volumes with temporary data and temporary volume with temporary data; no temporary volumes with permanent data. Last row shows the total values for all types of volumes. :: $ cubrid spacedb -s testdb Space description for database 'testdb' with pagesize 16.0K. (log pagesize: 16.0K) type purpose volume_count used_size free_size total_size PERMANENT PERMANENT DATA 2 61.0 M 963.0 M 1.0 G PERMANENT TEMPORARY DATA 1 12.0 M 500.0 M 512.0 M TEMPORARY TEMPORARY DATA 1 40.0 M 88.0 M 128.0 M - - 4 113.0 M 1.5 G 1.6 G .. option:: -p, --purpose This option shows detailed information on the purpose of stored data. The information includes number of files, used size, size of file tables, reserved sectors size and total size. :: Space description for database 'testdb' with pagesize 16.0K. (log pagesize: 16.0K) Detailed space description for files: data_type file_count used_size file_table_size reserved_size total_size INDEX 17 0.3 M 0.3 M 16.5 M 17.0 M HEAP 28 7.6 M 0.4 M 26.0 M 34.0 M SYSTEM 8 0.4 M 0.1 M 7.5 M 8.0 M TEMP 10 0.0 M 0.2 M 49.8 M 50.0 M - 63 8.2 M 1.0 M 99.8 M 109.0 M .. _compactdb: compactdb --------- The **cubrid compactdb** utility is used to secure unused space of the database volume. In case the database server is not running (offline), you can perform the job in standalone mode. In case the database server is running, you can perform it in client-server mode. .. note:: The **cubrid compactdb** utility secures the space being taken by OIDs of deleted objects and by class changes. When an object is deleted, the space taken by its OID is not immediately freed because there might be other objects that refer to the deleted one. Therefore, when you make a table to reuse OIDs, it is recommended to use a REUSE_OID option as below. .. code-block:: sql CREATE TABLE tbl REUSE_OID ( id INT PRIMARY KEY, b VARCHAR ); However, a table with a REUSE_OID option cannot be referred by the other table. That is, this table cannot be used as a type of the other table. .. code-block:: sql CREATE TABLE reuse_tbl (a INT PRIMARY KEY) REUSE_OID; CREATE TABLE tbl_1 ( a reuse_tbl); :: ERROR: The class 'reuse_tbl' is marked as REUSE_OID and is non-referable. Non-referable classes can't be the domain of an attribute and their instances' OIDs cannot be returned. To see details of REUSE_OID, please refer to :ref:`reuse-oid`. Reference to the object deleted during compacting is displayed as **NULL**, which means this can be reused by OIDs. :: cubrid compactdb [options] database_name [class_name], class_name2, ...] * **cubrid**: An integrated utility for the CUBRID service and database management. * **compactdb**: A command that compacts the space of the database so that OIDs assigned to deleted data can be reused. * *database_name*: The name of the database whose space is to be compacted. The path name to the directory where the database is to be created must not be included. * *class_name_list*: You can specify the list of tables names that you want to compact space after a database name; the **-i** option cannot be used together. If you use the lists on client/server mode, it skips securing space taken by objects such as catalog, delete files and tracker, etc. **-I**, **-c**, **-d**, **-p** options are applied in client/server mode only. The following shows [options] available with the **cubrid compactdb** utility. .. program:: compactdb .. option:: -v, --verbose You can output messages that shows which class is currently being compacted and how many instances have been processed for the class by using the **-v** option. :: cubrid compactdb -v testdb .. option:: -S, --SA-mode This option specifies to compact used space in standalone mode while database server is not running; no argument is specified. If the **-S** option is not specified, system recognizes that the job is executed in client/server mode. :: cubrid compactdb --SA-mode testdb .. option:: -C, --CS-mode This option specifies to compact used space in client/server mode while database server is running; no argument is specified. Even though this option is omitted, system recognizes that the job is executed in client/server mode. .. option:: -i, --input-class-file=FILE You can specify an input file name that contains the table name with this option. Write one table name in a single line; invalid table name is ignored. Note that you cannot specify the list of the table names after a database name in case of you use this option. If you use this option on client/server mode, it skips securing space taken by objects such as catalog, delete files and tracker, etc. The following options can be used in client/server mode only. .. option:: -p, --pages-commited-once=NUMBER You can specify the number of maximum pages that can be committed once with this option. The default value is 10, the minimum value is 1, and the maximum value is 10. The less option value is specified, the more concurrency is enhanced because the value for class/instance lock is small; however, it causes slowdown on operation, and vice versa. :: cubrid compactdb --CS-mode -p 10 testdb tbl1, tbl2, tbl5 .. option:: -d, --delete-old-repr You can delete an existing table representation (schema structure) from catalog with this option. Generally you'd better keep the existing table representation because schema updating cost will be saved when you keep the status as referring to the past schema for the old records. .. option:: -I, --Instance-lock-timeout=NUMBER You can specify a value of instance lock timeout with this option. The default value is 2 (seconds), the minimum value is 1, and the maximum value is 10. The less option value is specified, the more operation speeds up. However, the number of instances that can be processed becomes smaller, and vice versa. .. option:: -c, --class-lock-timeout=NUMBER You can specify a value of instance lock timeout with this option. The default value is 10 (seconds), the minimum value is 1, and the maximum value is 10. The less option value is specified, the more operation speeds up. However, the number of tables that can be processed becomes smaller, and vice versa. .. _optimizedb: optimizedb ---------- Updates statistical information such as the number of objects, the number of pages to access, and the distribution of attribute values. :: cubrid optimizedb [option] database_name * **cubrid**: An integrated utility for the CUBRID service and database management. * **optimizedb**: Updates the statistics information, which is used for cost-based query optimization of the database. If the option is specified, only the information of the specified class is updated. * *database_name*: The name of the database whose cost-based query optimization statistics are to be updated. The following shows [option] available with the **cubrid optimizedb** utility. .. program :: optimizedb .. option:: -n, --class-name The following example shows how to update the query statistics information of the given class by using the **-n** option. :: cubrid optimizedb -n event_table testdb The following example shows how to update the query statistics information of all classes in the database. :: cubrid optimizedb testdb .. _plandump: plandump -------- The **cubrid plandump** utility is used to display information on the query plans stored (cached) on the server. :: cubrid plandump [options] database_name * **cubrid**: An integrated utility for the CUBRID service and database management. * **plandump**: A utility that displays the query plans stored in the current cache of a specific database. * *database_name*: The name of the database where the query plans are to be checked or dropped from its server cache. If no option is used, it checks the query plans stored in the cache. :: cubrid plandump testdb The following shows [options] available with the **cubrid plandump** utility. .. program :: plandump .. option:: -d, --drop This option drops the query plans stored in the cache. :: cubrid plandump -d testdb .. option:: -o, --output-file=FILE This option stores the results of the query plans stored in the cache to a file. :: cubrid plandump -o output.txt testdb .. _statdump: statdump -------- **cubrid statdump** utility checks statistics information processed by the CUBRID database server. The statistics information mainly consists of the following: File I/O, Page buffer, Logs, Transactions, Concurrency/Lock, Index, and Network request. You can also use CSQL's session commands to check the statistics information only about the CSQL's connection. For details, see :ref:`Dumping CSQL execution statistics information `. :: cubrid statdump [options] database_name * **cubrid**: An integrated utility for the CUBRID service and database management. * **statdump**: A command that dumps the statistics information on the database server execution. * *database_name*: The name of database which has the statistics data to be dumped. The following shows [options] available with the **cubrid statdump** utility. .. program:: statdump .. option:: -i, --interval=SECOND This option specifies the periodic number of Dumping statistics as seconds. The following outputs the accumulated values per second. :: cubrid statdump -i 1 -c demodb The following outputs the accumulated values during 1 second, as starting with 0 value per every 1 second. :: cubrid statdump -i 1 demodb The following outputs the last values which were executed with **-i** option. :: cubrid statdump demodb The following outputs the same values with the above. **-c** option doesn't work if it is not used with **-i** option together. cubrid statdump -c demodb The following outputs the values per every 5 seconds. :: $ cubrid statdump -i 5 -c testdb Mon November 11 23:44:36 KST 2019 *** SERVER EXECUTION STATISTICS *** Num_file_creates = 0 Num_file_removes = 0 Num_file_ioreads = 0 Num_file_iowrites = 3 Num_file_iosynches = 3 The timer values for file_iosync_all are: Num_file_iosync_all = 0 Total_time_file_iosync_all = 0 Max_time_file_iosync_all = 0 Avg_time_file_iosync_all = 0 Num_file_page_allocs = 0 Num_file_page_deallocs = 0 Num_data_page_fetches = 0 Num_data_page_dirties = 0 Num_data_page_ioreads = 0 Num_data_page_iowrites = 0 Num_data_page_flushed = 0 Num_data_page_private_quota = 11327 Num_data_page_private_count = 0 Num_data_page_fixed = 1 Num_data_page_dirty = 0 Num_data_page_lru1 = 18 Num_data_page_lru2 = 10 Num_data_page_lru3 = 0 Num_data_page_victim_candidate = 0 Num_log_page_fetches = 0 Num_log_page_ioreads = 0 Num_log_page_iowrites = 6 Num_log_append_records = 9 Num_log_archives = 0 Num_log_start_checkpoints = 0 Num_log_end_checkpoints = 0 Num_log_wals = 0 Num_log_page_iowrites_for_replacement = 0 Num_log_page_replacements = 0 Num_page_locks_acquired = 0 Num_object_locks_acquired = 0 Num_page_locks_converted = 0 Num_object_locks_converted = 0 Num_page_locks_re-requested = 0 Num_object_locks_re-requested = 0 Num_page_locks_waits = 0 Num_object_locks_waits = 0 Num_object_locks_time_waited_usec = 0 Num_tran_commits = 0 Num_tran_rollbacks = 0 Num_tran_savepoints = 0 Num_tran_start_topops = 0 Num_tran_end_topops = 0 Num_tran_interrupts = 0 Num_btree_inserts = 0 Num_btree_deletes = 0 Num_btree_updates = 0 Num_btree_covered = 0 Num_btree_noncovered = 0 Num_btree_resumes = 0 Num_btree_multirange_optimization = 0 Num_btree_splits = 0 Num_btree_merges = 0 Num_btree_get_stats = 0 Num_btree_online_inserts = 0 Num_btree_online_inserts_same_page_hold = 0 Num_btree_online_inserts_reject_no_more_keys = 0 Num_btree_online_inserts_reject_max_key_len = 0 Num_btree_online_inserts_reject_no_space = 0 Num_btree_online_release_latch = 0 Num_btree_online_inserts_reject_key_not_in_range1 = 0 Num_btree_online_inserts_reject_key_not_in_range2 = 0 Num_btree_online_inserts_reject_key_not_in_range3 = 0 Num_btree_online_inserts_reject_key_not_in_range4 = 0 Num_btree_online_inserts_reject_key_false_failed_range1 = 0 Num_btree_online_inserts_reject_key_false_failed_range2 = 0 The timer values for btree_online are: Num_btree_online = 0 Total_time_btree_online = 0 Max_time_btree_online = 0 Avg_time_btree_online = 0 The timer values for btree_online_insert_task are: Num_btree_online_insert_task = 0 Total_time_btree_online_insert_task = 0 Max_time_btree_online_insert_task = 0 Avg_time_btree_online_insert_task = 0 The timer values for btree_online_prepare_task are: Num_btree_online_prepare_task = 0 Total_time_btree_online_prepare_task = 0 Max_time_btree_online_prepare_task = 0 Avg_time_btree_online_prepare_task = 0 The timer values for btree_online_insert_same_leaf are: Num_btree_online_insert_same_leaf = 0 Total_time_btree_online_insert_same_leaf = 0 Max_time_btree_online_insert_same_leaf = 0 Avg_time_btree_online_insert_same_leaf = 0 Num_query_selects = 0 Num_query_inserts = 0 Num_query_deletes = 0 Num_query_updates = 0 Num_query_sscans = 0 Num_query_iscans = 0 Num_query_lscans = 0 Num_query_setscans = 0 Num_query_methscans = 0 Num_query_nljoins = 0 Num_query_mjoins = 0 Num_query_objfetches = 0 Num_query_holdable_cursors = 0 Num_sort_io_pages = 0 Num_sort_data_pages = 0 Num_network_requests = 3 Num_adaptive_flush_pages = 0 Num_adaptive_flush_log_pages = 0 Num_adaptive_flush_max_pages = 14464 Num_prior_lsa_list_size = 0 Num_prior_lsa_list_maxed = 0 Num_prior_lsa_list_removed = 3 Time_ha_replication_delay = 0 Num_plan_cache_add = 0 Num_plan_cache_lookup = 0 Num_plan_cache_hit = 0 Num_plan_cache_miss = 0 Num_plan_cache_full = 0 Num_plan_cache_delete = 0 Num_plan_cache_invalid_xasl_id = 0 Num_plan_cache_entries = 0 Num_vacuum_log_pages_vacuumed = 0 Num_vacuum_log_pages_to_vacuum = 0 Num_vacuum_prefetch_requests_log_pages = 0 Num_vacuum_prefetch_hits_log_pages = 0 Num_heap_home_inserts = 0 Num_heap_big_inserts = 0 Num_heap_assign_inserts = 0 Num_heap_home_deletes = 0 Num_heap_home_mvcc_deletes = 0 Num_heap_home_to_rel_deletes = 0 Num_heap_home_to_big_deletes = 0 Num_heap_rel_deletes = 0 Num_heap_rel_mvcc_deletes = 0 Num_heap_rel_to_home_deletes = 0 Num_heap_rel_to_big_deletes = 0 Num_heap_rel_to_rel_deletes = 0 Num_heap_big_deletes = 0 Num_heap_big_mvcc_deletes = 0 Num_heap_home_updates = 0 Num_heap_home_to_rel_updates = 0 Num_heap_home_to_big_updates = 0 Num_heap_rel_updates = 0 Num_heap_rel_to_home_updates = 0 Num_heap_rel_to_rel_updates = 0 Num_heap_rel_to_big_updates = 0 Num_heap_big_updates = 0 Num_heap_home_vacuums = 0 Num_heap_big_vacuums = 0 Num_heap_rel_vacuums = 0 Num_heap_insid_vacuums = 0 Num_heap_remove_vacuums = 0 The timer values for heap_insert_prepare are: Num_heap_insert_prepare = 0 Total_time_heap_insert_prepare = 0 Max_time_heap_insert_prepare = 0 Avg_time_heap_insert_prepare = 0 The timer values for heap_insert_execute are: Num_heap_insert_execute = 0 Total_time_heap_insert_execute = 0 Max_time_heap_insert_execute = 0 Avg_time_heap_insert_execute = 0 The timer values for heap_insert_log are: Num_heap_insert_log = 0 Total_time_heap_insert_log = 0 Max_time_heap_insert_log = 0 Avg_time_heap_insert_log = 0 The timer values for heap_delete_prepare are: Num_heap_delete_prepare = 0 Total_time_heap_delete_prepare = 0 Max_time_heap_delete_prepare = 0 Avg_time_heap_delete_prepare = 0 The timer values for heap_delete_execute are: Num_heap_delete_execute = 0 Total_time_heap_delete_execute = 0 Max_time_heap_delete_execute = 0 Avg_time_heap_delete_execute = 0 The timer values for heap_delete_log are: Num_heap_delete_log = 0 Total_time_heap_delete_log = 0 Max_time_heap_delete_log = 0 Avg_time_heap_delete_log = 0 The timer values for heap_update_prepare are: Num_heap_update_prepare = 0 Total_time_heap_update_prepare = 0 Max_time_heap_update_prepare = 0 Avg_time_heap_update_prepare = 0 The timer values for heap_update_execute are: Num_heap_update_execute = 0 Total_time_heap_update_execute = 0 Max_time_heap_update_execute = 0 Avg_time_heap_update_execute = 0 The timer values for heap_update_log are: Num_heap_update_log = 0 Total_time_heap_update_log = 0 Max_time_heap_update_log = 0 Avg_time_heap_update_log = 0 The timer values for heap_vacuum_prepare are: Num_heap_vacuum_prepare = 0 Total_time_heap_vacuum_prepare = 0 Max_time_heap_vacuum_prepare = 0 Avg_time_heap_vacuum_prepare = 0 The timer values for heap_vacuum_execute are: Num_heap_vacuum_execute = 0 Total_time_heap_vacuum_execute = 0 Max_time_heap_vacuum_execute = 0 Avg_time_heap_vacuum_execute = 0 The timer values for heap_vacuum_log are: Num_heap_vacuum_log = 0 Total_time_heap_vacuum_log = 0 Max_time_heap_vacuum_log = 0 Avg_time_heap_vacuum_log = 0 The timer values for heap_stats_sync_bestspace are: Num_heap_stats_sync_bestspace = 0 Total_time_heap_stats_sync_bestspace = 0 Max_time_heap_stats_sync_bestspace = 0 Avg_time_heap_stats_sync_bestspace = 0 Num_heap_stats_bestspace_entries = 0 Num_heap_stats_bestspace_maxed = 0 The timer values for bestspace_add are: Num_bestspace_add = 0 Total_time_bestspace_add = 0 Max_time_bestspace_add = 0 Avg_time_bestspace_add = 0 The timer values for bestspace_del are: Num_bestspace_del = 0 Total_time_bestspace_del = 0 Max_time_bestspace_del = 0 Avg_time_bestspace_del = 0 The timer values for bestspace_find are: Num_bestspace_find = 0 Total_time_bestspace_find = 0 Max_time_bestspace_find = 0 Avg_time_bestspace_find = 0 The timer values for heap_find_page_bestspace are: Num_heap_find_page_bestspace = 0 Total_time_heap_find_page_bestspace = 0 Max_time_heap_find_page_bestspace = 0 Avg_time_heap_find_page_bestspace = 0 The timer values for heap_find_best_page are: Num_heap_find_best_page = 0 Total_time_heap_find_best_page = 0 Max_time_heap_find_best_page = 0 Avg_time_heap_find_best_page = 0 The timer values for bt_fix_ovf_oids are: Num_bt_fix_ovf_oids = 0 Total_time_bt_fix_ovf_oids = 0 Max_time_bt_fix_ovf_oids = 0 Avg_time_bt_fix_ovf_oids = 0 The timer values for bt_unique_rlocks are: Num_bt_unique_rlocks = 0 Total_time_bt_unique_rlocks = 0 Max_time_bt_unique_rlocks = 0 Avg_time_bt_unique_rlocks = 0 The timer values for bt_unique_wlocks are: Num_bt_unique_wlocks = 0 Total_time_bt_unique_wlocks = 0 Max_time_bt_unique_wlocks = 0 Avg_time_bt_unique_wlocks = 0 The timer values for bt_leaf are: Num_bt_leaf = 0 Total_time_bt_leaf = 0 Max_time_bt_leaf = 0 Avg_time_bt_leaf = 0 The timer values for bt_traverse are: Num_bt_traverse = 0 Total_time_bt_traverse = 0 Max_time_bt_traverse = 0 Avg_time_bt_traverse = 0 The timer values for bt_find_unique are: Num_bt_find_unique = 0 Total_time_bt_find_unique = 0 Max_time_bt_find_unique = 0 Avg_time_bt_find_unique = 0 The timer values for bt_find_unique_traverse are: Num_bt_find_unique_traverse = 0 Total_time_bt_find_unique_traverse = 0 Max_time_bt_find_unique_traverse = 0 Avg_time_bt_find_unique_traverse = 0 The timer values for bt_range_search are: Num_bt_range_search = 0 Total_time_bt_range_search = 0 Max_time_bt_range_search = 0 Avg_time_bt_range_search = 0 The timer values for bt_range_search_traverse are: Num_bt_range_search_traverse = 0 Total_time_bt_range_search_traverse = 0 Max_time_bt_range_search_traverse = 0 Avg_time_bt_range_search_traverse = 0 The timer values for bt_insert are: Num_bt_insert = 0 Total_time_bt_insert = 0 Max_time_bt_insert = 0 Avg_time_bt_insert = 0 The timer values for bt_insert_traverse are: Num_bt_insert_traverse = 0 Total_time_bt_insert_traverse = 0 Max_time_bt_insert_traverse = 0 Avg_time_bt_insert_traverse = 0 The timer values for bt_delete_obj are: Num_bt_delete_obj = 0 Total_time_bt_delete_obj = 0 Max_time_bt_delete_obj = 0 Avg_time_bt_delete_obj = 0 The timer values for bt_delete_obj_traverse are: Num_bt_delete_obj_traverse = 0 Total_time_bt_delete_obj_traverse = 0 Max_time_bt_delete_obj_traverse = 0 Avg_time_bt_delete_obj_traverse = 0 The timer values for bt_mvcc_delete are: Num_bt_mvcc_delete = 0 Total_time_bt_mvcc_delete = 0 Max_time_bt_mvcc_delete = 0 Avg_time_bt_mvcc_delete = 0 The timer values for bt_mvcc_delete_traverse are: Num_bt_mvcc_delete_traverse = 0 Total_time_bt_mvcc_delete_traverse = 0 Max_time_bt_mvcc_delete_traverse = 0 Avg_time_bt_mvcc_delete_traverse = 0 The timer values for bt_mark_delete are: Num_bt_mark_delete = 0 Total_time_bt_mark_delete = 0 Max_time_bt_mark_delete = 0 Avg_time_bt_mark_delete = 0 The timer values for bt_mark_delete_traverse are: Num_bt_mark_delete_traverse = 0 Total_time_bt_mark_delete_traverse = 0 Max_time_bt_mark_delete_traverse = 0 Avg_time_bt_mark_delete_traverse = 0 The timer values for bt_undo_insert are: Num_bt_undo_insert = 0 Total_time_bt_undo_insert = 0 Max_time_bt_undo_insert = 0 Avg_time_bt_undo_insert = 0 The timer values for bt_undo_insert_traverse are: Num_bt_undo_insert_traverse = 0 Total_time_bt_undo_insert_traverse = 0 Max_time_bt_undo_insert_traverse = 0 Avg_time_bt_undo_insert_traverse = 0 The timer values for bt_undo_delete are: Num_bt_undo_delete = 0 Total_time_bt_undo_delete = 0 Max_time_bt_undo_delete = 0 Avg_time_bt_undo_delete = 0 The timer values for bt_undo_delete_traverse are: Num_bt_undo_delete_traverse = 0 Total_time_bt_undo_delete_traverse = 0 Max_time_bt_undo_delete_traverse = 0 Avg_time_bt_undo_delete_traverse = 0 The timer values for bt_undo_mvcc_delete are: Num_bt_undo_mvcc_delete = 0 Total_time_bt_undo_mvcc_delete = 0 Max_time_bt_undo_mvcc_delete = 0 Avg_time_bt_undo_mvcc_delete = 0 The timer values for bt_undo_mvcc_delete_traverse are: Num_bt_undo_mvcc_delete_traverse = 0 Total_time_bt_undo_mvcc_delete_traverse = 0 Max_time_bt_undo_mvcc_delete_traverse = 0 Avg_time_bt_undo_mvcc_delete_traverse = 0 The timer values for bt_vacuum are: Num_bt_vacuum = 0 Total_time_bt_vacuum = 0 Max_time_bt_vacuum = 0 Avg_time_bt_vacuum = 0 The timer values for bt_vacuum_traverse are: Num_bt_vacuum_traverse = 0 Total_time_bt_vacuum_traverse = 0 Max_time_bt_vacuum_traverse = 0 Avg_time_bt_vacuum_traverse = 0 The timer values for bt_vacuum_insid are: Num_bt_vacuum_insid = 0 Total_time_bt_vacuum_insid = 0 Max_time_bt_vacuum_insid = 0 Avg_time_bt_vacuum_insid = 0 The timer values for bt_vacuum_insid_traverse are: Num_bt_vacuum_insid_traverse = 0 Total_time_bt_vacuum_insid_traverse = 0 Max_time_bt_vacuum_insid_traverse = 0 Avg_time_bt_vacuum_insid_traverse = 0 The timer values for vacuum_master are: Num_vacuum_master = 561 Total_time_vacuum_master = 1259 Max_time_vacuum_master = 6 Avg_time_vacuum_master = 2 The timer values for vacuum_job are: Num_vacuum_job = 0 Total_time_vacuum_job = 0 Max_time_vacuum_job = 0 Avg_time_vacuum_job = 0 The timer values for vacuum_worker_process_log are: Num_vacuum_worker_process_log = 0 Total_time_vacuum_worker_process_log = 0 Max_time_vacuum_worker_process_log = 0 Avg_time_vacuum_worker_process_log = 0 The timer values for vacuum_worker_execute are: Num_vacuum_worker_execute = 0 Total_time_vacuum_worker_execute = 0 Max_time_vacuum_worker_execute = 0 Avg_time_vacuum_worker_execute = 0 Time_get_snapshot_acquire_time = 0 Count_get_snapshot_retry = 0 Time_tran_complete_time = 0 The timer values for compute_oldest_visible are: Num_compute_oldest_visible = 561 Total_time_compute_oldest_visible = 569 Max_time_compute_oldest_visible = 4 Avg_time_compute_oldest_visible = 1 Count_get_oldest_mvcc_retry = 0 Data_page_buffer_hit_ratio = 0.00 Log_page_buffer_hit_ratio = 0.00 Vacuum_data_page_buffer_hit_ratio = 0.00 Vacuum_page_efficiency_ratio = 0.00 Vacuum_page_fetch_ratio = 0.00 Data_page_fix_lock_acquire_time_msec = 0.00 Data_page_fix_hold_acquire_time_msec = 0.00 Data_page_fix_acquire_time_msec = 0.00 Data_page_allocate_time_ratio = 0.00 Data_page_total_promote_success = 0.00 Data_page_total_promote_fail = 0.00 Data_page_total_promote_time_msec = 0.00 Num_unfix_void_to_private_top = 0 Num_unfix_void_to_private_mid = 0 Num_unfix_void_to_shared_mid = 0 Num_unfix_lru1_private_to_shared_mid = 0 Num_unfix_lru2_private_to_shared_mid = 0 Num_unfix_lru3_private_to_shared_mid = 0 Num_unfix_lru2_private_keep = 0 Num_unfix_lru2_shared_keep = 0 Num_unfix_lru2_private_to_top = 0 Num_unfix_lru2_shared_to_top = 0 Num_unfix_lru3_private_to_top = 0 Num_unfix_lru3_shared_to_top = 0 Num_unfix_lru1_private_keep = 0 Num_unfix_lru1_shared_keep = 0 Num_unfix_void_to_private_mid_vacuum = 0 Num_unfix_lru1_any_keep_vacuum = 0 Num_unfix_lru2_any_keep_vacuum = 0 Num_unfix_lru3_any_keep_vacuum = 0 Num_unfix_void_aout_found = 0 Num_unfix_void_aout_not_found = 0 Num_unfix_void_aout_found_vacuum = 0 Num_unfix_void_aout_not_found_vacuum = 0 Num_data_page_hash_anchor_waits = 0 Time_data_page_hash_anchor_wait = 0 The timer values for flush_collect are: Num_flush_collect = 0 Total_time_flush_collect = 0 Max_time_flush_collect = 0 Avg_time_flush_collect = 0 The timer values for flush_flush are: Num_flush_flush = 0 Total_time_flush_flush = 0 Max_time_flush_flush = 0 Avg_time_flush_flush = 0 The timer values for flush_sleep are: Num_flush_sleep = 4 Total_time_flush_sleep = 4000307 Max_time_flush_sleep = 1000077 Avg_time_flush_sleep = 1000076 The timer values for flush_collect_per_page are: Num_flush_collect_per_page = 0 Total_time_flush_collect_per_page = 0 Max_time_flush_collect_per_page = 0 Avg_time_flush_collect_per_page = 0 The timer values for flush_flush_per_page are: Num_flush_flush_per_page = 0 Total_time_flush_flush_per_page = 0 Max_time_flush_flush_per_page = 0 Avg_time_flush_flush_per_page = 0 Num_data_page_writes = 0 Num_data_page_dirty_to_post_flush = 0 Num_data_page_skipped_flush = 0 Num_data_page_skipped_flush_need_wal = 0 Num_data_page_skipped_flush_already_flushed = 0 Num_data_page_skipped_flush_fixed_or_hot = 0 The timer values for compensate_flush are: Num_compensate_flush = 0 Total_time_compensate_flush = 0 Max_time_compensate_flush = 0 Avg_time_compensate_flush = 0 The timer values for assign_direct_bcb are: Num_assign_direct_bcb = 0 Total_time_assign_direct_bcb = 0 Max_time_assign_direct_bcb = 0 Avg_time_assign_direct_bcb = 0 The timer values for wake_flush_waiter are: Num_wake_flush_waiter = 0 Total_time_wake_flush_waiter = 0 Max_time_wake_flush_waiter = 0 Avg_time_wake_flush_waiter = 0 The timer values for alloc_bcb are: Num_alloc_bcb = 0 Total_time_alloc_bcb = 0 Max_time_alloc_bcb = 0 Avg_time_alloc_bcb = 0 The timer values for alloc_bcb_search_victim are: Num_alloc_bcb_search_victim = 0 Total_time_alloc_bcb_search_victim = 0 Max_time_alloc_bcb_search_victim = 0 Avg_time_alloc_bcb_search_victim = 0 The timer values for alloc_bcb_cond_wait_high_prio are: Num_alloc_bcb_cond_wait_high_prio = 0 Total_time_alloc_bcb_cond_wait_high_prio = 0 Max_time_alloc_bcb_cond_wait_high_prio = 0 Avg_time_alloc_bcb_cond_wait_high_prio = 0 The timer values for alloc_bcb_cond_wait_low_prio are: Num_alloc_bcb_cond_wait_low_prio = 0 Total_time_alloc_bcb_cond_wait_low_prio = 0 Max_time_alloc_bcb_cond_wait_low_prio = 0 Avg_time_alloc_bcb_cond_wait_low_prio = 0 Num_alloc_bcb_prioritize_vacuum = 0 Num_victim_use_invalid_bcb = 0 The timer values for alloc_bcb_get_victim_search_own_private_list are: Num_alloc_bcb_get_victim_search_own_private_list = 0 Total_time_alloc_bcb_get_victim_search_own_private_list = 0 Max_time_alloc_bcb_get_victim_search_own_private_list = 0 Avg_time_alloc_bcb_get_victim_search_own_private_list = 0 The timer values for alloc_bcb_get_victim_search_others_private_list are: Num_alloc_bcb_get_victim_search_others_private_list = 0 Total_time_alloc_bcb_get_victim_search_others_private_list = 0 Max_time_alloc_bcb_get_victim_search_others_private_list = 0 Avg_time_alloc_bcb_get_victim_search_others_private_list = 0 The timer values for alloc_bcb_get_victim_search_shared_list are: Num_alloc_bcb_get_victim_search_shared_list = 0 Total_time_alloc_bcb_get_victim_search_shared_list = 0 Max_time_alloc_bcb_get_victim_search_shared_list = 0 Avg_time_alloc_bcb_get_victim_search_shared_list = 0 Num_victim_assign_direct_vacuum_void = 0 Num_victim_assign_direct_vacuum_lru = 0 Num_victim_assign_direct_flush = 0 Num_victim_assign_direct_panic = 0 Num_victim_assign_direct_adjust_lru = 0 Num_victim_assign_direct_adjust_lru_to_vacuum = 0 Num_victim_assign_direct_search_for_flush = 0 Num_victim_shared_lru_success = 0 Num_victim_own_private_lru_success = 0 Num_victim_other_private_lru_success = 0 Num_victim_shared_lru_fail = 0 Num_victim_own_private_lru_fail = 0 Num_victim_other_private_lru_fail = 0 Num_victim_all_lru_fail = 0 Num_victim_get_from_lru = 0 Num_victim_get_from_lru_was_empty = 0 Num_victim_get_from_lru_fail = 0 Num_victim_get_from_lru_bad_hint = 0 Num_lfcq_prv_get_total_calls = 0 Num_lfcq_prv_get_empty = 0 Num_lfcq_prv_get_big = 0 Num_lfcq_shr_get_total_calls = 0 Num_lfcq_shr_get_empty = 0 The timer values for Time_DWB_flush_block_time are: Num_Time_DWB_flush_block_time = 0 Total_time_Time_DWB_flush_block_time = 0 Max_time_Time_DWB_flush_block_time = 0 Avg_time_Time_DWB_flush_block_time = 0 The timer values for Time_DWB_flush_block_helper_time are: Num_Time_DWB_flush_block_helper_time = 0 Total_time_Time_DWB_flush_block_helper_time = 0 Max_time_Time_DWB_flush_block_helper_time = 0 Avg_time_Time_DWB_flush_block_helper_time = 0 The timer values for Time_DWB_flush_block_cond_wait_time are: Num_Time_DWB_flush_block_cond_wait_time = 5352 Total_time_Time_DWB_flush_block_cond_wait_time = 5629578 Max_time_Time_DWB_flush_block_cond_wait_time = 1059 Avg_time_Time_DWB_flush_block_cond_wait_time = 1051 The timer values for Time_DWB_flush_block_sort_time are: Num_Time_DWB_flush_block_sort_time = 0 Total_time_Time_DWB_flush_block_sort_time = 0 Max_time_Time_DWB_flush_block_sort_time = 0 Avg_time_Time_DWB_flush_block_sort_time = 0 The timer values for Time_DWB_flush_remove_hash_entries are: Num_Time_DWB_flush_remove_hash_entries = 0 Total_time_Time_DWB_flush_remove_hash_entries = 0 Max_time_Time_DWB_flush_remove_hash_entries = 0 Avg_time_Time_DWB_flush_remove_hash_entries = 0 The timer values for Time_DWB_checksum_time are: Num_Time_DWB_checksum_time = 0 Total_time_Time_DWB_checksum_time = 0 Max_time_Time_DWB_checksum_time = 0 Avg_time_Time_DWB_checksum_time = 0 The timer values for Time_DWB_wait_flush_block_time are: Num_Time_DWB_wait_flush_block_time = 0 Total_time_Time_DWB_wait_flush_block_time = 0 Max_time_Time_DWB_wait_flush_block_time = 0 Avg_time_Time_DWB_wait_flush_block_time = 0 The timer values for Time_DWB_wait_flush_block_helper_time are: Num_Time_DWB_wait_flush_block_helper_time = 0 Total_time_Time_DWB_wait_flush_block_helper_time = 0 Max_time_Time_DWB_wait_flush_block_helper_time = 0 Avg_time_Time_DWB_wait_flush_block_helper_time = 0 The timer values for Time_DWB_flush_force_time are: Num_Time_DWB_flush_force_time = 0 Total_time_Time_DWB_flush_force_time = 0 Max_time_Time_DWB_flush_force_time = 0 Avg_time_Time_DWB_flush_force_time = 0 Num_alloc_bcb_wait_threads_high_priority = 0 Num_alloc_bcb_wait_threads_low_priority = 0 Num_flushed_bcbs_wait_for_direct_victim = 0 Num_lfcq_big_private_lists = 0 Num_lfcq_private_lists = 0 Num_lfcq_shared_lists = 0 Num_data_page_avoid_dealloc = 0 Num_data_page_avoid_victim = 0 Num_data_page_fix_ext: Num_data_page_promote_ext: Num_data_page_promote_time_ext: Num_data_page_unfix_ext: Time_data_page_lock_acquire_time: Time_data_page_hold_acquire_time: Time_data_page_fix_acquire_time: Num_mvcc_snapshot_ext: Time_obj_lock_acquire_time: Thread_stats_counters_timers: Thread_pgbuf_daemon_stats_counters_timers: Num_dwb_flushed_block_volumes: Thread_loaddb_stats_counters_timers: The following are the explanation about the above statistical information. You can find the statistic category (database module), the name, the stat type and a brief description for each statistic. There are several types of statistic, based on how they are collected: * Accumulator: The stat values are incremented whenever the tracked action happens. * Counter/timer: The stat tracks both the number and the duration of an action. Also biggest and average duration are tracked. * Snapshot: The stat is peeked from database. * Complex: The stat tracks multiple values for an action, separated by various attributes. Most statistics are accumulators (they are incremented when an action happens). Other statistics can be counter/timers (they track both number of actions and their duration), some are peeked from database (snapshot) and some are computed based on other values. Lastly, there are several complex statistics which track detailed information on some operations. **File I/O** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_file_removes | Accumulator | The number of files removed | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_file_creates | Accumulator | The number of files created | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_file_ioreads | Accumulator | The number of files read | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_file_iowrites | Accumulator | The number of files stored | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_file_iosynches | Accumulator | The number of file synchronization | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..file_iosync_all | Counter/timer | The number and duration of sync all files | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_file_page_allocs | Accumulator | The number of page allocations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_file_page_deallocs | Accumulator | The number of page deallocations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Page Buffer** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_fetches | Accumulator | The number of fetched pages | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_dirties | Accumulator | The number of dirty pages | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_ioreads | Accumulator | | The number of pages read from disk | | | | | (more means less efficient, it correlates with lower hit ratio) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_iowrites | Accumulator | The number of pages write to disk (more means less efficient) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_private_quota | Snapshot | The target number of pages for private LRU lists | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_private_count | Snapshot | The actual number of pages for private LRU lists | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_fixed | Snapshot | The number of fixed pages in data buffer | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_dirty | Snapshot | The number of dirty pages in data buffer | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_lru1 | Snapshot | The number of pages in LRU1 zone in data buffer | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_lru2 | Snapshot | The number of pages in LRU2 zone in data buffer | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_lru3 | Snapshot | The number of pages in LRU3 zone in data buffer | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_victim_candidate | Snapshot | | The number of victim candidate pages in data buffer | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Logs** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_log_page_fetches | Accumulator | The number of fetched log pages | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_log_page_ioreads | Accumulator | The number of log pages read | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_log_page_iowrites | Accumulator | The number of log pages stored | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_log_append_records | Accumulator | The number of log records appended | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_log_archives | Accumulator | The number of logs archived | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_log_start_checkpoints | Accumulator | The number of started checkpoints | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_log_end_checkpoints | Accumulator | The number of ended checkpoints | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_log_wals | Accumulator | The number of log flushes requested to write a data page. | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_log_page_iowrites_for_replacement | Accumulator | | The number of log data pages written to disk due to replacements | | | | | (should be zero) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_log_page_replacements | Accumulator | The number of log data pages discarded due to replacements | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_prior_lsa_list_size | Accumulator | | Current size of the prior LSA(Log Sequence Address) list. | | | | | CUBRID write the order of writing into the prior LSA list, before | | | | | writing operation from the log buffer to the disk; this list is | | | | | used to raise up the concurrency by reducing the waiting time of | | | | | the transaction from writing to disk | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_prior_lsa_list_maxed | Accumulator | | The count of the prior LSA list being reached at the maximum size. | | | | | The maximum size of the prior LSA list is log_buffer_size * 2. | | | | | If this value is big, we can assume that log writing jobs happen a | | | | | lot at the same time | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_prior_lsa_list_removed | Accumulator | | The count of LSA being moved from prior LSA list into log buffer. | | | | | We can assume that the commits have happened at the similar count | | | | | with this value | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Log_page_buffer_hit_ratio | Computed | | Hit ratio of log page buffers | | | | | (Num_log_page_fetches - Num_log_page_fetch_ioreads)*100 | | | | | / Num_log_page_fetches | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Concurrency/lock** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_page_locks_acquired | Accumulator | The number of locked pages acquired | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_object_locks_acquired | Accumulator | The number of locked objects acquired | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_page_locks_converted | Accumulator | The number of locked pages converted | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_object_locks_converted | Accumulator | The number of locked objects converted | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_page_locks_re-requested | Accumulator | The number of locked pages requested | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_object_locks_re-requested | Accumulator | The number of locked objects requested | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_page_locks_waits | Accumulator | The number of locked pages waited | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_object_locks_waits | Accumulator | The number of locked objects waited | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_object_locks_time_waited_usec | Accumulator | The time in microseconds spent on waiting for all object locks | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Time_obj_lock_acquire_time | Complex | Time consumer for locking objects classified by lock mode | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Transactions** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_tran_commits | Accumulator | The number of commits | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_tran_rollbacks | Accumulator | The number of rollbacks | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_tran_savepoints | Accumulator | The number of savepoints | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_tran_start_topops | Accumulator | The number of top operations started | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_tran_end_topops | Accumulator | The number of top operations stopped | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_tran_interrupts | Accumulator | The number of interruptions | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_tran_postpone_cache_hits | Accumulator | The number of cache hits when executing transaction postpone ops | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_tran_postpone_cache_miss | Accumulator | | The number of cache misses when executing transaction postpone ops | | | | | Cache misses may degrade performance of transaction commits and | | | | | may impact all log operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_tran_topop_postpone_cache_hits | Accumulator | The number of cache hits when executing top operations postpone ops | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_tran_topop_postpone_cache_miss | Accumulator | | The number of cache misses when executing top operations postpone | | | | | Cache misses may degrade performance of top operations commits and | | | | | may impact all log operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Index** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_btree_inserts | Accumulator | The number of nodes inserted | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_btree_deletes | Accumulator | The number of nodes deleted | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_btree_updates | Accumulator | The number of nodes updated | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_btree_covered | Accumulator | | The number of cases in which an index includes all data upon query | | | | | execution | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_btree_noncovered | Accumulator | | The number of cases in which an index includes some or no data upon | | | | | query execution | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_btree_resumes | Accumulator | | The exceeding number of index scan specified due to too many | | | | | results | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_btree_multirange_optimization | Accumulator | | The number of executions on multi-range optimization for the | | | | | WHERE ... IN ... LIMIT condition query statement | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_btree_splits | Accumulator | The number of B-tree split-operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_btree_merges | Accumulator | The number of B-tree merge-operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_btree_get_stats | Accumulator | The number of B-tree get stat calls | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_leaf | Counter/timer | The number and duration of all operations in index leaves | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_find_unique | Counter/timer | The number and duration of B-tree 'find-unique' operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..btrange_search | Counter/timer | The number and duration of B-tree 'range-search' operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_insert_obj | Counter/timer | The number and duration of B-tree 'insert object' operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_delete_obj | Counter/timer | The number and duration of B-tree 'physical delete object' operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_mvcc_delete | Counter/timer | The number and duration of B-tree 'mvcc delete' operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_mark_delete | Counter/timer | The number and duration of B-tree mark delete operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_undo_insert | Counter/timer | The number and duration of B-tree 'undo insert' operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_undo_delete | Counter/timer | The number and duration of B-tree 'undo physical delete' operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_undo_mvcc_delete | Counter/timer | The number and duration of B-tree 'undo mvcc delete' operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_vacuum | Counter/timer | The number and duration of B-tree vacuum deleted object operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_vacuum_insid | Counter/timer | The number and duration of vacuum operations on B-tree 'insert id' | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_fix_ovf_oids | Counter/timer | The number and duration of B-tree overflow page fixes | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_unique_rlocks | Counter/timer | The number and duration of blocked read locks on unique indexes | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_unique_wlocks | Counter/timer | The number and duration of blocked write locks on unique indexes | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_traverse | Counter/timer | The number and duration of B-tree traverse | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_find_unique_traverse | Counter/timer | The number and duration of B-tree traverse for 'find unique' | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_range_search_traverse | Counter/timer | The number and duration of B-tree traverse for 'range search' | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_insert_traverse | Counter/timer | The number and duration of B-tree traverse for 'insert' | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_delete_traverse | Counter/timer | The number and duration of B-tree traverse for 'physical delete' | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_mvcc_delete_traverse | Counter/timer | The number and duration of B-tree traverse for 'mvcc delete' | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_mark_delete_traverse | Counter/timer | The number and duration of B-tree traverse for 'mark delete' | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_undo_insert_traverse | Counter/timer | The number and duration of B-tree traverse for 'undo physical insert' | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_undo_delete_traverse | Counter/timer | The number and duration of B-tree traverse for 'undo physical delete' | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_undo_mvcc_delete_traverse | Counter/timer | The number and duration of B-tree traverse for 'undo delete' | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_vacuum_traverse | Counter/timer | The number and duration of B-tree traverse for vacuum deleted object | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bt_vacuum_insid_traverse | Counter/timer | The number and duration of B-tree traverse for vacuum 'insert id' | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Load Index Online** +----------------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +----------------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..btree_online_load | Counter/timer | The number and duration of B-tree online index loading statements | +----------------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..btree_online_insert_task | Counter/timer | The number and duration of batch insert tasks by index loader | +----------------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..btree_online_prepare_task | Counter/timer | The number and duration of preparing (sorting) index loader tasks | +----------------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..btree_online_insert_leaf | Counter/timer | | The number and duration of leaf pages processed by index loader | | | | | (multiple keys may be inserted while a leaf page is processed) | +----------------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_btree_online_inserts | Accumulator | The number of key inserts by index loader | +----------------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_btree_online_inserts_same_page_hold | Accumulator | | The number of successive inserts by index loader in same leaf page | | | | | (loader optimization to avoid expensive index traversals) | +----------------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_btree_online_inserts_retry | Accumulator | | The number of restarted inserts because successive keys do not | | | | | belong to same leaf or because there is not enough space | +----------------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_btree_online_inserts_retry_nice | Accumulator | The number of restarted inserts to let others access leaf page | +----------------------------------------------------+----------------+-----------------------------------------------------------------------+ **Query** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_query_selects | Accumulator | The number of SELECT query execution | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_query_inserts | Accumulator | The number of INSERT query execution | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_query_deletes | Accumulator | The number of DELETE query execution | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_query_updates | Accumulator | The number of UPDATE query execution | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_query_sscans | Accumulator | The number of sequential scans (full scan) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_query_iscans | Accumulator | The number of index scans | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_query_lscans | Accumulator | The number of LIST scans | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_query_setscans | Accumulator | The number of SET scans | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_query_methscans | Accumulator | The number of METHOD scans | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_query_nljoins | Accumulator | The number of nested loop joins | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_query_mjoins | Accumulator | The number of parallel joins | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_query_objfetches | Accumulator | The number of fetch objects | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_query_holdable_cursors | Snapshot | The number of holdable cursors in the current server. | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Sort** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_sort_io_pages | Accumulator | | The number of pages fetched on the disk during sorting | | | | | (more means less efficient) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_sort_data_pages | Accumulator | | The number of pages found on the page buffer during sorting | | | | | (more means less efficient) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Network** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_network_requests | Accumulator | The number of network requested | | | | | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Heap** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_stats_sync_bestspace | Accumulator | | The updated number of the "best page" list. | | | | | | | | | "Best pages" means that the data pages of which the free space is | | | | | more than 30% in the environment of multiple INSERTs and DELETEs. | | | | | Only some information of these pages are saved as the "best page" | | | | | list. In the "best page" list, the information of a million pages is| | | | | saved at once. This list is searched when INSERTing a record, and | | | | | then this list is updated when there are no free space to store this| | | | | record on the pages. If there are still no free space to store this | | | | | record even this list is updated for several times, this recored is | | | | | stored into a new page. | | | | | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_home_inserts | Accumulator | The number of inserts in heap HOME type records | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_big_inserts | Accumulator | The number of inserts in heap BIG type records | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_assign_inserts | Accumulator | The number of inserts in heap ASSIGN type records | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_home_deletes | Accumulator | The number of deletes from heap HOME type records in non-MVCC mode | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_home_mvcc_deletes | Accumulator | The number of deletes from heap HOME type records in MVCC mode | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_home_to_rel_deletes | Accumulator | | The number of deletes from heap HOME to RELOCATION type records in | | | | | MVCC mode | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_home_to_big_deletes | Accumulator | The number of deletes from heap HOME to BIG type records in MVCC mode | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_rel_deletes | Accumulator | | The number of deletes from heap RELOCATION type records in non-MVCC | | | | | mode | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_rel_mvcc_deletes | Accumulator | The number of deletes from heap RELOCATION type records in MVCC mode | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_rel_to_home_deletes | Accumulator | | The number of deletes from heap RELOCATION to HOME type records in | | | | | MVCC mode | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_rel_to_big_deletes | Accumulator | | The number of deletes from heap RELOCATION to BIG type records in | | | | | MVCC mode | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_rel_to_rel_deletes | Accumulator | | The number of deletes from heap RELOCATION to RELOCATION type | | | | | records in MVCC mode | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_big_deletes | Accumulator | The number of deletes from heap BIG type records in non-MVCC mode | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_big_mvcc_deletes | Accumulator | The number of deletes from heap BIG type records in MVCC mode | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_home_updates | Accumulator | | The number of updates in place of heap HOME type records in | | | | | non-MVCC mode(*) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_home_to_rel_updates | Accumulator | | The number of updates of heap HOME to RELOCATION type records in | | | | | non-MVCC mode(*) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_home_to_big_updates | Accumulator | | The number of updates of heap HOME to BIG type records in non-MVCC | | | | | mode(*) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_rel_updates | Accumulator | | The number of updates of heap RELOCATION type records in non-MVCC | | | | | mode(*) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_rel_to_home_updates | Accumulator | | The number of updates of heap RELOCATION to HOME type records in | | | | | non-MVCC mode(*) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_rel_to_rel_updates | Accumulator | | The number of updates of heap RELOCATION to RELOCATION type records | | | | | in non-MVCC mode(*) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_rel_to_big_updates | Accumulator | | The number of updates of heap RELOCATION to BIG type records in | | | | | non-MVCC mode(*) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_big_updates | Accumulator | The number of updates of heap BIG type records in non-MVCC mode(*) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_home_vacuums | Accumulator | The number of vacuumed heap HOME type records | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_big_vacuums | Accumulator | The number of vacuumed heap BIG type records | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_rel_vacuums | Accumulator | The number of vacuumed heap RELOCATION type records | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_insid_vacuums | Accumulator | The number of vacuumed heap newly inserted records | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_remove_vacuums | Accumulator | The number of vacuum operations that remove heap records | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_insert_prepare | Counter/timer | The number and duration of preparing heap insert operation | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_insert_execute | Counter/timer | The number and duration of executing heap insert operation | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_insert_log | Counter/timer | The number and duration of logging heap insert operation | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_delete_prepare | Counter/timer | The number and duration of preparing heap delete operation | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_delete_execute | Counter/timer | The number and duration of executing heap delete operation | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_delete_log | Counter/timer | The number and duration of logging heap delete operation | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_update_prepare | Counter/timer | The number and duration of preparing heap update operation | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_update_execute | Counter/timer | The number and duration of executing heap update operation | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_update_log | Counter/timer | The number and duration of logging heap update operation | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_vacuum_prepare | Counter/timer | The number and duration of preparing heap vacuum operation | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_vacuum_execute | Counter/timer | The number and duration of executing heap vacuum operation | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_vacuum_log | Counter/timer | The number and duration of logging heap vacuum operation | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Query plan cache** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_plan_cache_add | Accumulator | The number of entries added to query cache | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_plan_cache_lookup | Accumulator | The number of lookups in query cache | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_plan_cache_hit | Accumulator | The number of hits in query cache | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_plan_cache_miss | Accumulator | The number of misses in query cache | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_plan_cache_full | Accumulator | The number of times query cache becomes full | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_plan_cache_delete | Accumulator | The number of entries deleted from query cache | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_plan_cache_invalid_xasl_id | Accumulator | The number of failed attempts of retrieving entries by XASL ID. | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_plan_cache_entries | Snapshot | The current number of entires in query cache | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **High Availibility** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Time_ha_replication_delay | Accumulator | Replication latency time (sec.) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Vacuuming** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_vacuum_log_pages_vacuumed | Accumulator | The number of log data pages processed by vacuum workers. | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_vacuum_log_pages_to_vacuum | Accumulator | | The number of log data pages to be vacuumed by vacuum workers. | | | | | (if value is much bigger than Num_vacuum_log_pages_vacuumed, | | | | | it means vacuum system lags behind) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_vacuum_prefetch_requests_log_pages | Accumulator | The number of requests to prefetch buffer for log pages from vacuum | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_vacuum_prefetch_hits_log_pages | Accumulator | The number of hits to prefetch buffer for log pages from vacuum | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..vacuum_master | Counter/timer | The number and duration of vacuum master iterations. | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..vacuum_job | Counter/timer | The number and duration of vacuum jobs | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..vacuum_worker_process_log | Counter/timer | The number and duration of process log tasks | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..vacuum_worker_execute | Counter/timer | The number and duration of execute vacuum tasks | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Vacuum_data_page_buffer_hit_ratio | Computed | Hit ratio of vacuuming data page buffers | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Vacuum_page_efficiency_ratio | Computed | | Ratio between number of page unfix of vacuum with dirty flag and | | | | | total number of page unfix of vacuum. Ideally, the vacuum process | | | | | performsonly write operations since it cleans up all unused records.| | | | | Even with an optimized vacuum process, 100% efficiency is not | | | | | possible. | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Vacuum_page_fetch_ratio | Computed | Ratio (percentage) of page unfix from vacuum module versus total. | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_avoid_dealloc | Snapshot | The number of data pages that cannot be deallocated by vacuum | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Heap Bestspace** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_stats_sync_bestspace | Counter/timer | The number and duration of bestspace synchronization operations | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_stats_bestspace_entries | Accumulator | The number of best pages which are saved on the "best page" list | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_heap_stats_bestspace_maxed | Accumulator | The maximum number of pages which can be saved on the "best page" list| +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bestspace_add | Counter/timer | The number and duration of adding entries to bestspace cache | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bestspace_del | Counter/timer | The number and duration of deleting from bestpace cache | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..bestspace_find | Counter/timer | The number and duration of finding a bestpace cache entry | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_find_page_bestspace | Counter/timer | The number and duration of searching heap pages in bestspace cache | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..heap_find_best_page | Counter/timer | | The number and duration of finding or creating (if not found) a | | | | | page to insert in heap. | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Page buffer fix** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Data_page_fix_lock_acquire_time_msec | Computed | Time waiting for other transaction to load page from disk | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Data_page_fix_hold_acquire_time_msec | Computed | Time to obtain page latch | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Data_page_fix_acquire_time_msec | Computed | Total time to fix page | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Data_page_allocate_time_ratio | Computed | | Ratio of time necessary for page loading from disk versus the total | | | | | time of fixing a page | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Data_page_total_promote_success | Computed | Number of successful page latch promotions from shared to exclusive | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Data_page_total_promote_fail | Computed | Number of failed page latch promotions | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Data_page_total_promote_time_msec | Computed | Time for promoting page latches | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_hash_anchor_waits | Accumulator | Number of waits on page buffer hash bucket | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Time_data_page_hash_anchor_wait | Accumulator | Total wait time on page buffer hash bucket | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_fix_ext | Complex | | Number of data page fixes classified by: | | | | | - module (system, worker, vacuum) | | | | | - page type | | | | | - page fetch/found mode | | | | | - page latch mode | | | | | - page latch condition | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Time_data_page_lock_acquire_time | Complex | | Time consumed waiting for other thread to load data page from disk: | | | | | - module (system, worker, vacuum) | | | | | - page type | | | | | - page fetch/found mode | | | | | - page latch mode | | | | | - page latch condition | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Time_data_page_hold_acquire_time | Complex | | Time consumed waiting for data page latch: | | | | | - module (system, worker, vacuum) | | | | | - page type | | | | | - page fetch/found mode | | | | | - page latch mode | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Time_data_page_fix_acquire_time | Complex | | Time consumed fixing data page: | | | | | - module (system, worker, vacuum) | | | | | - page type | | | | | - page fetch/found mode | | | | | - page latch mode | | | | | - page latch condition | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_promote_ext | Complex | | Number of data page promotions classified by: | | | | | - module (system, worker, vacuum) | | | | | - page type | | | | | - promote latch condition | | | | | - holder latch mode | | | | | - successful/failed promotion | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_promote_time_ext | Complex | | Time consumed for data page promotions classified by: | | | | | - module (system, worker, vacuum) | | | | | - page type | | | | | - promote latch condition | | | | | - holder latch mode | | | | | - successful/failed promotion | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Page buffer unfix** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_void_to_private_top | Accumulator | Unfix newly loaded data page and add to top of private LRU list | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_void_to_private_mid | Accumulator | Unfix newly loaded data page and add to middle of private LRU list | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_void_to_shared_mid | Accumulator | Unfix newly loaded data page and add to middle of shared LRU list | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_lru1_private_to_shared_mid | Accumulator | Unfix data page and move from zone 1 of private list to shared middle | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_lru2_private_to_shared_mid | Accumulator | Unfix data page and move from zone 2 of private list to shared middle | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_lru3_private_to_shared_mid | Accumulator | Unfix data page and move from zone 3 of private list to shared middle | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_lru2_private_keep | Accumulator | Unfix data page and keep it in zone 2 of private list | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_lru2_shared_keep | Accumulator | Unfix data page and keep it in zone 2 of shared list | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_lru2_private_to_top | Accumulator | Unfix data page and boost it from zone 2 of private list to its top | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_lru2_shared_to_top | Accumulator | Unfix data page and boost it from zone 2 of shared list to its top | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_lru3_private_to_top | Accumulator | Unfix data page and boost it from zone 3 of private list to its top | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_lru3_shared_to_top | Accumulator | Unfix data page and boost it from zone 3 of shared list to its top | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_lru1_private_keep | Accumulator | Unfix data page and keep it in zone 1 of private list | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_lru2_shared_keep | Accumulator | Unfix data page and keep it in zone 2 of shared list | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_void_to_private_mid_vacuum | Accumulator | | Unfix newly loaded data page and add to middle of private LRU list | | | | | (vacuum thread) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_lru1_any_keep_vacuum | Accumulator | | Unfix data page and keep it in zone 1 of private/shared list | | | | | (vacuum thread) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_lru2_any_keep_vacuum | Accumulator | | Unfix data page and keep it in zone 2 of private/shared list | | | | | (vacuum thread) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_lru3_any_keep_vacuum | Accumulator | | Unfix data page and keep it in zone 3 of private/shared list | | | | | (vacuum thread) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_void_aout_found | Accumulator | Newly loaded data page was found in AOUT list | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_void_aout_not_found | Accumulator | Newly loaded data page was not found in AOUT list | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_void_aout_found_vacuum | Accumulator | Newly loaded data page was found in AOUT list (vacuum thread) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_unfix_void_aout_not_found_vacuum | Accumulator | Newly loaded data page was not found in AOUT list (vacuum thread) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_unfix_ext | Complex | | Number of data page unfixes classified by: | | | | | - module (system, worker, vacuum) | | | | | - page type | | | | | - dirty or not | | | | | - dirtied by holder or not | | | | | - holder latch mode | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Page buffer I/O** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Data_page_buffer_hit_ratio | Computed | | Hit ratio of data page buffers | | | | | (Num_data_page_fetches - Num_data_page_ioreads)*100 | | | | | / Num_data_page_fetches | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_adaptive_flush_pages | Accumulator | The number of data pages requested from adaptive flush controller. | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_adaptive_flush_log_pages | Accumulator | The number of log data pages requested from adaptive flush controller | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_adaptive_flush_max_pages | Accumulator | The total number of page tokens assigned by adaptive flush controller | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..compensate_flush | Counter/timer | | The number and duration of flush compensations force by adaptive | | | | | flush controller | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..assign_direct_bcb | Counter/timer | The number and duration of assigning bcb's directly to waiters | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..wake_flush_waiter | Counter/timer | The number and duration of waking up a thread waiting for bcb | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..flush_collect | Counter/timer | The number and duration of flush thread collecting BCB sets | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..flush_flush | Counter/timer | The number and duration of flush thread flushing BCB sets | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..flush_sleep | Counter/timer | The number and duration of flush thread pauses | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..flush_collect_per_page | Counter/timer | The number and duration of flush thread collecting one BCB | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..flush_flush_per_page | Counter/timer | The number and duration of flush thread flushing one BCB | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_writes | Accumulator | The total number of data pages flushed to disk | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_dirty_to_post_flush | Accumulator | Number of flushed pages sent to post-flush thread for processing | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_skipped_flush | Accumulator | The total number of BCB's that flush thread skipped | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_skipped_flush_need_wal | Accumulator | | The number of BCB's that flush thread skipped because it required | | | | | log data pages be flushed first | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | | Num_data_page_skipped\ | Accumulator | | The number of BCB's that flush thread skipped because they have | | | \_flush_already_flushed | | | been flushed already | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_skipped_flush_fixed_or_hot | Accumulator | | The number of BCB's that flush thread skipped because they are fixed| | | | | or have been fixed since collected. | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Page buffer victimization** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..alloc_bcb | Counter/timer | | The number and duration of BCB allocation to store new data page. | | | | | When a database is just started, the page buffer has available | | | | | BCB's ready to be picked. However, once page buffer becomes full | | | | | all BCB's are in use, one must be victimized. The time tracked here | | | | | includes BCB victimization and loading from disk. | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..alloc_bcb_search_victim | Counter/timer | The number and duration of searches through all LRU lists for victims | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..alloc_bcb_cond_wait_high_prio | Counter/timer | The number and duration of direct victim waits in high-priority queue | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..alloc_bcb_cond_wait_low_prio | Counter/timer | The number and duration of direct victim waits in low-priority queue | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_alloc_bcb_prioritize_vacuum | Accumulator | The number of vacuum direct victim waits in high-priority queue | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_alloc_bcb_wait_threads_high_priority | Snapshot | The current number of direct victim waiters in high-priority queue | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_alloc_bcb_wait_threads_low_priority | Snapshot | The current number of direct victim waiters in low-priority queue | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_flushed_bcbs_wait_for_direct_victim | Snapshot | | The current number of BCB's waiting for post-flush thread to process| | | | | them and assign directly. | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_use_invalid_bcb | Accumulator | The number of BCB's allocated from invalid list | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..alloc_bcb_get_victim_search\ | Counter/timer | The number and duration of getting a victim from own private list | | \_own_private_list | | | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..alloc_bcb_get_victim_search\ | Counter/timer | The number and duration of getting a victim from other private lists | | \_others_private_list | | | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..alloc_bcb_get_victim_search\ | Counter/timer | The number and duration of getting a victim from a shared list | | \shared_list | | | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_data_page_avoid_victim | Accumulator | | The number of BCB's that cannot be victimized because they are | | | | | in process of being flushed to disk | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_assign_direct_vacuum_void | Accumulator | The number of direct victims assigned from void zone by vacuum worker | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_assign_direct_vacuum_lru | Accumulator | The number of direct victims assigned from LRU zone 3 by vacuum worker| +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_assign_direct_flush | Accumulator | The number of direct victims assigned by flush thread | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_assign_direct_panic | Accumulator | | The number of direct victims assigned by panicked LRU searches. | | | | | If there are a lot of waiters for victims, threads that found other | | | | | victims while searching LRU list, will also try to assign more | | | | | directly. | | | | | Page buffer maintenance thread assignments are also counted here | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_assign_direct_adjust_lru | Accumulator | The number of direct victims assigned when BCB falls to LRU zone 3 | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_assign_direct_adjust_lru\ | Accumulator | | The number of BCB's falling to LRU zone 3 **not** assigned as direct| | \_to_vacuum | | | victims because a vacuum thread is expected to access it | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_assign_direct_search\ | Accumulator | | The number of direct victims assigned by flush thread while | | \_for_flush | | | collecting BCB sets for flush | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_shared_lru_success | Accumulator | The number of successful victim searches in shared LRU lists | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_own_private_lru_success | Accumulator | The number of successful victim searches in own private LRU lists | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_other_private_lru_success | Accumulator | The number of successful victim searches in other private LRU lists | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_shared_lru_fail | Accumulator | The number of failed victim searches in shared LRU lists | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_own_private_lru_fail | Accumulator | The number of failed victim searches in own private LRU lists | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_other_private_lru_fail | Accumulator | The number of failed victim searches in other private LRU lists | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_all_lru_fail | Accumulator | | The number of unlucky streaks to find victims in the sequence: | | | | | 1. Own private LRU list (if over quota) | | | | | 2. Other private LRU list (if own private is over quota) | | | | | 3. Shared LRU list | | | | | (this is simplified explanation, see *pgbuf_get_victim* function) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_get_from_lru | Accumulator | The total number of victim searches in any LRU list | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_get_from_lru_was_empty | Accumulator | | The number of victim searches in any LRU list that stop | | | | | immediately because candidate count is zero | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_get_from_lru_fail | Accumulator | | The number of failed victim searches in any LRU list although the | | | | | candidate count was not zero | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_victim_get_from_lru_bad_hint | Accumulator | | The number of failed victim searches in any LRU list because victim | | | | | was wrong | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_lfcq_prv_get_total_calls | Accumulator | The number of victim searches in non-zero candidate private LRUs queue| +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_lfcq_prv_get_empty | Accumulator | The number of times non-zero candidate private LRUs queue was empty | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_lfcq_prv_get_big | Accumulator | | The number of victim searches in only very big non-zero candidate | | | | | private LRUs queue (in this context, very big means way over quota) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_lfcq_shr_get_total_calls | Accumulator | The number of victim searches in non-zero candidate shared LRUs queue | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_lfcq_shr_get_empty | Accumulator | The number of times non-zero candidate shared LRUs queue was empty | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_lfcq_big_private_lists | Snapshot | The current number of very big non-zero candidate private LRU lists | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_lfcq_private_lists | Snapshot | The current number of non-zero candidate private LRU lists | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_lfcq_shared_lists | Snapshot | The current number of non-zero candidate shared LRU lists | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Double write buffer** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..DWB_flush_block | Counter/timer | The number of blocks flushed and total writing duration | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..DWB_file_sync_helper | Counter/timer | The number and duration of files synchronized by DWB helper | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..DWB_flush_block_cond_wait | Counter/timer | The number and duration of DWB thread waits | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..DWB_flush_block_sort | Counter/timer | The number and duration of sorting pages for flush | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..DWB_decache_pages_after_write | Counter/timer | The number and duration of removing pages from DWB cache after flush | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..DWB_wait_flush_block | Counter/timer | | The number and duration of waiting for block to be flush to add a | | | | | page | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..DWB_wait_file_sync_helper | Counter/timer | The number and duration of waiting for DWB helper to sync file | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | ..DWB_flush_force | Counter/timer | The number and duration of forced full DWB flushes | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_dwb_flushed_block_volumes | Complex | | A histogram of number of files synchronized by each block flush | | | | | (last value is for ten or more files) | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **MVCC Snapshot** +------------------------------------------+----------------+-----------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Time_get_snapshot_acquire_time: | Accumulator | Total time consumed by all transactions to get a snapshot | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Count_get_snapshot_retry: | Accumulator | The number of retries to acquire MVCC snapshot | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Time_tran_complete_time: | Accumulator | Time spent to invalidate snapshot and MVCCID on commit/rollback | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Time_get_oldest_mvcc_acquire_time: | Accumulator | Time spend to acquire "global oldest MVCC ID" | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Count_get_oldest_mvcc_retry: | Accumulator | The number of retries to acquire "global oldest MVCC ID" | +------------------------------------------+----------------+-----------------------------------------------------------------------+ | Num_mvcc_snapshot_ext | Complex | | Number of data page fixes classified by: | | | | | - snapshot type | | | | | - insert/delete MVCCID's status | | | | | - visible/invisible | +------------------------------------------+----------------+-----------------------------------------------------------------------+ **Thread workers** Statistics collected by thread worker pools: +--------------------------+----------------+---------------------------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..start_thread | Counter/timer | The number and duration of starting new threads | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..create_context | Counter/timer | The number and duration of creating thread context | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..execute_task | Counter/timer | The number and duration of executed tasks | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..retire_task | Counter/timer | The number and duration of retiring task objects | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..found_task_in_queue | Counter/timer | | The number of tasks found in queue and the duration of claiming from queue after | | | | | finishing previous task | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..wakeup_with_task | Counter/timer | The number of tasks assigned to threads on standby and the duration to wakeup thread | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..recycle_context | Counter/timer | The number and duration of thread context recyclings between task executions | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..retire_context | Counter/timer | The number and duration of retired thread contexts | +--------------------------+----------------+---------------------------------------------------------------------------------------+ Statistics are collected from two worker pools: * **Thread_stats_counters_timers**: statistics for workers executing client requests. * **Thread_loaddb_stats_counters_timers**: statistics for workers loading data into database (using **loaddb** command). *At least one load session must be active to see these statistics*. **Thread daemons** Statistics collected by background daemon threads: +--------------------------+----------------+---------------------------------------------------------------------------------------+ | **Stat name** | **Stat type** | **Description** | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..daemon_loop_count | Accumulator | The number of loops executed by daemon thread | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..daemon_execute_time | Accumulator | The total duration spent by daemon thread on execution | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..daemon_pause_time | Accumulator | The total duration spent by daemon thread between executions | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..looper_sleep_count | Accumulator | The number of times thread looper was put to sleep | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..looper_sleep_time | Accumulator | The total duration thread looper spent on sleep | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..looper_reset_count | Accumulator | The number of times an incremental looper is reset by wakeup | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..waiter_wakeup_count | Accumulator | The number of wakeup requests on daemon thread | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..waiter_lock_wakeup\ | Accumulator | The number of wakeup requests on daemon thread that required lock | | \_count | | | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..waiter_sleep_count | Accumulator | The number of times daemon thread went to sleep | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..waiter_timeout_count | Accumulator | The number of daemon thread waits ended with timeout | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..waiter_no_sleep_count | Accumulator | The number of times daemon thread spins with no wait | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..waiter_awake_count | Accumulator | The number of times daemon thread is awaken by other thread request | +--------------------------+----------------+---------------------------------------------------------------------------------------+ | ..waiter_wakeup_delay\ | Accumulator | The total duration of awaking daemon thread | | \_time | | | +--------------------------+----------------+---------------------------------------------------------------------------------------+ Statistics are collected for next daemon threads: +-------------------------------------------+---------------------------------------------------------------------------------------+ | **Daemon name** | **Description** | +-------------------------------------------+---------------------------------------------------------------------------------------+ | Page_flush_daemon_thread | Background thread that flushes data pages to disk | +-------------------------------------------+---------------------------------------------------------------------------------------+ | Page_post_flush_daemon_thread | Background thread that may reclaim memory space occupied by flushes data pages | +-------------------------------------------+---------------------------------------------------------------------------------------+ | Page_flush_control_daemon_thread | Background thread that controls data flush rate | +-------------------------------------------+---------------------------------------------------------------------------------------+ | Page_maintenance_daemon_thread | Background thread that recalculates quotas for private LRU lists | +-------------------------------------------+---------------------------------------------------------------------------------------+ | Deadlock_detect_daemon_thread | Background thread that looks for deadlocks and chooses victims to unblock the system | +-------------------------------------------+---------------------------------------------------------------------------------------+ | Log_flush_daemon_thread | Background thread that flushes log data to disk | +-------------------------------------------+---------------------------------------------------------------------------------------+ .. Note:: (*) : These statistics measure the non-MVCC operations or MVCC operations which are performed in-place (decided internally) .. option:: -o, --output-file=FILE **-o** options is used to store statistics information of server processing for the database to a specified file. :: cubrid statdump -o statdump.log testdb .. option:: -c, --cumulative You can display the accumulated operation statistics information of the target database server by using the **-c** option. Num_data_page_fix_ext, Num_data_page_unfix_ext, Time_data_page_hold_acquire_time, Time_data_page_fix_acquire_time information can be output only when this option is specified; however, these informations will be omitted because they are for CUBRID Engine developers. By combining this with the **-i** option, you can check the operation statistics information at a specified interval. :: cubrid statdump -i 5 -c testdb .. option:: -s, --substr=STRING You can display statistics about items, the names of which include the specified string by using **-s** option. The following example shows how to display statistics about items, the names of which include "data". :: cubrid statdump -s data testdb *** SERVER EXECUTION STATISTICS *** Num_data_page_fetches = 0 Num_data_page_dirties = 0 Num_data_page_ioreads = 0 Num_data_page_iowrites = 0 Num_data_page_flushed = 0 Num_data_page_private_quota = 327 Num_data_page_private_count = 898 Num_data_page_fixed = 1 Num_data_page_dirty = 3 Num_data_page_lru1 = 857 Num_data_page_lru2 = 873 Num_data_page_lru3 = 898 Num_data_page_victim_candidate = 898 Num_sort_data_pages = 0 Vacuum_data_page_buffer_hit_ratio = 0.00 Num_data_page_hash_anchor_waits = 0 Time_data_page_hash_anchor_wait = 0 Num_data_page_writes = 0 Num_data_page_dirty_to_post_flush = 0 Num_data_page_skipped_flush = 0 Num_data_page_skipped_flush_need_wal = 0 Num_data_page_skipped_flush_already_flushed = 0 Num_data_page_skipped_flush_fixed_or_hot = 0 Num_data_page_avoid_dealloc = 0 Num_data_page_avoid_victim = 0 Num_data_page_fix_ext: Num_data_page_promote_ext: Num_data_page_promote_time_ext: Num_data_page_unfix_ext: Time_data_page_lock_acquire_time: Time_data_page_hold_acquire_time: Time_data_page_fix_acquire_time: .. note:: Each status information consists of 64-bit INTEGER data and the corresponding statistics information can be lost if the accumulated value exceeds the limit (highly unlikely though). .. note:: Some sets of performance statistics are activated/deactivated by **extended_statistics_activation** system parameter. Each set is represented by a value power of two. To be activated, it needs to be present in the base-2 representation of the system parameter. This is the lists of sets that can be manipulated: ========= ===================================== =========== ==================================================================== Value Name Active Description Default ========= ===================================== =========== ==================================================================== **1** **Detailed b-tree pages** Yes | Classifies b-tree pages into 3 categories: root, non-leaf and leaf | Affected statistics: | - Num_data_page_fix_ext | - Time_data_page_lock_acquire_time | - Time_data_page_hold_acquire_time | - Time_data_page_fix_acquire_time | - Num_data_page_promote_ext | - Num_data_page_promote_time_ext | - Num_data_page_unfix_ext **2** **MVCC Snapshot** Yes | Activates statistics collection for MVCC snapshot: | - Num_mvcc_snapshot_ext **4** **Time locks** Yes | Activate statistics collection for timing lock waits: | - Num_object_locks_time_waited_usec **8** **Hash anchor waits** Yes | Activate statistics collection for hash anchor waits: | - Num_data_page_hash_anchor_waits | - Time_data_page_hash_anchor_wait **16** **Extended victimization** No | Activate statistics collection for extended page buffer I/O and | victimization module: | - Num_data_page_writes | - flush_collect_per_page | - flush_flush_per_page | - Num_data_page_skipped_flush_already_flushed | - Num_data_page_skipped_flush_need_wal | - Num_data_page_skipped_flush_fixed_or_hot | - Num_data_page_dirty_to_post_flush | - Num_alloc_bcb_prioritize_vacuum | - Num_victim_assign_direct_vacuum_void | - Num_victim_assign_direct_vacuum_lru | - Num_victim_assign_direct_flush | - Num_victim_assign_direct_panic | - Num_victim_assign_direct_adjust_lru | - Num_victim_assign_direct_adjust_lru_to_vacuum | - Num_victim_assign_direct_search_for_flush | - Num_victim_shared_lru_success | - Num_victim_own_private_lru_success | - Num_victim_other_private_lru_success | - Num_victim_shared_lru_fail | - Num_victim_own_private_lru_fail | - Num_victim_other_private_lru_fail | - Num_victim_get_from_lru | - Num_victim_get_from_lru_was_empty | - Num_victim_get_from_lru_fail | - Num_victim_get_from_lru_bad_hint | - Num_lfcq_prv_get_total_calls | - Num_lfcq_prv_get_empty | - Num_lfcq_prv_get_big | - Num_lfcq_shr_get_total_calls | - Num_lfcq_shr_get_empty **32** **Thread workers** No | Activate statistics collection for thread worker pools | - Thread_stats_counters_timers | - Thread_loaddb_stats_counters_timers **64** **Thread daemons** No | Activate statistics collection for daemon threads | - Thread_pgbuf_daemon_stats_counters_timers **128** **Extended DWB** No | Activate extented statistics collection for Double Write Buffer | - Num_dwb_flushed_block_volumes **MAX** **All statistics** No | Activate collection of all statistics ========= ===================================== =========== ==================================================================== .. _lockdb: lockdb ------ The **cubrid lockdb** utility is used to check the information on the lock being used by the current transaction in the database. :: cubrid lockdb [options] database_name * **cubrid**: An integrated utility for the CUBRID service and database management. * **lockdb**: A command used to check the information on the lock being used by the current transaction in the database. * *database_name*: The name of the database where lock information of the current transaction is to be checked. The following example shows how to display lock information of the *testdb* database on a screen without any option. :: cubrid lockdb testdb The following shows [options] available with the **cubrid lockdb** utility. .. program:: lockdb .. option:: -o, --output-file=FILE The **-o** option displays the lock information of the *testdb* database as a output.txt. :: cubrid lockdb -o output.txt testdb Output Contents ^^^^^^^^^^^^^^^ The output contents of **cubrid lockdb** are divided into three logical sections. * Server lock settings * Clients that are accessing the database * The contents of an object lock table **Server lock settings** The first section of the output of **cubrid lockdb** is the database lock settings. :: *** Lock Table Dump *** Lock Escalation at = 100000, Run Deadlock interval = 0 The lock escalation level is 100,000 records, and the interval to detect deadlock is set to 0 seconds. For a description of the related system parameters, **lock_escalation** and **deadlock_detection_interval**, see :ref:`lock-parameters`. **Clients that are accessing the database** The second section of the output of **cubrid lockdb** includes information on all clients that are connected to the database. This includes the transaction index, program name, user ID, host name, process ID, isolation level and lock timeout settings of each client. :: Transaction (index 1, csql, dba@cubriddb|12854) Isolation COMMITTED READ Timeout_period : Infinite wait Here, the transaction index is 1, the program name is csql, the user ID is dba, the host name is cubriddb, the client process identifier is 12854, the isolation level is COMMITTED READ and the lock timeout is unlimited. A client for which transaction index is 0 is the internal system transaction. It can obtain the lock at a specific time, such as the processing of a checkpoint by a database. In most cases, however, this transaction will not obtain any locks. Because **cubrid lockdb** utility accesses the database to obtain the lock information, the **cubrid lockdb** is an independent client and will be output as such. **Object lock table** The third section of the output of the **cubrid lockdb** includes the contents of the object lock table. It shows which client has the lock for which object in which mode, and which client is waiting for which object in which mode. The first part of the result of the object lock table shows how many objects are locked. :: Object lock Table: Current number of objects which are locked = 2001 **cubrid lockdb** outputs the OID, object type and table name of each object that obtained lock. In addition, it outputs the number of transactions that hold lock for the object (*Num holders*), the number of transactions (*Num blocked-holders*) that hold lock but are blocked since it could not convert the lock to the upper lock (e.g., conversion from **SCH_S_LOCK** to **SCH_M_LOCK**), and the number of different transactions that are waiting for the lock of the object (*Num waiters*). It also outputs the list of client transactions that hold lock, blocked client transactions and waiting client transactions. For rows, but not class, MVCC information is also shown. The example below shows an object in which the object type is a class, that will be blocked because the class OID( 0| 62| 5 ) that has **IX_LOCK** for transaction 1 and **SCH_S_LOCK** for transaction 2 cannot be converted into **SCH_M_LOCK**. It also shows that transaction 3 is blocked because transaction 2 is waiting for **SCH_M_LOCK** even when transaction 3 is only waiting for **SCH_S_LOCK**. :: OID = 0| 62| 5 Object type: Class = athlete. Num holders = 1, Num blocked-holders= 1, Num waiters = 1 LOCK HOLDERS : Tran_index = 1, Granted_mode = IX_LOCK, Count = 1, Nsubgranules = 1 BLOCKED LOCK HOLDERS : Tran_index = 2, Granted_mode = SCH_S_LOCK, Count = 1, Nsubgranules = 0 Blocked_mode = SCH_M_LOCK Start_waiting_at = Wed Feb 3 14:44:31 2016 Wait_for_secs = -1 LOCK WAITERS : Tran_index = 3, Blocked_mode = SCH_S_LOCK Start_waiting_at = Wed Feb 3 14:45:14 2016 Wait_for_secs = -1 The next example shows an instance of class, object OID( 2| 50| 1 ), that was inserted by transaction 1 which holds **X_LOCK** on the object. The class has a unique index and the key of inserted instance is about to be modified by transaction 2, which is blocked until transaction 1 is completed. :: OID = 2| 50| 1 Object type: instance of class ( 0| 62| 5) = athlete. MVCC info: insert ID = 6, delete ID = missing. Num holders = 1, Num blocked-holders= 1, Num waiters = 1 LOCK HOLDERS : Tran_index = 1, Granted_mode = X_LOCK, Count = 1 LOCK WAITERS : Tran_index = 2, Blocked_mode = X_LOCK Start_waiting_at = Wed Feb 3 14:45:14 2016 Wait_for_secs = -1 *Granted_mode* refers to the mode of the obtained lock, and *Blocked_mode* refers to the mode of the blocked lock. *Starting_waiting_at refers* to the time at which the lock was requested, and *Wait_for_secs* refers to the waiting time of the lock. The value of *Wait_for_secs* is determined by **lock_timeout**, a system parameter. When the object type is a class (table), *Nsubgranules* is displayed, which is the sum of the record locks and the key locks obtained by a specific transaction in the table. :: OID = 0| 62| 5 Object type: Class = athlete. Num holders = 2, Num blocked-holders= 0, Num waiters= 0 LOCK HOLDERS: Tran_index = 3, Granted_mode = IX_LOCK, Count = 2, Nsubgranules = 0 Tran_index = 1, Granted_mode = IX_LOCK, Count = 3, Nsubgranules = 1 Tran_index = 2, Granted_mode = IX_LOCK, Count = 2, Nsubgranules = 1 .. _tranlist: tranlist -------- The **cubrid tranlist** is used to check the transaction information of the target database. :: cubrid tranlist [options] database_name If you omit the [options], it displays the total information about each transaction. "cubrid tranlist demodb" outputs the similar result with "cubrid killtran -q demodb", but tranlist outputs more items; "User name" and "Host name". "cubrid tranlist -s demodb" outputs the same result with "cubrid killtran -d demodb". The following shows what information is displayed when you run "cubrid tranlist demodb". :: $ cubrid tranlist demodb Tran index User name Host name Process id Program name Query time Tran time Wait for lock holder SQL_ID SQL Text -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1(ACTIVE) public test-server 1681 broker1_cub_cas_1 0.00 0.00 -1 *** empty *** 2(ACTIVE) public test-server 1682 broker1_cub_cas_2 0.00 0.00 -1 *** empty *** 3(ACTIVE) public test-server 1683 broker1_cub_cas_3 0.00 0.00 -1 *** empty *** 4(ACTIVE) public test-server 1684 broker1_cub_cas_4 1.80 1.80 3, 2, 1 e5899a1b76253 update ta set a = 5 where a > 0 5(ACTIVE) public test-server 1685 broker1_cub_cas_5 0.00 0.00 -1 *** empty *** -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SQL_ID: e5899a1b76253 Tran index : 4 update ta set a = 5 where a > 0 In the above example, when each three transaction is running INSERT statement, UPDATE statement is tried to run in the other transaction. In the above, UPDATE statement with "Tran index" 4 waits for the transactions 3,2,1, which are found in "Wait for lock holder", to be ended. "SQL Text" is SQLs which are stored into the query plan cache; this is printed out as **empty** when this query's execution is terminated. Each column's meaning is as following. * Tran index : the index of transaction * User name: database user's name * Host name: host name of CAS which running this transaction * Process id : client's process id * Program name : program name of a client * Query time : total execution time for the running query (unit: second) * Tran time : total run time for the current transaction (unit: second) * Wait for lock holder : the list of transactions which own the lock when the current transaction is waiting for a lock * SQL_ID: an ID for SQL Text * SQL Text : running SQL text (maximum 30 characters) Transaction status messages, which are shown on "Tran index", are as follows. * ACTIVE : active state * RECOVERY : recovering transaction * COMMITTED : transaction which is already committed and will be ended soon. * COMMITTING : transaction which is committing * ABORTED : transaction which is rolled back and will be ended soon. * KILLED : transaction which is forcefully killed by the server. The following shows [options] available with the **cubrid tranlist** utility. .. program:: tranlist .. option:: -s, --summary This option outputs only summarized information(it omits query execution information or locking information). :: $ cubrid tranlist -s demodb Tran index User name Host name Process id Program name ------------------------------------------------------------------------------- 1(ACTIVE) public test-server 1681 broker1_cub_cas_1 2(ACTIVE) public test-server 1682 broker1_cub_cas_2 3(ACTIVE) public test-server 1683 broker1_cub_cas_3 4(ACTIVE) public test-server 1684 broker1_cub_cas_4 5(ACTIVE) public test-server 1685 broker1_cub_cas_5 ------------------------------------------------------------------------------- .. option:: --sort-key=NUMBER This option outputs the ascending values sorted by the NUMBERth column. If the type of the column is the number, it is sorted by the number; if not, it is sorted by the string. If this option is omitted, the output is sorted by "Tran index". The following is an example which outputs the sorted information by specifying the "Process id", the 4th column. :: $ cubrid tranlist --sort-key=4 demodb Tran index User name Host name Process id Program name Query time Tran time Wait for lock holder SQL_ID SQL Text -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1(ACTIVE) public test-server 1681 broker1_cub_cas_1 0.00 0.00 -1 *** empty *** 2(ACTIVE) public test-server 1682 broker1_cub_cas_2 0.00 0.00 -1 *** empty *** 3(ACTIVE) public test-server 1683 broker1_cub_cas_3 0.00 0.00 -1 *** empty *** 4(ACTIVE) public test-server 1684 broker1_cub_cas_4 1.80 1.80 3, 1, 2 e5899a1b76253 update ta set a = 5 where a > 0 5(ACTIVE) public test-server 1685 broker1_cub_cas_5 0.00 0.00 -1 *** empty *** -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SQL_ID: e5899a1b76253 Tran index : 4 update ta set a = 5 where a > 0 .. option:: --reverse This option outputs the reversely sorted values. The following is an example which outputs the reversely sorted values by the "Tran index". :: Tran index User name Host name Process id Program name Query time Tran time Wait for lock holder SQL_ID SQL Text ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 5(ACTIVE) public test-server 1685 broker1_cub_cas_5 0.00 0.00 -1 *** empty *** 4(ACTIVE) public test-server 1684 broker1_cub_cas_4 1.80 1.80 3, 2, 1 e5899a1b76253 update ta set a = 5 where a > 0 3(ACTIVE) public test-server 1683 broker1_cub_cas_3 0.00 0.00 -1 *** empty *** 2(ACTIVE) public test-server 1682 broker1_cub_cas_2 0.00 0.00 -1 *** empty *** 1(ACTIVE) public test-server 1681 broker1_cub_cas_1 0.00 0.00 -1 *** empty *** ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ SQL_ID: e5899a1b76253 Tran index : 4 update ta set a = 5 where a > 0 .. _killtran: killtran -------- The **cubrid killtran** is used to check transactions or abort specific transaction. Only a **DBA** can use options for killing a transaction. :: cubrid killtran [options] database_name * **cubrid**: An integrated utility for the CUBRID service and database management * **killtran**: A utility that manages transactions for a specified database * *database_name*: The name of database whose transactions are to be killed Some [options] refer to killing specified transactions; others refer to print active transactions. If no option is specified, **-d** is specified by default so all transactions are displayed on the screen. :: cubrid killtran demodb Tran index User name Host name Process id Program name ------------------------------------------------------------------------------- 1(ACTIVE) dba myhost 664 cub_cas 2(ACTIVE) dba myhost 6700 csql 3(ACTIVE) dba myhost 2188 cub_cas 4(ACTIVE) dba myhost 696 csql 5(ACTIVE) public myhost 6944 csql ------------------------------------------------------------------------------- The following shows [options] available with the **cubrid killtran** utility. .. program:: killtran .. option:: -i, --kill-transaction-index=ID1,ID2,ID3 This option kills transactions in a specified index. Several transaction indexes can be specified by separating with comma(,). If there is an invalid transaction ID among several IDs, it is ignored. :: $ cubrid killtran -i 1 demodb Ready to kill the following transactions: Tran index User name Host name Process id Program name ------------------------------------------------------------------------------- 1(ACTIVE) DBA myhost 15771 csql 2(ACTIVE) DBA myhost 2171 csql ------------------------------------------------------------------------------- Do you wish to proceed ? (Y/N)y Killing transaction associated with transaction index 1 Killing transaction associated with transaction index 2 .. option:: --kill-user-name=ID This option kills transactions for a specified OS user ID. :: cubrid killtran --kill-user-name=os_user_id demodb .. option:: --kill-host-name=HOST This option kills transactions of a specified client host. :: cubrid killtran --kill-host-name=myhost demodb .. option:: --kill-program-name=NAME This option kills transactions for a specified program. :: cubrid killtran --kill-program-name=cub_cas demodb .. option:: --kill-sql-id=SQL_ID This option kills transactions for a specified SQL ID. :: cubrid killtran --kill-sql-id=5377225ebc75a demodb .. option:: -p, --dba-password=PASSWORD This option can only be used, if using killing option such as -i and --kill options. A value followed by the -p option is a password of the **DBA**, and should be entered in the prompt. .. option:: -q, --query-exec-info The difference with the output of "cubrid tranlist" command is that there are no "User name" column and "Host name" column. See :ref:`tranlist`. .. option:: -d, --display-information This is the default option and it displays the summary of transactions. Its output is the same as the output of "cubrid tranlist" with **-s** option. See :option:`tranlist -s` .. option:: -f, --force This option omits a prompt to check transactions to be stopped. :: cubrid killtran -f -i 1 demodb .. _checkdb: checkdb ------- The **cubrid checkdb** utility is used to check the consistency of a database. You can use **cubrid checkdb** to identify data structures that are different from indexes by checking the internal physical consistency of the data and log volumes. If the **cubrid checkdb** utility reveals any inconsistencies, you must try automatic repair by using the --**repair** option. :: cubrid checkdb [options] database_name [table_name1 table_name2 ...] * **cubrid**: An integrated utility for CUBRID service and database management. * **checkdb**: A utility that checks the data consistency of a specific database. * *database_name*: The name of the database whose consistency status will be either checked or restored. * *table_name1 table_name2*: List the table names for consistency check or recovery The following shows [options] available with the **cubrid checkdb** utility. .. program:: checkdb .. option:: -S, --SA-mode This option is used to access a database in standalone, which means it works without processing server; it does not have an argument. If **-S** is not specified, the system recognizes that a database is running in client/server mode. :: cubrid checkdb -S demodb .. option:: -C, --CS-mode This option is used to access a database in client/server mode, which means it works in client/server process respectively; it does not have an argument. If **-C** is not specified, the system recognize that a database is running in client/server mode by default. :: cubrid checkdb -C demodb .. option:: -r, --repair This option is used to restore an issue if a consistency error occurs in a database. :: cubrid checkdb -r demodb .. option:: --check-prev-link This option is used to check if there are errors on previous links of an index. :: $ cubrid checkdb --check-prev-link demodb .. option:: --repair-prev-link This option is used to restore if there are errors on previous links of an index. :: $ cubrid checkdb --repair-prev-link demodb .. option:: -i, --input-class-file=FILE You can specify tables to check the consistency or to restore, by specifying the **-i** *FILE* option or listing the table names after a database name. Both ways can be used together. If a target is not specified, entire database will be a target of consistency check or restoration. :: cubrid checkdb demodb tbl1 tbl2 cubrid checkdb -r demodb tbl1 tbl2 cubrid checkdb -r -i table_list.txt demodb tbl1 tbl2 Empty string, tab, carriage return and comma are separators among table names in the table list file specified by **-i** option. The following example shows the table list file; from t1 to t10, it is recognized as a table for consistency check or restoration. :: t1 t2 t3,t4 t5 t6, t7 t8 t9 t10 .. option:: --check-file-tracker Check about all pages of all files in file-trackers. .. option:: --check-heap Check about all heap-files. .. option:: --check-catalog Check the consistency about catalog information. .. option:: --check-btree Check the validity about all B-tree indexes. .. option:: --check-class-name Check the identical between the hash table of a class name and the class information(oid) brought from a heap file. .. option:: --check-btree-entries Check the consistency of all B-tree entries. .. option:: -I, --index-name=INDEX_NAME Check if the index specified with this option about checking table. If you use this option, there is no heap validation check. Only one table and one index are permitted when you use this option; if you don't input a table name or input two tables, an error occurs. .. _diagdb: diagdb ------ You can check various pieces of internal information on the database with the **cubrid diagdb** utility. Information provided by **cubrid diagdb** is helpful in diagnosing the current status of the database or figuring out a problem. :: cubrid diagdb options database_name * **cubrid**: An integrated utility for the CUBRID service and database management. * **diagdb**: A command that is used to check the current storage state of the database by Dumping the information contained in the binary file managed by CUBRID in text format. It normally executes only when the database is in a stopped state. You can check the whole database or the file table, file size, heap size, class name or disk bitmap selectively by using the provided option. * *database_name*: The name of the database whose internal information is to be diagnosed. The following shows [options] available with the **cubrid diagdb** utility. .. program:: diagdb .. option:: -d, --dump-type=TYPE This option specifies the output range when you display the information of all files in the *demodb* database. If any option is not specified, the default value of -1 is used. :: cubrid diagdb -d 1 demodb The utility has 9 types of **-d** options as follows: +------+--------------------------------------+ | Type | Description | +------+--------------------------------------+ | -1 | Displays all database information. | +------+--------------------------------------+ | 1 | Displays file table information. | +------+--------------------------------------+ | 2 | Displays file capacity information. | +------+--------------------------------------+ | 3 | Displays heap capacity information. | +------+--------------------------------------+ | 4 | Displays index capacity information. | +------+--------------------------------------+ | 5 | Displays class name information. | +------+--------------------------------------+ | 6 | Displays disk bitmap information. | +------+--------------------------------------+ | 7 | Displays catalog information. | +------+--------------------------------------+ | 8 | Displays log information. | +------+--------------------------------------+ | 9 | Displays heap information. | +------+--------------------------------------+ .. option:: -o, --output-file=FILE The **-o** option is used to store information of the parameters used in the server/client process of the database into a specified file. The file is created in the current directory. If the **-o** option is not specified, the message is displayed on a console screen. :: cubrid diagdb -d8 -o logdump_output demodb .. option:: --emergency Use **--emergency** option to suppress recovery. **This option is meant ONLY for debugging, if there are recovery issues. It is recommended to backup your database before using this option.** .. _paramdump: paramdump --------- The **cubrid paramdump** utility outputs parameter information used in the server/client process. :: cubrid paramdump [options] database_name * **cubrid**: An integrated utility for the CUBRID service and database management * **paramdump**: A utility that outputs parameter information used in the server/client process * *database_name*: The name of the database in which parameter information is to be displayed. The following shows [options] available with the **cubrid paramdump** utility. .. program:: paramdump .. option:: -o, --output-file=FILE The **-o** option is used to store information of the parameters used in the server/client process of the database into a specified file. The file is created in the current directory. If the **-o** option is not specified, the message is displayed on a console screen. :: cubrid paramdump -o db_output demodb .. option:: -b, --both The **-b** option is used to display parameter information used in server/client process on a console screen. If the **-b** option is not specified, only server-side information is displayed. :: cubrid paramdump -b demodb .. option:: -S, --SA-mode This option displays parameter information of the server process in standalone mode. :: cubrid paramdump -S demodb .. option:: -C, --CS-mode This option displays parameter information of the server process in client/server mode. :: cubrid paramdump -C demodb .. _tde-utility: tde --- The **cubrid tde** utility is used to manage the TDE encryption of the database and can only be executed by the **DBA** user. With **cubrid tde** utility, you can change the key set on the database, add a new key, or remove a key in the key file stably. Also, you can inquire about the keys added to the key file and the key set on the database. For more information, see :ref:`tde`. :: cubrid tde [option] database_name * **cubrid**: An integrated utility for the CUBRID service and database management. * **tde**: A utility that manages TDE encryption applied to the database. * *operation*: There are four types of operation: key addition, key deletion, key change, and showing keys' information. One operation must be set, and they are exclusive. * *database_name*: The name of the database on which TDE administration operations to be performed. The following table shows available with the cubrid tde utility. .. program:: tde .. option:: -s, --show-keys This option displays information about the keys set on the database and keys in the key file (_keys). :: $ cubrid tde -s testdb Key File: /home/usr/CUBRID/databases/testdb/testdb_keys The current key set on testdb: Key Index: 2 Created on Fri Nov 27 11:14:54 2020 Set on Fri Nov 27 11:15:30 2020 Keys Information: Key Index: 0 created on Fri Nov 27 11:11:27 2020 Key Index: 1 created on Fri Nov 27 11:14:47 2020 Key Index: 2 created on Fri Nov 27 11:14:54 2020 Key Index: 3 created on Fri Nov 27 11:14:55 2020 The number of keys: 4 **The current key** section shows the information on the key set on the current database, which displays the index for the key in the key file, the creation time, and the set time. The set key can be identified by the key index and creation time, and a key change plan can be established with the set time. **Keys Information** section shows the keys added and being managed in the key file, through which the key indexes and creation time of them is checked. .. option:: -n, --generate-new-key This option is used to add a new key to the key file (up to 128). If it is successful, the index of the added key is displayed, and this index is used to identify the key when changing or removing the key later. Information of added keys can be checked by \\-\\-show-keys. :: $ cubrid tde -n testdb Key File: /home/usr/CUBRID/databases/testdb/testdb_keys SUCCESS: A new key has been generated - key index: 1 created on Tue Dec 1 11:30:47 2020 .. option:: -d, --delete-key=KEY_INDEX This option is used to remove a key specified by index from the key file. The key currently set on the database cannot be removed. :: $ cubrid tde -d 1 testdb Key File: /home/usr/CUBRID/databases/testdb/testdb_keys SUCCESS: The key (index: 1) has been deleted .. option:: -c, --change-key=KEY_INDEX This option is used to change the key set on the database to another key existing in the key file. When changing, both the previously set key and the new key to be set must exist. :: $ cubrid tde -c 2 testdb Key File: /home/usr/CUBRID/databases/testdb/testdb_keys Trying to change the key from the key (index: 0) to the key (index: 2).. SUCCESS: The key has been changed from the key (index: 0) to the key (index: 2) To change the key set on the database, a user must first create a key to be set by the \\-\\-generate-new-key option. The user can create a new key to change, or create multiple keys in advance for changing the key according to their own security plans. The following table shows [options] available with the cubrid tde utility. .. option:: -p, --dba-password=PASSWORD This option specifies the password of the DBA. HA Commands ----------- **cubrid changemode** utility prints or changes the HA mode. **cubrid applyinfo** utility prints the information of applied transaction logs in the HA environment. For more details, see :ref:`cubrid-service-util`. .. _locale-command: Locale Commands --------------- **cubrid genlocale** utility compiles the locale information to use. This utility is executed in the **make_locale.sh** script ( **.bat** for Windows). **cubrid dumplocale** utility dumps the compiled binary locale (CUBRID locale library) file as a human-readable format on the console. It is better to save the output as a file by output redirection. **cubrid synccolldb** utility checks if the collations between database and locale library are consistent or not, and synchronize them. For more detailed usage, see :ref:`locale-setting`. Timezone Commands ----------------- **cubrid gen_tz** utility has two modes: - **new** mode when it compiles the IANA timezone data stored in the tzdata folder into a C source code file. This file is then converted into a .so shared library for Linux or .dll library for Windows using the **make_tz.sh** (Linux) / **make_tz.bat** (Windows) scripts. - **extend** mode is similar to new but is used when you want to update your timezone data to a different version and ensure backward compatibility with the old data. It is always used with a database name argument. In some situations, when it is impossible to ensure backward compatibility just by merging the two versions of timezone data, an update of the data in the tables of the database is done. It is executed using **make_tz.sh -g extend** for Linux and **make_tz.bat /extend** for Windows. **cubrid dump_tz** utility dumps the compiled CUBRID timezone library file as a human-readable format on the console. It is better to save the output as a file by output redirection. They went down to the water-side to try the effects of a bath in the surf as it rolled in from the Pacific Ocean. They found it refreshing, and were tempted to linger long in the foam-crested waves. Near by there was a fishing-place, where several Japanese were amusing themselves with rod and line, just as American boys and men take pleasure in the same way. Fish seemed to be abundant, as they were biting freely, and it took but a short time to fill a basket. In the little harbor formed between the island and the shore several junks and boats were at anchor, and in the foreground some smaller boats were moving about. There was not an American feature to the scene, and the boys were thoroughly delighted at this perfect picture of Japanese life. It was sea-life, too; and they had island and main, water and mountain, boats and houses, all in a single glance. "For our sick soldiers!" "Yes, I'm going to take that away with me to-day." "I destroyed it. There was no object in keeping it. I tore it up then and there and pitched it on the pavement. The motor was driven by a dumb man, who conveyed me to the corner house. It struck me as strange, but then the owner might have returned. When I got there I found the man subsequently murdered suffering from a combination of alcoholic poisoning and laudanum. It was hard work, but I managed to save him. A Spanish woman--the only creature besides my patient I saw--paid me a fee of three guineas, and there ends the matter." fatherly letter--but frank! He said he saw from the address that I ¡°Who are you, please?¡± Sandy shot the question out suddenly. He had gone back. "You'll come through all right," said the Surgeon smiling. "You're the right kind to live. You've got grit. I'll look at your partner now." 'he Took Another Look at his Heavy Revolver.' 254 But after the gun was gone, and after Shorty had written a laborious letter, informing Sammy of the shipment of the gun and its history, which letter inclosed a crisp greenback, and was almost as urgent in injunctions to Sammy to write as Sammy had been about his piece of ordnance, Shorty sat down in sadness of heart. He was famishing for information from Maria, and at the lowest calculation he could not hope for a letter from Sammy for two weeks. The firing and stone-throwing lasted an hour or more, and then seemed to die down from sheer exhaustion. Odiam had triumphed at last. Just when Reuben's unsettled allegiance should have been given entirely to the wife who had borne him a son, his farm had suddenly snatched from him all his thought, all his care, his love, and his anxiety, all that should have been hers. It seemed almost as if some malignant spirit had controlled events, and for Rose's stroke prepared a counter-stroke that should effectually drive her off the field. The same evening that Rose had gone weeping and shuddering upstairs, Reuben had interviewed the vet. from Rye and heard him say "excema epizootica." This had not conveyed much, so the vet. had translated brutally: "I don't ask for that to-night¡ªall I ask is food and shelter, same as you'd give to a dog." "Yes, yes, we will consider of some more fitting answer," said Leicester fiercely;¡ªand after consulting earnestly for a few minutes with Jack Straw, Thomas Sack, and other leaders, he returned to De Vere, and said¡ª HoMEÃâ·ÑÍøÕ¾Ò»¼¶ÊÓƵ²¤ÂÜÃÛ ENTER NUMBET 0018zesheng100.com.cn
beijsyl.com.cn
www.zykbj.com.cn
tynsh.com.cn
ivzk.com.cn
www.jlyp.net.cn
www.fvrq.com.cn
taik.com.cn
arccore.com.cn
h0p.com.cn
迷人的浪屄 重口味av 狂操小姐特爽吗 美女屄照片 仓井空片子 潘号 美女大胸色图 美女xingjiao18p 妇女小穴图片 c168b91e000357e6 丝袜骚妇爱爱 操逼图1234 制服诱惑五月四房间 美鲍图下载 亚洲猛女性交图片150p 欧美做爱15图片 草妈妈小姨子穴 刘亦菲无码艳照图 少女和狗性交 裸模陈丽佳 WWW.73XH.COM WWW.22222SE.COM WWW.QOEDU.ORG WWW.NNNN16.COM WWW.KYFDZ.COM WWW.CCC156.COM WWW.GUOXUE.COM WWW.YLQWX.COM WWW.TFKRQ.COM WWW.MAODH.COM WWW.BBB184.COM WWW.2323AV.COM WWW.JAVCHIP.COM WWW.BX2500.COM WWW.SYFX168.COM WWW.XIEEGUO.COM WWW.DSYQ.COM WWW.2651.CN WWW.222128.COM BAWRIBOON.CHANREUA WWW.N9B3.COM WWW.999KPW.COM WWW.ZG99.COM WWW.HHH689.COM WWW.SJ1718.COM WWW.AIDJE.COM WWW.7777RR.COM WWW.BOBO138.COM WWW.QQHJY.COM WWW.5ITAOTU.COM WWW.576586.COM WWW.44SJSJ.COM WWW.464HP.COM WWW.CX765.COM WWW.CCC559.COM WWW.H3AA.COM WWW.998QQ.COM WWW.696EE.COM WWW.752HH.COM WWW.PLAYQTU.COM WWW.HWXNT.COM WWW.BST818.COM WWW.WJABBS.COM WWW.YSTS8.COM WWW.JXAXS.COM WWW.96ZIE.COM WWW.161XS.COM WWW.74KD.COM WWW.VERISIGN.COM WWW.16KK.COM WWW.YNSERVER.COM WWW.QDH100.COM WWW.520SU.COM WWW.CENTOSCN.COM WWW.CCC680.COM WWW.ES60.COM WWW.AXQ2.COM WWW.CK180.COM WWW.38TVTV.COM WWW.KDSMIT.COM WWW.4455FF.COM WWW.HBYPHG.COM WWW.Y5ZN.COM WWW.111FN.COM ILYA.IOSIFOV WWW.YJSBB.COM WWW.9877YX.COM FABRIZIO.FERRACAN WWW.3344G.COM WWW.SJYHOME.COM WWW.984AA.COM WWW.PPAV1515.COM 青青草注册会员 chengrenseqingyingyuan 亚洲丰满大肥屁股视频 欧美少女OOXX svs视频精品分享视频 719BBcom AV制服丝袜 13yn_com wwwOOSIHUCOMmagnet 一本道处女A片视频 抽打妈妈的淫穴15p 播色网1 三邦车视欧洲 成人动漫阿凡达 成人综合社区免费视频www5xsq1com 乱伦家庭一级a片在线播放 四虎影库必出精品浅仓彩音 干老太太wwwjiujiu6pcom wwwonlyjizzcom 连裤袜成人 sq小说网站 欧美色图就爱啪啪啪 亚洲内衣振动器magnet 午夜剧场成人av专场 自拍av射射 伦理琪琪影院a 天天电影网吧 wwwxixi5566 女人下部真实图片 淫荡的黄蓉校园春色 校园春色古典武侠在线视频 雨宫琴音小朋友 武侠古典长篇连载黄色笑话校园春色性爱技巧淫妻交换 干法国小姑娘 童颜巨乳港台三级视频 调教家政妇serious漫画在线观看 wwwvom色小姐 赵薇评价古巨基 男生舔女生bb的照片 东京热苍井空QVOD aluoli5社区 wwwaicbbcom 校花跟我xxx 制服美女小色网 黄色视频机哇插屁股 俄罗斯三级排行 啪啪影院破解版免费 wwwyoujizzjizzcom 三圾片都有哪些 都市激情校园春色家庭乱伦文学 网盘迅雷五月 文爱小说h xfplay丝袜美腿 www3324444comwwwwoaisikucom av爱爱aaa 久久打炮性生活 性爱偷情乱伦做爱操逼 熟女炮友自拍在线视频 裸成人AV 美国成年免费网站 葵司三级片 38p0pocom XxPen成人免费视频 色播五月情天 亚州女性自慰视频wwwjiujiu6pcom 九九色大姐 免费在线视频色小说无广告 欧美下体艺术写真 www4hu41 能见到毛的免费日本电影 影音免费观看欧美A片 japanese12在线homesextopnetsextopnet 给个网站你们懂的2017 久草热av在线小说 q1se 爆操白嫩人妻p 72bao在线 天天拍天天操天天撸 avtt2020 幼女av电影资源种子 3D台湾香港经典三级日本 国产成年人Av影院 琪琪影院金瓶梅 亚洲色～ 性爱合成图片 www5060lucom 尤物人妻小说 张柏芝艳照门在线手机 妓院虐待美女图 3W699UUUCOM wwwyy4480org亚洲AVqq 裸妇熟女 古装一级无码A片王昭君rmvb av空姐蕾丝 dizhi99妇科检查 AV区亚洲AV欧美男同AV 迅雷蚂蚁泰国女优 小骚逼操操操啊啊啊 大鸡巴逼 孙子狂草奶奶 wwwaa456com 9115sss视频在线 少妇少男同奸 3p夫妻交换做爱 狼人综合网123 wwwkkkk25 外国幼女网址 成人视频在线看青青草在线看 狗和人的伦理电影 qiuxis6com 大胆操逼BB人体 月光宝盒官网bai5acn 最新黄色口交图 成人老婆在线性爱视频 不要vip的完整黄片 色和尚香蕉撸 熟妇人妻在线av pornxxx幼女 裸体赌过程 三级片满清十大酷刑 在车上被强嗯啊不要120p wwwxbxbcon 真实偷拍初中生厕所12p 东方av亚洲图片欧美图片bbcc789com 澳门博彩裸体艺术图片 成人动画理论片 亚洲欧美日韩强奸 妓女学校妓女小说 LELEHEIUSmagnet 轮奸文章 淫妻按摩录 色爱影视 幼女嫩穴下载 超碰免费动漫视频 狠狠干胖妞 大机巴饶了我吧视频 人体艺术摄影动漫 幼女色吧 狼人艹综合 先锋资源av色撸 影视操逼的人生 亚洲性爱www8oyxcom 五月姬情 美女姐姐15p 亚洲欧洲校园另类心灵捕手 欧美亚洲激情小说色图另类 妈妈被我t 欧美肥婆性爱 亚zhou色图 人妻好吊视频在线观看 萝莉裸下体 磨豆腐漫画 同学妈妈随便逼操 2B姐姐的色图 偷拍自拍下载 色色色色色小说激情 平井玛利亚 女仆 尻绳 欧美性爱偷拍自拍古典武侠 欧美另类幼女做爱 在线手机播放器 伊人88综合图片网 有声小说每天撸一撸 麻生希第一部快播 制服诱惑亚洲图片 风月恶之花剧情介绍 ckck爱情电影网 女优美弥藤无码先锋影音 戌人快播电影 欧美肥臀影视 着a片 2017宝妈手机在线看片 欧韩久久视频 成人小说3q 成人ob快播 母子乱伦爱爱在线mmissno1com 干网在线清洗流程图 骑淫妻网 wap9999akcom ye3333com 暴插大奶少妇 Yinse人妻 看黄色网站主持人大屁股大逼图 swwwbu370comhtmindexhtm 亚州强爆乱伦视频 亚洲激情性 色莱坞免在线视频 美女粉色AV 极品夫妻大白屁股 丝袜护士的逼 987资源网 丝袜妹子穿丝袜wwwyymeizicom 交换人妻番号 人妖重口味另类文学 综合征服色的站 人妖性爱高潮图片 巨乳幻想第二集 殴美色妇1024 AV作品免费视频 www淫色色淫com奇米综合网 44kkmm` 啊鲁啊奴 我抽插巨乳女教师 守望先锋av动画在线 日本中文a漫 激情五月狠狠干 美国搞师傅 porn91明星 a片哪里可以下载地址 wwwribiavcom W66cccom 瑜伽口交无码成人自拍 欧美人与XXX 亚洲有码偷拍制服丝袜 www115cdcom aV天堂手一 男女全裸舔逼高清片 啊撸啊了嗯 女自拍揉胸视频大全 西方黄色成人三集A片 撸春 超碰爸爸闯进来 亚洲清纯美女性爱炮图片15p 日本黄色电影成年网 射精女性xxx 乱伦熟女人妻在线 波多野结衣床上被操 夜夜撸在线视频暗暗撸在线视频加多撸在线视频天天撸在线视频 淫荡啊浪叫啊操我 国产谷露1 册册XX 美日韩A片在线观看mp4 WWW55ybybC0m下载 夜夜撸wwwkanav05comwwwqbiryfrdoizcn 3344EVCOM 足交手机在线 美女直播videombaiducom 久久在线视频精品99re6wwwbs799com6655acom 中国成人av视频 羞涩涩 av红楼梦在线播放 动漫套图第一页 经典干幼幼小说mchinadmdcomwwwgzyunhecom 捆绑色色色 美女艺术照无码 www凤凰网con 在线播放成人网 偷拍自拍强奸乱伦要在线观看 250pp6wpin 闹洞房就去干 乱伦电影狠狠撸hhh600com 巴扎黑电影 操老师嫰穴 日屄短文 女性阴体艺术图147 熟女沙织漫画 白虎小穴被早 张悠雨叉开腿露b高清 偷看屄的故事 黄色动画图片小说 插菊花色色 幼奸吧 WWW_ZZZ13K_COM 肏笓片 我把就舅妈给操了 进进出出美少女 人与动物交配哪里者 影音先锋激情综合网 超清躶体美女写真 53kkk亚洲小说 杨永晴ed2k 张莜雨人体艺术致意 抠屄淫色网 zipailaobishipin 国模茶雪大尺度高清局部私处人体艺术图片 小女孩逼尿屄图片 南宁极品美女 欧美 性交图片 113rr WWW_RIRIHEI_COM 夫妻性交真像视频 a片强奸系列快播片 k8经典伦理 韩国女主播朴妮唛的黄色小说 和妈妈在火车上做边爱 色 WWW_WW789MM_COM 那个爽啊 出卖女友刘晴小说 干逼空姐电影 av销量第一的番号 撸管色中色 水果干影院 电影 高清口交图 ed2k佐佐木 黑木耳验收材料 老奶奶跟孙子做爱电影 弟弟和姐姐乱伦 147日本人大胆子女艺术图 黄色漫画书免费3级 一个20岁的凶虎 进爆欧美性爱 中国老女人草比 苍井空av百度网盘高清 亚洲美女论坛 与淑女乱伦 婷婷五月性 少男裸体人体艺术 尼钭空 龚玥菲xiaos 欧美裸体私处照 制服丝袜松下美由纪 调教日本女优 幼幼撸片 侏儒女 � aikojiaocom 32式夫妻性姿势动态图 xingaidexiaoshuo 美女一丝挂全一裡图 护士嫩b50p 第四成人黄色网站 京野结衣电影 漂亮女人下载 小色迷ge 美女车模操逼 西西自拍波多野结衣 欧美动态成人视频 女人一天最多能承受多少次性爱 五月天天色小说 越南女优 外国成人频道在线 欧美裸体影 丁香裸图 入江辉美在线电影 葵花牌壮腰健肾片 广末凉子成人片被性侵 美女裸体人体大胆脱小内内露b穴毛图 成人大胆摄图 亚洲色图 筱 和公公乱伦的女人们 少妇美嫁娘 中国人做爱自拍偷拍视频 银虎导航网银虎新地址 田韩a片 我姐尻屁片 儿子强奸继母图 美女全裸劈腿被奸照片 月野沙里qovd 护士不穿内衣要我的大鸡巴操她逼 经典性爱图片 精品少妇被老外硬刺无码吞精 qvod 套动换妻 色色艹妹妹 免费成人网8888 中华人民共和国行政诉讼法 暑假危机夏令营修改器 彩色面条机 兴业银行赤道银行 大朗启明星初级中学 孟锦云照片 俄罗是做爱 巨乳超美熟妇人妻 gegeyaocaobidianying 郑州私人影院装修 pornsoraaoi 小姐操逼照片删除删除 非洲美女大胆人体艺术照 weiriguobidejiba 狠撸撸蜜桃 klk第一主双插双枪爆菊 毛逼网站 做爱图片激情小说 WWW260TUCOM 大尺度裸体操逼图片 制服美女淫影院 射在里面的照片16p 美鲍色图操b 学生尻妣视频 www色中色在线色com 张柏芝艳照偷拍 美女性爱过程图 同志小说一直男干了我和老婆 日本少女乳头人体艺术照 美女用手掰逼套图 日韩在线自拍在线 各地美女人体艺犬 农村黄 好看的乡村熟妇小说 父与女偷摸乱伦 我和少女做爱视频 我插入女老师体内 东京热无需播放器 快播一本道a波多野姐姐 淫秽网站专区 水里狠插屄 丝袜骚妇人妻乱伦 酒色1413 大胆人体艺术导航 快播孕妇影片 欧美自拍偷拍下载 oumei在线长篇小说 WWWKE47COM 章子怡淫照 操阴快片 宋祖英大胆人体艺术 香港成人免费电影艳照门 首页52avzycom mac版淫色网站 美女被马强奸小说 综合色站影音先锋 儿子操妈妈bi 影院里那些男孩的秘密txt 免费在线3p口交图片 亚卅大胆人体艺术摄影 美国性感波吧 强奸丝袜美女的视频 为什么上不去成人电影网了 张幼女大胆美女人体艺网 韩国限制片迅雷种子下载 女乱15p 骚逼大咪咪高潮了 亚洲色区成人电影图片 与老师性交 农夫导航人体艺术 日本丝袜片子下载 3p性感尤物内射她的小骚穴 粉红亚洲妹偷拍自拍 风情谱女公关第10集下 黑人大战亚洲骚货 五月天婷婷乱伦图书 美女图片大胸删除 屄草垮 黄色glf 黑人强奸熟女影音先锋 足x番号 插逼里动态图 妹妹干偷拍私拍自拍性爱色图 激情美丽小骚屄 温州女友做爱视频 迅雷黑人a片下载 美女邪恶裸露人体艺术 日本黄seibt 苍井空擦b 第9影院在线观看 丰乳肥臀迅雷 WWWWW87XXOOCOM 快播大陆少女1级片 丝袜足交老师小说 国产视频熟女系列 女人与大黑狗真实插入播放器 农夫成人电影人与兽交 淫崎千鹤动画 五月天乱伦色色的有哪些小说 工具插入小穴 鸡巴图片网 怒火街头在线视频 快播日本a优 久操偷拍自拍 18女人人体 lu二哥男人影院 零度战姬ed2k 性感日本古典黄色图集 姐妹情室光棍 日木三极片 激情亚洲色图先锋 动慢成人 伊人在线琪琪色酒色网 朋户区av视频 肉丝裤袜跳蛋小说 丝袜美腿新感觉要操逼网 日本老奶性视频在线观看 爆乳欲室在线观看 狼人干综合新地址HD播放 saiavloanmagnet 性启蒙番号 老淫哥 搞清大片人人看欧美 亚洲美穴15p 彩漫哥哥的sex计划 av成人视频干妹妹 xx妹妹 裸体毛网站 亚洲幼女口交电影 亚洲色偷拍亚洲图片18m18vecom 国产自拍韩国综合 三级片嫩模做爱视频成人片 激情乱伦三级片 女性做爱人体艺术 狼国网成人小说网 我和妹妹在浴室里操 大姨姐与妹夫乱伦偷情 妻子蜜穴 夫妻自拍和朋友做爱偷拍自拍全部视频 overthumbspenis图 酒色狼国成人 干呦呦图片 裸体漏阴茎阴道性交流k精 狼国3p图 父女奸淫荡 pom黄片 小说区黄色小说 av磁力网站 www美女sex 米奇影影 新婚开苞 日本大胸熟女妈妈在线视频 色就是色欧美图片亚洲图片7eavcom 强插小嫩妹 撸撸火影同人 wwwmumu50comuc 就爱啪欧 女教师成人电影网 亚洲色图制服丝袜骚秘书 金麟岂是池中物无修版 久久热人兽交配 成人电影成人网站成人小说网 模特公车痴汉在线 mama姐弟cao oojizz 成人性交免费一级黄片 日本漂亮的av无码网址 全裸无码无内衣照片 女王专区 夜i夜i骑 欧美五月香婷婷 黄色三级片爱色色哥哥 同性恋黄色小说小卖部 人体艺术照sadrine私房美女图 MP4视频亚洲日韩色就是色欧美setu avHS动漫网站 艹比视频免 成人诱惑网 丝袜淫母 最新幼交自拍上传视频 丝袜美女说我爱被你插在线播放 男屁眼被曰小说 男男性爱想双飞XX网 av女苍井空大胆人体 插射进去操综合网 先锋影音av资源站馒头 女婿让我疯狂 wwwhaorenshuoc 空港magnet 249hh快播电影 70岁操屄 色影院 另类有声小说 小泽玛利亚码新作 小泽玛利亚vod 哪里有h网 www小沈阳网com www松原油区二中 东京热antianshaji 东京热妇女 酒色网电影 手机现在怎么看黄片 去哪看黄片 想看黄色小说 彩美旬果 国产自拍 就爱插比 就去黄色 性爱用品 苍井空与狗 广播五月天 淫荡色小说 007成人网 12点文学网 人间风月影院 台灣佬娛樂網 唐伯虎成人站 淫妹妹激情图 163色电影网 在线电影性乐汇色高清 桃花族 撸特特 篱笆女人和狗电视剧 一本道avt天堂网大香蕉 好吊妞视频 mp4 亚洲欧美动漫在线字幕 淫色人妻午夜 色色色999韩在线播放 狼人干综合亚洲av 外兔网黄色网 DVDES- -664 mp4 av在线东方影库 免费看片美女 久久爱一本道 老鸭窝伊人无码不卡无码一本道 亚洲日韩色偷高猫咪 丁香五月综会缴猜小说 美祢藤コウ影院 吉泽明步 极道之妻 先锋 舒淇三彶在线观看 鲁大妈Xo 裸条在线观看神马在线 女捜査官西条琉璃在线 IPTD 853 在线 色色影视插插综合网 AV成人电影天堂 泷泽萝拉无码 ftp 大波浪综合成人网 欧美手机成网站 绝色福利导航视频 200bbb 国产自拍 视频 - 色色风-成人在线视频首选! 祼露毛片 jlzzjlzz现在播放 靠逼动漫影音 自拍经典迅雷下载 91大神扬风回馈网友支持,邀请网友一起3P白嫩性感的大奶女友,前半夜操完睡觉后 佐藤佳代无码 妹妹影院福利片 秋霞电院在线情侣偷拍 性8春暖花开论坛亚洲区 兄妹番号 新疆梦郎车震3P轮战50老逼 青青草免费在线播放 全裸正面叉视全裸正面叉视频 亚洲aV 性感皮裤高跟36D爆乳骚货情人性欲高涨 边看AV边暴力淫操 高潮迭起 浪叫不断 使劲 校园春色视频 求一个免费看成人直播的网站 小片网站 日韩无码国产精品欧美激情 日本无遮拦搞基视频 在线偷拍女厕正面视频 日韩丝袜写真视频 影音先锋看片资源q814@ 圆挺奶 在线观看美肉流刑地 天堂鸟影院西瓜 幼女自拍 超频免费视频12 剧情演绎在线 春野樱黄 萝莉做爱 日本午夜大片免费下载 欧美一本道字慕v 曹逼逼 成人影院d 91apt cn/mc taosege 玉足亲吻袜袜屋关注的视频 曰本人男女做爰视频 人休艺术张伯 用啥看考比视频下载 福利视频伊一 广州sm论坛 泰国古装A片 下载 五月福利视频导航 宅男福利成人在线 亚洲 视频偷拍 五月色播 loli h movie 下载大鸡巴视频资源在线播放 火星打接触在线免费观看 诱惑自拍 爱情鸟做爱视频 丝袜全包挑战视频采集 灵猴福利影院下载 三级做爱网站视频 少妇寂寞与狗迅雷下载 下载 被大鸡吧塞满的视频 99福利视频在线 大香蕉一本道富二代 李宗瑞在线午夜福利 欧美艳舞在线播放XXX yy6080影视觉影 黄色小视频一 公海 日本 美女 MP4下载 操你啦在线视频综合视频 亚州福利色 苍老师唯一流出视频看 女神自慰磁力下载 殴美黄色视频 g0g0图片大全 big acg 杨丽箐丝袜 美山兰子 富姐搭讪坐顺风车被 爆乳天堂 麻酥酥哟完整视频 magnet 美教师地狱责问 免费啪啪free 女生自拍在线 蜜桃直播脱内内 欲忘岛在线免费视频 迅雷下载 双穴 高分影视盒视频播放器 色爱亚洲五月天 wwwuuu7777com 无翼鸟少女全集 美莉喷奶截图 深夜影院免费打炮无码电影 台湾理论一本道电影 四库影院在线看的免费视频 午夜影院色琪琪 初川南 xfplay 2018黄色网站仼你搞不一样的搞法 caositayingyuan 曾舒蓓 w午福利人 91大神经典作品酒吧认识 青青草在线自拍综合 韩国操逼现场 jux886在线观看 樱井莉亚97集在线播放 t66y上榴人士 4444国产自拍 农夫av片导航电影 足控电影有哪些 三级riri看 亚洲强奸乱伦比比资源站 欧美破苞手机在 韩国可疑的美容院电影斑马影院 4438x2最新 韩国演艺圈1313在线观看 网站升级反问 xfyy卡通动漫 弱气乙女 浴室套图 成人资源AC av在线直播 韩国 年轻妈妈在瑜伽室做爱 最后还在家里的电影 www,5x脳,coM 8055神马电影 六点成人 波波视频成人影院 av插进去 看片+v信 www路AV av网站国产在线观看 俺去啦怎么打不开在 神马综合天堂 疯狂做爱dvd xianfengAV 德国老太AAA视频免费一览 第3页自拍tp 大香蕉狼人3d动漫 大香蕉新人人现 飞机福利视频导航 福利gof 浮淫视频 对白精彩淫荡风骚眼镜熟女妈妈与干儿子淫乱直播吊钟大奶妈妈是真的骚被爆操内 xx4s4scc 噜噜ccc 88电影于是院 18ansvideosdese ov 日本成人黄色动漫视频 大香蕉高清网站在线 高富帅小鲜肉微信约炮粉嫩小穴童颜美眉啪啪啪 青青草小穴视频 小奶屄 成人隔壁老王网站 国产综合5x视频在线 白虎嫩滑视频 激色猫欧美系列大香蕉 求黄片百度云链接 韩国女主播种子下载 magnet 波儿影院 99rehd。cc 欧美视频1随机播放 人人妻在线人人 成人av所有网址 天天re99 俺播 视频二区 亚洲 欧美免费 涩琪琪手机原网站 一冢本av中文字幕 wwwAV手机 朴妮唛福利全集霸气村 xxxooo日韩 御工黄色视频 色色播播,四四播播 ai美女鲍鱼b 今日推荐视频更新于 ------------------------ 《幼幼》两个18岁日本学妹背着 日本公开在线无码视频 182福利大香蕉影院 sosonn 在线漫画 午午西西影院 好看的吃奶av番号 eee119改域名 口交视频app 小黄瓜免费的福利视频 梦莉视频导航 馒头B紧身裤视频热舞 国产2017自拍视频 国产 偷拍 日韩 欧美 9丨福利社区你懂的 xxxx日本免费视频高清无码 【正在播放 [MXGS-754] 別顏空姐 麻生希[中文字幕] 第1集_日本av电影 av网站 青青草韩国演艺圈悲惨 0077cao改成什么了 丁香花开心五月手机在线 51av影院 醉地艾迪东方 秋霞影院www,eeussyy 守望先锋AV动漫版 影音先锋 兽兽门2008在线 理论片中文动漫dvd 午夜无码影院百度 亚洲色农夫Av 狼狼在线观看免费 新人主播性感长腿小安妮，情趣内衣火辣热舞，粉嫩骚逼激情自慰，呻吟可射，精彩不要错过第二弹 射精王 成人短片库m4格式 被窝全黄色片 妹控ova 日日操无码视频 香丁六月婷香丁网 河南露脸超嫩 日日在线 在线偷拍福利视频 一本道插逼逼 美女破处 大空美绪 午夜av影院 手机版 色尼姑影灰灰影院 日韩护士丝袜无码迅雷看看 免得黄色视频 伊甸园李丽莎福利在线 日本偷拍免费高清视频， 3344动画伦理片 图片小说 西瓜影音 黄色视频小说网站 番号水杯里面下药 WWW4T4F 日本女人喷潮完整视频 撸大爷影院 日必在线播放 91在线福利影院 最美人妻女教师 苍井空 Z影院。 gvg464中文字幕 成年轻人网站色直接看免费 电影颐和园耒删版在线播放 男人天堂在线资源tb hqnxiucao ffeex日本女孩 7k7k成人网 柳州莫菁视频12部全集 有点婴儿肥的清纯巨乳小学妹 资源影院tom51西瓜 9uu18 con 369看片永久免费 star-527古川ぃぉり 泰国天皇秀视频高清 757午夜视频第28集 极品F罩杯二次元狂热少女女生寝室场景视角自拍视频 51avi免费视频新地址 小明中文字幕免费视频在线观看 想看老外日屄的视频 性爱 视频 性交细节抽插视频 邪恶少漫画大全3d全彩欧美 鸭王2abc影 性交视频中国 小雪小视频bd 邪恶全彩无码ac漫画大全 JAVHIHIHI视频 神马影院dy88 福利 松果儿你懂的 幼nv fanhao App爱波成人影院 艺术片 伦理片 国产精品 od369韩国漫画 阿v在线观看免费 天堂 ananshe 日本东凛视频在线 成人电影午夜剧场a 开心丁香综合缴情网 任你在干线 玖玖色北条麻妃 av小说秘 欧美脚交在线视频foot 巴西美女按摩视频 色色哒福利 绝色老人轮奸波多野结衣 操妞视频播放 she一夜做爱视频 日亚洲欧美牛b叉电影 CcCC77欧美性爱 s第一福利 岛国激情片 我的老师黄片 hd东京热无码视频 成人性感动漫xxx 午夜影院xo暴爽影院 想要零用钱妹妹 素股 春节来历 催乳成人福利视频在线观看 亚州色图片成人插入视频 淫色草民电影 1027 核工厂 down xp 黄色视频高潮 播放s级毛片 日本成人性视频 日本厕所偷拍视频tub 摸射你在线视频 四虎尻屁影库 群橹大香蕉一本道dvd 白石さゆり 司机 亚里沙tsdv 41636在线 白白操在线免费观看 人人澡人人漠大学生 擼擼色綜合 黄色网站2117 芥麦色片 五月天亚洲网站 国外a片成人网 北山柑菜 中文字幕 被知道丈夫隔着魔镜 美容 国产在线导肮 苍井老师成人视频免费下载 猜谜系列的AV 波兰性交比赛视频 草莓午夜视频在国产 北京熟女楼凤群交 视频 国模超级福利在线 av导航大全 白肉淫 成人快播有声毛片 凹逼美女 老太太影院 黄播龙虾直播 陌陌约炮视频在线观看 自拍 欧美福利图片 800AV最新地址 未封av网站 蝌蚪窝窝在线观看 台湾怡红院 2018av国产手机在线视频 肉嫁高柳 magnet 澳门avav pppd424正在播放 向井蓝AV天堂 rbd浣肠 ts国产视频大全 wanz226mp4 vidz老湿影院 RIBENSANJIXIANGGANGSANJIHUANGSEWANGZHAN sl深夜福利 叉开大腿b我要添视频 rhj 228 播放 北川瞳在线高清 成人啪啪碰在线视频 RHJ-228 savk10 屄片小 se86视频在线观看 波多野结衣在家线观看 renrenmoshiping 美女主播露全身视频 プレステージ在线电影 国内偷看在线 93gao免费视频 绫波世娜磁力迅雷链接 老婆被 后入 91 KTDS-681 在线播放 ipx-072播放 电影我被人强奸 伦理片冫 日本女人,淫荡视频 干b乱视频 女同a片 9l国产自拍 吉吉影音冲田杏梨 乳胶xo影院 国内夫妻自拍tu视频 俺去啦在线不要播放器 橘佑金短视频 在线亚洲 欧美综合网 可以看的手机小视频 AV福利人妖 爱爱黄业视频 足交丝控漫画 海贼王黄版视频在线观看 2222老司机福利 女人与马干 thunder 日本三级,韩国三级,香港三级黄色视频在线观看色就是色 黄色丝袜小视频 美女主播仙桃福利视频ck kan3p cn在线电影 在线内射 mp4 后λ视频 国产精品在线视频Chinese 被大阴茎插哭的经历 偷拍 自偷 亚洲 在线 678dvd yy4408 伦理电影 牛牛视频露脸 黑人碰碰视频在线观看 1234色视频 韩国美女ⅴiρ神马视频 日本高清做爱无码视频网站 黑丝白肉我珍藏的av女优 春暖花开性吧有你亚洲无码 骑兵射福利一本道电影 无码嘿嘿嘿种子 波多野结衣末剪版在线观看 操呦呦777 仓多真央电影在线 国产自拍视频 yunfile 韩国最新网红主播福利视频大秀在线 国产在线偷录叫床 国产足j在线观看 韩国女主播福利导航 国模嘉妮大尺度视频 淫荡网欧美性交 免费性感a片野视频 熟母乱伦在线 pppd424在线播放午夜剧场 0 d恋老视频 SM 自拍 免费下载 747看看福利午夜影院 qingqingcaohaodiaosi 5566夜色在线 吐痰推荐,国外收费作品高品质CG动画51V整合1 四虎影院wap 1做爱 日本 中国人 小老汉在线视频 182tv-人人草-大香蕉-av在线 欧美激情日本视频 极品H片 我爱你AV52 亚卅无码最大视频 午夜影院费试看一分钟 84papa av网站800东方在线 日本三级香港三级成人网自拍在线观看 哪可以看工口 种子番号全集 ftp 村上丽奈番号 天天操天天玩 创造女生脱裤子洗澡 灰灰福利dianshioing 伦理图片二本道 国产自拍在线网页 在线 熟 激情邪恶大香蕉 九洲做爱视频 伊人久久五十路 一次肯德基哄骗邻家 十大暴力番号 第一福利成人在线 裸体女人的福利 伦理片天天射 美女被调教视频网址 乱伦交配视频 美国十次人与兽 美女91影院下载 乱伦片 下载 乱交在线视频 琪琪影院 黄页网站大全免费视频酥酥影院 全国最大成人网4438x9 青青在线自拍频vip 极品女神级网红美女可爱小胖丁和长屌土豪酒店约炮 白皙皮肤 经典欧美推荐第一页 吉迟明步1313 姐弟亲嘴啪啪啪视频 精子窝最新永久视频 青娱乐首页 耄耋视频亚洲 伦理巨乳速发福利 4438x是啊 伦理电影在线观看自慰 曰本lAV视频 yuojizz中国熟女 紫藤·伊莉娜h动画 偷拍广东情侣野战视频 大香蕉520 去便利店的途中在车内发情的妹妹 国产重口在线 不橹三二一 琪琪在线va 日本性交真灬 奇米第四春影视盒 百合情韵在线观看 唐山葬本子 动漫里番在线 se0107com 午夜伦天堂理影院 水滴摄像头偷拍 青虹资源搜索网站 双性人妖系列在线 mc小仙儿喊麦mp3 zzaa1 海瑟格拉汉姆大尺度电影 javhdvideo15,18岁 深喉 视频 @ simulant 黑人插pp 24p动态视频 黄瓜视频网站在线播放 女主播赫本磁力 好看的欧美无码中文字幕 护士被羞辱调教 一级黄片XxXx 桃园怜奈磁力 人 妻 少妇 很恨鲁在线视频播放 日本老熟妇性欲 wankz小黄鸭 国产自拍 黑丝诱惑 欧美性爱免播放器在线播放 后入 夫妻 自拍 视频 夫妻一级黄色录像片子 亚洲无码自拍 成人两性拍拍红番阁 四虎女友 皮皮虾无码 肛虐泥鳅在线看 邪恶里番漫画 四虎伦理手机在线 仔仔网 九州 国产自拍 av 动漫番号种子 韩国女主播迅雷磁力链 特殊视频百度云资源 ooxxoum 国产自拍偷拍操逼视频 女同偷拍自拍 秘密网av 石原莉奈电影院痴汉 26uuu小说 magnet 猫咪热播喷奶视频 婷婷丁香色 东京热哥av 女主播BT 在线成人av影院 视频 女神思瑞在线播放p 我与憧憬的太太中文字幕 mm无码 扣逼免费视频 亚洲一本道免费观看看 艾薇儿口爆百度云盘 wwwtoutouyaocom 韩色漫app 国外操逼磁力链接 下载 免费GAY片在线播放 男生福利影剧院 好逼免费电影 国内丝足熟女视频 内裤哥郭静在线 动漫XXOO视频在线观看 澳门自拍偷拍视频 丝袜伦理中文版 蛋蛋剧场骑士影院 涉谷果步sdde 绝色毛片无遮挡 无码性爱视频播放器 91超频碰人人在线 午夜视频是看体验区30区 伦理片 在线听书 午夜玩bb视频 国产 日韩 中文 自拍 8x在线成人 在线视频 手机视频在线日本 宅男啪啪福利 汤姆影院 avtom_四虎_四虎影库 欧美三级电影 甜蜜的乐团 AV超级搜索 猫咪maomi永久发布 日本X××oo 921影院 av隔壁老王每日更新在线 窝窝炮 西瓜影音 www99bb9com 福利前线影院 三上悠亚xz 插萝莉影院 1315影院 久久口交插萝莉影院 神父AⅤ动漫在线观看 wwwdd324con 亚洲风情 国内自拍 日韩 208午夜福利手机在线 欧美畜生伦理 wwwsavk18com 西西里高清模特艺术图 有声huangse小说 哥迅雷 女人操逼打炮 兰桂坊黄色电影 三邦车视网图片 小姨子的丝情袜意3p 妈妈跟狗搞 狂干黑丝足交美少妇 天天操欧美图片 日本黄片用避孕套 幼女小说集 日本乱伦狠狠插图 luxiaorenchaobi2008 樱井夕树无码 插得好爽在线小说 性爱女子会所小说 漂亮美眉床战色图 八匹狼娱乐社区成人 三级片神马影院 WWW_49979_COM 同性挤奶 亚洲人人体艺术大胆照片生殖器官 WWW_8090YYYY_COM 张篠雨人体艺术大胆照 女色幼rmvb 欧美老女人性爱电影 免费的皇瑟图片 幸富配电子书 赣榆淫妻 就去caobi 1314seqingwang 极品白富美爆操15p 亚洲成人影音先锋 很狠爽欧美 撸撸鸡巴射屄了 我要看明星淫伦的图片 自拍在线网 欧美av人体图片 看裸体漏阴道 飘花电影网乱伦小说 成人艺术色天空 撕开女友丝袜做爱 15岁少女撸撸色 西西人体粉色 japan sex woman 亿性家成人综合社区 少妇与老头黄色小说 誉田まみvideo 日本人体赛车大奖赛 骚女无毛逼 小b插的流水了 有哪些欧美同人成人版电影 骚妹影院删除 张瑞草书写法 性爱动态图片15p 姥姥撸一撸姥姥网 次原佳奈美图片 ooxx的日本动画片 父母性生活论坛 偷拍偷窥少妇内衣 裸体美女艺犬 奶妈肉穴 陈冠希功夫影音先锋视频 quanjialuanlun 欧美美女人体艺术动态 美女全裸图片百度 无码时间停止器 李宗瑞哪里又看 刺激抽插爱爱 色亲资源网 成人妹妹 视频 苍井空 时间停止 色老爹小说 小泉彩人体摄影 大骚哥 小色弟在线电影 女儿的嫩穴qvod 人体艺术图片topai 不要播放器鸡吧操进屄 张柏芝舒淇露大屄图 少女美鲍人体写真 av女优超市 淫荡的性爱图片 sex8ccpoweroriginalwestern 狠狠射操逼视频 rosi99 苹果手机迅雷云看片网站你懂的 日本美眉尻骚 16yeye 深圳合租挽妻 鸡巴插逼视频快播 穿越之淫乱小太监 强奸a片艳照 俄罗斯明星人体艺术 成人片a片区内 女人bb图片 五月天第一会所 日本超大胆人体艺术组图 18日本美女张开腿图 亚洲色图 偷拍自拍 我和小姨 20美女嫩穴 日本拳交迅雷 胖妹子人体艺术 真实做爱的快播伦理电影 蝌蚪窝一个释放 另类视频成人激情网址 lunxiaosou 狠狠插电影 苍井空拍过哪些电影 清水凉子summer 超大奶裸体人体图片 俄罗斯乱伦熟女 欧美鸡巴操阴道 吃了春药的女人会有什么反应图片 超大胆裸体黄色图片 日本快伦播电影 厕拍 博客 极度兽性未删减 先锋影院日本模特 美女的乳头人体艺术 陈静仪乳头很大吗 影音先锋韩国偷拍电影 乱伦故事狠狠碰 操妈妈屁眼快播下载 13岁美少女人体艺术图片 波多野结衣被射精图 激情偷拍自拍影音先锋 大鸡巴插入少妇小穴最性感 生命的力量全套照片 找个色阿姨 母子群交乱伦 第1集 幼乳图片 大色哥小色妹淫色网 搜狗裸体女人 夏娃露三点 张柏芝美屄 和美少女做爱 超大美乳妊妇 什么yiemeichuangyifudemeinvtupian chuangshangsheqing 小妹的屄好浪 我给小妞抠屄 淫荡骚姨 弟与妹性交弟阴筋长粗妹更舒服吧 我爱人妖色色 mm五月天影视 仓井空55伦理 男女明星亲吻做爱的电影有哪些 欧美大逼片 粉木耳 两穴 很黄很色好想撸 黄色小说乱伦姐姐 qvod校园偷拍 WWW_CHESSOURGAME_COM 激情狂干风骚高老师 被男老师拍照奸的漫画 欲妇小说 www46xxxcn 绘狗大奶子人体 毛毛片性爱做爱视频 WWW_AVXQL_COM 徐静波 魔兽世界335 十八和谐最新地址 姚双喜 孩子脾气暴躁怎么办 潘益兵新浪博客 阴毛摄影 激情爱爱色成人综合网站 妈妈的逼逼就是给儿子操的 丝足美腿性爱 欧美艺术性先锋影音 腿攥 女人的阴毛都是什么样子 女儿摸爸爸jj摸乳头 WWW_PSW_COM 黑人轮奸故事小说 WWW_258SAO_COM WWW_TSOHU_COMURLJS 日本深夜成人节目下载 崛北真希无码图 0099aaaa 三十七度二极品人体艺妓 天天花逼网 mp4xxoo 给我视频舔逼 夜夜撸美女色图亚洲色图 日本幼幼照片 日本艺术照 看3d动画a片的网站 mmm摄影图片东莞纪实 超级乱伦qvod 爆操少妇内逼网 bdcda061000018b3 操小姨骚穴图 裸体黄色性交片 baihumantoubicao 日本老师av华为网盘 益ど缜? 淫虫操动漫美女 乱伦伦理成人电影在线观看 黄蓉肉棒音影先锋 亚洲少妇门 大奶熟穴 WWW_KKAAA_NET 小说大奶老婆阿云 春药强奸大肉棒插骚穴 18avady 东京热一起撸图片 人体穴位高清大图 美女的丝袜小穴 张柏芝快播图片下载 美女被鬼搞穴 久操b网新闻 京子20歳sm身体改造肛门拳交 成认小说乱伦 狼客导航 我的可爱女友黄色 中国大大奶老太婆 欧美sese老肥熟 色kanav 一丝不挂美女做爱动太 骚姨妈成人网 成人图欧 偷情操逼图 人体艺体虎穴 ed2k艳照门陈冠希 乡村m女草逼小说 操少妇的屁眼 天天干狠狠干 乡下老夫妻扫墓坟前做爱高清偷拍 avhbocom yazhouwuwuma 万全影院在线观看1一 迅雪极品图洁 操欧美少女逼 中学屄吧 岳母乱伦电影 肥佬影音怎么看黄 92jiba 48岁人妻自拍 人与动物交网 欧美美女人体偷拍 小明看看主页永久播放 蜡笔小新1 花裙人体模特写真 强奸孕妇系列先锋播放 日韩美女黄色图片 人与动物xxxx 操逼电影种子 和波多野结衣一起演过口交的 江湖yin娘txt第二部分 男女办公室激战 自拍操六十老女人屁眼 少妇的裸体照片 爸爸插错洞吉吉 人与驴bt 五月色任 我我我xex8 幼女专区 wwshe3com 把鸡巴插入女生屁眼里的动态图片 鲁大妈黄色做爱网站 90后粉嫩馒头b 阴毛留长了好吗小说 萌芭下马 WWWPLXSWCN 操我干我种子 26uuu色酷色 所属分类日韩 幼女阴体 宾馆偷拍p 无码av电影影音下载 伦理片艺术片菅野亚梨沙 小牡蛎13部ed2k 丰乳嫩穴 成人人体色色图 女人阴口是屁股眼吗 无广告的人体艺术 女同成人狠狠插 色尼姑久久草视频 WWW53AVCOM 欧美快播性爱 少女被干影片 一夲道京东热全部电影 PRoN3oo 哥哥插我大鸡吧亚洲色图 土逼成人短视频人与狗激情 在线母女性交 会动的幼幼动漫爱爱图 骚穴内射骚逼 一色百毛片 五月慢菜种植 超大胆艺术摄影 一级全黄色片 少妇添阴自拍偷拍 韩国色人体艺网 成人毛片图 ddd42色妞妞基地 肏骚屄莲莲 yyrt5yy 日本性感美女阴部性交 bbse5在线观看 曰韩美女解禁大图 日本美女1234图片 WWW378PAPACOM 爆操大奶少妇 日本十二岁少女阴部裸体艺术图片 色吧图片快播你懂的 西川结衣百度影音 欧美性脚足交视频 夜夜撸小萝莉露逼高清图 插你妹影音先锋 www1122aqcom 淫色舅妈 亚洲欧美动漫日韩国产 艳照门无码高清照片 乱伦爱情看电影吧影音先锋 亚洲色图老女人13p图片 妹妹冈 色图操bb强奸 超成人免费视频在线 鲁大妈色播网色网 欧美人体巨乳大尺度艺术 艳鬼还魂被奸图片 日逼做爱干逼摸咪咪视频 aika黄图 亚洲学生妺大战西洋枪 赤裸羔羊接吻 群交肛交老婆屁眼故事 天天啪啪久久嫂子 干的护士嗷嗷叫50p15p 中国爱城bt 女尊男子白虎 被医生舔的好爽 bt撸撸色 啊不要舔那里不要吸有声小说 freevideocum 成人天堂av2017www9966acomnv325com 阴道检查H视频 白白色白白撸 成人在线超碰资源网 亚洲欧美丝袜自拍变态 567pp男人最爱上的网 兰州美女买阴qq号是多少 乱伦高潮大叫生殖器特大 操逼在线赌博视频 自拍偷伯乱伦小说 女淫欲网 直线与圆的方程试题 qyuletv青娱乐在线 caopotn尿尿 拷问凌辱潮吹 国内自拍mmagnet 西协美智子人体 百度热javhd 丝袜脚意淫 绿色无毒的av电影网址 激情综合网激情五月肉棒 ppt播放avi黑屏 韩国美女自拍偷拍做爱图片 群撸网magnet 欧美精品有声精品 额我也去撸苍井空 淫嫂乱伦 制服盒子 乱伦小说网址导航 明星宅男 百青青草 另类女同群交小说 色色激情开心无码影音 欧美美女图片网 美女乱伦wwwtb181com 浪妈妈电影院 动漫AV中文字幕迅雷下载链接 亚洲日日干哥哥日日妹妹 老婆和小伙干小说 超碰97人妻办公室 雪白的古典武侠 农村老头做爱视频自拍 校员春色搜狗 性暴力俱乐部 亚洲成人图片偷拍图片小说 欧美seut 情人偷拍第一页 老汉推车g8 猛插淫女骚穴 肥姥姥性交 粉嫩pao 免费大香蕉狼人干伊人久草AV网址 丝袜自拍露脸套图 狼客库 小男孩与塾女乱伦系列小说 色taotu qingjunlu3最新网 亚洲成人网站做爱小视频 成人网站狠狠撸 busx2晓晓 母子乱伦竞赛 骚女孩的禁照 公公大鸡巴太大了视频 撸撸鸡巴kk569com 南国成人网 偷拍裙底玉足 好大的奶好爽妇人 北京ktv抱起小姐狠狠操 青青草wwwxxb29com 绝色美人妖魅力百度 俄罗斯情侣系列 草草飞飞爆菊 久久女同小说 长发高中妹子宿舍自拍 荡妻快乐得公用洞 结婚偷拍10p 妞干母 成人激活网 女人力三级片 最大胆的美女生殖器人体艺术摄影 美国chengrenpian视频 激情网怡春园 a片长图搜一下 avtt一字马 WWW_K_6X9X_COM 电影一苍井空一 美岛玲子 人逼被狗插 潘号 色图偷拍白富美 yese321com 家庭乱伦之人妻 ccc36最新偷偷撸影院 嫂子在厨房 115礼包码变态秦兽交 伊人在线小泽玛利亚 WWW_KKBOSE_COM 图纸上井道是怎么表示的 五月天母子乱伦网 影音先锋最多人性交 � 我要操成人电影 色科蚪 一路向西欧美伦理电影 欧美a片家族乱伦下载 强奸岳母wwwwwww85com 爸爸在隔壁9 小白黄片 熟女多汁20p色中阁 霜姐 m625成人影院 龙腾视频网 波多野结衣裸体人体艺术 wwwshafoucom 亚洲综合图自拍欧美 黑人幼女肛交 写真视频网站免费 人狗红色录像一级带大片 有这骚逼长腿女友操了她 人体室 wwe51yycom 大帝av视频娜娜操总动员 阴布图片大全 xplay在线播放 绝美少女玩内射 wwwgegeganne 夫妻乱伦性爱 皮裤美女10p 色久久色琪琪第四色www978aaacom goo电影777 色狼窝wwwqqqq64com wwwpz599cpm 色小结 纵犬潜伏下载magnet 萌妹国产在线 艳遇传说 av成人在线视频在线超碰网 找黄色激情小说 wwwsihu184com xxootv 偷拍影音先锋电影网 老婆和小姨子们在广场上及野外肏屄 高中女生美鲍 免费大鸡巴猛插美女淫穴视频 艳照门女主角 美色www色mwin4000com 春色网激情区 www535ddcom 日本自慰游戏网 分享翘臀老婆贴吧 自拍在线视频第一页 淫妻色图网站 超碰国产偷拍视频 色妹子综合 常用的黄片 熟女炮友自拍在线视频 搜索www妈妈与儿子乱伦大杂烩 操少妇1024在线视频 动画妹影院 日本无码片百度 家庭黄色一级网 插死我吧啊啊啊好爽 淫色美女图 先锋在线成人片 国外网友偷拍自拍 婷婷中文字幕高清 www110com 被窝福利合集250集 哥哥干公公的奸淫 母子乱伦3d动画 WWW19MMCOM 类似达酷的网站 正在播放露脸熟女后入式最后直接给口爆第11370集偷拍盗摄在线视频五月色 工口成人 [欧美]国产情景剧风骚美女不穿内裤路遇色魔跟踪迷昏后捆绑 资源铯站mv950点cc 美腿丝袜32p 伦理图片亚洲 色狗电影 bbee9966com 怡红院免费视频 以前的66波波网址是 哥去射天天翘 插吧插吧视频在线播放 色和尚亚洲妹 开心鬼黄色片 大爷操影院色色影院撸撸影院宅男影院下载 动漫鬼作 媚药bl 蝌蚪窝AⅤ 亚洲乳头 成人淫荡图 图霸人体艺术模特 老师喜欢玻璃瓶做爱 第四色春色在线电影 亚洲撸撸magnet 大屁股岳母 全聚色 wwwxxoo2com 台湾AV日本 wwwssss47 家庭伦理伦乱 231avav 热片网乱伦小说 wwwnntt999com 影音先锋夜色资源网 激情小说 亚洲色图 欧美 裸体姿势艺术诱惑 脱光操井 东京天堂在线 撸一撸涩涩 44bbmm下载 八戒影院褐色影院成人电影影视 狠狠撸Av图片 极品美女深喉吞精视频观看 日韩av使劲撸撸出激情 白白色大香蕉狠狠插妹妹 成人古典乱伦小说 动漫av迅雷下载 成人摄影色图 日碰碰碰超 成人电影午夜A片 洛天依色图 下载免费的AV小电影 www99aahh 944rr 66美女人体 wwwpubb94com 护士操穴色图 A片39efcom 色一点的小说 母其弥雅小说 我狠狠操风骚丝袜嫂子 无极影院美腿丝袜 韩国电影vip 幼男幼女黄色视频网站 15p熟妇 wwwddd20com 乱伦落红视频 黄网国内 九九视频在线视频观看 cdcd22 色色的妹妹 成人动画理论片 表妹做爱大全 漂亮美眉被肛交 七夕夜在ktv把爆乳女神蝌蚪窝 撸撸管长篇连载 色爱区mp4 五色网 自拍熟女另类亚洲欧美 女将av 虐阴100种 肥逼大妈 影视软件论坛 东方AV在线狠狠撸亚州无码 AV影音先锋影院 老师花核流水 校园春色sex8小说 韩国少妇AV影院 成人小说ftp 色三八点com 高清妹妹先抠逼再让我干 国外黄色视频网址 色福利加油站 操可以播放的站街老鸡视频 我是眼镜控迷奸 wwwcao664comlist42html 超碰成人在线免费高清巨乳视频 av美女天堂下载 影视操逼的人生 乱伦电影一页 人妻熟女自慰文 黄色的乱伦 勾魂欧美av高清影院 身材不错的女友家中诱惑自拍 熟女群p网s 我在厨房插了老师不详 色你妹眯眯 www sqwuyt com 川岛和津实视频 seseav 自拍学生白虎13 X666xx人与兽 淫淫淫涩 欣赏她浑圆的屁股 色色女主播magnet 91porn三级 日本骚妇丝袜视频 搞了两个90后mm 曰逼视频播放器 汇集全球熟女12p 青青草资源啦 淫荡妹妹性奴 激情乱伦校园人妻小说 夫妻在线AV 性与爱图片 欲望丝袜妹妹 啊啊啊好舒服图片 第一社区会所文学地址 色色av一本道加勒比 wwwsek0ngge2c0m 鬼片电影全集国语高清 成人激情图片，电影mmmnn7777 风流媳妇和壮公公 青青草美女自慰视频免费观看 东方Av偷 kkxkkx 黄色淫荡书 车上干骚逼 www268hhcom 我的美腿丝袜女儿 帅哥和保姆啪啪啪wwwshuaijiaocomvideo wwwjjj85 av电影www5yycom 美女久纱野水萌MP4 幼男幼女性爱演戏漫画 淫色淫香照片 美女基情四月 青青草露脸在线视频 啪啪啪全球免费社区 wuyue天婷婷 妞干网2015版www003hhhcom susu30cm 国产另类第二视频 亚洲色图狠狠撸夜夜撸 骚色综合www68ixcom 影音在线久久草 男同在线观看手机免费 天海丽白色吊带 国产视频日韩人兽 欧美性交影院自拍偷拍情人旅馆开房视频 日你色色色色色色色 超碰国产少妇在线 酒瓶门视频在线观看 三级片黄色父女乱伦 深空部落在线观看 第4涩涩 神雕侠侣伦理片 哪个网站可以观看苍井空电影 嗯啊不要嗯不要舔作者不详 四虎影视二级 黑丝袜视频床上秀 WWWSHUANGTVNET 影音先锋偷看媳妇中文 92电影看看 成人电影xox同性 看黄色三级片哦 哒哒哒哒哒嗯嗯嗯嗯嗯嗯 蕾丝边制服诱惑mp4 色无极主页影院跳转 岛国熟女撸撸色 911vv a片无限成人卡通 www892con下载 澳门美女直播间 xf0av2info 超碰吉林 亚洲欧美偷拍制服国产 西西人体美女鲍图片 swww222dzcom 在线访问升级中 黄鳝门ftp y亚洲超碰 丁香五月激情五月狠狠干 激情小说第四页 撸丝电影一区 欧美母子乱论 bbb笫bbb笫四 亚洲制服丝袜BT 冬月枫 欧美幼teenmoⅴies兽交 姐夫我要你的大鸡巴啊嗯嗯嗯嗯啊 开心狠撸五月 鸡鸡爱逼逼av淘宝视频 在线播放成人网 强奸漂亮的人妻magnet ss111亚洲 250pp6wpin 成人A节爽片视频 色俺去 和妈妈一起乱伦九城社区 同志带颜色的漫画网址 WWWASIA4 人妻 韩国av qvod 狠撸15p qingse 肥佬影音 摸乃图片 我与母亲电影无删减版 重温阿娇艳照门无码 军事网 国模菲菲大胆人体艺术 mianfeichengrenshipin 苍井空全集云播 欧洲美女黑丝 ipad去哪网站看色图 绘狗美女主播 处女中出 广濑玲什么时候开始拍av 你有b吗大片网站 长沙天气苍井空口交 婷婷炸天鲁 偷拍明星做爱视屏 cluanlun 兽兽门色图 屄水湿屄毛 嫂子和我看毛片 ryidongwuxiengjiaoshipien 为什么人体艺术模特的阴部都是黑的 欧美金发骚女情趣内衣人体 可爱美女人体艺术 张婉婉做爱白浆都操出来了 90性交视频 日本人体合成艺术 自慰屄 视频色哥哥 新一本道qovd 插妈妈逼婷婷五月天黄色网站 色黄朝 人娇黄色小说 操b 13 p 色五月图库 911sssus主站 2007日本人妖视频 素云佳柔 日本骚女舞 和大姨子日逼之续 网抱妹av 色中色成人av社区 淫荡猫女 幼女激情做爱 wohewodefengsaoxiaoyima 影音乱轮 春暧花开性吧有你 亚洲有码 臀部上放酒瓶的女人是谁 xxx美女逼毛图 义母电影一区 拳交屄屄 第一人体艺术图 好国美女主播系列之苹果 内射护士10p 黑人操逼偷拍自拍 胖女人maopian 午夜色撸撸 ww 5252se 黑白大战15p百度 eluosiqingse 宝莲寺淫僧 人妻乱伦强奸图片 柳州艳照门12部 快播欧洲重口味 嫂子浪叫 成人无码图 动1动少妇 人本艺术图片p01040100 激情小说草裙未满18禁区 偷情主妇 苍井空美女太太 男女激情做爱的高清照片 韩国丝袜美女在家和男友大胆露穴美腿口活自拍视频 强奸人的动态图 吉吉11ff xanggangxiezigongdianyingang 丰满女人求职被我给操了 成熟女人裸体正面照片 男人可以操母狗吗 残酷美吉田月 台湾av色站 大胆西西露阴艺术 26uuu女主播朴妮唛 自拍熟女自慰 日本成人乱伦网站 国产操逼片 姐姐在家做爱自拍 筱田优无码 插入16岁美少女花径 韩国第一美女 影音先锋能用的码你懂的 WWW_SE65_COM 人体牲生活片 模特强奸电影 苍井空电影gif出处 陈佳丽大但照片 韩国情欲电影大全 美女爱爱日 哈起码萝莉幼女片 hhhhhhdpornfree 毕夏漏点 溜冰骚女 faya美女性交18p 色 逼 搔 射 最年轻漂亮苗条的大学女生骗了老板钱被老板吧小穴和人给折磨了的完整版图片 姐姐的阴蒂被我舔硬了 百度影音能打开的黄网 为什么男朋友做爱时喜欢把我插哭 哥哥干动漫图片 色姐姐姐影院 五月 性美女操 最人体大胆女艺术 人体艺术huahuagongzidaohangchengrenwang 干逼520 张筱雨做爱图片 a片合集迅雷合集 马六姐人体艺术 精品少妇被老外硬刺无码吞精 qvod 日本骚女诱惑裸体 妻子推油 草裙女大胆美女迅雷 缺金的男孩名字大全 明星织发 疾病查询 军魂 3322kk 河北省教师资格证网 毒战百度影音 黄粲扒皮 理疗有副作用吗 37tp人体艺术果果6655人体艺术开心色播色尼玛 厕所针孔偷拍屄屄尿尿 女人淫乱图 性交插b淫图 诱色天使是传销吗 www555focom 顶级电影 都有那些人体艺术网站 爱人体高清大胆裸体照 色救救综合网 av内射电影 俄罗斯色图16p 快播电影小孩操大人 汤芳2007后花园 骚屁股骚逼逼 欧美人妖射精视频搜狐视频 av免费图片免费视频 WWW388AACOM 福利搬运工6080青涩 av女美国奶子 大黑鸡巴操韩国美女 欧美女星艺术图片 东北熟女骚 性爱狠撸撸小说 www韩国骚妇 WWW991ASZYCOM 新盖影院 与姐乱伦 五月天我一晚上干了个 谷门吹 怡红院 怡春院美国分院 WWWSANFUCOM 大奶大鸡鸡的美女 婷婷大色窝深爱五月 忠义乾坤之爱子情深40 国产自拍图片区国产区小说区 亚洲色国47 黄色小说激情小说成人小说网 主人性爱竹 波多野结衣av作品图蜜桃网 杜箐箐大胆人体艺体图片 撸熟女骚 插的好狠好舒服 林柏欣性交片 插黑丝骚b 亚洲色网av天堂 性感写真视频下载 女子学校返回途中乱搞6p淫乱大派对02 9iisesese 爽歪歪电影宗合 qingchunmeinvpeike 六月天婷婷 可以用大肥佬看的色网站 操屁眼小说大全 在线视频录像 男人鸡巴艹 rentiluozhao 28揷屄 liuyan裸身图 丁香网站五一婷婷 幽人谷乱伦网 中山市色色婚纱摄影 性裸体舞蹈 美女大白奶子 光棍电影影院yy俄罗斯年青母亲 贵阳哪家药店可以买到万艾可 欧美性交片视频大全 阳具冰棒 小小淫女 干爸爸大鸡吧好棒 99smav 象数疗法 学妹开苞疼哭视频观看 杉田瞳i～淫若妻妊妇 苍井空百度影音人与动物 mp3性交故事在线播放 妇人呢屄图 成人免费m看片12 wwwav189com 美女小穴19p 很多男人都操过我的骚屄 ww爱色com 逼你干网 色东东电影网 永作由美作品下载 幼幼性爱美图 天海翼人体艺术图片 美脚ol穿上黑丝连裤袜从后面插入妃悠爱大槻 凌波芹天使注射快播 姐夫和小姨子激情视频 天天打飞机色色网 我奸淫了女同事 开心色播手机图片 手机yy哥歌网 舔舔美人足 草君社 看人体大白逼成人网 影音先锋姊姊 涩色涩香 风野舞子写真视频图 开心宝贝色播网 WWW82JGCOM 三级片玉女心经 回族女人毛阴15p 白嫩美女做爱全图片 有免费的操逼视频吗 五月色播博 快射电影 大奶淫秽图片 淫水诱惑26p 那夜插进妹妹的蜜穴 撸哥哥老女人逼 avdiguocom日本骑兵 陈冠希艳昭门图 图图bt资源库 自慰国语三级欧美 五月先锋媳妇 五月天淫荡图片 黄鳝自慰在线15p 久久久久日韩xxx 成人影片人人插人人搞 金发碧眼巨乳萝莉 吉泽明步绿色x站 有没有幼女系列 仲平一家的乱伦生活 wwwhuangsecome 陈冠希艳照门先锋下载 变态儿子强奸乱伦图 xiaogeshizonghe av手机av亚洲天堂妹妹网 大叔操幼女小说 刘嘉玲人体艺术大胆写真 亚洲援交 裸体做爱激情床戏 脱衣女奴 91pron自拍福利网 荒野嗯啊 校园色农夫 尤成人版电影下载 小女孩榨干 插姐姐奶 自拍bibi 日本另类a片 美女特工强奸小说 操妹妹天天操?1?7?1?7)天撸色妹妹 色惰快乐影院48gaocom 日本厕所偷拍总集 2929tvtvcom2929tvtvcom 骚逼色综合 假阳具扩肛自慰在线视频 千乃杏美先锋 花花公子人休艺术成人导航网 女人挨操流精图片 av黄鳝自慰小说 最新巨乳淫妻magnet miaomiav怎么进网站了 米奇影影 丰满白嫩的日本女优 阿姨的性爱漫画小说 老师2016中文在线观看wwwkan99net 性爱录像片 无敌综合色 成人动漫亚洲色图意淫强奸亚洲色图意淫强奸 做爱高潮叫床视频 黑鬼片 亚洲色图av亚洲美色图 中国处女宝鉴 后入菊花 欧美咪下载 台湾成人论坛网站 苏联群交 孙子操奶奶的小说 国内偷拍自拍调教女奴 国外黄网在线免费成人电影 波霸暴露 a片黄色片wwwavtallcom 暴肏大骚屄 逍遥社区欧美日韩 白灵人体马六人体 jzbuwsyapopcn 结婚淫荡图片 欧美缴情av影视mpppp19com a4y艳舞 www867bbconm 新标签页最大黄色网站 日本aV女优天天堂网 不用播放器的性爱网站 包射网哪里去了 徐娘露脸图 操逼性交被人操了小说 肌肉女做爱英文 自拍成人视频在线播放myiwancom 欧美老逼乱伦性爱图片 亚洲日韩黄色成人电影 81xacom韩国料理 性侵人妻小说 插了一个不该插的人 老婆的妹妹 成人有色小说 春色性吧 春色都市 春色满人间 春色书目 雪肌肤解禁樱井莉亚 樱井莉亚作品列表 樱井莉亚作品美誉 樱井莉亚床戏 樱井莉亚四部合集 小泽玛利亚09年 能用快播的h网 能搜索的h网 开心五月天 深爱 东京热色人 成人色天 酒色网 欧美黄色小说 黄色小说区 黄色小说图片电影 哪有黄色小说 桥本凉 あやみ旬果 花花电影 色姐导航 大色姐导航 搞处女电影 强奸幼稚园 日B成人网 艳门照全集 日本变态图吧 寻找一夜激情 淫荡小妹电影 做爱技巧视频 高速无需播放器 欲望之城成人社区 桃色 皇兄个个狠狂野 狠狠爽 我要干 京骚戏画 涩涩爱性 江苏卫视在线直播网 猫咪av大香蕉网 超碰978 暴乳790 韩国av先锋 人人私信 怡人网av东京热 超蓬免费上传国产视频 欧美三级大胸保姆 日韩AV大香蕉 哪里能找到4438x liusiji最新 ipz041 91福利社动 大香焦久草是易视 亚洲AV外卖 市来美保教师在线观看 男人爱爱天堂av 宫地蓝视频在线观看 醉地va 91dizhcOm xoxo欧洲 mp4 皇家Lu23 90社区福利视频 ggg373 神玛影院理伦片 后入pp 极品唯美女同视频 33333男人天堂 色播屋99 易通电影院 鸭子给富婆舔逼 舔的逼水直流清晰可见 青鱼视频自拍在线视频 人狗资源福利在线 小莹姐吃奶之汁口述全过程 邪恶gif老湿影院 全裸美女直播 - 百度 小孩日大人视频 mp4 日本乳汁私密视频 在线内射大奶小穴 在线 无码 国产自拍 丝袜 中文字幕 在线拍sss 右上角ffyybb是什么番号 日本人性交视频 91小哥佩奇在线观看 wsnmm 免费 在线 云播 欢爱 在线ab 雪本芽依 大香蕉强奸 视频偷拍自拍在线 ai福利电影 微熟女在线关看 国外性交网站 老司机网址导航 正在播放julia 香椎梨亚在线视频 国产酒店床上av 威廉王子av 2018潮喷喷水av直播视频 585看片 J\香五月 神纳花作品在线播放 bree xart 在线 haoav008 水嶋あずみ白丝 taosege 野狼aⅴ导航 骚女A片式看 在线偷怕人家 1亚欧成人小视频 哪里有不用下载的AV视频 抽插视频完整版 rhj223 中国理论电影强奸视频 l 高清美女视频欧美高 耽美粗大侵犯骑木马 狠狠干在线视频 日本少妇8p 公媳止痒 福利视频伊一 噢门国际赌场小视频 全裸美女秀磁力链接 lu7700com 福利网站懂的2018 下载大鸡巴视频资源在线播放 三级鲁鲁片 DOCP030C 亚洲女优无码影音 超熟素人在线 超碰视频123zzz b里香视频在线2白色爽 美巨乳女子校生懲姦孕汁江藤つかさ 基腐动漫性爱 女主播紫薇喷水 乳视频在线播放 永利国际福利在线 意大利啪啪啪视频 WDD-002 magnet xt urn btih cbinese home made video 有关致母亲的AV无码 白嫩36C巨乳情人扭腰摇摆 青青草做爱视频网站 动画片操逼小视频 福利视频弟150集黄可 aul player 先锋影音福利在线 波波视频性多多 成人操逼视频97 午夜高清偷拍 爱爱视频教程未 漂亮女友的胸做爱自拍 xxx日本免费在线视频 家庭乱论小说第66部分阅读 卵蛋网MIDE 国产自拍磁力合计 大相蕉伊本道 剧情版经典无码 赌博视频a 素人约啪系列在线观看 口交吃奶揉奶视频 好屌操三八 1wan8不正经的一群人在线视频做爱 李保田何晴激情视频 国产自拍性爱视频在线播放 麻生希-东京热 - 百度 sm啪啪啪视频在线观看 亚洲av做爰 污亚洲 萝莉自慰跳蛋故事 av川村真矢在线影片 先锋影视AV明步 亚洲VS天堂 好屌妞精品偷拍视频 av中文字幕在线看手机 364hu 天天骑天天干 av 在线手机电影天堂 av手机日韩在线 明日花绮罗男人装 caopren在线 美女妇科全面检查 CD1,内窥镜看子宫深处,假鸡鸡量阴道到底多深,牛逼啊 香澄遥美人教师在线播放 电影港福利 美国日本A片黄色视频 1茉莉metch 裸体avav 性爱啪啪影院 去拍摄视频在线观看 凸起乳头的诱惑 在线 狂肏空姐小说 55segui 唐朝av免费观看 760pao xfyy卡通动漫 免费h视频的app 草莓tv影院在线安装试爱 小清新影院变态seqin 乱理永家,庭大片 超碰caoporn任你操 色优优资源网 法国Av 中文字幕人妻出轨av番号 旺旺影院色 传统在线视频cao12 881vz 巨乳视频天狼影院 伦理片4438 下众之爱 ftp WWW色姐姐 万全伦理k2014 亚洲天啪 草民影院偷拍自拍无码 影音先锋371无码影院 老司机综合网大全 鲁鲁狠狠在线影院 1004色导航 东方 av 在线 XXⅩhd性亚洲 成人自拍视频福利 福利美女视频 东方亚洲av 大陆 自拍 偷拍 国产 动漫骚逼视频 大香蕉青青免费视频 赤井美月伦理电影 福利影院APP 大香蕉伊在线一本线d 戴眼罩口交猜阳具 大神夜店大山极品美女带回高级寓所阳台一直 二重生活无码 福利裸体黄色片 夫妻做爱一级录像片 性姿势高清视频 有賀遊空 国产阿姨在线自拍 美女把最大的跳蛋放进菊花里视频 午夜福利在线资源站 91prorn业余 谷露另类四虎影视 日本性爱美女 好看的华人自拍隔壁老王 萝莉学生操哭 f8国货自拍 淫色天王 东方成人正确网站 猫咪av大香蕉网站 日本娇喘 rctd 045 chloe vevrier怀孕 天堂info 平平草在线 av ,np 高h 18岁 禁止 五月色伊人综合色 vr在线播放免费人成 2018国产援交 magnet 老施影院视费x看 毛片其地 毛片播放 青楼社区黄色视频免费的不用洗内容 日本三级有码视频 91国产伦理片 自拍照片磁力 肉棒插进美女阴道资源 日本v很色视频 神马影院三级片 magnet 舔丝袜国产剧情视频在线播放 rq在线视频 yy4480wwwsss 自拍 偷拍 另类 变态 fetiahkorea md487 wwwf994 日本黄片10000部大蕉 性感美女全裸体视频 国产白领,迅雷 magnet 寂寞厂妹李伟 张倩倩 wwwbbb811ang 52我爱干免费看 1177韩漫免费官网 大积焦伊人视频135在线 5566df 4438x全国成长 日b视频过程狠狠色哥网站 琪琪韩国理论宅男电影 色偷偷资源共享 爱色影激情在线002 狠狠爱狠狠天天2017 pans福利 wm62con视频 手机激情影院 藏经阁成人 www502rr,com 内射刺激视频 免费在线观看aavv 26uuu 成人网站地址 国产自拍福利亚洲 福利深夜视频在线观看 金瓶梅视频链接 qaaahhhkk 伦理在线智源 日本小学女生光乳头视频 国产剧情精品小视频 xxxr日本 caoliu情侣自拍 2017日日爽天天干日日啪 激情成人免费视频 雷炳侠洗澡门完整版视频 日本AV操比视频 les网站h片 人人肉肉大战 凤凰av在线高清 丝袜激情在线 图片小说快播色色在线 汤姆AV影院在线 好吊妞视频人妻偷拍 白木优子番号 mp4 王者色 mp4 岛国爱情动作片卵蛋 青春网综合无码av 目本一本道波多野吉衣 jizzss av色天堂。五月 笑白小曼 magnet gav免费播放成人大片 你愿意让我操你吗 大胆二嫂和闺蜜3龙2凤5P大战真担心二嫂这单薄的身子骨受 久久青青草风吟鸟唱视频 nnuu22 bt欧美兹力连接 AV火山小黄人 情人自拍偷拍在线 黑鸡吧爆操白臼嫩嫩美女 先锋影音亚洲人妻制服乱伦资源 小视频啪啪来电话女的说他免费 新娘被艹黄色视频 小夫妻福利视频导航 小明同学和我妈妈后入 小清新影院午夜网站 性插成人理论 香i巷黄色片 性交福利91视频 迅雷eev 崩坏之人璃沙 芳露福利 高清无码视频大全 黄片在线韩国女主播福利直播视频 与0101电影网类似 日逼去在线视频 岛国少妇视频 狼窝成人视频 老溟影院 在线av短片 日本妞啪啪高清 古装福利电影院 k频道新网 美祢藤コウ在线 东方影库正确地址域名 美乳少妇动态视频 人人爱人人色 北川瞳 简介 做爱自拍偷拍27P 国产精品大片182cm车模女仆装娇艳欲滴粉木 av喝尿的片哪有 老师与学生三级视频 边打电话边给我口交,我抠她骚逼到潮 免费毛片tube sex cosplay不知火舞 吸奶子头操逼视频资源 WWW,57ppp,com 啪啪影院自拍偷拍 荡女报恩亚洲视频 神马电影自拍偷拍 天天碰视频免费视频老影院 乱伦小说专区 捆绑Sm magnet 日本人六九xxx视频 avXXX日本 ab俺去射 日韩美女网 在线刺激导航 久久影院-星魔网百度 abp561c 国产成人规频在线 2018欧美在线理论重口味 538PORCOm www,333zk 长泽雅美无码在线观看 1开心影院贝贝邪恶 色导航第四色 草莓午夜免费福利小电影 波多野结衣海边群交 草莓国产午夜视频色琪琪电影 韩国学生俊男靓女酒店骑马摇摆抽插 国内自拍直播网 被侵犯的母亲优优色影院 变态另类在线直播欧美 国产玩呦 操逼逼吃奶视频 苍井空A影线费观看百度 韩国AV 下载 强奸乱伦-第8页 色综合2 杉浦友集磁力 mp4 秘密搜查官qvod 苍老师 ftp 一本道 丝袜 天海翼 色悠悠久草 做爱性交视频福利 那种漫画小说你懂的 中文字幕rct-470在线 love大桥未久爱情电影 成人在线免m免费观看 se66 亚洲自拍 色综合 协和手机在线播放 成人aⅤ影视 成人动漫在线播放 QZ75 西瓜影音 sspd强奸系列 包臀 无码 成宫琉璃视频 ftp wuxiaorui rion视频区在线 成人福利网址 你懆操 番号onsk 高潮视频西瓜影音先锋 苍井空xun迅雷下载 20我想看脱光腚了看操逼操逼的女人 午夜福利插b剧场 8x8x视频福利 高清大尺度丝袜老师 www銆倆ih8 wwwaaa,678kblz 偷情丝袜 刘瑞琪空姐门 貂蝉肉棍棒小说 少妇抠逼图片24p下一页 深夜福利无码视频在线 女神 主播自慰 在线 黄-色性交免费视频播放 小牛棚视频导航 黄色做爱小影院 海贼王黄版视频在线观看 www,87bbee,com 大桥未久在线资源 rounailujibanannv 午夜人与兽性交福利在线7O 变态搞基网站 qiuxia手机影院同性恋 时间停止器在线观看吉吉影音 快播成人妻视频 网友自拍笫3页 台湾三级片视频 久草视频16 小早川怜子伦理 湿情影院 青青在线葡京视频 小骚娃 金瓶梅电影偷性全视频 和小女生车震自拍视频 破呙福利 国产丝袜高跟鞋无码下载 萝莉 无内 小视频 毕业生里番 艹爽啪啪啪视频 不知火舞和三个男儿公园全彩 藏花阁在线直播平台 厕所偷拍在线观看 不用下载就可以马上看超碰免费视频洗澡BB 国内自拍新世界的大门巨乳列传 国产自拍第四页 操大奶丁字裤美女做爱故事 国产自拍直播 被侵犯的女子校生不知世事的大小姐 裸体搞p视频 ttllcc 大鸡巴操b视频 少女哥哥我想看那个床震作文 大香蕉在线福利观看 超碰成人内射0视频 3agirls视频 外国乱乱网站 97超碰人妻在线视频 国产真实干妈影院 国产a片直播 赶尸艳谈在线播放 邪恶丝袜美女嗯嗯啊啊 亚洲日本大鸡巴视频 天天拍干天天射 闪电奇迹裸体 华裔女神电击视频在线观看 性交视频有哪些网站 成人快播伦理欧美图片 不一样的操淫逼视频 757h 自拍 最新 另类 nb544 1huang&#039;se动漫 正在播放爱泽花梨教室 好看的高清无码 宇都宫紫苑 红秀 青青草成人快播免费视频 大鸡巴逼逼逼片 欧美性爱大片黄 午夜影院码 保拉的诱感在线视频 好色妻降临视频在线 正在播放年轻的女邻居 蔡番号 烧熟女吧 sewujiyazhouyingyuan1 a4yy万利达首播影院官网 午夜福利视频自拍偷拍 日本强奸绑架 下载 华人自拍专区 上海罗城厕所种子 日本免费AV camporn国产自拍 激情邪恶大香蕉 印度三部曲百度网盘 jiqing伍月天小说 龙在少林国语高清优酷 美女被虐中出视频 乱伦交配视频 伦理片爆乳美女写真 鲁尔山在线你慬的大片 美国十次la视频导 青青草大猫咪 骑车的女人韩国 极品美女磁力链 强插幼洞视频 极品黑丝性感女友宾馆中慢慢调情玩弄 鸡巴用力插入小穴 精彩剧情演绎 情趣黑丝高跟美骚妇装看病勾引药店医师 病床上激烈ML爆操 无套 激情视频图片小说在线播放 吉本多香美三级 青青草熟妇视频 江疏影不雅 视频地址 Sq222 壮汉番号 日本三级喷奶视频 老板润滑嗯嗯啊 琪姐在线视频 亲亲视频在线首页 露奶子的黄色小视频 婷婷大香蕉伊人线 性激情影院 日本三级456重口味 换妻书 红楼影/院 国产自拍叫床 仔仔网今天怎么打不开 4438x全国最大成人网址 富二代大屌哥和学院女神预览视频 就快播 私人玩物玩具酱在线视频 waifu哔咔官网 正在播放 成都极品女神 汤姆影视在线视频观看 风吟鸟唱摄影师嫩模 亚州视频狠狠插大香蕉 女王俱乐部免费视频 好日日中文字幕 啪啪啪视频AV 黄色网络视频在线播放 嘿嘿lovo大香蕉在线视频 朋友胸大漂亮的E奶女友勾搭了一个多月终于在朋友出差时出租屋里操了她看她害 黄片下截连接 黑田万结花无码magnet 欧美女主播 狠狠日色格格影院 小姐和顾客链接 magnet 泰国伦理院在线观看 578sao 在线丝袜影视 日本高清无码视频自拍 偷拍商场女厕所全景磁力链接 magnet 户外免费毛片 每日更新在线观看偷拍 longteng xiaishuo 丝袜av福利 96av在线草莓免费视频 30路熟女快播在线播放 日本娇喘黄片 黄色色播站 秋霞一级特黄高清无码影院播放 ibw619 老师邪恶影院a 色妇影院 www,4438x7 14438x最新网站有哪些 sesihu 1电影天堂EEUSS 年轻小夫妻性爱视频 91大神国产自拍 KEDQUXxX 巨乳家政妇无码 magnet 莫西哥性爱 里番轮奸俱乐部 成人免费视频 A片 被玩弄的50岁熟妻 歴代豊滿巨乳大人気女優 东莞21,55实拍视频 乱情影视的兄弟网站 xxxvdynom 快播色色影院 国产在线主播 91小青蛙红杏出墙3p 男主叫佐藤女主叫千里的里番 秘杜mmsscom 南京熟妇做爱视频 韩国主播梦 波 福利 耐克真黄色录像一级片 免费视频一级AV 摸I奶乳头视频 国模白鹭 色伊人好看动漫色 白丝福利露裆部 免賛福利影院 福利在线神马51 国产无码偷拍小视频 国产出租屋偷拍链接 延禧宫电视剧全集西瓜 小视频黄网 丁香五月欧洲视频播放 正在播放国产熟女 莞式按摩服务伦理 干逼网址免费在线观看 撸网在线 亚洲野狼群AV 手机五月丁人网 a阿vvt天堂2014在线 东方影视 永久在线 东方四虎av伊人 三级纶理片 肛交乳交奶推视频 恋足足交视频92 四虎 小穴 韩日AV 好吊曰妞欧美 在线高清高速影院 日性感少妇 快播巨乳少女在线播放 李湘人体忆书照 亚洲视频夜必橹 美女伦理图片大全 欧美性交私处图 若兰神马影院 农村操逼网 黄色三级小说 影音先锋熟女淫乱 女明星无优人体 金发女郎爽射无码 就去干bb 欧美人体五月天 男人日女人下面的视频 欧洲下体艺术照 色中色色中色白毛 爆操少妇在线 www003secom 人体私拍海天翼 傅贞怡艺术照 超级淫荡的嫂子勾引我 继母裸体 巨乳shufu 美女强奸视频快播 佐佐木心音影音先锋 988性爱网 台湾色老中文网 快播电影性爱女人 办公室爱爱自拍视频 欧美兽交肛交群交口交双插 美女做僾动感图片 姐也要内射图片 91热色色色 色岛撸水妃 口暴10p 六月婷婷激情网 影音先锋亚洲尻屄 干40多岁的女人 明星合成人体艺术 操弄美女 三p美少妇3p 黄榕胆大人体艺术