search
HomeDatabaseMysql Tutorial 【原创】Infobright 4.5 版本的一些新特性详解

Infobright4.5版本相比4.0版本增加了一系列的特性。我来详解下几个重要的提升。1.对系统默认的LOG输出级别可以动态调整了。在之前要是想调整这个默认级别,就得

Infobright 4.5 版本相比 4.0 版本增加了一系列的特性。 我来详解下几个重要的提升。

1. 对系统默认的LOG 输出级别可以动态调整了。

  在之前要是想调整这个默认级别,就得在配置文件里面(brighthouse.ini)里设置好,完了重启infobright server。 这样很不方便,不能及时的查看相关SQL详细执行计划以及对系统资源的详细占用。

IB>show variables like '%control%'; +---------------------------------+-------+ | Variable_name | Value | +---------------------------------+-------+ | brighthouse_ini_controlmessages | 5 | +---------------------------------+-------+ 1 row in set (0.00 sec) IB>set global brighthouse_ini_controlmessages=1; Query OK, 0 rows affected (0.00 sec) IB>show variables like '%control%'; +---------------------------------+-------+ | Variable_name | Value | +---------------------------------+-------+ | brighthouse_ini_controlmessages | 1 | +---------------------------------+-------+ 1 row in set (0.00 sec)


此处说明下, 这个值越大,香港空间,执行计划日志里面涉及到的信息就越全面。


2. 重新整理知识网格。

  用过infobright的人可能都知道,infobright有一种特有的类似行式数据库的索引结构,自己内部的名称叫知识网格,一直常驻内存,以提高查询效率。 我们知道,当我们对表本身的数据进行多次的增删改等等写入操作后,知识网格里面的信息也变的不完整,这样就会严重的影响到查询性能,因为此时必须读取磁盘完了解压才能得到相关的结果。  在4.0以及之前的版本,想要重新生成一个完整的知识网格,就必须重新导入数据, 这个操作是蛮烦人的,香港空间, 而且浪费时间,浪费资源。 从4.5版本开始,可以动态调整只是网格了。


[root@IB-centos ~]# icm --rebuild-kns --datadir /usr/local/infobright/data --database test 2013-08-21 10:12:16 Infobright Consistency Manager started. For database: 'test', table: 't1' Test of table metadata consistency ... [ PASS ] Test of knowledge grid format for column: id ... [ PASS ] Test of knowledge grid consistency for column: id ... [ PASS ]



这里我只重置了TEST库的知识网格。ICM是infobright自带的一个强大的工具,可以做很多事情, 这里我们只演示重置只是网格,其他的自己去开发吧。


3. DLP校验规则的更改。

  DLP,也就是分布式导入工具,服务器空间,每小时可以达到3TB导入速度的强大工具。 原来字符校验规则只支持*_bin, 现在是所有校验规则都支持了。 也就是说,我们不必要去分别更改每张表的校验规则来适应DLP了。


本文出自 “上帝,咱们不见不散!” 博客,请务必保留此出处

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
How do you alter a table in MySQL using the ALTER TABLE statement?How do you alter a table in MySQL using the ALTER TABLE statement?Mar 19, 2025 pm 03:51 PM

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

How do I configure SSL/TLS encryption for MySQL connections?How do I configure SSL/TLS encryption for MySQL connections?Mar 18, 2025 pm 12:01 PM

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

How do you handle large datasets in MySQL?How do you handle large datasets in MySQL?Mar 21, 2025 pm 12:15 PM

Article discusses strategies for handling large datasets in MySQL, including partitioning, sharding, indexing, and query optimization.

What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)?What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)?Mar 21, 2025 pm 06:28 PM

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]

How do you drop a table in MySQL using the DROP TABLE statement?How do you drop a table in MySQL using the DROP TABLE statement?Mar 19, 2025 pm 03:52 PM

The article discusses dropping tables in MySQL using the DROP TABLE statement, emphasizing precautions and risks. It highlights that the action is irreversible without backups, detailing recovery methods and potential production environment hazards.

How do you represent relationships using foreign keys?How do you represent relationships using foreign keys?Mar 19, 2025 pm 03:48 PM

Article discusses using foreign keys to represent relationships in databases, focusing on best practices, data integrity, and common pitfalls to avoid.

How do you create indexes on JSON columns?How do you create indexes on JSON columns?Mar 21, 2025 pm 12:13 PM

The article discusses creating indexes on JSON columns in various databases like PostgreSQL, MySQL, and MongoDB to enhance query performance. It explains the syntax and benefits of indexing specific JSON paths, and lists supported database systems.

How do I secure MySQL against common vulnerabilities (SQL injection, brute-force attacks)?How do I secure MySQL against common vulnerabilities (SQL injection, brute-force attacks)?Mar 18, 2025 pm 12:00 PM

Article discusses securing MySQL against SQL injection and brute-force attacks using prepared statements, input validation, and strong password policies.(159 characters)

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

Hot Tools

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

DVWA

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software