Any MSQL experts out there - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Any MSQL experts out there

robbieukranger Avatar
banned5y, 11m agoPosted 5 years, 11 months ago
I have a error on one of my forums thats causing major load spikes

Can anyone help

Thanks in advance
robbieukranger Avatar
banned5y, 11m agoPosted 5 years, 11 months ago
Options

All Comments

(10) Jump to unreadPost a comment
Comments/page:
#1
robbieukranger
I have a error on one of my forums thats causing major load spikes

Can anyone help

Somebody will be able to if you provide more details.

BFN,

fp.
#2
Hi - I work as a sql developer as my job so I might be able to help. PM me if you like with the error.
banned#3
mark2013
Hi - I work as a sql developer as my job so I might be able to help. PM me if you like with the error.

PM'ed Thanks
#4
robbieukranger, I had a look what you sent me but it was a series of separate sql statements with no real reference as to which specific one was causing the error. The statements were also cut off at the end.

So all I can say really at this stage is there were a lot of deletes from smf_log_online so it might be a reference issue - really need the specific error message produced though, at a line number if possible to help any more.

Sorry I can't PM you - I don't have the "right" to yet.
banned#5
OK thanks for your help if I get anymore info I'll let you know
#6
I also use MySQL and MS SQL Server in development. It is worth indexing the tables using the correct fields as indexes are almost essential when performing JOINs on a lot of data. I'm not sure if you are using MySQL or MS SQL Server but both provide Profile Analysers to determine where indexes should be used. Have you created the relevant indexes?

If you are JOINing string fields you will find a performance boost by using substrings.

By all means, post the queries here and I can take a look.

Edited By: ElliottC on Dec 15, 2010 21:52
banned#7
mysql or mssql?! big difference!
#8
vibeone
mysql or mssql?! big difference!

Could be MSQL, I suppose but whether it is MSQL, MySQL, MS SQL I have seen incorrect usage of indexes to cause high CPU loads.
banned#9
ElliottC
vibeone
mysql or mssql?! big difference!


Could be MSQL, I suppose but whether it is MSQL, MySQL, MS SQL I have seen incorrect usage of indexes to cause high CPU loads.


I meant the OP's system, not your reply dude.

I agree.
#10
vibeone
ElliottC
vibeone
mysql or mssql?! big difference!
Could be MSQL, I suppose but whether it is MSQL, MySQL, MS SQL I have seen incorrect usage of indexes to cause high CPU loads.
I meant the OP's system, not your reply dude.I agree.

I know but he might have been genuinely talking about MSQL though, which I hadn't realised either.

Edited By: ElliottC on Dec 15, 2010 22:21: .

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!