papering - 博客园

2016年12月30日

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 阅读(167) 评论(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 阅读(252) 评论(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 阅读(222) 评论(0) 推荐(0)

w-BIG TABLE 1-toSMALLtable @-toMEMORY

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

posted @ 2016-12-30 15:00 papering 阅读(132) 评论(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 阅读(219) 评论(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 阅读(331) 评论(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 阅读(266) 评论(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 阅读(463) 评论(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 阅读(289) 评论(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 阅读(206) 评论(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 阅读(202) 评论(0) 推荐(0)

1920.154s 0.309s 30817

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

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

Example Microprocessor Register Organizations

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

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

2016年12月29日

x square x cube

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

posted @ 2016-12-29 23:25 papering 阅读(146) 评论(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 阅读(428) 评论(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 阅读(216) 评论(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 阅读(521) 评论(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 阅读(183) 评论(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 阅读(411) 评论(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 阅读(175) 评论(0) 推荐(0)

w-BIG TABLE-view+where-small table

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

posted @ 2016-12-29 15:59 papering 阅读(254) 评论(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 阅读(172) 评论(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 阅读(212) 评论(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 阅读(263) 评论(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 阅读(283) 评论(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 阅读(159) 评论(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 阅读(277) 评论(0) 推荐(0)

2016年12月28日

MySQL 5.6.3

摘要： SHOW VARIABLES LIKE '%version%'; https://dev.mysql.com/doc/refman/5.6/en/explain.html As of MySQL 5.6.3, permitted explainable statements for EXPLAIN 阅读全文

posted @ 2016-12-28 20:02 papering 阅读(242) 评论(0) 推荐(0)

Heterogeneous System Architecture

摘要： https://en.wikipedia.org/wiki/Heterogeneous_System_Architecture Steps performed when offloading calculations to the GPU on a non-HSA system Steps perf 阅读全文

posted @ 2016-12-28 16:26 papering 阅读(231) 评论(0) 推荐(0)

What is Heterogeneous Computing?

摘要： http://developer.amd.com/resources/heterogeneous-computing/what-is-heterogeneous-computing/ Heterogeneous computing refers to systems that use more th 阅读全文

posted @ 2016-12-28 16:23 papering 阅读(237) 评论(0) 推荐(0)

ping img.onload 原理 ping相关协议

摘要： ping（网络诊断工具）_百度百科 https://baike.baidu.com/item/ping/6235?fr=aladdin 在物理链路连通和路由设置正确的情况下，使用Ping命令仍然屏不通，可能有以下几个问题： (1)网线刚插到交换机上就Ping通网关，忽略了生成树的收敛时间。当然，较新阅读全文

posted @ 2016-12-28 15:42 papering 阅读(483) 评论(0) 推荐(0)

发现美的眼睛 Prepared SQL Statement

摘要： http://dev.mysql.com/doc/refman/5.7/en/sql-syntax-prepared-statements.html 阅读全文

posted @ 2016-12-28 14:17 papering 阅读(207) 评论(0) 推荐(0)

Alternative Representations for 4-Bit Integers

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

posted @ 2016-12-28 13:19 papering 阅读(239) 评论(0) 推荐(0)

2016年12月27日

Twos Complement Representation

摘要： COMPUTER ORGANIZATION AND ARCHITECTURE DESIGNING FOR PERFORMANCE NINTH EDITION Like sign magnitude, twos complement representation uses the most signi 阅读全文

posted @ 2016-12-27 23:24 papering 阅读(307) 评论(0) 推荐(0)

SELECT 'www' = 0; 1

摘要： http://dev.mysql.com/doc/refman/5.7/en/type-conversion.html MySQL 5.7 Reference Manual / Functions and Operators / Type Conversion in Expression Evalu 阅读全文

posted @ 2016-12-27 19:09 papering 阅读(254) 评论(0) 推荐(0)

SET ? DECLARE

摘要： http://dev.mysql.com/doc/refman/5.7/en/declare-local-variable.html http://dev.mysql.com/doc/refman/5.7/en/set-variable.html SET Syntax for Variable As 阅读全文

posted @ 2016-12-27 18:40 papering 阅读(204) 评论(0) 推荐(0)

Defining Stored Programs

摘要： ok ok http://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html 阅读全文

posted @ 2016-12-27 18:11 papering 阅读(222) 评论(0) 推荐(0)

Sign-Magnitude Representation

摘要： COMPUTER ORGANIZATION AND ARCHITECTURE DESIGNING FOR PERFORMANCE NINTH EDITION There are several alternative conventions used to represent negative as 阅读全文

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

the core or essence of a computer

摘要： COMPUTER ORGANIZATION AND ARCHITECTURE DESIGNING FOR PERFORMANCE NINTH EDITION The ALU is that part of the computer that actually performs arithmetic 阅读全文

posted @ 2016-12-27 13:23 papering 阅读(246) 评论(0) 推荐(0)

HEXADECIMAL NOTATION is Syntactic_sugar.

摘要： Syntactic_sugar. 阅读全文

posted @ 2016-12-27 13:20 papering 阅读(139) 评论(0) 推荐(0)