NineSec Team Shell

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	Size	Last Modified	Owner	Permissions	Options
..	--	April 08 2025 12:08:09	root	0755
bulgarian	--	February 12 2024 9:07:23	root	0755
charsets	--	February 12 2024 9:07:23	root	0755
czech	--	February 12 2024 9:07:23	root	0755
danish	--	February 12 2024 9:07:23	root	0755
docs	--	February 12 2024 9:07:21	root	0755
dutch	--	February 12 2024 9:07:23	root	0755
english	--	February 12 2024 9:07:23	root	0755
estonian	--	February 12 2024 9:07:23	root	0755
french	--	February 12 2024 9:07:23	root	0755
german	--	February 12 2024 9:07:23	root	0755
greek	--	February 12 2024 9:07:23	root	0755
hungarian	--	February 12 2024 9:07:23	root	0755
italian	--	February 12 2024 9:07:23	root	0755
japanese	--	February 12 2024 9:07:23	root	0755
korean	--	February 12 2024 9:07:23	root	0755
norwegian	--	February 12 2024 9:07:23	root	0755
norwegian-ny	--	February 12 2024 9:07:23	root	0755
polish	--	February 12 2024 9:07:23	root	0755
portuguese	--	February 12 2024 9:07:23	root	0755
romanian	--	February 12 2024 9:07:23	root	0755
russian	--	February 12 2024 9:07:23	root	0755
serbian	--	February 12 2024 9:07:23	root	0755
slovak	--	February 12 2024 9:07:23	root	0755
spanish	--	February 12 2024 9:07:23	root	0755
swedish	--	February 12 2024 9:07:23	root	0755
ukrainian	--	February 12 2024 9:07:23	root	0755

debian_create_root_user.sql	1.79 KB	January 17 2024 9:13:42	root	0644
dictionary.txt	24.976 KB	December 12 2023 7:09:36	root	0644
echo_stderr	0.026 KB	January 17 2024 9:13:42	root	0755
innodb_memcached_config.sql	3.905 KB	December 12 2023 7:09:36	root	0644
install_rewriter.sql	2.164 KB	January 17 2024 9:13:42	root	0644
mysql-log-rotate	1.931 KB	January 17 2024 9:13:42	root	0644
mysql-systemd-start	2.09 KB	June 14 2023 9:23:16	root	0755
mysqld_multi.server	1.036 KB	December 12 2023 7:09:36	root	0755
uninstall_rewriter.sql	1.219 KB	January 17 2024 9:13:42	root	0644

NineSec Team - 2022