OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	11/10/2024 09:42:49 AM	rwxr-xr-x
📁 bulgarian	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 charsets	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 czech	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 danish	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📄 debian_create_root_user.sql	1.79 KB	04/23/2023 02:08:47 PM	rw-r--r--
📄 dictionary.txt	24.98 KB	03/16/2023 03:25:04 PM	rw-r--r--
📁 docs	-	05/09/2024 07:13:50 AM	rwxr-xr-x
📁 dutch	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📄 echo_stderr	27 bytes	04/23/2023 02:08:47 PM	rwxr-xr-x
📁 english	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📄 errmsg-utf8.txt	518.77 KB	03/16/2023 03:25:04 PM	rw-r--r--
📁 estonian	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📄 fill_help_tables.sql	1.03 MB	03/16/2023 03:33:21 PM	rw-r--r--
📁 french	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 german	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 greek	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 hungarian	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📄 innodb_memcached_config.sql	3.91 KB	03/16/2023 03:25:04 PM	rw-r--r--
📄 install_rewriter.sql	2.17 KB	04/23/2023 02:08:47 PM	rw-r--r--
📁 italian	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 japanese	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 korean	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📄 magic	773 bytes	03/16/2023 03:25:04 PM	rw-r--r--
📄 mysql-log-rotate	844 bytes	04/23/2023 02:08:47 PM	rw-r--r--
📄 mysql-systemd-start	1.91 KB	08/19/2021 04:34:52 PM	rwxr-xr-x
📄 mysql_security_commands.sql	2.12 KB	03/16/2023 03:25:04 PM	rw-r--r--
📄 mysql_sys_schema.sql	281.58 KB	03/16/2023 03:25:04 PM	rw-r--r--
📄 mysql_system_tables.sql	151.8 KB	03/16/2023 03:25:04 PM	rw-r--r--
📄 mysql_system_tables_data.sql	1.19 KB	03/16/2023 03:25:04 PM	rw-r--r--
📄 mysql_test_data_timezone.sql	10.61 KB	03/16/2023 03:25:04 PM	rw-r--r--
📄 mysqld_multi.server	1.04 KB	04/23/2023 02:08:47 PM	rwxr-xr-x
📁 norwegian	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 norwegian-ny	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 polish	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 portuguese	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 romanian	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 russian	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 serbian	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 slovak	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 spanish	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 swedish	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📁 ukrainian	-	05/09/2024 07:13:51 AM	rwxr-xr-x
📄 uninstall_rewriter.sql	1.21 KB	04/23/2023 02:08:47 PM	rw-r--r--

Editing: innodb_memcached_config.sql

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);