Active RFID tags

Alas

Apache

Application programming interface (API)

Architectural tests

Archive storage engine

Artificial-intelligence algorithm

AUTO_INCREMENT_FLAG set

Benchmarking

    database systems

    guidelines

    performance

Berkeley Database (BDB)

Bidirectional buggers

Binary large objects (BLOB) fields

Binary log

    additional resources

    .index extension

    intermediate slave

    --log-bin option

    mysqlbinlog client

    mysql client

    --relay-log startup option

    row formats

    SHOW BINLOG EVENTS command

    time recovery

Black-box testing

Blackhole storage engine

Book vending machine (BVM)

    data and database

    design

    interface

    project creation

Buffer

Build_query_tree() method

Challenge-and-response sequence

CHANGE MASTER command

check_rewind() method

Classes and structures

    ITEM_ Class

    LEX structure

    NET structure

    READ_RECORD structure

    THD class

cleanup_context() method

Client-side plugin

    defining

    get_rfid_code() method

    mysql_declare_client_plugin

    mysql_end_client_plugin

    MYSQL_RFID_PORT variable

    reading RFID code

    rfid_send() method

    sending RFID code

    write_packet() method

close() method

Cluster storage engine

CMakeLists.txt file

Commercial proprietary software vs. open source software

    competitive threat

    complex capabilities and complete feature sets

    flexibility and creativity

    proof of advantages

    responsive vendors

    security

    tested software

Compiled query

Corporate acquisition. See Oracle’s MYSQL acquisition

Cost-based optimizer

    database catalog

    dynamic programming techniques

    frequency distribution

    heuristic optimization

    Microsoft SQL Server

    optimization techniques

    Oracle

    parametric query optimization

    query-evaluation plans

    rows and tables

    semantic optimization

    statistics

    uniform distributions

create() method

create_new_thread() function

Cross-product Algorithm

CSV storage engine

Customer table

Custom storage engine

Database catalog

Database experiment project (DBXP)

    attribute class

    building and running

    check_rewind() method

    cmake files

    do_join() method

    do_project() method

    do_restrict() method

    execution engine

    expression evaluation mechanism

    get_next() method

    high-level architecture

    implementation (see MySQL implementation)

    join operation

    MySQL parser

    MySQL system replacement

    node

    optimized query tree

    parameters

    pipeline execution algorithms

    prepare() method

    project operation

    pulsing

    query-optimization theory

    Query_tree class

    query tree concept

    query tree, example of

    query-tree execution

    query tree vs. relational calculus

    restrict operation

    SELECT DBXP Command

    send_data() method

    test designing

    test runs

    theta-joins

    transformation

Database system

    MySQL database system (see MySQL database system)

    object-oriented database system

    object-relational database system

    record vs. tuple

    relational database systems (see Relational database system (RDBMS))

Database system internals

    DBXP (see Database experiment project (DBXP))

    MySQL

        less-invasive method

        limitations and concerns

        parser and lexical analyzer

        prompt command

        source code experimenting

        TCP port 3307

        virtual machine

    query execution

        compiled query

        interpretative methods

        iterative methods

        MySQL

Data definition language (DDL)

Data manipulation language (DML)

DBT2

DBXP_explain_select_command() method

DBXP helper classes

DBXP join algorithm

DBXP join method

DBXP query optimizer

DBXP_SELECT command

DBXP_select_command() method

Deadlocking

Debugging

    code

    command-line switch

    conditional compilation

    error handler

    external (see External debuggers)

    Hello world program

    inline debugging statements

    inline statements (see Inline debugging statement)

    Linux

        ddd

        gdb

        SHOW AUTHORS command

    logic error

    method

    multithreaded model

    MySQL

        error handlers

        inline debugging statements

        source code

    origins

    patch creation

    SHOW AUTHORS command

    syntax errors

    system debuggers

    windows (see Windows)

delete_all_rows() method

delete_row() method

Delete_rows_log_event

delete_table() method

Development milestone release (DMR)

Diagnostic operation or technique

dispatch_command() function

DMR. See Development milestone release (DMR)

do_command() function

do_handle_one_connection() function

do_join() method

Dual license of MySQL

Dynamic programming algorithm

Embedded database system

