Devam Ediyor

488997 Mysql optimization: Table crashes daily

Situation:

We rent a dedicated server at Softlayer. A few domains are on there, but one popular where the cause of the error is. Since last week, at random times, the server crashes. Investigation by Softlayer Support told me that it was caused by high Mysql connection load... I found that everytime the server went back up again, a popular table crashed, making it impossible for the site to function, leaving members behind with nothing...

The situation is that after the server crashed, I rebooted, and then in Mysql the table "ad_clicks" crashed and I had to repair via phpmyadmin to make it work again (otherwise users were getting an error of duplicate row xxx when trying to credit for ads). I'm not 100% sure if this is the CAUSE of the server crash or the RESULT of the crash... but still, it shouldn't happen

The situation started a week ago, and there is no significant increase of traffic or users or anything else...

Below you can find information provided by Softlayer support:

Employee Response - 2011-Apr-03 07:45 (GMT-0600) [Update 37]

Based on my observations in the server as well as reviewing the history of this ticket, I'm going to say fairly definitively that, in order to prevent these scenarios from happening or improve the current issue, you would need to either have MySQL optimized (which may or may not solve the issue, particularly if there are design problems in the database structure/content, so you may want to do this as well) or upgrade your system. That said, the load spikes look to be temporary and appear to die off after some time. Take a look at the following load averages that were shown in the recent log entries:

------------------------------------------

Apr 3 06:31:01 buxp00 loadavg: 06:31:01 up 1 day, 22:25, 0 users, load average: 1.71, 1.82, 1.94

Apr 3 06:32:01 buxp00 loadavg: 06:32:01 up 1 day, 22:26, 0 users, load average: 1.82, 1.82, 1.93

Apr 3 06:33:01 buxp00 loadavg: 06:33:01 up 1 day, 22:27, 0 users, load average: 1.43, 1.71, 1.89

Apr 3 06:34:02 buxp00 loadavg: 06:34:02 up 1 day, 22:28, 0 users, load average: 2.21, 1.91, 1.94

Apr 3 06:35:01 buxp00 loadavg: 06:35:01 up 1 day, 22:29, 0 users, load average: 1.51, 1.74, 1.88

Apr 3 06:36:01 buxp00 loadavg: 06:36:01 up 1 day, 22:30, 0 users, load average: 1.43, 1.69, 1.85

Apr 3 06:37:01 buxp00 loadavg: 06:37:01 up 1 day, 22:31, 0 users, load average: 2.76, 1.98, 1.94

Apr 3 06:38:01 buxp00 loadavg: 06:38:01 up 1 day, 22:32, 0 users, load average: 3.26, 2.25, 2.03

Apr 3 06:39:01 buxp00 loadavg: 06:39:01 up 1 day, 22:33, 0 users, load average: 2.16, 2.12, 2.00

Apr 3 06:40:01 buxp00 loadavg: 06:40:01 up 1 day, 22:34, 0 users, load average: 2.02, 2.08, 1.99

Apr 3 06:41:01 buxp00 loadavg: 06:41:01 up 1 day, 22:35, 0 users, load average: 3.12, 2.40, 2.11

Apr 3 06:42:01 buxp00 loadavg: 06:42:01 up 1 day, 22:36, 0 users, load average: 2.55, 2.42, 2.13

Apr 3 06:43:01 buxp00 loadavg: 06:43:01 up 1 day, 22:37, 0 users, load average: 1.92, 2.27, 2.10

Apr 3 06:44:01 buxp00 loadavg: 06:44:01 up 1 day, 22:38, 0 users, load average: 1.97, 2.21, 2.09

Apr 3 06:45:01 buxp00 loadavg: 06:45:01 up 1 day, 22:39, 0 users, load average: 1.63, 2.05, 2.04

Apr 3 06:46:01 buxp00 loadavg: 06:46:01 up 1 day, 22:40, 0 users, load average: 1.83, 2.03, 2.03

Apr 3 06:47:02 buxp00 loadavg: 06:47:02 up 1 day, 22:41, 0 users, load average: 2.00, 2.02, 2.02

