kill LOAD DATA INFILE
Hi all, I've a question, i need to killing a load data in file. Normally used show processlist and kill PID. But don't work. any idea? Thanks :D { name : Rafael Valenzuela, open source: [Saiku Admin Console,Anaytical Sport], location : Madrid Spain, twitter : [@sowe https://twitter.com/sowe] , linkedin : profilehttp://es.linkedin.com/pub/rafael-valenzuela/19/694/61a/ }
Mysql proxy
Hi all, I have a question, i'm trying to create a high envairoment , i'm searching in google and see the MySQL proxy proyect but i don't know if is a good idea use this proyect ?. I'm try to ask in the irc chanel but i can't, i need a espcial user or privilege? Thanks { name : Rafael Valenzuela, open source: [Saiku Admin Console,Anaytical Sport], location : Madrid Spain, twitter : [@sowe https://twitter.com/sowe] , linkedin : profilehttp://es.linkedin.com/pub/rafael-valenzuela/19/694/61a/ }
Materialized Views
Hi All, I have a question about the materialized views , i remember in the DBA course my trainer said me. In Mysql doesn't exist this type views like Oracle. But My boss think the opposite. In the new version has this type of view? and the diferences the differences between views Mysql and Oracle? Thanks --
Re: Materialized Views
Ok Thanks El 23/06/2013 21:13, Reindl Harald h.rei...@thelounge.net escribió: Am 23.06.2013 20:59, schrieb Bruce Ferrell: On 06/23/2013 11:18 AM, Rafael Valenzuela wrote: Hi All, I have a question about the materialized views , i remember in the DBA course my trainer said me. In Mysql doesn't exist this type views like Oracle. But My boss think the opposite. In the new version has this type of view? and the diferences the differences between views Mysql and Oracle? Thanks I think you're operating off of old information: http://dev.mysql.com/doc/refman/5.0/en/create-view.html and *where* do you see there *any* word about *MATERIALIZED* views except a comment with the words Since MySQL currently doesn't support materialized views, here is simple way to simulate materialized views that consists on creating a static table and a robust updating script?
real Time
Hi all, i've a question about the mysql configuration, in my project, we need use data in real time (read and insert) . But i don't idea about this matter. Any advice or information? i'm so sorry the hassle. -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/
Aborted connection 102
Hi everybody, I have this notice , 111214 11:55:53 [Warning] Aborted connection 102 to db: 'proninop_proninop' user: 'pronino' host: 'xxx.xxx.xxx.xxx' (Got timeout reading communication packets) I have watched in this site http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html but I have not seen the number 102. Any idea? thanks a lot -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/
Re: Aborted connection 102
Hi Michael, Thanks :D. 2011/12/14 Michael Dykman mdyk...@gmail.com 102 is just the run-time assigned connection id. It appears that the server bailed on a client connection due to a timeout. This suggests that either you have/had network issues, an error on the client side or someone just killed a client connection without closing properly. Unless you are seeing a lot of these, don't waste your time.. it looks like operational white-noise. - michael dykman On Wed, Dec 14, 2011 at 9:39 AM, Rafael Valenzuela rav...@gmail.com wrote: Hi everybody, I have this notice , 111214 11:55:53 [Warning] Aborted connection 102 to db: 'proninop_proninop' user: 'pronino' host: 'xxx.xxx.xxx.xxx' (Got timeout reading communication packets) I have watched in this site http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html but I have not seen the number 102. Any idea? thanks a lot -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Web http://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/ -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/
Re: Loading of large amounts of data
Hi , I normally use the PDI(pentaho data integration), this software is like talent or one batch process in C . On 07/12/11 14:16, Shawn Green (MySQL) wrote: Hello Machiel, On 12/6/2011 01:40, Machiel Richards - Gmail wrote: Good day all I have someone who has asked me the following, however due to not having that many years of experience in these type of volumes, I am posting this as I know that someone will probably be able to answer it better than me. (This will also give me a learning opportunity to see what to do) _*Client Question: *_ Well let me describe the issue. 1.I require to load records into a MySQL database table - no problem so far ;-) 2.The table represents stock that will be being searched and transacted (i.e. sold, which involves changing flags on the record) by a live system. 3.The stock table will be big --millions or tens of millions of rows 4.Stock is uniquely identified by two fields -- a supplier ID (numeric) and a serial number (varchar) 5.Transaction volumes may also be very high 6.Stock must be available to the system 24/7 7.I will need to replenish the stock table from a file, one or more times a day -- potentially loading tens or hundreds of thousands of rows each time 8.The DB will be a master-slave: reporting and recon files off the slave, transactions off the master (and presumably replenishment into master) I can go into a lot more detail about the process I am using (using an ETL tool called Talend) ... but the essential question is around strategies for doing this kind of dynamic loading: 1.How to insert data (high volumes) into the live table without locking it and affecting transaction performance (Insert low_priority?) 2.How to speed up inserts, even when there are two unique key constraints. My observation is obvious -- that inserts get slower and slower as the table grows (date based partitions of some kind maybe?). 3.General principles/ strategies in dealing with situations like this. Can someone please assist. I can't give you precise details but I can point you in the right directions. Your requirements are well-formed but they tend to contradict each other. While there are no ways to completely remove the contradictions, there are ways to minimize their impacts. #5 High transaction volumes #6 Available 24x7 #1,#7 Bulk updates of 1+ records daily These three are in conflict. Database changes require indexes to be rebuilt. Index rebuilds can be fast (for small changes or small indexes) or take a noticeable length of time (larger changes or larger indexes or both). This means you may need to have two systems you flip-flop into place to minimize your downtime. The same problem was solved by graphics card manufacturers by creating multiple frame buffers. You can make your 'unavailability' time as short as possible by updating a passive copy of the data while it is not being pointed to by your application front-end then swapping the 'updated' set of data for the 'old' set of data by either altering the virtual IPs of your sets of instances or by redirecting which set your applications are pulling data from. #8 System will be master-slave My flip-flop idea implies that your system will have two sets of master-slave(s) one carrying the 'current' data and one used to build the 'new' set of data (with the imports). This also implies that your 'active' set will need to be replicating to your 'passive' set to keep it in sync between bulk updates. #2a Many records need to change in a day #3 There will be millions of records #2b Searches need to be fast These conflict with each other too. The more records you add to a table, the longer any indexed lookup will take. If you can't use the data in memory in the index then a trip to the disk will be necessary to retrieve the columns for your query. Combine this with the number of queries at any one time and divide that by the maximum number of random-access reads a physical disk can achieve and you may easily exceed the capacity of any one disk storage system to supply. This implies that you need to look at how to divide your storage among several independent devices at the same time. Options abound: sharding, partitioning, simple configuration changes (some tablespaces on one device, some on others). Or, you can look at pricing solid-state disks for your storage neeeds. Factoring in need #4, this suggests that a partitioning scheme based on (supplier, serial#) may be a good first design choice. So... After discussing the pain points of each of your requirements I have the following mental image of a system: a) two sets of master-slaves. The master of the passive set will be a 'slave' to the master of the active set. b) data on each set is using InnoDB c) data partitioned on the stock table based on (serial#, supplier) - I chose that order because I think it will give a better random spread among the partition tables and because I think it will be
Re: the best way compare String
Hi Reindl, Thanks for your quick answer, but i think the engine is MySAM but I'm not sure, What type of index recomendais me, unique, full-text, etc..? Thanks a lot 2011/12/4 Reindl Harald h.rei...@thelounge.net Am 04.12.2011 20:25, schrieb Rafael Valenzuela: Hi all, In one query, I am comparing a string with a 'like=%patron%', but is very slow and expensive .What is the best way to compare a string? like or regular expression? The data base is too big table 1TB, any idea? thanks a lot http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html without indexes is big tables is no fast search possible if you are useing innodb you have currently lost -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/
Datawarehouse
Hello all, I'm doing a data warehouse and i've a questions. What is the best engine? or any other suggestion. I think the size will be aprox 1TB. Thanks a lot -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/
Re: SPAM: please remove gregario.es from the list
hi The message sid this : Dear, inform you that your email _ * has not been delivered to the recipient * _ because there is no mailbox in the domain A greeting. I have many problems sending mail , any problem or any ideas? 2011/4/2 Reindl Harald h.rei...@thelounge.net Can anybody remove this (i think spanish) autoreply-spammer from the list nbecause the only thing i understand is some price in € and that our spm-firewall is tagging it Original-Nachricht Betreff:[SPAM] Re: Re: Can't connect to MySQL server on '127.0.0.1' (111) Datum: 2 Apr 2011 17:17:20 +0200 Von:no-re...@gregario.es An: h.rei...@thelounge.net Estimad@, le informamos que su mensaje de correo electrónico _*no ha sido entregado al destinatario*_ ya que no existe el buzón de correo en el dominio Un saludo. Consigue gratis tu bono de 30 € para utilizar con Google Adwords http://www.googld.es/ Te regalamos una camiseta personalizada con tu foto http://clk.tradedoubler.com/click?p(22814)a(1548325)g(1076669)url(http://www.vistaprint.es/male-female-tshirts.aspx) -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/
performance debian lenny and vmware
Hi Carlos and all: Our architecture is a vm-ware virtual machine with debian lenny as S.O (64 bits), with 4 Gb of RAM . The virtual machine is a dedicated server with MySQL 5.0. (INDB) Attached the my.cnf file. I've searched information about this problem and to many persons the same have problem. My mysql server is too slow. And I'm follow this white paper http://www.vmware.com/files/pdf/Virtualization-for-MySQL-on-VMware.pdf. Thanks a lot 2011/3/28 Carlos Proal carlos.pr...@gmail.com Rafael Performance depends on several things, but none related with debian or vmware per se. So we need more information about you configuration (ram, buffers, etc) and you environment (concurrent users, transactions, etc). Maybe you have not tuned your mysql and it is slow because of that. Carlos Proal On 3/27/2011 1:14 PM, Rafael Valenzuela wrote: Hi all: I have installed mysql 5.0 on a debian lenny 64 bits, in vmware,but I see that there are problems with mysql performance the server is too very slow. any solution? or any idea? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=rav...@gmail.com -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/ -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
performance debian lenny and vmware
Hi all: I have installed mysql 5.0 on a debian lenny 64 bits, in vmware,but I see that there are problems with mysql performance the server is too very slow. any solution? or any idea? -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/
performance debian lenny and vmware
Hi all: I have installed mysql 5.0 on a debian lenny 64 bits, in vmware,but I see that there are problems with mysql performance the server is too very slow. any solution? or any idea? -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/
Question about performance
Hi all; I wonder if there is any tool to Performance Tuning querys. In other know if there is any way to kill connections that take x hours dead (for example 1 hour) -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/
Re: Question about performance
Hi Michael: Yeah , i think that i do a shell script.something like that. require 'mysql' mysql = Mysql.new(ip, user, pass) processlist = mysql.query(show full processlist) killed = 0 processlist.each { | process | mysql.query(KILL #{process[0].to_i}) } puts #{Time.new} -- killed: #{killed} connections 2011/2/17 Michael Dykman mdyk...@gmail.com from the mysql console: show processlist this will show you ids of all active connections, even the dead ones then, again form the console kill processid On Thu, Feb 17, 2011 at 3:52 PM, Rafael Valenzuela rav...@gmail.com wrote: Hi all; I wonder if there is any tool to Performance Tuning querys. In other know if there is any way to kill connections that take x hours dead (for example 1 hour) -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Web http://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/ -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/
Error
Hi everybody: I've this problem but i don't konw why? i use MySQL Server 5.5 and my application it's Pentaho 2011-01-13 11:00:44,156 WARN [org.pentaho.reporting.libraries.base.boot.PackageState] Unable to initialize the module ext-datasources-sampledata 2011-01-13 11:03:53,406 ERROR [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceSystemListener: PooledDatasourceSystemListener.ERROR_0003 - Unable to pool datasource object: hibernate caused by com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.ConnectException MESSAGE: Connection timed out: connect STACKTRACE: java.net.ConnectException: Connection timed out: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:529) at java.net.Socket.connect(Socket.java:478) at java.net.Socket.init(Socket.java:375) at java.net.Socket.init(Socket.java:218) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256) at com.mysql.jdbc.MysqlIO.init(MysqlIO.java:271) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771) at com.mysql.jdbc.Connection.init(Connection.java:1555) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:996) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:133) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceSystemListener.startup(PooledDatasourceSystemListener.java:57) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:340) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:322) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:289) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:206) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4544) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5016) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:140) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:812) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:787) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:570) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1010) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:933) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:468) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1267) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:308) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:89) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:328) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:308) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1043) at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:738) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:140) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1035) at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:289) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:140) at org.apache.catalina.core.StandardService.startInternal(StandardService.java:442) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:140) at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:674) at
Re: Error
I'm sorry Michael and list mysql , I had realised that my mistake not happen again 2011/1/13 Michael Dykman mdyk...@gmail.com This doesn't look like a mysql problem per-se. It looks like the problem lies with connection pooling somewhere in your Java stack; it looks like Pentaho's connection pooling is misconfigured alloing stale connections to remain in the pool. I suggest that you take this query to a Pentaho support group. - michael dykman On Thu, Jan 13, 2011 at 5:16 AM, Rafael Valenzuela rav...@gmail.com wrote: Hi everybody: I've this problem but i don't konw why? i use MySQL Server 5.5 and my application it's Pentaho 2011-01-13 11:00:44,156 WARN [org.pentaho.reporting.libraries.base.boot.PackageState] Unable to initialize the module ext-datasources-sampledata 2011-01-13 11:03:53,406 ERROR [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceSystemListener: PooledDatasourceSystemListener.ERROR_0003 - Unable to pool datasource object: hibernate caused by com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.ConnectException MESSAGE: Connection timed out: connect STACKTRACE: java.net.ConnectException: Connection timed out: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:529) at java.net.Socket.connect(Socket.java:478) at java.net.Socket.init(Socket.java:375) at java.net.Socket.init(Socket.java:218) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256) at com.mysql.jdbc.MysqlIO.init(MysqlIO.java:271) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771) at com.mysql.jdbc.Connection.init(Connection.java:1555) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:996) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:133) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceSystemListener.startup(PooledDatasourceSystemListener.java:57) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:340) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:322) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:289) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:206) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4544) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5016) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:140) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:812) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:787) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:570) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1010) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:933) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:468) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1267) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:308) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:89) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:328) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:308) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1043
Close connetion
Hi everyone: I've a problem , this is error http://pastebin.com/eCEqLQ9b , i've looking in for google and documentation of mysql and nothing. there any way to close connections with any command of mysql, i've modification the timeout and connexion number -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/
Re: Close connetion
THX Shawn Green i going to try this soluctions 2011/1/4 Shawn Green (MySQL) shawn.l.gr...@oracle.com On 1/4/2011 14:47, Rafael Valenzuela wrote: Hi everyone: I've a problem , this is error http://pastebin.com/eCEqLQ9b , i've looking in for google and documentation of mysql and nothing. there any way to close connections with any command of mysql, i've modification the timeout and connexion number Any user with the SUPER privilege should be able to use the KILL command to tell a MySQL client connection to self-terminate. Note, MySQL does not have a way to force-close a connection; the must see that it was flagged to stop and clean up after itself. Stopping a long-running command may require a rollback. Rollbacks may be up to 30x slower to unwind than the command itself required to make the pending changes. Be aware of this as you evaluate your options. http://dev.mysql.com/doc/refman/5.1/en/kill.html http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. Office: Blountville, TN -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/