papering - 博客园

2016年12月31日

摘要： https://www.enterprisedb.com/well-known-databases-use-different-approaches-mvcc Well-known Databases Use Different Approaches for MVCC Well-known Data 阅读全文

posted @ 2016-12-31 19:42 papering 阅读(242) 评论(0) 推荐(0)

Any changes made by a writer will not be seen by other users of the database until the changes have been completed

摘要： https://en.wikipedia.org/wiki/Multiversion_concurrency_control Multiversion concurrency control (MCC or MVCC), is a concurrency control method commonl 阅读全文

posted @ 2016-12-31 19:18 papering 阅读(208) 评论(0) 推荐(0)

Portable Operating System Interface for uni-X

摘要： https://kb.iu.edu/d/agjv 【可移植】 Short for "Portable Operating System Interface for uni-X", POSIX is a set of standards codified by the IEEE and issued 阅读全文

posted @ 2016-12-31 18:48 papering 阅读(302) 评论(0) 推荐(0)

SHARE NOTHING SHARE EVERYTHING

摘要： https://mp.weixin.qq.com/s/pMOqLJVCVuKG65ClXKHv7g 【科技文】PGXZ—腾讯分布式关系数据集群—架构解析 Original 2016-06-27 jasonysli 腾讯技术工程官方号 jasonysli李跃森本文作者数据平台部存储引擎组PGXZ项目负阅读全文

posted @ 2016-12-31 18:44 papering 阅读(1433) 评论(0) 推荐(0)

fopen w c

摘要： http://php.net/manual/en/function.fopen.php 阅读全文

posted @ 2016-12-31 13:53 papering 阅读(135) 评论(0) 推荐(0)

Given a compiled machine-language program, which statements in the source language cause the execution of the most machine-language instructions and what is the execution time of these instr

摘要： COMPUTER ORGANIZATION AND ARCHITECTURE DESIGNING FOR PERFORMANCE NINTH EDITION A variety of studies have been made to analyze the behavior of HLL prog 阅读全文

posted @ 2016-12-31 12:59 papering 阅读(373) 评论(0) 推荐(0)

A quick renice command rescheduled the upgrade to a lower priority and I was back to surfing in no time.

摘要： https://www.nixtutor.com/linux/changing-priority-on-linux-processes/ Changing Priority on Linux Processes Wed, Apr 22, 2009 What is Priority and Why S 阅读全文

posted @ 2016-12-31 09:48 papering 阅读(341) 评论(0) 推荐(0)

INSTRUCTION EXECUTION CHARACTERISTICS

摘要： Characteristics of Some CISCs, RISCs, and Superscalar Processors One of the most visible forms of evolution associated with computers is that of pro-g 阅读全文

posted @ 2016-12-31 09:45 papering 阅读(503) 评论(0) 推荐(0)

Characteristics of Some CISCs, RISCs, and Superscalar Processors

摘要： COMPUTER ORGANIZATION AND ARCHITECTURE DESIGNING FOR PERFORMANCE NINTH EDITION Although RISC architectures have been defined and designed in a variety 阅读全文

posted @ 2016-12-31 09:05 papering 阅读(261) 评论(0) 推荐(0)

2016年12月30日

the major advances since the birth of the computer

摘要： COMPUTER ORGANIZATION AND ARCHITECTURE DESIGNING FOR PERFORMANCE NINTH EDITION • The family concept: Introduced by IBM with its System/360 in 1964, fo 阅读全文

posted @ 2016-12-30 22:57 papering 阅读(211) 评论(0) 推荐(0)

15.2 THE USE OF A LARGE REGISTER FILE

摘要： COMPUTER ORGANIZATION AND ARCHITECTURE DESIGNING FOR PERFORMANCE NINTH EDITION 阅读全文

posted @ 2016-12-30 21:21 papering 阅读(136) 评论(0) 推荐(0)

principal-component-analysis

摘要： http://support.minitab.com/en-us/minitab/17/topic-library/modeling-statistics/multivariate/principal-components-and-factor-analysis/what-is-pca/ http: 阅读全文

posted @ 2016-12-30 20:04 papering 阅读(246) 评论(0) 推荐(0)

buffer pool

摘要： https://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_buffer_pool buffer pool The memory area that holds cached InnoDB data for both tables and i 阅读全文

posted @ 2016-12-30 16:03 papering 阅读(179) 评论(0) 推荐(0)