Apr 3 06:48:01 buxp00 loadavg: 06:48:01 up 1 day, 22:42, 0 users, load average: 1.72, 1.96, 2.00

Apr 3 06:49:01 buxp00 loadavg: 06:49:01 up 1 day, 22:43, 0 users, load average: 2.47, 2.12, 2.05

Apr 3 06:50:01 buxp00 loadavg: 06:50:01 up 1 day, 22:44, 0 users, load average: 3.24, 2.41, 2.15

Apr 3 06:51:01 buxp00 loadavg: 06:51:01 up 1 day, 22:45, 0 users, load average: 2.49, 2.35, 2.14

Apr 3 06:52:01 buxp00 loadavg: 06:52:01 up 1 day, 22:46, 0 users, load average: 2.83, 2.48, 2.20

Apr 3 06:53:01 buxp00 loadavg: 06:53:01 up 1 day, 22:47, 0 users, load average: 3.32, 2.70, 2.29

Apr 3 06:54:01 buxp00 loadavg: 06:54:01 up 1 day, 22:48, 0 users, load average: 2.47, 2.57, 2.27

Apr 3 06:55:01 buxp00 loadavg: 06:55:01 up 1 day, 22:49, 0 users, load average: 2.29, 2.49, 2.26

Apr 3 06:56:01 buxp00 loadavg: 06:56:01 up 1 day, 22:50, 0 users, load average: 3.67, 2.83, 2.39

Apr 3 06:57:01 buxp00 loadavg: 06:57:01 up 1 day, 22:51, 0 users, load average: 3.19, 2.87, 2.43

Apr 3 06:58:01 buxp00 loadavg: 06:58:01 up 1 day, 22:52, 0 users, load average: 2.91, 2.87, 2.46

Apr 3 06:59:01 buxp00 loadavg: 06:59:01 up 1 day, 22:53, 0 users, load average: 2.90, 2.94, 2.51

Apr 3 07:00:04 buxp00 loadavg: 07:00:04 up 1 day, 22:54, 0 users, load average: 4.02, 3.18, 2.62

Apr 3 07:01:02 buxp00 loadavg: 07:01:02 up 1 day, 22:55, 0 users, load average: 4.73, 3.53, 2.77

Apr 3 07:02:01 buxp00 loadavg: 07:02:01 up 1 day, 22:56, 0 users, load average:

Please rate this response

Worst Best

1 2 3 4 5

Employee Response - 2011-Apr-03 07:45 (GMT-0600) [Update 38]

4.91, 3.84, 2.93

Apr 3 07:03:01 buxp00 loadavg: 07:03:01 up 1 day, 22:57, 0 users, load average: 5.45, 4.20, 3.11

Apr 3 07:04:01 buxp00 loadavg: 07:04:01 up 1 day, 22:58, 0 users, load average: 8.37, 5.25, 3.53

Apr 3 07:05:01 buxp00 loadavg: 07:05:01 up 1 day, 22:59, 0 users, load average: 5.58, 5.08, 3.58

Apr 3 07:06:01 buxp00 loadavg: 07:06:01 up 1 day, 23:00, 0 users, load average: 5.08, 5.03, 3.66

Apr 3 07:07:01 buxp00 loadavg: 07:07:01 up 1 day, 23:01, 0 users, load average: 3.83, 4.67, 3.62

Apr 3 07:08:01 buxp00 loadavg: 07:08:01 up 1 day, 23:02, 0 users, load average: 2.86, 4.26, 3.54

Apr 3 07:09:01 buxp00 loadavg: 07:09:01 up 1 day, 23:03, 0 users, load average: 3.28, 4.15, 3.55

Apr 3 07:10:04 buxp00 loadavg: 07:10:03 up 1 day, 23:04, 0 users, load average: 4.20, 4.20, 3.60

Apr 3 07:11:02 buxp00 loadavg: 07:11:02 up 1 day, 23:05, 0 users, load average: 53.27, 18.23, 8.45

Apr 3 07:12:20 buxp00 loadavg: 07:12:20 up 1 day, 23:07, 0 users, load average: 48.28, 23.68, 11.10

