中文版
英語閱讀
今天是薄荷閱讀的76天，讀的書籍是亞瑟王。
Enid 擔心自己衣著難看而被宮廷里的人瞧不起，Enid的媽媽為她找來很多年前的漂亮衣服，而Geraint讓Enid穿回舊衣服，
理由一：當需要的時候，他媽媽會幫Enid 挑選新衣服，這樣有利于她們兩相互了解和成為朋友。
理由二：Geraint想知道他愛的人想嫁給他是因為愛他，而不是因為他可以給她和她的家人更好的生活。
并許下諾言，以后再也不懷疑Enid愛他的心。
他們回到了宮廷，Geraint的母親為他們舉行了盛大的婚禮。
人類是奇怪的生物，隨著時間的推移，會變的陌生，現(xiàn)在的Geraint無法確定自己對Enid的感情。
工作
1）升級方案評審
刷數(shù)據(jù)（將時間A刷成時間B），且是第二次做的升級。
起因：看到群里說去導現(xiàn)網(wǎng)的數(shù)據(jù)回來-對升級方案做測試，而理由是：上次未用現(xiàn)網(wǎng)的數(shù)據(jù)做測試-導致升級時遇到問題。
一看到這樣的理由，我的火氣莫名其妙就上來了，直接在群里回復：數(shù)據(jù)量大就分批分次，不用導現(xiàn)網(wǎng)數(shù)據(jù)回來。私底下給他們算了一筆賬：導數(shù)據(jù)2-3小時，傳回公司1小時，再導入庫2-3小時，測試1小時，發(fā)現(xiàn)執(zhí)行效率低?？梢惶煲簿瓦@么忙碌地過去了，什么問題都沒有解決。還牽涉了三個人，一個導出數(shù)據(jù)的實施，一個導入數(shù)據(jù)的測試，一個提供方案的研發(fā)。
項目經(jīng)理不是很明白我說的話，邀請我做方案把關(guān)，并給了我前一次升級方案，升級步驟是7步，回退步驟是2步，如此簡單的9步，有4步是存在問題的。
升級步驟N: ?給一個大數(shù)據(jù)量的表加字段-并帶了 默認值0。 ?
問題：會使得整個表鎖住，且效率低下。
正確的做法：先加字段，再設置默認值。
升級步驟N: ?對剛加并設置了默認值的表，又做了一次值為0。
問題：重復操作，無意義
操作的理由：老板說表加字段-并帶了 默認值0 有時無效，為了保險所以再設置一次值。
升級步驟N: 直接對大表做了更改數(shù)據(jù)的操作
問題：表大-執(zhí)行消耗長，會給數(shù)據(jù)庫帶來壓力。
正確的做法：update 的時候 在已有條件的基礎上，再加一個條件限制。比如：一次只修改5萬條。
回退步驟: 給flag為0、1的字段加索引
問題：無意義的操作
操作的理由：因為數(shù)據(jù)量大所以加索引。
而索引是在數(shù)據(jù)量大且數(shù)據(jù)值離散的情況下 加才有意義，不是0就是1，加個索引有什么用。
在第二次對差不多相同的方案做評審時這些問題基本都在，除了我在說外沒人給出補充意見。
于是有了這一場對話：
Me : Last time ,They were review the upgrade Plan ,But didn't find the extra step which lead to the upgrade time Extended。
Review ，need technology, if nobody known the interrelated??technology,The Review is will nothing worth。
Yz: ? ha，it is have to do.It doesn't matter with worth.
Me: ?Review is the must step,But its goal to find any question which affect success.
Yz: ?nobody care goal.
? ? ? ?nobody care success.
瞬間讓我無話可說，有些形式主義還真無法避免，而做了總比沒有做的好。
2）接口自動化代碼修改
起因：預計有上百個接口，且部分是json嵌套json，而靠手工做測試預計全團隊的人員加在一起都無法完成的工作量，必須自動化，而我2月份完成的版本-對接口的參數(shù)是無嵌套的，已不符合當前的現(xiàn)狀。
更改1：參數(shù)表設計的更改，增加了節(jié)點和節(jié)點類型字段。
更改2: ?加入接口參數(shù)的json 導入功能。解決單個錄入?yún)?shù)效率低問題。（明天有時間則繼續(xù)）
English?
MintReading
Today is the 76 day of MintReading. The book is king Arthur.
Enid worried that her clothes were ugly and looked down on the court, then Enid's mother found for her beautiful dress, But Geraint want Enid wear old clothes.
One：His mother will have to help choose new dress for Enid when she need, he hope Enid and his mother will get to know each other and become friends.
Two: ?he wanted to sure that Enid was marrying his because loved ,and not just because he might give her and her parents a better life.
Geraint promise that he will never doubt her again.
But humans are such strange, as times goes on ,They are unfamiliar with each other,Now Geraint can't make sure of his feelings about Enid.
Working
1) Review upgrade Plan
thing: ?update the data (as : update the time a to b), this is the second upgrade.
reason: In the group，they are talking about?export the online data to test?environment .?Last time we did not test in online's data ,ant than have many problems when upgrading.
my anger came up somehow when I know?such this reason, and reply:The data volume is large and batches are divided in batches,Don't need export the online data.?
export the data need 2-3?hours, import data need 2-3 hours,test need 1 hour, find?Low execution efficiency.one?day has?passed, and nothing to?solve. In this thing, three people do work for?it, one ops to export?data, one tester to import data ,one dev to give a plan.
The PM did't understand what?I say?about,He wanted me to help him review the upgrade plan，and give me the previous upgrade.
The upgrade have 7 upgrade step and 2 regresses step,In such easy 9 step, there are 4 steps that have problems.
one: Add a field to a large data table with a default value of 0.
problem: the table?will be locked and the efficiency is low.
Correct: add a field to table first ,then set ?default value.
two: ?set the default value to the table again.
problem:?Duplication of operation, meaningless
reason：The boss said that the default value ?is sometimes invalid, so need set again.
three:?Changing large table data at one time
problem：Long execution time, bring pressure to the database
Correct：add limit . as :Only 50 thousand changes at one time。
regresses step?: add index for the flag field which values 0 or 1.
problem:?meaningless
reason: ?because large data.
Index is added when data is large and the data value is discrete.
this questions are all exist in seconds review, and nobody?has mentioned it.
this?dialogue with Yz:?
Me : Last time ,They were review the upgrade Plan ,But didn't find the extra step which lead to the upgrade time Extended。
Review ，need technology, if nobody known the interrelated??technology,The Review is will nothing worth。
Yz: ? ha，it is have to do.It doesn't matter with worth.
Me: ?Review is the must step,But its goal to find any question which affect success.
Yz: ?nobody care goal.
? ? ? ?nobody care success.
I have nothing to say,Some formalism is really unavoidable, and it is better to do it than not to do it.
2）modify code?
reason：have 100 api interface needs to be test ,json nesting json.
change one：modify param table design，add node field ?& nodeType field.
change two: ? add json import function. Solving the problem of low efficiency of ?input parameter.
