Write Article

Category

Scope and Department
    Mathematics (1)
    Physics (1)
    Biological (3)
    Medicine (3)
    Civil (1)
    Environmental (2)
    Computer (17)
    Information (2)
    EE (2)
    Materials (1)
    Art (8)
    Social (16)
    Education (21)
    Language (11)
    Business (1)
    Law (1)

Content Type

 Restaurant(7)
 Shop(2)
 Blog(48816)
 News(568)
 Photo Blog(262)
 Video Blog(295)
 Music Blog(86)
 Travel(18)
 Announcement(118)
 Daily Notes(154)
 Study Notes(124)
 Work Notes(84)
 Writing(54)
 Game Blog(5)
 Bookmark(54)
 Online File(229)
 Food(12)
 Research(33)
 HOWTOs&DIY(23)
 Regular Article(257)

Popular Section

 VBA 程序大补贴 (VBA_consultant)
 庭院深深 (xx)
 學無止境 (米米)
 天上人間 (雲天)
 醫學知識 (席上之珍)
 纪录学习的步履 (newman1)
 英文學習 (席上之珍)
 學無止境 (lazygal)
 研究心得 (Yo~)
 勵志Good (♡°笨蛋.希°♡)
 隨筆記事 (凱歌)
 好書文章 (琪琪)
 種菜樂 (拉提夏 )
 study (SnowBird)

Latest Section

 種菜樂 (拉提夏 )
 英文學習 (席上之珍)
 好書文章 (琪琪)
 醫學知識 (席上之珍)
 勵志Good (♡°笨蛋.希°♡)
 纪录学习的步履 (newman1)
 天上人間 (雲天)
 study (SnowBird)
 學無止境 (米米)
 研究心得 (Yo~)
Display: 1 - 15 of 17, Total Pages: 2
1 2 > >>
[Study Notes] 請不要再點「按讚才能看全文」的網頁 [Copied] 2011-4-13 2:04am, zzzxxxooo
請不要再點「按讚才能看全文」的網頁 真心的奉勸各位,以後再看到那種「按讚才能看隱藏內容」的網頁,絕對不要再按了!因為那是「偽裝成讚的授權按鈕」,你的個資會被盜走,或許你認為你是無名小卒所以個資被盜無所謂,更可怕的是你的 Facebook 帳號會變成垃圾訊息散播的跳板,那就不妙了...。 那些文章其實也都是網路上盜來的,真的想看內容的話,請把文章標題複製到 Google 搜尋框,你會找..

Read Full Article...

Section:電腦 | Read:2289 | Comment:8 | Rating:100%

[Study Notes] The query optimizer and Last_query_cost [Original] 2009-11-18 12:15pm, cherry
MySQL uses a cost-based optimizer, which means it tries to predict the cost of variousexecution plans and choose the least expensive. The unit of cost is a single randomfour-kilobyte data page read. Y..

Read Full Article...

Section:MySQL DBA | Read:891 | Comment:0 | Rating:0%

[Study Notes] Speeding up [Original] 2009-11-10 12:54pm, cherry
Not all ALTER TABLE operations cause table rebuilds. For example, you can change or drop a column’s default value in two ways (one fast, and one slow). Say you want to change a film’s defa..

Read Full Article...

Section:MySQL DBA | Read:878 | Comment:0 | Rating:0%

[Study Notes] testing MySQL Cluster [Original] 2009-11-9 3:22pm, cherry
MySQL Clustering in a Sandboxhttp://www.databasejournal.com/features/mysql/article.php/3819061/MySQL-Clustering-in-a-Sandbox.htm MySQL Cluster Sandbox - pre-defined packageshttp://www.severalnines.co..

Read Full Article...

Section:MySQL DBA | Read:851 | Comment:0 | Rating:0%

[Study Notes] How MySQL handles errors during trigger execution? [Original] 2009-11-4 4:22pm, cherry
MySQL handles errors during trigger execution as follows:     * If a BEFORE trigger fails, the operation on the corresponding row is not performed.    * A BEFORE trigger..

Read Full Article...

Section:MySQL DBA | Read:2990 | Comment:0 | Rating:0%

[Study Notes] potential problems of Stored Programs in MySQL replication [Original] 2009-11-4 4:19pm, cherry
18.6. Binary Logging of Stored Programshttp://dev.mysql.com/doc/refman/5.4/en/stored-programs-logging.html However, there are certain binary logging issues that apply with respect to stored programs..

Read Full Article...

Section:MySQL DBA | Read:592 | Comment:0 | Rating:0%

[Study Notes] Disadvantages of mysql stored procedures [Original] 2009-11-4 4:17pm, cherry
• MySQL doesn’t provide good developing and debugging tools, so it’s harder towrite stored code in MySQL than it is in some other database servers.• The language is slow and prim..

Read Full Article...

Section:MySQL DBA | Read:3899 | Comment:0 | Rating:0%

[Study Notes] spider data sharding and replication [Original] 2009-10-22 5:20pm, cherry
A. what is spider? (extracted from spider document) 1. Spider Storage Engine creates table links from local databases to remote databases.   Spider makes available tables in remote MySQL..

Read Full Article...

Section:MySQL DBA | Read:2319 | Comment:0 | Rating:0%

