title: Closing active connections using RMySQL
body: <p>As per <a href="https://stackoverflow.com/questions/17506021/rmysql-is-finished-uploading-data-mysql-takes-days-for-it-to-appear">my question earlier today</a>, I suspect I have an issue with unclosed connections that is blocking data from being injected into my MySQL database. Data is being allowed into tables that are not currently being used (hence I suspect many open connections preventing uploading into that particular table).</p>
  
  <p>I am using RMySQL on Ubuntu servers to upload data onto a MySQL database.</p>
  
  <p>I'm looking for a way to a) determine if connections are open b) close them if they are. The command <code>exec sp_who</code> and <code>exec sp_who2</code> from the SQL command line returns an SQL code error.</p>
  
  <p>Another note: I am able to connect, complete the uploading process, and end the R process successfully, and there is no data on the server (checked via the SQL command line) when I try only that table.</p>
  
  <p>(By the way,: If all else fails, would simply deleting the table and creating a new one with the same name fix it? It would be quite a pain, but doable.)</p>