http://highscalability.com/blog/2015/5/18/how-mysql-is-able-to-scale-to-200-million-qps-mysql-cluster.html

摘要： http://highscalability.com/blog/2015/5/18/how-mysql-is-able-to-scale-to-200-million-qps-mysql-cluster.html 阅读全文

posted @ 2016-12-30 15:40 papering 阅读(143) 评论(0) 推荐(0)

most queries (more than 90 percent) never hit the database at all but only touch the cache layer

摘要： https://gigaom.com/2011/12/06/facebook-shares-some-secrets-on-making-mysql-scale/ Facebook shares some secrets on making MySQL scale Derrick Harris De 阅读全文

posted @ 2016-12-30 15:34 papering 阅读(220) 评论(0) 推荐(0)

faster with MyISAM tables than with InnoDB or NDB tables

摘要： http://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html Performance considerations. Some effects of partitioning operations on performanc 阅读全文

posted @ 2016-12-30 15:19 papering 阅读(194) 评论(0) 推荐(0)

w-BIG TABLE 1-toSMALLtable @-toMEMORY

摘要： BIG TABLE 1-toSMALLtable @-toMEMORY 阅读全文

posted @ 2016-12-30 15:00 papering 阅读(118) 评论(0) 推荐(0)

Indexing and Hashing

摘要： DATABASE SYSTEM CONCEPTS, SIXTH EDITION11.1 Basic ConceptsAn index for a ﬁle in a database system works in much the same way as the indexin this textb 阅读全文

posted @ 2016-12-30 14:56 papering 阅读(186) 评论(0) 推荐(0)

MEMORY Storage Engine MEMORY Tables TEMPORARY TABLE max_heap_table_size

摘要： http://dev.mysql.com/doc/refman/5.7/en/create-table.html You can use the TEMPORARY keyword when creating a table. A TEMPORARY table is visible only to 阅读全文

posted @ 2016-12-30 14:46 papering 阅读(289) 评论(0) 推荐(0)

controlling the variance of request response times and not just worrying about maximizing queries per second

摘要： http://highscalability.com/blog/2010/11/4/facebook-at-13-million-queries-per-second-recommends-minimiz.html Thursday, November 4, 2010 at 8:48AM Faceb 阅读全文

posted @ 2016-12-30 14:27 papering 阅读(229) 评论(0) 推荐(0)

Variance

摘要： http://mathworld.wolfram.com/Variance.html Variance For a single variate having a distribution with known population mean , the population variance , 阅读全文

posted @ 2016-12-30 14:06 papering 阅读(426) 评论(0) 推荐(0)

Population Mean

摘要： Probability and Statistics > Moments > History and Terminology > Disciplinary Terminology > Biological Terminology > History and Terminology > Discipl 阅读全文

posted @ 2016-12-30 13:50 papering 阅读(251) 评论(0) 推荐(0)

12.162s 1805.867s

摘要： 1 [SQL]DROP PROCEDURE IF EXISTS truncate_insert_sales_rank_toparow_week; 2 受影响的行: 0 3 时间: 0.001s 4 5 [SQL] 6 7 CREATE PROCEDURE truncate_insert_sales_rank_toparow_week () 8 BEGIN ... 阅读全文

posted @ 2016-12-30 12:16 papering 阅读(175) 评论(0) 推荐(0)

situations where MyISAM will be faster than InnoDB

摘要： http://www.tocker.ca/categories/myisam Converting MyISAM to InnoDB and a lesson on variance I'm about to start working through converting a large MySQ 阅读全文

posted @ 2016-12-30 11:52 papering 阅读(175) 评论(0) 推荐(0)

1920.154s 0.309s 30817

摘要： MyISAM HASH restart-buffer 阅读全文

posted @ 2016-12-30 10:21 papering 阅读(210) 评论(0) 推荐(0)

Example Microprocessor Register Organizations

摘要： COMPUTER ORGANIZATION AND ARCHITECTURE DESIGNING FOR PERFORMANCE NINTH EDITION 阅读全文

posted @ 2016-12-30 09:07 papering 阅读(214) 评论(0) 推荐(0)

2016年12月29日

x square x cube

摘要： Mathematical Thought From Ancient To Modern Times 阅读全文

posted @ 2016-12-29 23:25 papering 阅读(131) 评论(0) 推荐(0)

