Re: Fixed Connection Diagnostic Tool
Mike, much thanks and I have it fixed! The problem was that I screwed up setting the database permissions. I am really happy that I learned about mysql -h It will be a great help! Michel - Original Message - From: Michael Dykman mdyk...@gmail.com To: michel compu...@videotron.ca Cc: mysql@lists.mysql.com Sent: Tuesday, July 06, 2010 7:15 PM Subject: Re: Fixed Connection Diagnostic Tool C3P0 connection does, indeed work well on remote machines.. In fact, I only deploy it locally on dev servers. My production systems all use c3p0 on remote servers. Again, if you can connect from the command line of your client machine to the server *via TCP* with the same credentials as your DataSource is using, then it will all just work fine. You appear to have specified a bind address which made local TCP connections impossible. Address that, and you sohuld have no trouble at all. - md On Tue, Jul 6, 2010 at 6:45 PM, michel compu...@videotron.ca wrote: Thank you all for the help and info! This error happened because I started MySQL with -bind-address=91.203.57.207; even if Softslate is given the proper IP address and port number is fails on connection pooling. I fixed the problem by setting the MySQL IP address to 127.0.0.1. I am thinking that the reason is that the C3P0 connection pooling cannot work on a 'remote' machine. Michel - Original Message - From: Rob Wultsch wult...@gmail.com To: michel compu...@videotron.ca Cc: mysql@lists.mysql.com Sent: Tuesday, July 06, 2010 1:52 AM Subject: Re: Connection Diagnostic Tool On Mon, Jul 5, 2010 at 3:55 PM, michel compu...@videotron.ca wrote: I have been trying to figure this one out, but I don't have the skill sets here so I can use some help. I tried ' -h 127.0.0.1' in my bash shell and I get a command not found, so I am still really off-the-mark. Is there a place on the net I can look up what it does and how to run it? Thanks! I am pretty sure Michael that meant running the command line mysql client: mysql -uuser -ppass -h127.0.0.1 -e 'select hello world!' -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=compu...@videotron.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.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?unsub=compu...@videotron.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: AnySQL Maestro 10.7 released
Hi! SQL Maestro Group announces the release of AnySQL Maestro 10.7, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (MySQL, SQL Server, Oracle, Access, etc). The new version is immediately available at http://www.sqlmaestro.com/products/anysql/maestro/ This version features database profile management extensions, updated Script Runner, improved Data Analysis and Data Import tools, and some other useful things. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/anysql_maestro_10_7_released/ AnySQL Maestro comes in two editions: Freeware and Professional. The feature matrix can be found at http://www.sqlmaestro.com/products/anysql/maestro/free_vs_pro/ AnySQL Maestro has been successfully tested with all the latest official MySQL ODBC drivers and all the latest versions of MySQL database server. Background information: SQL Maestro Group offers complete database admin and management tools for MySQL, Oracle, MS SQL Server, DB2, PostgreSQL, SQL Anywhere, SQLite, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How to slim MySQL?
On Tue, Jul 6, 2010 at 8:39 PM, Andrés Tello mr.crip...@gmail.com wrote: The more information, the easiest to pinpoint solutions. delete all client and administrativ tools (mysql, mysqladmin, etc from the server, since you aren't doing any transactions, I think you can ditch all engines excepto the isam/myisam, the basic one, also you migth want to leave memory engine... If I understand your project, you migth copy the database to the ram into a tmpfs and if any change is needed, you update it, maybe to another engine?? What would I do. Build mysql in some machine, only copy mysqld and it's libraries, start it and trace it with strace -e open to see what files does it needs at startup. Supply them. Add the database, run the aplication. If not working, repeat... until it works... that would be my approach, I think that would take like... 2 days at most. Don't think about leaning down the mysql, better thik about providing what it barely needs to run properly. Good luck. It seems like a reasonable (though time-consuming) approach. I'm going to give it a try. I think watching for the open() function will suffice (strace -e open). Is there any other syscall I should be worry about? -- Nima Mohammadi