Aigaion Bibliography System 2.0.0 beta (Default branch)

12-24-2007

Registered User

26,240, 27

Join Date: Sep 2000

Last Activity: 1 August 2008, 3:09 PM EDT

Posts: 26,240

Thanks Given: 0

Thanked 27 Times in 26 Posts

Aigaion Bibliography System 2.0.0 beta (Default branch)

Aigaion is a Web-based shared bibliography managerbuilt on PHP/MySQL. It is based on the BibTeXformat, but has support for other formats as well.Some of its key features are extensive support fororganizing a bibliography in a topic structure,personal and public annotations on eachpublication, multi-user support, easyimport/export, and an intuitive user interface.License: GNU General Public License (GPL)Changes:
The entire code was rewritten and now relies on an MVC framework (Code Igniter). The most important changes: Access levels (public, intern, private) are customizable for publications, topics, notes, and attachments. The import and export code was improved. User group management was added. Support for guest users was improved. Modules were added for integrating login management with other systems such as wiki or CMS systems. Persistent bookmark lists were added. Topic assignment for publications were improved. Update management was improved. Flexible sort options were added for publication list display.

More...

Linux Bot

View Public Profile for Linux Bot

Find all posts by Linux Bot

NDB_INDEX_STAT(1) MySQL Database System NDB_INDEX_STAT(1) NAME
ndb_index_stat - NDB index statistics utility SYNOPSIS
ndb_index_stat options DESCRIPTION
ndb_index_stat ... Usage To obtain basic index statistics about a given NDB table, invoke ndb_index_stat as shown here, with the name of the table as the first argument and the name of the database containing this table specified immediately following it, using the --database (-d) option: ndb_index_stat table -d database In this example, we use ndb_index_stat to obtain such information about an NDB table named mytable in the test database: shell> ndb_index_stat -d test mytable table:mytable index:PRIMARY fragCount:4 sampleVersion:2 loadTime:1336751773 sampleCount:0 keyBytes:0 query cache: valid:1 sampleCount:0 totalBytes:0 times in ms: save: 12.380 sort: 0.001 NDBT_ProgramExit: 0 - OK The --verbose option provides some additional output, as shown here: shell> ndb_index_stat -d test mytable --verbose random seed 1337010518 connected loop 1 of 1 table:mytable index:PRIMARY fragCount:4 sampleVersion:2 loadTime:1336751773 sampleCount:0 keyBytes:0 read stats query cache created query cache: valid:1 sampleCount:0 totalBytes:0 times in ms: save: 20.766 sort: 0.001 disconnected NDBT_ProgramExit: 0 - OK shell> Options The following table includes options that are specific to the MySQL Cluster ndb_index_stat utility. Additional descriptions are listed following the table. For options common to most MySQL Cluster programs (including ndb_index_stat), see Options Common to MySQL Cluster Programs(1). Table 17.21. ndb_index_stat Options and Variables: MySQL Cluster NDB 7.2 +---------------------------------+--------------------------------------+-------------------------------------+ |Format | Description | Added / Removed | +---------------------------------+--------------------------------------+-------------------------------------+ | | Name of the database containing the | | | --database=name, | table. | All MySQL 5.5 based releases | | | | | | -d | | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Delete index statistics for the | | | --delete | given table, stopping any | All MySQL 5.5 based releases | | | auto-update | | | | previously configured. | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Update index statistics for the | | | --update | given table, restarting any | All MySQL 5.5 based releases | | | auto-update | | | | previously configured. | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Print the query cache. | | | --dump | | All MySQL 5.5 based releases | +---------------------------------+--------------------------------------+-------------------------------------+ | | Perform a number of random range | | | --query=# | queries on first key attr (must be | All MySQL 5.5 based releases | | | int | | | | unsigned). | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Drop any statistics tables and | | | --sys-drop | events in NDB kernel (all statistics | All MySQL 5.5 based releases | | | are | | | | lost) | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Create all statistics tables and | | | --sys-create | events in NDB kernel, if none of | All MySQL 5.5 based releases | | | them | | | | already exist | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Create any statistics tables and | | | --sys-create-if-not-exist | events in NDB kernel that do not | All MySQL 5.5 based releases | | | already exist. | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Create any statistics tables or | | | --sys-create-if-not-valid | events that do not already exist in | All MySQL 5.5 based releases | | | the | | | | NDB kernel. after | | | | dropping any that are invalid. | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Verify that NDB system index | | | --sys-check | statistics and event tables exist. | All MySQL 5.5 based releases | +---------------------------------+--------------------------------------+-------------------------------------+ | | Do not apply sys-* options to | | | --sys-skip-tables | tables. | All MySQL 5.5 based releases | +---------------------------------+--------------------------------------+-------------------------------------+ | | Do not apply sys-* options to | | | --sys-skip-events | events. | All MySQL 5.5 based releases | +---------------------------------+--------------------------------------+-------------------------------------+ | | Turn on verbose output | | | --verbose, | | All MySQL 5.5 based releases | | | | | | -v | | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Set the number of times to perform a | | | --loops=# | given command. Default is 0. | All MySQL 5.5 based releases | +---------------------------------+--------------------------------------+-------------------------------------+ ndb_index_stat statistics options. The following options are used to generate index statistics. They work with a given table and database. They cannot be mixed with ndb_index_stat system options. o --database=name, -d name +--------------------+------------------+ |Command-Line Format | --database=name | +--------------------+------------------+ | | -d | +--------------------+------------------+ | | Permitted Values | | +---------+--------+ | | Type | string | | +---------+--------+ | | Default | [none] | | +---------+--------+ | | Range | .. | +--------------------+---------+--------+ The name of the database that contains the table being queried. o --delete +--------------------+-------------------+ |Command-Line Format | --delete | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Delete the index statistics for the given table, stopping any auto-update that was previously configured. o --update +--------------------+-------------------+ |Command-Line Format | --update | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Update the index statistics for the given table, and restart any auto-update that previously configured. o --dump +--------------------+-------------------+ |Command-Line Format | --dump | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Dump the contents of the query cache. o --query=# +--------------------+------------------------+ |Command-Line Format | --query=# | +--------------------+------------------------+ | | Permitted Values | | +---------+--------------+ | | Type | numeric | | +---------+--------------+ | | Default | 0 | | +---------+--------------+ | | Range | 0 .. MAX_INT | +--------------------+---------+--------------+ Perform random range queries on first key attribute (must be int unsigned). ndb_index_stat system options. The following options are used to generate and update the statistics tables in the NDB kernel. They cannot be mixed with ndb_index_stat statistics options. o --sys-drop +--------------------+-------------------+ |Command-Line Format | --sys-drop | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Drop all statistics tables and events in the NDB kernel. This causes all statistics to be lost. o --sys-create +--------------------+-------------------+ |Command-Line Format | --sys-create | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Create all statistics tables and events in the NDB kernel. This works only if none of them exist previously. o sys-create-if-not-exist +--------------------+---------------------------+ |Command-Line Format | --sys-create-if-not-exist | +--------------------+---------------------------+ | | Permitted Values | | +------------+--------------+ | | Type | boolean | | +------------+--------------+ | | Default | true | | +------------+--------------+ | | Range | .. | +--------------------+------------+--------------+ Create any NDB system statistics tables or events (or both) that do not already exist when the program is invoked. o --sys-create-if-not-valid +--------------------+---------------------------+ |Command-Line Format | --sys-create-if-not-valid | +--------------------+---------------------------+ | | Permitted Values | | +------------+--------------+ | | Type | boolean | | +------------+--------------+ | | Default | true | | +------------+--------------+ | | Range | .. | +--------------------+------------+--------------+ Create any NDB system statistics tables or events that do not already exist, after dropping any that are invalid. o --sys-check +--------------------+-------------------+ |Command-Line Format | --sys-check | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Verify that all required system statistics tables and events exist in the NDB kernel. o --sys-skip-tables +--------------------+-------------------+ |Command-Line Format | --sys-skip-tables | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Do not apply any --sys-* options to any statistics tables. o --sys-skip-events +--------------------+-------------------+ |Command-Line Format | --sys-skip-events | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Do not apply any --sys-* options to any events. o --verbose +--------------------+-------------------+ |Command-Line Format | --verbose | +--------------------+-------------------+ | | -v | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Turn on verbose output. o --loops=# +--------------------+------------------------+ |Command-Line Format | --loops=# | +--------------------+------------------------+ | | Permitted Values | | +---------+--------------+ | | Type | numeric | | +---------+--------------+ | | Default | 0 | | +---------+--------------+ | | Range | 0 .. MAX_INT | +--------------------+---------+--------------+ Repeat commands this number of times (for use in testing). COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved. This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/. SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/. AUTHOR
Oracle Corporation (http://dev.mysql.com/). MySQL 5.5 01/30/2014 NDB_INDEX_STAT(1)

Software Releases - RSS News

Aigaion Bibliography System 2.0.0 beta (Default branch)

LEARN ABOUT LINUX

ndb_index_stat