Embedded MySQL applications

    advantages of

    book vending machine

        data and database

        design

        interface

        project creation

    bundled server embedding

    connection options

    data

    debugging

    deep embedding

    embedded database system

    embedded system

        definition

        types of

    error handling

    features

    functions

    header files

    libmysqld

        on Linux

        on Windows

    limitations of

    managed vs. unmanaged code

        administration form

        compiling and running

        customer interface

        database engine class

        interface detection

    MySQL C API documentation

    mysql_close() function

    mysql_fetch_row() function

    mysql_free_result() function

    mysql_query() function

    mysql_real_connect()

    mysql_server_end() function

    mysql_server_init() function

    mysql_store_result() function

    resource requirements

    security

    server creation

        Linux

        Windows

    string array

    Windows

Embedded system

    definition

    types of

enable_metadata command

Error handlers

Error num command

ESRI

execute_sqlcom_command() function

EXPLAIN command

Expression class header

External debuggers

    bidirectional

    definition

    GNU Data Display

    interactive

    stand-alone

        advantage

        GNU debugger

        inspecting memory

        interactive debuggers

        sample gdb session

        sample program

        source-code files

Federated storage engine

Field class

Find_join () method

Find_restriction() method

Format_description_log_event() method

FOSS. See Free and open source (FOSS) exception

Free and open source (FOSS) exception

Free software. See Open-source software systems

FRM files

Functional tests

Functions and commands

    add SQL commands

        big switch

        changes, SHOW DISK_USAGE

        compile errors

        execute, SHOW DISK_USAGE

        final outcome

        function declaration

        GNU

        LEX

        new commands

        parser syntax

        SHOW DISK_USAGE

        show_disk_usage_command()

        tokens

        YACC

    compile and test, native function

        gregorian()

        julian()

    information schema

        DISKUSAGE schema

        enum_schema_tables

        fill_disk_usage

        logical tables

        new DISKUSAGE schema

        prepare_schema_table function

        schema_tables array

    native functions

        create_func_gregorian class

        create_func_gregorian method

        gregorian symbol

        item_strfunc.cc file

        item_strfunc.h file

        lex files

        mysqld source code

    user defined functions

        command execution

        commands

        CREATE

        declaration, JULIAN function

        .def file

        DROP

        execute julian()

        functions sample

        implement julian()

        install

        julian_deinit()

        JULIAN function

        julian_init()

        library

        new function

        sample methods

        uninstall

Get_next() method

getrusage() method

Global Transaction Identifiers (GTIDs)

GNU-based license

    ethical dilemma

    property

GNU Data Display Debugger

GNU program

handle_connections_sockets() function

Handler class

    definition

    Sql_alloc

    storage-engine-class derivation

Handlerton

    data items

    elements

    structure

ha_spartan.cc file

ha_spartan class

ha_spartan_exts array

ha_tina::find_current_row() method

Heap-registration

HEAP tables

Helper methods

heuristic_optimization() method

Heuristic-optimization process

Heuristic optimizers

High availability. See Replication

ICONIX process

Ignorable_log_event

Incident_log_event

index_first() method

index_last() method

index_next() method

index_prev() method

index_read_map() method

info() method

Inline debugging statement

    inspection

    instrumentation

    rudimentary or cumbersome

    standard error stream

Inner-join algorithm

InnoDB

INSTALL PLUGIN command

Interactive debuggers

Interpretative methods

Intersect algorithm

Intvar_log_event

Iterative methods

Java Database Connectivity (JDBC)

Join algorithm

LAMP. See Linux, Apache, MySQL, and PHP/Perl/Python (LAMP)

LeapTrack software

Left outer joins

Legal issues. See GNU-based license

Lexical analyzer generator (Lex)

Linux

Linux, Apache, Mysql, and PHP/Perl/Python (LAMP)

List_iterator classes

List_iterator_fast class

Log events

    class declaration

    execution

        do_apply_event() method

        Log_event::next_event() method

        Log_event::read_log_event() method

    header file

    pack_info() method

    read_event() method

    types

    write_*() methods

Log_event::get_type_str() method

Log_event::read_log_event() method

Master

Memory storage engine

Merge storage engine

Multiple-release philosophy

Multithreaded slave (MTS)

my_copy() function

MyISAM

MySQL

mysqlbinlog client

MySQL Classic

MySQL Cluster Carrier Grade Edition

MySQL Community Edition

MYSQL connectors

MySQL database system

    architecture

    buffer pool

    file access via pluggable storage engine

        archive

        BDB

        blackhole

        cluster/NDB

        CSV

        custom

        features

        federated

        InnoDB

        memory

        merge

        MyISAM

        vs. PLUGIN

        transactional commands

    hostname cache

    join buffer cache

    key cache

    parser

    privilege cache

    query cache

    query execution

    query optimizer

    record cache

    source code

    SQL interface

    table cache