Apr 3 07:13:03 buxp00 loadavg: 07:13:02 up 1 day, 23:07, 0 users, load average: 46.17, 26.72, 12.73

Apr 3 07:14:01 buxp00 loadavg: 07:14:01 up 1 day, 23:08, 0 users, load average: 22.09, 23.51, 12.46

Apr 3 07:22:01 buxp00 loadavg: 07:22:01 up 5 min, 0 users, load average: 50.51, 33.52, 13.73

Apr 3 07:23:01 buxp00 loadavg: 07:23:01 up 6 min, 0 users, load average: 19.30, 27.66, 12.95

Apr 3 07:24:01 buxp00 loadavg: 07:24:01 up 7 min, 0 users, load average: 8.56, 23.02, 12.27

Apr 3 07:25:02 buxp00 loadavg: 07:25:02 up 8 min, 0 users, load average: 5.69, 19.43, 11.70

Apr 3 07:26:01 buxp00 loadavg: 07:26:01 up 9 min, 0 users, load average: 7.07, 17.79, 11.65

Apr 3 07:27:01 buxp00 loadavg: 07:27:01 up 10 min, 1 user, load average: 3.72, 14.87, 11.02

Apr 3 07:28:01 buxp00 loadavg: 07:28:01 up 11 min, 1 user, load average: 2.58, 12.50, 10.45

Apr 3 07:29:01 buxp00 loadavg: 07:29:01 up 12 min, 1 user, load average: 2.88, 10.84, 10.01

Apr 3 07:30:01 buxp00 loadavg: 07:30:01 up 13 min, 1 user, load average: 1.82, 9.10, 9.46

Apr 3 07:31:01 buxp00 loadavg: 07:31:01 up 14 min, 1 user, load average: 3.78, 8.34, 9.17

Apr 3 07:32:01 buxp00 loadavg: 07:32:01 up 15 min, 1 user, load average: 2.58, 7.22, 8.74

Apr 3 07:33:01 buxp00 loadavg: 07:33:01 up 16 min, 1 user, load average: 2.50, 6.38, 8.36

Apr 3 07:34:01 buxp00 loadavg: 07:34:01 up 17 min, 1 user, load average: 1.80, 5.46, 7.91

Apr 3 07:35:01 buxp00 loadavg: 07:35:01 up 18 min, 1 user, load average: 1.59, 4.73, 7.50

Apr 3 07:36:01 buxp00 loadavg: 07:36:01 up 19 min, 1 user, load average: 1.39, 4.09, 7.11

Apr 3 07:37:02 buxp00 loadavg: 07:37:02 up 20 min, 1 user, load average: 1.49, 3.68, 6.78

You can see that it reaches its peak load at 07:13:03 and then just dies off again. So you're probably already experiencing improved performance. This spike is almost certainly caused by a particular function or application in one of your websites that is either being accessed simultaneously by many people at once, or is developed in such a way that it is not utilizing resources correctly. I would not be able to pinpoint where or what this is, but it would need to be addressed by your web developers if you would like to find what causes these inflammations of sorts.

If you'd like to take the system upgrade route, just let me know and I can escalate this ticket over to Sales where they can assist you further. Also, if you have any questions about anything or need any further assistance, I'd be glad to help.

Thank you for choosing SoftLayer!

Ryan R

Customer Support Technician

[url removed, login to view]

Solution: I have paid people to do Mysql optimization before, and all basic optimization is done, but I want someone to fix this problem of the server crashing daily... I will provide all information given by Softlayer support...

Beceriler: Her şey Kabul, MySQL

Daha fazlasını görün: where to find the best web developers, where to find sales people, where to find best web developers, where do i find developers, where do find developers, where can i rent a, what do database developers do, we trying to function, this day in history database, temporary sales people, table customer, repair people, rent people, rent a mysql database, peak design, peak 10, paid to solve problems, need web developers for my site design, mysql developers, mysql customer database, m&t resources, min its com, log in design 99, it support technician, increase your web traffic

İşveren Hakkında:
( 8 değerlendirme ) Brussels, Belgium

Proje NO: #2234908

Seçilen:

ilanr

As explained

1 gün içinde 125$ USD
(0 Değerlendirme)
0.0