Part1: who did that? As DBAs often encounter, some tables are mistakenly manipulated, truncate, deleted, and even drop. Most of the reasons for this are caused by human + permission issues. Some public accounts, such as the Ceshi account, can be operated by all people, and by mistake caused by these public accounts, you shout in the office: who deleted my watch? 80% no one will respond to you.Audit log functionality, which is implemented primarily in the mariadb10.0/10.1 and Percona 5.6 version
". You actually use these names to express other meanings, which can be confusing. So don't do this.
If you have to use i,j,it such a vague name, then you have a good reason to convince yourself.
498) this.width=498; ' OnMouseWheel = ' javascript:return big (This) ' alt= ' \ ' src= ' http://www.bkjia.com/uploadfile/2013/ 0904/20130904095424739.png "/>
Summarize
In the process of coding, it takes a few seconds to come up with a good name, and you will find
Introduction
I have been working on projects for a long time, so I am relatively busy. Today I finally have time to look back at my own code and see where there is a problem and where there is a "bad taste ".
Slowly, slowly recall the code. Start to capture bad taste.
What you often do and what you always want
498) this. width = 498; 'onmousewheel = 'javascript: return big (this) 'alt = "\" src = "http://ww
I have been working on projects for a long time, so I am relatively busy. today I finally have time to look back at my own code to see where there is a problem and where there is a bad taste.
What you often do and what you always want
Obscure if condition
1) Processing |
The above code takes more time to understand than the following code
Although reducing the number of lines of code is a good goal, it is a better goal to minimize the time requi
I have been working on projects for a long time, so I am relatively busy. today I finally have time to look back at my own code to see where there is a problem, where there is a bad taste, what I often do and what I often think.
Obscure if condition
1) Processing |
The above code takes more time to understand than the following code
Although reducing the number of lines of code is a good goal, it is a better goal to minimize the time required t
Tags: des style blog color io re1 --ways to find bad sql:2 3 Select * from(SelectBuffer_gets, Sql_text4 5 fromV$sqlarea6 7 whereBuffer_gets>500000 8 9 Order byBuffer_getsdesc)whereRowNum -; Ten One --SQL that executes more times A - SelectSql_text,executions from - the(SelectSql_text,executions fromV$sqlareaOrder byExecutionsdesc) - - whereRowNumBayi; - + --read hard disk for more
Ways to find Bad SQL
Find the running system bad SQL is an old topic, we should according to their own actual situation to analyze.
The methods described below must not be used in dogma.
When these SQL statements are used, the system tables are grouped and, of course, the load on the system is increased.
It is recommen
/1881053-- summary --Audit will affect the performance of the database more or less, can not open as far as possible. In addition to open the audit database users to real-name or one-on, so as not to do bad people deadbeat ~ due to the author's level is limited, writing time is also very hasty, the text will inevitably appear some errors or inaccurate places, inappropriate place to ask readers to criticize correct.This article is from the "He Lei Tec
sensitivity of less than 10%, which can be adjusted as needed. mysql>selectp.table_schema,p.table_name,c.index_name,c.car,p.car totalfrom-> (Selecttable_schema,table_name, index_name,max (cardinality) car-> Frominformation_schema. statistics->whereindex_name!= ' PRIMARY ' ->groupbytable_schema,table_name,index_name) c,- > (Selecttable_schema,table_name,max (cardinality) car ->frominformation_schema. statistics->whereindex_name= ' PRIMARY ' andtable_ schema!= ' MySQL ' ->groupbytable_schema,ta
What you often do and what you always want
Obscure if condition
1) Processing |
The above Code takes more time to understand than the following code
Although reducing the number of lines of code is a good goal, it is a better goal to minimize the time required to understand the code.
Return Value
The above "$ ret" is the toast of "I can't think of a name. Instead of using such an empty name, it is better to pick a name that can describe the object value or purpose.
$ Alias declares th
Something that is often done and often thought of.
Obscure if condition
1) for | | The processing
The code above will take more time than the following code.
Although reducing the number of lines of code is a good goal, minimizing the time required to understand the code is a better goal.
return value
The "$ret" above is an alibi for "I can't think of a name." Instead of using such empty names, pick a name that describes the value or purpose of the entity.
$alias declares tha
Who can find the hidden error of this bad applet-Linux general technology-Linux programming and kernel information. The following is a detailed description. # Include
# Include
# Include
# Inlcude
# Include
Main (int argc, char * argv [])
{
Int val, m;
Char buf [18] = "hellow my world ";
Char auf [18];
If (ar
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.