mysqld_main() function

MySQL Embedded (OEM/ISV)

MySQL Enterprise Edition

mysql_execute_command() function

MySQL implementation

    DBXP EXPLAIN Test

    DBXP_SELECT command

        command enumeration

        lexical structures

        mysqld.cc file changes

        MySQL parser

        testing

    EXPLAIN enumeration

    files added and changed

    parser command code

    parser switch statement

    query tree class

        CMakeLists.txt File

        DBXP Parser Helper file

        execution

        parser command code

        parser command switch

        query-tree header file creation

        testing

    show_plan function

        DBXP EXPLAIN Command Source Code

        protocol store and write statements

        show_plan Source Code

    test creation

mysql_parse() function

mysql.plugin table

MySQL query execution

MySQL source code

    build process

    classes and structures

        ITEM_ Class

        LEX structure

        NET structure

        READ_RECORD structure

        THD class

    coding guidelines

        documentation

        doxygen

        engineering logbook

        functions and parameters

        my_alloc() function

        naming convention

        spacing and indention

        sql_alloc() function

        track change

    connections and thread management

        alloc_query() function

        create_new_thread() function

        dispatch_command() function

        do_command() function

        do_handle_one_connection() function

        handle_connections_sockets() function

        network communication method

    development release

    license

    mysqld_main() function

    optimize()

    parse query

    platform support

    plugins

        INFORMATION_SCHEMA PLUGINS view

        installing and uninstalling plugins

    process vs. thread

    query execution

    query path

    query preparation

    sample statement

    SELECT statement

    server version

    /sql folder

    sub_select() function

    supporting libraries

    win_main() method

MySQL Standard Edition

MySQL structures and classes

    build_query_tree() method

    cost_optimization()

    DBXP helper classes

    Field class

    heuristic_optimization()

    heuristic optimizer

        DBX method

        find_join() method

        find_projection() method

        find_restriction() method

        prune_tree() method

        push_joins() method

        push_projections() method

        push_restrictions() method

        split_project_with_join() method

        split_restrict_with_join() method

        split_restrict_with_project() method

    iterators

        List<Item_field>

        loop structures

        template <> class List

        template <> class List_iterator

        template <> class List_iterator_fast

        loop structures

    query_tree.cc file

    query_tree.h file

    TABLE structure

mysql.user table

MySQL Utilities

MySQL Workbench software

Object-oriented database systems (OODBSs)

Object-relational database-management systems (ORDBMSs)

Open Database Connectivity (ODBC)

open() method

Open source software systems

    choosing to use

    code modification

    vs. commercial proprietary software

        competitive threat

        complex capabilities and complete feature sets

        flexibility and creativity

        proof of advantages

        responsive vendors

        security

        tested software

    cost reduction

    development using MySQL

        alpha stage

        beta stage

        clone wars

        development milestone release (DMR)

        development stage

        enterprise server

        FOSS exception

        generally available (GA) stage

        lab release

        multiple-release philosophy

        MySQL Classic

        MySQL Cluster Carrier Grade Edition

        MySQL Community Edition

        MySQL dual license

        MySQL Embedded (OEM/ISV)

        MySQL Enterprise Edition

        MySQL modification

        MySQL modification guidelines

        MySQL Standard Edition

        MYSQL 5.6 VERSION

        parallel development strategy

        release candidate stage

    GNU project

    LAMP stack

    legal issues and GNU-based license

        ethical dilemma

        property

    licensing mechanisms

    Linux

    Oracle’s MYSQL acquisition

    reliable software

    revolution and reformation

    robust software

    TiVo

Oracle’s MYSQL acquisition

Outer-join Algorithm

Parametric optimizers

Parser and lexical analyzer

Path testing

Personal identification code (PIN)

PHP/Perl/Python

plugin-dir variable

Plugins

    API

        attributes and function pointers

        plugin_auth.h file

        PROPRIETARY license type

        st_mysql_auth structure

        st_mysql_plugin structure

        st_mysql_structure definition

        symbols definitions

        version number

    architecture

    commands

    compilation

    configuration file

    daemon_example plugin

    INFORMATION_SCHEMA.plugins

    INSTALL PLUGIN command

    libraries

    LOAD PLUGIN command

    mysql_plugin client application

    RFID authentication (see Radio frequency identification card (RFID))

    SHOW PLUGINS command

    something_cool

    types

position() method

Prepare() method

Profiling

Project algorithm