[Study Notes] MySQL cluster summary [Original] 2009-9-17 10:57pm, cherry
MySQL Cluster features Overview:• MySQL Cluster is a technology that enables clustering of in-memorydatabases in a shared-nothing system.• MySQL Cluster is designed not to have any single point of fai..

Read Full Article...

Section:MySQL DBA | Read:1796 | Comment:0 | Rating:0%

[Study Notes] MySQL Cluster Performance [Original] 2009-9-1 3:40pm, cherry
MySQL Cluster has a very different impact on the concepts of response time, throughput, and scalability than a normal single-system, disk-based database, such as MyISAM or InnoDB.   Response ti..

Read Full Article...

Section:MySQL DBA | Read:1281 | Comment:0 | Rating:0%

[Study Notes] SQL_CALC_FOUND_ROWS and FOUND_ROWS() [Original] 2009-8-26 11:58am, cherry
SQL_CALC_FOUND_ROWS and FOUND_ROWS() can be useful in situations when you want to restrict the number of rows that a query returns, but also determine the number of rows in the full result set without..

Read Full Article...

Section:MySQL DBA | Read:5197 | Comment:0 | Rating:0%

[Study Notes] optimize MIN() and MAX() [Copied] 2009-8-25 11:58am, cherry
MySQL doesn’t optimize certain MIN( ) and MAX( ) queries very well. Here’s anexample: mysql> SELECT MIN(actor_id) FROM sakila.actor WHERE first_name = 'PENELOPE'; Because there’..

Read Full Article...

Section:MySQL DBA | Read:2159 | Comment:0 | Rating:0%

[Study Notes] how to calculate open file limit? [Copied] 2009-8-23 11:39am, cherry
每打开一个MyISAM表,就需要使用2个文件描述符,咱们来验证一下MySQL如何计算打开文件数。 一、试验 从手册的"6.4.8. How MySQL Opens and Closes Tables"可以了解到,每打开一个MyISAM表,就需要使用2个文件描述符,咱们来验证一下。 1. 重启mysqld /etc/init.d/mysql restart 2. 看看打开了几个文件 lsof | g..

Read Full Article...

Section:MySQL DBA | Read:2465 | Comment:0 | Rating:0%

[Study Notes] 輕鬆自行下載youtube各種格式影片 [Original] 2009-8-19 3:32am, say123
之前寫的youtube下載程式不能用了,上網查一下才發現youtube網頁又修改了,以下提供新的下載方法:首先開啟影片(以http://www.youtube.com/watch?v=1HkXjUxWW74為例子) 進去後開啟網頁原始碼,然後按下ctrl+f收尋以下字串 (fmt_url_map),之後把後面雙引號包住的那一長串url編碼文字複製下來,這些就是下載網址了:"34%7Chttp%3..

Read Full Article...

Section:小小蔡 | Read:3447 | Comment:1 | Rating:0%

[Study Notes] Tools for sharding [Original] 2009-8-18 11:33am, cherry
(high performance MySQL 2nd Ed. Page 417~432) 1. MySQL proxy http://forge.mysql.com/wiki/MySQL_Proxy HSCALE - Horizontal Scaling for MySQLhttp://hscale.org/display/HSCALE/Home HSCALE is a plugin w..

Read Full Article...

Section:MySQL DBA | Read:4251 | Comment:0 | Rating:0%

1 2 > >>

Hottest Tags:

17  顧曉軍  history  Justice  學習  民主运动  郭旭東將軍  段海山 段海紅 趙衛華 盜採砂石 段海春 木林鎮 大韓莊  國際戰爭  北京奧運會示威區抗議A demonstration in the designated protest venues during Beijing Olimpic Games 2008  人體實驗  旅游  宗教信仰  法輪大法好falundafa's perfect  politics  腦控  詩歌    精神控制  法輪功  中國人權  修煉  新聞  SomeCustomInjectedHeader:injected_by_wvs  評論  雨風  中共  彌勒  洗腦  教育  江澤民  【分享大觀園】  政治  趙衛華  段海春  大韓莊  段海紅  盜採砂石  木林鎮  人生  段海山  人權  中國政府  addcontentsave  宗教迫害Belief Persecution  朋友  set|set&set  神韻  生活  經濟  懷孕  生命  純善純美神韻  上帝  【禁歌禁片】  貴金屬  外匯  共產黨  人权  思維隱形超限  電腦  安徽王焰  財經  彌勒佛  《何健語錄》  法輪大法  freedom  投資  健康  歐元對美元  音樂  democracy  王焰  波士頓  【辛灝年-袁騰飛專輯】  中共江蘇省委?  毛澤東  毒藥  【 地震《掩埋》的真象】  國家安全部  心的祝福  王海松  王剛  真相  慢性毒藥  武術  精神控制實驗  趙寧臣 江蘇省委 葛秀蘭  心靈之窗  李健  盧映川  【世界廣角】  搞笑  心情  【中國良心律師高智晟】  奇聞  ';print(md5(acunetix_wvs_security_test));$a='  ..%2F..%2F..%2F..%2F..%2F..%2F..%2F..%2F..%2F..%2Fetc%2Fpasswd%00.jpg  1'"  "set|set&set" 

Latest Comments:

Partners:  Dealone