c**t
发帖数: 2744 | 1 [OK] Currently running supported MySQL version 5.6.30
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -----------------------------------------
------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM
+MyISAM +PERFORMANCE_SCHEMA
[--] Data in MyISAM tables: 170K (Tables: 17)
[--] Data in InnoDB tables: 28M (Tables: 107)
[!!] Total fragmented tables: 5
-------- Security Recommendations ------------------------------------------
... 阅读全帖 |
|
j**n
发帖数: 54 | 2 thanks. I am using InnoDB right now, because of this, seems I need to change
to MyiSam.
The index file is the same as data file, for MyiSam, rebuild the index or
optimize the table both shrink the files a lot, but no effect on InnoDB
files. |
|
a*******s
发帖数: 324 | 3 You'd better not do it like this way. It is very slow because of the full
table scan.
do this way
create tabel tb1(content text, subject varchar(50), fulltext(content,
subject)) engine = MYISAM;
select * from tb1 where match(content, subject) against ('ABC' in NATUARL
LANGUAGE MODE)
remind: only MYISAM engine supports the FULLTEXT index. |
|
c**t
发帖数: 2744 | 4 在inMotion租了个eLite Dedicated Server: 3.7G Turbo 4C/8T; 16GB RAM and
2X250 GB SSD. 想跑个小的ＭｙＳＱＬ，支持８００人同时在线，主要是读。总感觉ｍ
ｙｓｑｌ的设置不对。哪位大虾帮忙指点一下，怎么优化设置？
07:27 PM/etc>cat my.cnf
[mysqld]
max_connections = 150
max_user_connections = 100
query_cache_size = 64M
skip-external-locking
key_buffer_size = 64M
max_allowed_packet=268435456
table_open_cache = 256
sort_buffer_size = 1M
net_buffer_length = 16K
read_buffer_size = 1M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 32M
innodb_file_per_table
tmp_table_s... 阅读全帖 |
|
r*******3
发帖数: 35 | 5 Ask.com, Oakland, CA
Test and Quality Engineer
Summary
Ask.com is looking for a Test and Quality Engineer who is technically
skilled and passionate about testing. The candidate will work side-by-side
with the Development and Release Engineering teams in a fast-paced, Agile/
SCRUM environment. This position must use their knowledge of QA best
practices and methods along with their scripting experience to ensure
quality throughout the site and maintain and extend Ask’s testing framework
including... 阅读全帖 |
|
x*******3
发帖数: 8342 | 6 恩 mysql myisam table crush了？ |
|
T*T
发帖数: 1386 | 7 我这准备做个中文的网站，以前没过中文的站点，被charset这个问题搞了一天了。我
在meta 已经加了content="text/html; charset=utf-8"， mysql里面 database,
table, column的collation都是用utf8-general-ci, engine 是 MyISAM。但是php网页
里，从数据库query出来的数据还是显示一堆问号，？？？？？？这样的。我查了一些
中文站点的source，好像都只在meta加一下就好。请教下，我还差什么设置没弄好？ |
|
D*******I
发帖数: 29 | 8 do you need to perform full text search? if so ... you can only use myisam
storage engine, but this is not as good as innoDB (which does not support full
text search ) .
I think maybe, you can use innodb to do storage , but use another third party
package to do the full text search. |
|
d********r
发帖数: 199 | 9 我的表都是 InnoDB的，因为需 要 transaction.
可是InnoDB的表不支持 full text index.
有什么办法吗？
难道把需要full text index的几个字段单独抽取出来做成 MyISAM 表？
这是一个好主意吗？ |
|
I******e
发帖数: 101 | 10 Almost that. Are you using InnoDB or MyISAM? A simple way is to use
mysqldump to dump everything a file and re-load the database. MySQL does
not have online re-organization ability.
BTW, do you have a lot of indexes? |
|
I******e
发帖数: 101 | 11 In general, InnoDB is much better than MyISAM. If you can tolerate the
downtime, you can do the process periodically.
How large is your data now? |
|
a*******s
发帖数: 324 | 12 It seems fulltext index introduced in MySQL 5.0 and can only be used for
myisam type table.
At least, you should add the fulltext index when you create the table. |
|
y****r
发帖数: 17 | 13 is your table MYISAM?
why you put whitespace after Difficult in your 2nd query?
but
why?
)&
') |
|
L******r
发帖数: 199 | 14 how do I know if the table is myisam?
difficult'
Difficult |
|
M*****r
发帖数: 1536 | 15 My 2 cents:
SQL Server: Windows only, Windows only, and Windows only
For mysql, the architecture is different. You can plug-in different database
engine to it.
Usually, people are talking about innodb or myisam databases engines.
selling points are: fast/compact/cross-platform/easy to manage (??)/plug-in
architecture.
The replication and database clustering are really easy to setup (but with
major limitations...).
innodb's design is heavliy influenced by Oracle, and it has been bought by
Oracle. |
|
M*****r
发帖数: 1536 | 16 http://blogs.mysql.com/kaj/2008/05/06/mysql-server-is-open-source-even-backup-extensions/
As reported yesterday from CommunityOne:
* MySQL Server is and will always remain fully functional and open
source,
* so will the MySQL Connectors, and
* so will the main storage engines we ship.
In addition:
* MySQL 6.0’s pending backup functionality will be open source,
* the MyISAM driver for MySQL Backup will be open source, and
* the encryption and compression backup features wi |
|
y**b
发帖数: 88 | 17 Hi,
I am new to MySQL. I have a MyISAM table with more than 60m records. It took
forever to rebuild the index on it. Is there anyway to speed it up? Google
said large value of key_buffer_size, myisam_sort_buffer_size helps. Any best
practice to set the proper value? Thanks in advance. |
|
z*3
发帖数: 33 | 18 这个个人感觉还是一个比较复杂的问题，如果一般的index的话是指b+ tree，并不是每
次insert都会产生balance tree的操作。只有某个node全充满的时候才会，进行
balance tree操作，或许还有left rotation和right rotation的操作。
如果使用mysql的话，可以设定经常插入的数据库的engine是inndo，不要每次insert都
commit，先insert若干条，再commit，然后用master-slave replication把数据同步到
，经常查询的一个数据库，而这个数据库的engine是myisam。
oracle的话，个人感觉可以对date，建立一个bitmap index，这样的话，其实不会有
tree的运算，每次只是没有操作或是更新一下某个gap的up或low bound。然后建一个
job，每隔一段时间dbms_stats.gather_stats,这样的话，可以尽快更新execution
plan,达到更好的效果。 |
|
M*****r
发帖数: 1536 | 19 我也记得PostgreSQL 一直有MVCC for ACID的
另外，MySQL本质上只是个中间件，后面可以plugin各种database engine,它的ACID的
实现也依赖于后面的database engine.当年起家是靠MyISAM，没有transaction的。
InnoDB is owned by Oracle since 2005
http://www.innodb.com/company/ |
|
|
B*****g
发帖数: 34098 | 21 【 以下文字转载自 JobHunting 讨论区 】
发信人: ricky8413 (上善若水), 信区: JobHunting
标 题: job openning-Test and Quality Engineer,MySQL Database Administrator
发信站: BBS 未名空间站 (Fri Jan 13 18:21:20 2012, 美东)
Ask.com, Oakland, CA
Test and Quality Engineer
Summary
Ask.com is looking for a Test and Quality Engineer who is technically
skilled and passionate about testing. The candidate will work side-by-side
with the Development and Release Engineering teams in a fast-paced, Agile/
SCRUM environment. This position must u... 阅读全帖 |
|
y*****g
发帖数: 677 | 22 你不是说的是Monte 吧，我不看好他；搞了myisam, 做嫁衣；现在绝大部分缺省是
INNODB,其他的还真是辅助。
还有mariaDB, 有了INNODB, 其它类似的就不需要了。oracle 很有眼光，在收购MySQL
之前，就收买了INNODB。 |
|
d***e
发帖数: 793 | 23 要面个广告公司， job description如下
Mysql query performance analysis.4+ years RDBMS experience working in a high
volume production environment.
MySQL 5.x (InnoDB and MyISAM engines)
MySQL replication (Master-Master, Master-Slave ) and sharding.
Experience/familiarity with Percona toolkit for backup, restore , online
schema change.
Develop tools for db monitoring, collect and analyze performance metrics.
Expertise in Ruby, Python preferred.
Familiarity with configuration management tools like Puppet.
1. ... 阅读全帖 |
|
b***i
发帖数: 3043 | 24 具体问题，我只能逐渐写，因为mitbbs居然
数据库一列是blob，用下面的语句生成table,但是这个blob不是utf8。
String create ="CREATE TABLE File (
"name varchar(255) character set utf8 not null,
type varchar(64) character set utf8 not null,
data mediumblob,
ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
primary key (name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|
d********g
发帖数: 10550 | 25 MySQL以前快是MyISAM，换了InnoDB也就那么回事，还不如PostgreSQL呢。以前PHP我还
用MySQL，现在老早就PostgreSQL了。当然MySQL群众基础不错，有问题好解决 |
|
A******g
发帖数: 612 | 26 大牛，ACID的database每一句sql语句都是一个transaction啊，"transaction" key
word是把多个sql语句弄到一个transaction里。虽然MySQL里MyISAM storage engine不
支持transaction，但最常用的innodb的transactional的。Transaction在多线程里是
一个很方便的概念，不然用户自己要实现锁或者其他syncrhonization的算法。如果只
是对单用户，那才能说over design。 |
|
