Kapalı

mysql query times out after certain periodof inactivity $10

i have this situation.

using latest mysql server,

after some period of inactivity my website sqls times out (only some not all)

Testing results

1. when execute a simple sql like (select count(*) from products) this works fine all the time.

2. when execute below sql

SELECT [url removed, login to view] FROM products INNER JOIN catalog ON products.cid=[url removed, login to view] WHERE products.is_visible='Yes' AND ( products.inventory_control = 'No' OR [url removed, login to view] > 0 OR products.inventory_rule = 'OutOfStock' OR (products.inventory_control = 'AttrRuleInc' AND [url removed, login to view] >= 0) ) AND products.is_home='Yes' GROUP BY [url removed, login to view]

it times out ( Note it will not timeout all the time, this happens after 1 hour or 2 hour of inactivity)

1. The very first execution takes 30+ seconds and it times out and after that the above executing SQL 2 to 3 times the 4th time onwards it executes fast in 3 to 5 seconds

after 1 or 2 hour inactivity this pattern repeats.

I did not do any changes in settings.

i have 2 sites on this server.

1st server has 20,000 rows of in database ( this one works fine ) 2nd site has 150,000 rows in the databse ( this one is having this issue)

So this is something "query time out"

i do not think this is something on SQL settings, if it is then i should see this behavior on both sites

can anyone help me

Beceriler: MySQL, SQL

Daha fazlasını görün: n query, sql mysql, simple query, out, mysql query, databse, mysql database catalog, times website, works join, execute seconds, help mysql, certain, sql query help, mysql join, certain time, timeout, sql group takes, join group, query results website, onwards, testing sql, stock sql, simple sql, database mysql simple website, mysql help

İşveren Hakkında:
( 29 değerlendirme ) bear, India

Proje NO: #721399

17 freelancer bu iş için ortalamada 326$ teklif veriyor

LeaderTeam

Hi. Please check PMB for details.

in 0 gün içinde499$ USD
(11 Değerlendirme)
4.8
islbd

Please check PMB

in 0 gün içinde250$ USD
(6 Değerlendirme)
4.0
leandrodardini

Hello, I am a Linux sysadmin with strong knowledge in Mysql query and server optimization. I think the problem is in the Mysql server itself and the query time out because the server is not optimized enough. I can opt Daha fazlası

in 5 gün içinde250$ USD
(6 Değerlendirme)
3.9
wincent

I am MySQL expert and ready to work with you.

in 2 gün içinde250$ USD
(4 Değerlendirme)
3.7
apostle13th

Please, check your pmb

in 0 gün içinde250$ USD
(2 Değerlendirme)
3.8
richammond

lets start!! Check reviews!!

in 0 gün içinde250$ USD
(6 Değerlendirme)
3.7
kommandant

Experience !!!

1 gün içinde 250$ USD
(10 Değerlendirme)
3.9
ykm

Please see my pm!

in 2 gün içinde250$ USD
(5 Değerlendirme)
3.3
impank

I read your project requirement very carefully and find that i am able to satisfy you according to your project.Our actual bid is $100.

1 gün içinde 250$ USD
(3 Değerlendirme)
3.7
MegaBigBoss

Hi ! I'm a MySQL administrator. I know this problem well and his solution. Thanks

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

We can develop as per your requirement. u could check that out. we can work till your satisfaction. -- Please check My PMB

in 21 gün içinde556$ USD
(0 Değerlendirme)
0.0
dtquan712

Please check PMB, Thank you, Kind regard.

in 20 gün içinde500$ USD
(0 Değerlendirme)
0.0
darren14

Let me work on these, thanks

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

I can fix this. Please contact me.

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

Respected Client This is Himanshi from Tri-Force Consulting Services. We are an US based company having off-shore department center in India.We are an US based company having 60+ developers an designers well experie Daha fazlası

in 15 gün içinde730$ USD
(0 Değerlendirme)
0.0
WestSider

Sir, I am a query expert and can solve that particular query within some hours. Pls check PMB.

in 0 gün içinde250$ USD
(0 Değerlendirme)
0.0
MatthewSteeples

I'm very interested in taking on this project. Please see your PMB for details.

in 2 gün içinde250$ USD
(0 Değerlendirme)
0.0