Website notes _ MySQL

Website notes bitsCN.com

I have done a lot of websites .. But like this website .. From conception to code writing to online promotion, the process of writing code independently is still the first.

Because the first time .. Websites have many imperfections .. Just say a few .. There is no pressure on the website to officially promote its predecessors .. I often write code when I feel free .. Tune the program .. However, there were a lot of problems after the launch .. First of all, I did not expect that the website will become so popular after being promoted. Statistics show that the website's ip address soared by 100 within half an hour .. This really caught me off guard .. I sent it at 10 o'clock .. As a result, the daily traffic volume exceeded 300 .. This is a result that none of my websites can achieve .. It is too late to imagine how high the website traffic will be in the future. The first thing that comes to my mind is whether the server can withstand my attacks .. Students without money .. I am using Sina's free "cloud" server (I really don't understand how it works ).. However, the website gave me the answer the next day .. 2 K of small traffic can still withstand Sina .. At least Sina can cope with such websites .. I feel relieved .. But Sina took the lead that night .. The database crashed .. His head is blank .. What should I do .. More than 2 k data .. So it's gone? Calm down .. .. Let's take a look at Sina's Forum .. I'm glad to hear that .. Sina's forum is also suspended .. I am very happy .. This shows that my database has such active connection with the database of Sina bbs .. The data on his forum will surely be repaired .. That's why my data is also visible .. I went to bed with peace of mind .. At the same time, we gradually realized how important database backup is .. How important it is .. The first thing to wake up the next day is to open the website with a mobile phone .. Take a long breath .. The database is normal .. Thanks to Sina and thanks to Sina .. There are still many bugs in the implementation of website functions .. The most typical is the game score .. Before creating a website, you may think that the website may be used by some plug-ins .. For example, the key-pushing Genie .. At that time, I did not think of a good solution .. No .. So I got a very bug score when I got online .. Second .. Score submission also has many problems .. It hurts a lot .. Various geek uses various methods to submit various abnormal scores .. As a result, the homepage has been refreshed by a very abnormal score .. Fortunately, the data type of the score is not set to long int .. Otherwise, the home page will not be full of numbers .. Now the number of users has reached 2 k .. The real problem has just emerged .. Sina Cloud server has a very abnormal restriction .. The number of slow database queries within one minute cannot exceed 10 .. The definition of slow query is that the query time of a statement exceeds one second .. I don't know how low the efficiency is .. Currently, only 2 K of data is always slow to query with me .. So you have to optimize the mysql code .. There is another fear on the website .. Is afraid of injection .. It is strange that some anti-injection functions of Sina cannot be used .. No way .. I had to use some of my methods ..

That's all .. The first time .. More .. I want to learn more ..

BitsCN.com