Re: MySql and AOP?
probablemente por que mark es el manager del desarrollo de software de conectividad para Mysql...entre ellos jdbc.. :-) Saludos, Alvaro Avello. Fernando Asteasuain wrote: Thanks por answering Mark! By the way, how do you know that JDBC driver uses AspectJ? I´ve vissited several jdbc web sites and i didn´t find this information. Quoting Mark Matthews [EMAIL PROTECTED]: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Fernando Asteasuain wrote: Hi: I was visiting the Aspect Oriented Software Development (AOSD) -Europe Workshop 2005 website, (http://www.aosd-europe.net/workshop-web/discussions.html) especially the discusion area. There, I read the following: What is the state of application of AOSD especially in industry? The exact extent of where AOSD tools and techniques are used is difficult to evaluate, in particular, because of its hidden nature as an enabling technology in applications. There are not many open-source projects that clearly feature AOSD techniques, notable exceptions being MySQL and AJ Hotdraw. Furthermore, eight commercial IBM products currently include AOSD libraries. Is MySql implemented using AOSD technology? How they are related? I wasn´t aware of this. Thanks, Fernando. Fernando, The JDBC driver uses Aspect/J to weave in tracing aspects, if that's what they're referring to. I'm not sure the server uses any technology that could be considered aspects. -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Connectivity www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDTTm3tvXNTca6JD8RAq4UAJ4rUb5LtDj8mqTvunzFy0EFfg0FTACfRo+k 4bgDFPNQxRWIoFI4u4p/25w= =suQZ -END PGP SIGNATURE- - This mail sent through IMP: http://horde.org/imp/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL 4.0.2 is topping out at 1024 threads!
master for this slave - required #master-host = hostname # # The username the slave will use for authentication when connecting # to the master - required #master-user = username # # The password the slave will authenticate with when connecting to # the master - required #master-password = password # # The port the master is listening on. # optional - defaults to 3306 #master-port = port # # binary logging - not required for slaves, but recommended #log-bin # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname # Uncomment the following if you are using BDB tables #bdb_cache_size = 384M #bdb_max_lock = 10 # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group_home_dir = /var/lib/mysql/ #innodb_log_arch_dir = /var/lib/mysql/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #innodb_buffer_pool_size = 384M #innodb_additional_mem_pool_size = 20M # Set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 100M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout Thanks All! Matt Babineau Web Developer Criticalcode - http://www.criticalcode.com -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 8:26 AM To: Gleb Paharenko Cc: [EMAIL PROTECTED] Subject: Re: MySQL 4.0.2 is topping out at 1024 threads! In the last episode (Nov 17), Gleb Paharenko said: Help! I can't figure out a way to stop my server from topping out at 1024 threads. This is a very strange behavoir. I have tons of legit use on my database server but I don't think the threads are dying does anyone have any suggestions for this? Similar problems are often found in lists. Usually they are solved by increasing file limits. You likely need to increase open-files-limit. If you're running Linux, you may need to recompile your linuxthreads library also: http://dev.mysql.com/doc/mysql/en/Source_notes-Linux.html -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Alvaro Avello [EMAIL PROTECTED] Servinco S.A.
replication log error
Hi. I'm having a problem with a slave replication server. the 'show slave status' command shows : mysql show slave status; +-+-+-+---+-+-+--+---+---+--+---+-+-++--+--+-+-+ | Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | Exec_master_log_pos | Relay_log_space | +-+-+-+---+-+-+--+---+---+--+---+-+-++--+--+-+-+ | hubble | replica | 3306| 60| hubble-bin.009 | 646906124 | gemini-relay-bin.008 | 1006270724| hubble-bin.009 | No | No | | | 0 | error 'unexpected success or fatal error' on query 'INSERT INTO COBGE7A' | 0 | 646905758 | 1006271180 | +-+-+-+---+-+-+--+---+---+--+---+-+-++--+--+-+-+ 1 row in set (0.00 sec) the query shows a table that don't exists ( COBGE7A ) , so what I thought is that the relay log was corrupt. I'm trying to read the log with mysqlbinlog : mysqlbinlog -f gemini-relay-bin.008 nuevo.sql and got : ERROR: Error in Log_event::read_log_event(): 'Event too small', data_len=0,event_type=0 ERROR: Could not read entry at offset 909811060 : Error in log format or read error Could i skip the lines before the infamous offset number or something else...? Thanks in advance and have a good weekend. -- Alvaro Avello [EMAIL PROTECTED] Servinco S.A.
RE: replication log error
mysql show slave status\G; *** 1. row *** Master_Host: hubble Master_User: replica Master_Port: 3306 Connect_retry: 60 Master_Log_File: hubble-bin.009 Read_Master_Log_Pos: 646906124 Relay_Log_File: gemini-relay-bin.008 Relay_Log_Pos: 1006270724 Relay_Master_Log_File: hubble-bin.009 Slave_IO_Running: No Slave_SQL_Running: No Replicate_do_db: Replicate_ignore_db: Last_errno: 0 Last_error: error 'unexpected success or fatal error' on query 'INSERT INTO COBGE7A' Skip_counter: 0 Exec_master_log_pos: 646905758 Relay_log_space: 1006271180 1 row in set (0.01 sec) On Fri, 2004-11-05 at 14:37 -0800, Max Michaels wrote: Please run the command as 'show slave status\G' and send those results. Makes it much, much easier to read :) -Original Message- From: Alvaro Avello [mailto:[EMAIL PROTECTED] Sent: Friday, November 05, 2004 3:36 PM To: [EMAIL PROTECTED] Subject: replication log error Hi. I'm having a problem with a slave replication server. the 'show slave status' command shows : mysql show slave status; +-+-+-+---+-+-+--+---+---+--+---+-+-++--+--+-+-+ | Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | Exec_master_log_pos | Relay_log_space | +-+-+-+---+-+-+--+---+---+--+---+-+-++--+--+-+-+ | hubble | replica | 3306| 60| hubble-bin.009 | 646906124 | gemini-relay-bin.008 | 1006270724| hubble-bin.009 | No | No | | | 0 | error 'unexpected success or fatal error' on query 'INSERT INTO COBGE7A' | 0 | 646905758 | 1006271180 | +-+-+-+---+-+-+--+---+---+--+---+-+-++--+--+-+-+ 1 row in set (0.00 sec) the query shows a table that don't exists ( COBGE7A ) , so what I thought is that the relay log was corrupt. I'm trying to read the log with mysqlbinlog : mysqlbinlog -f gemini-relay-bin.008 nuevo.sql and got : ERROR: Error in Log_event::read_log_event(): 'Event too small', data_len=0,event_type=0 ERROR: Could not read entry at offset 909811060 : Error in log format or read error Could i skip the lines before the infamous offset number or something else...? Thanks in advance and have a good weekend. -- Alvaro Avello [EMAIL PROTECTED] Servinco S.A.
Re: Arguments to fight against Ms SQL Server and Oracle
Leonardo : La verdad es que debes analizar lo que yo llamo ¿donde te aprieta el zapato? , esto quiere decir , que si requieres procedimientos almacenados y triggers y vistas , quizas oracle haga el trabajo. Si por otro lado la logica del negocio esta en tus aplicacciones y no requieres de estas caracteristicas que te nombre anteriormente Mysql es una buena opcion . la verdad es que debes leer respecto de las caracteristicas que hoy en dia tiene Mysql y comparar con los otros motores ya que como dicen por alli /la ignorancia es insolente/. Saludos, Alvaro Avello. Jochem van Dieten wrote: Leonardo Javier Belén wrote: The staff on the other hand, is thinking in using ORACLE, and I need very solid arguments to beet them. Any ideas I can borrow? If *you* don't know any arguments, then maybe Oracle is the best solution. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql in a jail
chrooted ? Rhino wrote: Maybe you could explain what a jail is. In 20+ years doing systems work I've never heard that term mean anything but a place where criminals are locked up. Rhino - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 11:28 AM Subject: mysql in a jail I have a system running FreeBSD 4.9 four jails. MySQL is running in two of the jails and I am trying to add it to a 3rd jail. Starting the server gets the message: 040302 19:34:15 mysql started 040302 19:34:15 Can't start server : Bind on unix socket: Permission denied 040302 19:34:15 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 040302 19:34:15 Aborting 040302 19:34:15 /usr/local/libexec/mysqld: Shutdown Complete 040302 19:34:15 mysqld ended The new jail was created by copying the file tree from a jail that had the desired configuration and then doing clean-up as required. In response to the error I tried configuring mysqld to use a different port and socket file. That did not fix the problem. I had forgotten the other two mysql's are using port 3306 and /tmp/mysql.sock. I next removed mysql and its dependencies and reinstalled mysql-server-4.0.16 using pkg_add. I am still getting the same error. At this point I think it is a jail problem with something I missed in clean-up but I do not know where to look next. Having done all this, I recalled in installing the 2nd MySQL jail, it was necessary to remove and reinstall mysql. In that instance the re-installation solved the problem. Thanks for any ideas. _ Douglas Denault [EMAIL PROTECTED] Voice: 301-469-8766 Fax: 301-469-0601 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem with wildcards in host field .
Hi everybody : I'm experiencing a trouble with user permissions and wildcards in the host field ( % ). I have several MySQL databases and we connect to them through myodbc to Centura team developer apps . Since the beginning we create all the users with a wildcard in the host field because we needed to connect from different LAN ' s . in the other hand ,we build a web server with apache - php - mysql and started to create app's which we used to connect to the 'stand alone' MySQL Servers. Everything was fine, until the web server crashed . So, we needed to move all the php app's to one of our MySQL 'stand alone' servers . since then we can not connect through php to the databases located in the same server . we have errors like ' access denied to [EMAIL PROTECTED] ' and thats o.k. the questions is , the wildcard in host field doesn't involve localhost o a machine host's ? Which kind of permissions we have to put in host fields to have a mobility and not to be afraid to move our servers for an emergency ? the mysql version i'm using is 4.0.14 . Thanks in Advance and happy weekend ¡ :-) Saludos / Regards , Alvaro. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql Support Contract
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi guys , I'm sorry for this very OT post , but i guess that someone in the list can help me . I've made contact with a sales representant of mysql to purchase a mysql support contract , but the communication seems to be a little slow ( my company is in Chile - South America ). In fact , I already know what kind of support i want to pay, but , i still can't contact him to finish the transaction ( this is a kind of non OT thing in a SQL list :-) ) There's any chance that someone could give me a name or a mail where i can send my info and finish this ? Thanks in Advance ( And sorry for my poor english ) Saludos / Regards, Alvaro Avello. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Netscape - http://enigmail.mozdev.org iD8DBQE/mWRgR9NZaw5tbc0RAoc8AJ992nQRYLnVpnsuQBi7h+EGKE7pjQCfXFtG nxo+nX+l55JREqcLaPl9Lbk= =Zyd8 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb file won't shrink
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sorry HeikkiCan you give me a few steps to obtain that...? Thanks a lot. Alvaro Avello. Heikki Tuuri wrote: |Alvaro, | |- Original Message - |From: Alvaro Avello [EMAIL PROTECTED] |To: Heikki Tuuri [EMAIL PROTECTED] |Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] |Sent: Tuesday, July 15, 2003 1:13 AM |Subject: Re: innodb file won't shrink | | |-BEGIN PGP SIGNED MESSAGE- |Hash: SHA1 | |There 's any chance that in the future every InnoDB table files from a |determinated database can be placed in the same directory of the mysql ( |MyISAM ) database ? . My point is that if you want to take a binary |backup of all databases in the mysql directory and you want to restore |just one of the databases , you could just copy the directory to the |correct place and thats all you have to do to restore a single |database.. I guess I'm getting tired to wait for the dump to |re-create all the indexes and stuff like that. | | |it will not be straightforward. The undo logs used to purge old versions of |rows and roll back uncommitted transaction will not be placed to those table |files. But if you let the database to be silent and run purge to completion, |then you will get clean tables you can restore later individually to the |database. | |Thanks In advance | |Saludos / Regards , | |Alvaro Avello. | | |Regards, | |Heikki | |walt wrote: | ||Heikki Tuuri wrote: || || ||On September 15th, 2003 you will be able to put every InnoDB table |into its ||own file. That should alleviate this kind of problem. || || ||Best regards, || ||Heikki Tuuri ||Innobase Oy ||http://www.innodb.com ||Transactions, foreign keys, and a hot backup tool for MySQL ||Order MySQL technical support from https://order.mysql.com/ || || ||That is great news! Will a single table be able to span several ||datafiles? || ||Thanks! ||walt || |-BEGIN PGP SIGNATURE- |Version: GnuPG v1.2.1 (GNU/Linux) |Comment: Using GnuPG with Netscape - http://enigmail.mozdev.org | |iD8DBQE/EysJR9NZaw5tbc0RAnMHAJ4/ZxbE5sRwAjW8cDAcXOr6cbsiowCeJU14 |y/QT2dFY16n6L/OcJ0vCHyw= |=PCGI |-END PGP SIGNATURE- | | | | | -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Netscape - http://enigmail.mozdev.org iD8DBQE/FGZMR9NZaw5tbc0RAn6lAJ0filp6siUs+TBk7N2CP8Il6mgHvwCfV20j YBIWR33O86CMczdhleqvZKs= =iQu1 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Fwd: Bind Variables.]
Hi everybody: I 'm actually having an problem trying to mygrate to mysql. it's true that mysql does not support bind variables ? . Actually the development in my company is over Centura team developer connected to Centura Sqlbase , and the code of the aplications is widely using bind variables . there is a workaround for this ? there is a posibility that in the future releases of mysql bind variables will be supported ?' thanks in advance. Alvaro. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bind Variables.
Hi everybody: I 'm actually having an problem trying to mygrate to mysql. it's true that mysql does not support bind variables ? . Actually the development in my company is over Centura team developer connected to Centura Sqlbase , and the code of the aplications is widely using bind variables . there is a workaround for this ? there is a posibility that in the future releases of mysql bind variables will be supported ?' thanks in advance. Alvaro. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Detecting Mysql servers on the network
¿ ? OT. Defryn, Guy wrote: Is it possible to detect mysql servers on the network without knowing the hostname? cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
myodbc problem.
Hi ¡ : I Have a problem. I 'm connecting Centura Team Developer to Mysql Trough myodbc . when i send a select to the server , i can see that the select statement works fine. but when I evaluate the variables that the server returns , it returns the CHAR fields as empty values . this does not happen to an INT field. I ' ve check the database and the rows isn't empty. anybody has the same problem ? Thanks In advance. Saludos / Regards , Alvaro Avello. System Administrator. Servinco S.A. Santiago , Chile. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php