push_back() method

push_front() method

Push_joins() method

Push_projection() method

Push_restriction() method

Query execution

    cross-product operation

    DBXP (see Database experiment project (DBXP))

    full outer joins

    inner-join operation

    intersect operation

    join operation

    left outer joins

    outer joins algorithm

    project algorithm

    restrict algorithm

    right outer joins

    union operation

Query_log_event

Query optimization

    CMakeLists.txt file

    cost-based optimizer (see Cost-based optimizer)

    DBXP_select_command() method

    DBXP test

    heuristic-optimization process

    INGRES

    in-memory database systems

    MySQL structures and classes (see MySQL structures and classes)

    query plan

    System R

    test runs

    theory

    volcano optimizer

Query plan

Query shipping

Radio frequency identification card (RFID)

    authentication mechanism

    authentication plugins

        architecture

        client-side plugin

        CMakeLists.txt file

        compilation

        include files and definitions

        INFORMATION_SCHEMA.plugins view

        logging

        mysqladmin client application

        --plugin-dir option

        rfid_auth.ini file

        server-side plugin

        verification

    module

        board

        card identification numbers

        driver installation

        keycard

        securing

        SparkFun’s RFID starter kit

    more-secure user-login mechanism

    mysql.plugin table

    operations

    tag

    validate_password plugin

RAID device

Rand_log_event

READ_RECORD

read_row() method

Record command

Refactoring

ref() method

register_slave() method

Regression testing

Relational database system (RDBMS)

    client applications

    file-access mechanism

        cache mechanism

        file organization

        index mechanisms

        (I/O) system

        performance trade-offs

    internal query representation

    vs. MYSQL

    query execution

        compiled query

        data access

        interpretative methods

        iterative methods

        join operation

        query operations

    query interface

    query optimization

        cost-based optimizer

        heuristic optimizers

        hybrid optimizer

        parametric query optimization

        plan-based query-processing

        semantic optimization

        unbound parameters

    query processing

        data independence

        logical query

        query optimization

        query shipping

        query tree

        steps

    query results

    SQL

    storage repository database

Relay slave

remove() method

rename_table() method

Replication

    architecture

    binary log(see Binary log)

    definition

    extension

        slave connect logging(see Slave connect logging)

        STOP SLAVE command(see STOP SLAVE command)

        subsystem

    failover

    GTIDs

    master configuration

        GRANT statement

        log_bin variable

        mysql_bin

        REPLICATION SLAVE privilege

        server_id

        SHOW MASTER STATUS command

        variable setting

    master–slave connection

    mysqlfailover

    requirements

    role switching

    server roles

    slave configuration

    source code

        files

        log events(see Log events)

    switchover

    usage

RESET MASTER command

Restrict algorithm

rfid_auth.ini file

rfid_auth plugin

Right outer joins

rnd_init() method

rnd_next() method

rnd_pos() method

Rotate_log_event

Row-based replication (RBR)

Rows_log_event

Rows_query_log_event

Runtime type information (RTTI)

savepoint_release() method

savepoint_rollback() method

savepoint_set() method

SELECT-PROJECT-JOIN query processor

SELECT-PROJECT-JOIN strategy

Semantic optimizers

send_data() method

Server-side plugin

set_server_version function

Shipping

SHOW AUTHORS command

show_authors function

SHOW FULL PROCESSLIST command

SHOW MASTER command

SHOW PROFILES and SHOW PROFILE commands

SHOW SLAVE STATUS command

SHOW SLAVE STATUS report

SHOW STATUS command

Slave_connect_log_event methods

Slave_connect_log_event::pack_info() method

Slave_connect_log_event::print() method

Slave_connect_log_event::Slave_connect_log_event() method

Slave_connect_log_event::∼Slave_connect_log_event() method

Slave_connect_log_event::write_data_body() method

Slave connect logging

    changed files

    cleanup_context() method

    code compiling

    deletion condition

    diagnosing and repairing replication

    enumeration addition

    enum Log_event_type list

    error condition

    example execution

        binary log events on master

        console mode

        setting up replication

        SHOW BINLOG EVENTS command

        starting master and slave

    excluding destroy condition

    Format_description_log_event() method

    Log_event::get_type_str() method

    LOG_EVENT_IGNORABLE_F flag

    Log_event::read_log_event() method

    register_slave() method

    Rows_query_log_event action

    SHOW SLAVE STATUS

    slave_connect_ev variable initialization

    Slave_connect_log_event class

    Slave_connect_log_event methods

    Slave_connect_log_event::do_apply_event() method

    Slave_connect_log_event::pack_info() method

    Slave_connect_log_event::print() method

    Slave_connect_log_event::Slave_connect_log_event() method

    Slave_connect_log_event::∼Slave_connect_log_event() method

    Slave_connect_log_event::write_data_body() method

    variable addition

    write_slave_connect() method

