namespace MySQL
{
    public static class GetMyConfig
    {
        public static string Getmy(string Path)
        {
            string str = "";
            str += "[client]\r\n";
            str += "port=3306\r\n";
            str += "[mysql]\r\n";
            str += "default-character-set=utf8\r\n";
            str += "\r\n";
            str += "[mysqld]\r\n";
            str += "#端口\r\n";
            str += "port=3306\r\n";
            str += "#数据库\r\n";
            str += "basedir=\"" + Path + "\"\r\n";
            str += "#数据库数据\r\n";
            str += "datadir=\"" + Path + "/data\"\r\n";
            str += "#编码格式\r\n";
            str += "character-set-server=utf8\r\n";
            str += "#引擎 旧 MyISAM 、 新 INNODB\r\n";
            str += "default-storage-engine=INNODB\r\n";
            str += "#支持 INNODB 引擎模式。修改为　default-storage-engine=INNODB　即可。\r\n";
            str += "#如果 INNODB 模式如果不能启动，删除data目录下ib开头的日志文件重新启动。\r\n";
            str += "\r\n";
            str += "sql-mode=\"NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION\"\r\n";
            str += "max_connections=512\r\n";
            str += "\r\n";
            str += "query_cache_size=0\r\n";
            str += "table_cache=256\r\n";
            str += "tmp_table_size=18M\r\n";
            str += "\r\n";
            str += "thread_cache_size=8\r\n";
            str += "myisam_max_sort_file_size=64G\r\n";
            str += "myisam_sort_buffer_size=35M\r\n";
            str += "key_buffer_size=25M\r\n";
            str += "read_buffer_size=64K\r\n";
            str += "read_rnd_buffer_size=256K\r\n";
            str += "sort_buffer_size=256K\r\n";
            str += "\r\n";
            str += "innodb_additional_mem_pool_size=2M\r\n";
            str += "\r\n";
            str += "innodb_flush_log_at_trx_commit=1\r\n";
            str += "innodb_log_buffer_size=1M\r\n";
            str += "\r\n";
            str += "innodb_buffer_pool_size=47M\r\n";
            str += "innodb_log_file_size=24M\r\n";
            str += "innodb_thread_concurrency=8\r\n";
            str += "\r\n";
            return str;
        }
    }
}