i wanna check all the queries running on mysql but i found only top queries r been visible its not helping me at any point in my requirement Do u have any feathers that shuts me well as it does in sql profiler
Hi, Jet Profiler polls of the database, so it only sees queries running while polling. Therefore it cannot see ALL queries. There is no way around it. However, if you are able to generate load on your system, there should be no problem determining your performance bottlenecks.
I m running jet profiler in windows xp and i m remotely connecting to the server i found as i went through all ur discussion form i found this idea in one of those and tried it resulted i started downloading the soft 1 by 1 i downloaded all the 5 but couldn't install them nor use any of them. Can u help me or guid me how to install any of them as well as please highlight is there any other effect of using this load on the server.I hope this discussion will help many other user intern. i have used SELECT BENCHMARK(200000000, now()) it helped can u give some more this kind of query to increase much load i want more load
ya i downloaded all of them but failed to execute can u help in me on that it is better if u giv me more such queries like SELECT BENCHMARK(200000000, now()) i would prefer queries rather then any such tools if i need to use them plz guide how to use them in windows xp
I've added two more tools to the list, ApacheBench and loadUI. Please check those links out, there are some tutorial videos for loadUI on their website.
For your cooperation and valuable info i also modified a little in that query SELECT BENCHMARK(50000000,ENCODE('hello','goodbye'))it really helped as well as the tools that u have added are also working well. hope this discussion will help other's too Your tools works great n feels all requirement