Slaves

Slave Slave_connect_log_event::do_apply_event() method

slave_worker_exec_job() method

Sleep command

Smart singletons

Software testing

    alpha-stage testing

    beta-stage testing

    component testing

    functional vs. defect testing

    goals

    integration testing

    interface testing

    path testing

    performance testing

    regression testing

    release, functional, and acceptance testing

    reliability testing

    test design

        partition tests

        specification-based tests

        structural tests

    usability testing

    verification and validation

Spartan_data class constructor

Spartan_data destructor

Spartan storage engine

    low-level I/O classes

    Spartan_data class

        BLOBs fields

        header

        my_xxx utility methods

        source code

        uchar pointer

        variable fields

    Spartan_index class

        B-tree structure

        header

        insert_index() method

        load_index() method

        my_write() method

        point queries execution

        range queries execution

        save_index() method

        SDE_INDEX structure

        source code

Spatial database system

Split_project_with_join() method

Split_restrict_with_join() method

Split_restrict_with_project() method

sql_dbxp_parse.cc file

SQL SELECT command

START SLAVE command

Statement-based replication (SBR)

Static variables

st_mysql_plugin structure

STOP SLAVE command

    code compiling

    code modifications

    example execution

        checking topology

        demonstration

        mysqlrplshow command

        mysqlserverclone utility

        MySQL utilities

        result

        setting topology

        setting up replication

Storage engine

    archive engine

    BLOB fields

    call sequence

    command-line MySQL client

    create() method

    CSV engine

    Cygwin

    data indexing

        class file updation

        CMakeLists.txt file

        header file updation

        testing

    development process

    get_row() method

    get_share() method

    ha_archive.cc file

    handler class (see Handler class)

    handlerton (see Handlerton)

    header file updation

    layered architecture

    log file

    my_create() method

    /mysql-test directory

    MySQL test suite

    /mysql-test/t directory

    physical data layer abstracting

    plugin architecture

    reading and writing data

        source file updation

        testing

    real_write_row() method

    relational-database-processing engine

    relational database systems

    rnd_next() method

    server and debugger

    singleton

    source files

    Spartan(see Spartan storage engine)

    streamlining and standardizing

    stubbing

        adding CMakeLists.txt file

        compiling Spartan engine

        spartan plugin source files

        testing Spartan engine

    tables

        class file updation

        header file updation

        I/O routines

        /mysys directory files

        testing

    test file

    transaction

        external_lock() method

        implementation

        InnoDB

        MyISAM table type

        rollback

        savepoint

        SQL commands

        start_stmt() method

        stopping

    updating and deleting data

        header file updation

        source file updation

        testing

    write_row() method

Stress testing

SysBench

System R optimizer

table_flags() method

Table handler

Table_map_log_event

TABLE structure

Test-driven MySQL development

    agile programming

    benchmarking(see Benchmarking)

    benchmarking vs. profiling

    MySQL benchmarking suite

        applied benchmarking

        command-line parameters

        limitation

        multi-threaded tests

        MySQL profiling

        MySQL query cache

        partial list

        small tests benchmark excerpt

        sql-bench directory

        SysBench and DBT2

        test—create benchmark test

        vs. testing suite

        test result data

    mysqlshow command

    MySQL test suite

        advanced tests

        bug report

        Cygwin environment

        mysqltest

        mysql-test directory

        new test creation

        new test execution

        Perl modules

        result file

        running tests

    profiling

    software testing (see Software testing)

    testing vs. debugging

    unified modeling language diagrams

TiVo

Trace

Tree arrangements

trunc_table() method

UndoDB back-trace commands

UndoDB by Undo Ltd

Union algorithm

Unknown_log_event

update_row() method

Update_rows_log_event

User_var_log_event

validate_password plugin

Virtual machine

Visual Studio .NET

Volcano optimizer

WHERE clause

White-box testing

Windows

    Microsoft Visual Studio

    Visual Studio .NET

        Attach to Process

        debugger setup

        debugging session output

        displaying variable values

        editing values, memory

win_main() method

write_row() method

Write_rows_log_event

write_slave_connect() method

Yet another compiler compiler (YACC)