算法构成时间复杂度

摘要：总结： 1、一个算法由控制结构（顺序、分支和循环3种）和原操作（指固有数据类型的操作）构成的，则算法时间取决于两者的综合效果。 2、 N*N矩阵乘法算法时间复杂度T(n)=O(n^3) for(i=1;i<=n;i++) for(j=1;j<=n;j++) c[i][j]=0 for(k=1;k 阅读全文

posted @ 2016-12-29 19:54 papering 阅读(396) 评论(0) 推荐(0)

only for equality comparisons Hash Index Characteristics

摘要： http://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html Hash Index Characteristics Hash indexes have somewhat different characteristics from thos 阅读全文

posted @ 2016-12-29 19:16 papering 阅读(183) 评论(0) 推荐(0)

NULL-safe equal null 索引空字符串

摘要：小结 1、 mysql> INSERT INTO my_table (phone) VALUES (NULL); 有手机号但是不知道 mysql> INSERT INTO my_table (phone) VALUES ('');没有手机号 http://dev.mysql.com/doc/refm 阅读全文

posted @ 2016-12-29 19:06 papering 阅读(484) 评论(0) 推荐(0)

Why MySQL could be slow with large tables ?

摘要： https://www.percona.com/blog/2006/06/09/why-mysql-could-be-slow-with-large-tables/ 阅读全文

posted @ 2016-12-29 18:56 papering 阅读(164) 评论(0) 推荐(0)

Boyer-Moore algorithm

摘要： http://www-igm.univ-mlv.fr/~lecroq/string/node14.html Main features performs the comparisons from right to left; preprocessing phase in O(m+) time and 阅读全文

posted @ 2016-12-29 17:13 papering 阅读(385) 评论(0) 推荐(0)

The index also can be used for LIKE comparisons if the argument to LIKE is a constant string that does not start with a wildcard character.

摘要： http://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html MySQL 5.7 Reference Manual / ... / Comparison of B-Tree and Hash Indexes 9.3.8 Comparison 阅读全文

posted @ 2016-12-29 17:02 papering 阅读(152) 评论(0) 推荐(0)

w-BIG TABLE-view+where-small table

摘要： w-BIG TABLE USING BTREE >BETTER >USING HASH 阅读全文

posted @ 2016-12-29 15:59 papering 阅读(222) 评论(0) 推荐(0)

a single statement, not multiple statements

摘要： http://dev.mysql.com/doc/refman/5.7/en/prepare.html Statement names are not case sensitive. preparable_stmt is either a string literal or a user varia 阅读全文

posted @ 2016-12-29 10:59 papering 阅读(150) 评论(0) 推荐(0)

Introducing the Accelerated Mobile Pages Project, for a faster, open mobile web

摘要： https://googleblog.blogspot.com/2015/10/introducing-accelerated-mobile-pages.html October 7, 2015 October 7, 2015 Smartphones and tablets have revolut 阅读全文

posted @ 2016-12-29 09:55 papering 阅读(174) 评论(0) 推荐(0)

Introduction to Structured Data json的2种形式 JAVA解析JSON数据 - JsonArray JsonObject

摘要： https://developers.google.com/search/docs/guides/intro-structured-data Structured data refers to kinds of data with a high level of organization, such 阅读全文

posted @ 2016-12-29 09:45 papering 阅读(225) 评论(0) 推荐(0)

Bigtable: A Distributed Storage System for Structured Data

摘要： https://static.googleusercontent.com/media/research.google.com/en//archive/bigtable-osdi06.pdf Abstract Bigtable is a distributed storage system for m 阅读全文

posted @ 2016-12-29 09:22 papering 阅读(248) 评论(0) 推荐(0)

Decoder with 3 Inputs and 2 3 = 8 Outputs

摘要： COMPUTER ORGANIZATION AND ARCHITECTURE DESIGNING FOR PERFORMANCE NINTH EDITION 阅读全文

posted @ 2016-12-29 09:05 papering 阅读(142) 评论(0) 推荐(0)

Seven-Segment LED Display Example Design an 8-to-1 multiplexer.

摘要： COMPUTER ORGANIZATION AND ARCHITECTURE DESIGNING FOR PERFORMANCE NINTH EDITION 阅读全文

posted @ 2016-12-29 08:50 papering 阅读(237) 评论(0) 推荐(0)