中文版
英语阅读
今天是薄荷阅读的76天,读的书籍是亚瑟王。
Enid 担心自己衣着难看而被宫廷里的人瞧不起,Enid的妈妈为她找来很多年前的漂亮衣服,而Geraint让Enid穿回旧衣服,
理由一:当需要的时候,他妈妈会帮Enid 挑选新衣服,这样有利于她们两相互了解和成为朋友。
理由二:Geraint想知道他爱的人想嫁给他是因为爱他,而不是因为他可以给她和她的家人更好的生活。
并许下诺言,以后再也不怀疑Enid爱他的心。
他们回到了宫廷,Geraint的母亲为他们举行了盛大的婚礼。
人类是奇怪的生物,随着时间的推移,会变的陌生,现在的Geraint无法确定自己对Enid的感情。
工作
1)升级方案评审
刷数据(将时间A刷成时间B),且是第二次做的升级。
起因:看到群里说去导现网的数据回来-对升级方案做测试,而理由是:上次未用现网的数据做测试-导致升级时遇到问题。
一看到这样的理由,我的火气莫名其妙就上来了,直接在群里回复:数据量大就分批分次,不用导现网数据回来。私底下给他们算了一笔账:导数据2-3小时,传回公司1小时,再导入库2-3小时,测试1小时,发现执行效率低。可一天也就这么忙碌地过去了,什么问题都没有解决。还牵涉了三个人,一个导出数据的实施,一个导入数据的测试,一个提供方案的研发。
项目经理不是很明白我说的话,邀请我做方案把关,并给了我前一次升级方案,升级步骤是7步,回退步骤是2步,如此简单的9步,有4步是存在问题的。
升级步骤N: 给一个大数据量的表加字段-并带了 默认值0。
问题:会使得整个表锁住,且效率低下。
正确的做法:先加字段,再设置默认值。
升级步骤N: 对刚加并设置了默认值的表,又做了一次值为0。
问题:重复操作,无意义
操作的理由:老板说表加字段-并带了 默认值0 有时无效,为了保险所以再设置一次值。
升级步骤N: 直接对大表做了更改数据的操作
问题:表大-执行消耗长,会给数据库带来压力。
正确的做法:update 的时候 在已有条件的基础上,再加一个条件限制。比如:一次只修改5万条。
回退步骤: 给flag为0、1的字段加索引
问题:无意义的操作
操作的理由:因为数据量大所以加索引。
而索引是在数据量大且数据值离散的情况下 加才有意义,不是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月份完成的版本-对接口的参数是无嵌套的,已不符合当前的现状。
更改1:参数表设计的更改,增加了节点和节点类型字段。
更改2: 加入接口参数的json 导入功能。解决单个录入参数效率低问题。(明天有时间则继续)
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.