php - Why does this SQL query kill my server? -

php - Why does this SQL query kill my server? -

When I run this query from a varnish cache server on SQL Server

  select count (A separate email), in AICL files where user ID = (upload_user from okol_file where limit of upload_user = userid1)     Table with aiki_users  & gt; 80000 rows  
 and  ocal_files  tables and gt; 30000 lines  
 It kills the server. It is called through a php script through AJAX. I have to close the page that says it.  
 I do not know what this gives, but I know that what I want to do should be made with the group when it happens, but I do not have technical information.  
 The same_yujs table looks like this:  
  If none exists, then 'AII_User' (`UIIID ') (9) unsigned Not Auto_interpret,' Username ' Varchar (100) faucet default '', `full_name` varchar (255) no tap,` country 'varchar (255) no tap, `gender' varchar (25) no, zero,` job 'varchar (255) no password `Vergar (100) No tap default '',` oauth_passcode` varchar (255) No, zero, `oauth_token` varchar (255) tap,` oauth_token_secret` varchar (255) tap, usergroup int (10) 0 ',' Email 'code (100) tap Default '', 'first_ip' varchar (40) tap default '0', 'first_login' datatyme faucet, 'last_login', datetime faucet, 'fault', 'avatar' varchar (255), 'homepage' varchar (100) 'Randaki' varchar (255) is not faucet, `` active '', 'last_p` is not acceptable,' user is not 'text,' merilist 'ent (1), log in_number`t (11) Act '(5) null, primary (`user id'), key 'username' ('userman')) engine = mesam default charge = utf8 aUTO_INCREMENT = 3;    I do not have the right access to the server, I can not see the removal of the Oklal_files, but:  
  ocal_files.aiki_users = aiki_users.userid    Can anyone tell me how bad the query is and what is it?   
 
  You are selecting from both aiki_user and ocal_files in the main query, without specifying an included section , Where to stop joining the full table in the nested query ...   

 


  






03:22

















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment







Popular Posts




google chrome extension - Reason for Uncaught Error: Attempting to use
a disconnected port object -



    While retrieving the request from the content script, I get this error in the background page. Does anyone know that this error What can be the reason?   Full stack trace:    Unwanted error: Attempt to use Chrome / Renderer Extension Binding Disconnected Port Objects: 147 Chrome.port Post Message Chrome / Renderer Extension Binings: 147 ChromeHird.port DicePatchOnConnect.Connect Event Chrome / Renderer Extension Binings: 89IExtension.fu SendResponse.state background.js: 1573db.readTransaction.tx.executeSql.paramStr background.js: 1038    This only happens when Reloading extension is not being helpful for a few hours - it is not that after restarting the Chrome browser it will be a solution that becomes normal for a few hours, content script may continue to send requests for background No response can be sent from the background. Is there any way that I can catch this unwanted error and reset the listener?   I am using chrome.extension.onRequest.addListener for my communication. Bef...






visual studio 2010 - How to reinstall MVC 2 tools for VS2010? -



    I uninstalled ASP.Net MVC 2 device for Visual Studio 2010. How can I restore it? MVC2 downloads seem to include only the VS2008 device.   Whatever I said, says that MVC 2 has been included in VS2010, but the installation of an improvement did not fix it, and MVC 2 is not listed. Add VS2010 / Select a component in the Remove screen.      You will get your VS2010ToolsMVC2.msi VS2010 DVD under WCU \ ASPNETMVC - hopefully it will do!    






Git Bash script to check whether repo has any commits? -



    I have a script on which I need to work differently if there is one, which is one or more , Commits. What is the best way to do this?   Something like this will appear in the proxy code.    #! / Bin / bash if [[`git log_count`] ==" 0 "]]; Then there is no commodity for this repo. # What goods ... and echo are "one or more committed!" # What are the other things?    Any ideas?      you can    git rev-parse -verify HEAD    (after :)     This is a pipeline command, and its behavior vs. "  git diff " There is very little possibility to change   I find it more pronounced  rev-parse -verify  means "is this a valid object name?"    This is your  show-ref .  You ask "Is there anything in this safe / head in the safe?"  I ask, "what current  head  exists?"   In practice, both of these are fair tests, because once you have a branch, so to achieve the  HEAD , some mock values will indicate manually lack of editing It is very diffic...








Powered by Blogger