papering - 博客园

2016年12月30日

摘要： 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 阅读(186) 评论(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 阅读(177) 评论(0) 推荐(0)

1920.154s 0.309s 30817

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

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

Example Microprocessor Register Organizations

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

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

2016年12月29日

x square x cube

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

posted @ 2016-12-29 23:25 papering 阅读(133) 评论(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 阅读(407) 评论(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 阅读(189) 评论(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 阅读(493) 评论(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 阅读(166) 评论(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 阅读(388) 评论(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 阅读(154) 评论(0) 推荐(0)

w-BIG TABLE-view+where-small table

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

posted @ 2016-12-29 15:59 papering 阅读(228) 评论(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 阅读(156) 评论(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 阅读(183) 评论(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 阅读(239) 评论(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 阅读(261) 评论(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 阅读(144) 评论(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 阅读(239) 评论(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 阅读(230) 评论(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 阅读(205) 评论(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 阅读(221) 评论(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 阅读(446) 评论(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 阅读(181) 评论(0) 推荐(0)

Alternative Representations for 4-Bit Integers

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

posted @ 2016-12-28 13:19 papering 阅读(228) 评论(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 阅读(279) 评论(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 阅读(228) 评论(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 阅读(187) 评论(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 阅读(202) 评论(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 阅读(428) 评论(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 阅读(213) 评论(0) 推荐(0)

HEXADECIMAL NOTATION is Syntactic_sugar.

摘要： Syntactic_sugar. 阅读全文

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

Converting from Decimal Notation to Binary Notation for Fractions

摘要： COMPUTER ORGANIZATION AND ARCHITECTURE DESIGNING FOR PERFORMANCE NINTH EDITION Therefore, the conversion algorithm involves repeated multiplication by 阅读全文

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

convert from base 10 to base 2

摘要： COMPUTER ORGANIZATION AND ARCHITECTURE DESIGNING FOR PERFORMANCE NINTH EDITION Hence, we convert from base 10 to base 2 by repeated divisions by 2. Th 阅读全文

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

MYSQL PASSWORD()

摘要： https://www.pythian.com/blog/hashing-algorithm-in-mysql-password-2/ 阅读全文

posted @ 2016-12-27 12:04 papering 阅读(167) 评论(0) 推荐(0)

Environment Variables

摘要： https://msdn.microsoft.com/en-us/library/windows/desktop/ms682653(v=vs.85).aspx Every process has an environment block that contains a set of environm 阅读全文

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

Why Stored Procedures?

摘要： http://www.w3resource.com/mysql/mysql-procedure.php Stored procedures are fast. MySQL server takes some advantage of caching, just as prepared stateme 阅读全文

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

delimiter

摘要： http://www.mysqltutorial.org/getting-started-with-mysql-stored-procedures.aspx The first command is DELIMITER // , which is not related to the stored 阅读全文

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

2016年12月26日

page fault rate

摘要： COMPUTER ORGANIZATION AND ARCHITECTURE DESIGNING FOR PERFORMANCE NINTH EDITION A program computes the row sums Ci=anj = 1aij of an array A that is 100 阅读全文

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

2016年12月25日

Segmentation

摘要： COMPUTER ORGANIZATION AND ARCHITECTURE DESIGNING FOR PERFORMANCE NINTH EDITION There is another way in which addressable memory can be subdivided, kno 阅读全文

posted @ 2016-12-25 15:10 papering 阅读(380) 评论(0) 推荐(0)

自动记录气压计

摘要：数学分析张筑生阅读全文

posted @ 2016-12-25 09:59 papering 阅读(167) 评论(0) 推荐(0)