Skip to content

Monster Oasis

  • 浪況預測
  • KML2CSV
  • World Marathon
  • Privacy Policy

DATABASE

mysqldump 不鎖 table 備份 command , nolock , no lock

2012/05/042012/04/16 by Monster
mysqldump -u -p -h host --lock-tables=false stat tbl_test | gzip -cf > 1.gz
Categories DATABASE, JOB Tags mysql

Protected: [memo] 標準前台安裝 , SOP , steps

2014/02/272011/11/08 by Monster

This content is password protected. To view it please enter your password below:

Categories Copy_N_Paste, DATABASE, JOB, Programming/misc, Programming/php, Software, System/Linux/Unix*

Protected: [LAB] Best practices guidelines for running MySQL databases on NetApp® storage , 測試結果

2011/06/182011/06/16 by Monster

This content is password protected. To view it please enter your password below:

Categories DATABASE, JOB Tags lab, mysql

Protected: special oracle SQL command , prevent join

2011/05/262011/05/25 by Monster

This content is password protected. To view it please enter your password below:

Categories DATABASE Tags oracle

建 mysql partition table 遇到的問題

2011/04/14 by Monster

1. Out of resources when opening file
在 my.cnf 加 open-files-limit = 6000

2. Too many partitions were defined

Ref. URL :  https://www.monster.com.tw/archives/2504

Categories DATABASE, JOB Tags mysql, partition table

[note] ubuntu 裝 LAMP 的 guide (中文)

2011/03/12 by Monster

http://wiki.ubuntu-tw.org/index.php?title=UbuntuTW_Guide_ch14

Categories DATABASE, Programming/php, System/Linux/Unix*

很好的一篇文章 Apache Cassandra

2011/03/122011/03/10 by Monster

URL  = http://www.rackspace.com/cloud/blog/2010/05/12/cassandra-by-example/

先用 SQL 式的來說明 twitter 的結構 / 流程 , 再用 no-SQL 的 Cassandra 再解釋一次 , 說明得很清楚 , 可以當做入門 Cassandra 的好範例.

 

http://wiki.apache.org/cassandra/ThriftExamples

Categories Article or News, DATABASE, JOB

Protected: mysql grouping syntax vs. php code grouping performance compare …. 待查

2011/02/14 by Monster

This content is password protected. To view it please enter your password below:

Categories DATABASE, JOB

[case] compare Oracle : select …. in (…) / or … explain result

2011/01/06 by Monster

擷取oracle_or_in_syntax

explain 結果一樣.

Categories DATABASE Tags oracle

Protected: [memo] mysql CPU / MEMORY / DISK / SERVER

2010/11/18 by Monster

This content is password protected. To view it please enter your password below:

Categories DATABASE, JOB Tags mysql
Older posts
Newer posts
← Previous Page1 Page2 Page3 Page4 … Page17 Next →
© 2025 Monster Oasis • Built with GeneratePress