MySQL Community Server 5.5.32 has been released
ed GROUP_CONCAT() and an ORDER BY clause that named multiple columns could cause the server to exit. (Bug #16075310) * ORDER BY MATCH ... AGAINST could cause a server exit. (Bug #16073689) * When a partition is missing, code in ha_innodb.cc would retry 10 times and sleep for a microsecond each time while holding LOCK_open. The retry logic for partitioned tables was introduced as a fix for Bug#33349 but did not include a test case to validate it. This fix removes the retry logic for partitioned tables. If the problem reported in Bug#33349 reappears, a different solution will be explored. (Bug #15973904) * The mysql.server script exited with an error if the status command was executed with multiple servers running. (Bug #15852074) * A query with a union and a join could crash the parser. (Bug #14786792, Bug #16076289) * Installation using Solaris packages ran mysql_install_db during upgrade operations (this should occur only for new installations). (Bug #14747671, Bug #16534721) * When processing row-based-replication events in the old binary log format from prior to MySQL 5.1 GA builds, mysqlbinlog could result in out-of-bounds heap buffer reads and undefined behaviour. (Bug #14771299) * The mysql client allocated but did not free a string after reading each line in interactive mode, resulting in a memory leak. (Bug #14685362) * INSERT ... ON DUPLICATE KEY UPDATE on a view could cause a server exit. (Bug #14261010) * Grouping by an outer BLOB column in a subquery caused a server exit. (Bug #13966809, Bug #14700180) * The server could exit due to improper handling of the error from an invalid comparison. (Bug #13009341) * The CMake check for unsigned time_t failed on all platforms. (Bug #11766815) * On 64-bit Mac OS X systems, CMake used x86 rather than x86_64 when determining the machine type. (Bug #58462, Bug #11765489) * The parser rejected legal queries that involved a UNION where the right hand side query term has a table in parenthese. (Bug #54382, Bug #11761854) * The url columns in the mysql datatbase help tables were too short to hold some of the URLs in the help content. For new installations, these columns are now created as type TEXT to accommodate longer URLs. For upgrades, mysql_upgrade does not update the columns. Modify them manually using these statements: ALTER TABLE mysql.help_category MODIFY url TEXT NOT NULL; ALTER TABLE mysql.help_topic MODIFY url TEXT NOT NULL; (Bug #61520, Bug #12671635) * If Loose Index Scan was used to evaluate a query that compared an integer column to an integer specified as a quoted string (for example, col_name = '1'), the query could return incorrect results. (Bug #68473, Bug #16394084) * IF() function evaluations could produce different results when executed in a prepared versus nonprepared statement. (Bug #45370, Bug #11753852) * It is now possible to suppress installation of the mysql-test directory after compiling MySQL from source by invoking CMake with the INSTALL_MYSQLTESTDIR option explicitly set to empty: cmake . -DINSTALL_MYSQLTESTDIR= Previously, attempts to do this resulted in an error. (Bug #58615, Bug #11765629) * Using range access with an index prefix could produce incorrect results. (Bug #68750, Bug #16540042) * MD5() code did not properly initialize one of its data structures. (Bug #68909, Bug #16626742) * When specified in an option file, the plugin-dir client option was ignored. (Bug #68800, Bug #16680313) * If an UPDATE containing a subquery caused a deadlock inside InnoDB, the deadlock was not properly handled by the SQL layer. The SQL layer then tried to unlock the row after InnoDB rolled back the transaction, raising an assertion inside InnoDB. (Bug #69127, Bug #16757869) On behalf of Oracle MySQL RE Team Ramesh Maddali -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Joining tables from different Instances
Hi I have a different schemas in different instances. I would like to join the tables in different instances for the required result. Is it possible? Example = Server I - table_1a, table_2b Server II - table_2a,table_2b. I want to join the table_1a with table_2b. Is is possible?
Re: MyISAM Repair table problem
Is that index and all will be fine in that table, or have to create again? On 19 May 2011 11:11, Ramesh wrote: > > Lost all the records once i done the repair table with use_frm. > > On 19 May 2011 10:30, Suresh Kuna wrote: > >> Run this - repair table SystemEvents use_frm ; >> >> >> On Thu, May 19, 2011 at 10:24 AM, Ramesh wrote: >> >>> mysql> repair table SystemEvents.frm; >>> >>> +--++--++ >>> | Table| Op | Msg_type | >>> Msg_text | >>> >>> +--++--++ >>> | SysEvents.frm | repair | Error| Table 'SysEvents.frm' doesn't exist >>> | >>> | SysEvents.frm | repair | error| >>> Corrupt| >>> >>> +--++--++ >>> 2 rows in set (0.00 sec) >>> >>> But the SysEvents.frm is there in the datadir. >>> >>> >>> >>> On 19 May 2011 09:35, Suresh Kuna wrote: >>> >>>> use repair table table_name use_frm ; and try it out. >>>> >>>> It needs to be run inside mysql. >>>> >>>> >>>> On Thu, May 19, 2011 at 9:30 AM, Ramesh wrote: >>>> >>>>> Hi, >>>>> >>>>> I am trying to repair the table and i got this error >>>>> >>>>> I tried with myisamchk --rq --tmpdir= >>>>> /var/lib/mysql/tablog/TabEvents.MYI >>>>> >>>>> [root@uidsyslog001 mysql]# myisamchk --rq --tmpdir=/var/lib/mysql >>>>> /var/lib/mysql/tablog/TabEvents.MYI >>>>> check record delete-chain >>>>> - recovering (with sort) MyISAM-table >>>>> /var/lib/mysql/tablog/TabEvents.MYI >>>>> Data records: 58354301 >>>>> - Fixing index 1 >>>>> Wrong bytesec: 0- 0- 0 at 15899573240; Skipped >>>>> MyISAM-table '/var/lib/mysql/Syslog/SystemEvents.MYI' is not fixed >>>>> because >>>>> of errors >>>>> Try fixing it by using the -safe-recover (-o), the --force (-f) option >>>>> or by >>>>> not using the --quick (-q) flag >>>>> >>>>> Then i tried the below one >>>>> >>>>> [root@> myisamchk --safe-recover --force --tmpdir=/var/lib/mysql >>>>> /var/lib/mysql/tablog/TabEvents.MYI >>>>> - recovering (with keycache) MyISAM-table '/var/lib/mysql >>>>> /var/lib/mysql/tablog/TabEvents.MYI' >>>>> Data records: 78918751 >>>>> Wrong bytesec: 0- 0- 0 at 15899573240; Skipped >>>>> Data records: 82882799 >>>>> >>>>> What might be the problem and how to make the table repair >>>>> successfully. >>>>> >>>>> Guidance needed >>>>> >>>>> Thanks >>>>> Ramesh >>>>> >>>> >>>> >>>> >>>> -- >>>> Thanks >>>> Suresh Kuna >>>> MySQL DBA >>>> >>> >>> >> >> >> -- >> Thanks >> Suresh Kuna >> MySQL DBA >> > >
Re: MyISAM Repair table problem
Lost all the records once i done the repair table with use_frm. On 19 May 2011 10:30, Suresh Kuna wrote: > Run this - repair table SystemEvents use_frm ; > > > On Thu, May 19, 2011 at 10:24 AM, Ramesh wrote: > >> mysql> repair table SystemEvents.frm; >> >> +--++--++ >> | Table| Op | Msg_type | >> Msg_text | >> >> +--++--++ >> | SysEvents.frm | repair | Error| Table 'SysEvents.frm' doesn't exist >> | >> | SysEvents.frm | repair | error| >> Corrupt| >> >> +--++--++ >> 2 rows in set (0.00 sec) >> >> But the SysEvents.frm is there in the datadir. >> >> >> >> On 19 May 2011 09:35, Suresh Kuna wrote: >> >>> use repair table table_name use_frm ; and try it out. >>> >>> It needs to be run inside mysql. >>> >>> >>> On Thu, May 19, 2011 at 9:30 AM, Ramesh wrote: >>> >>>> Hi, >>>> >>>> I am trying to repair the table and i got this error >>>> >>>> I tried with myisamchk --rq --tmpdir= >>>> /var/lib/mysql/tablog/TabEvents.MYI >>>> >>>> [root@uidsyslog001 mysql]# myisamchk --rq --tmpdir=/var/lib/mysql >>>> /var/lib/mysql/tablog/TabEvents.MYI >>>> check record delete-chain >>>> - recovering (with sort) MyISAM-table >>>> /var/lib/mysql/tablog/TabEvents.MYI >>>> Data records: 58354301 >>>> - Fixing index 1 >>>> Wrong bytesec: 0- 0- 0 at 15899573240; Skipped >>>> MyISAM-table '/var/lib/mysql/Syslog/SystemEvents.MYI' is not fixed >>>> because >>>> of errors >>>> Try fixing it by using the -safe-recover (-o), the --force (-f) option >>>> or by >>>> not using the --quick (-q) flag >>>> >>>> Then i tried the below one >>>> >>>> [root@> myisamchk --safe-recover --force --tmpdir=/var/lib/mysql >>>> /var/lib/mysql/tablog/TabEvents.MYI >>>> - recovering (with keycache) MyISAM-table '/var/lib/mysql >>>> /var/lib/mysql/tablog/TabEvents.MYI' >>>> Data records: 78918751 >>>> Wrong bytesec: 0- 0- 0 at 15899573240; Skipped >>>> Data records: 82882799 >>>> >>>> What might be the problem and how to make the table repair successfully. >>>> >>>> Guidance needed >>>> >>>> Thanks >>>> Ramesh >>>> >>> >>> >>> >>> -- >>> Thanks >>> Suresh Kuna >>> MySQL DBA >>> >> >> > > > -- > Thanks > Suresh Kuna > MySQL DBA >
Re: MyISAM Repair table problem
mysql> repair table SystemEvents.frm; +--++--++ | Table| Op | Msg_type | Msg_text | +--++--++ | SysEvents.frm | repair | Error| Table 'SysEvents.frm' doesn't exist | | SysEvents.frm | repair | error| Corrupt | +--++--++ 2 rows in set (0.00 sec) But the SysEvents.frm is there in the datadir. On 19 May 2011 09:35, Suresh Kuna wrote: > use repair table table_name use_frm ; and try it out. > > It needs to be run inside mysql. > > > On Thu, May 19, 2011 at 9:30 AM, Ramesh wrote: > >> Hi, >> >> I am trying to repair the table and i got this error >> >> I tried with myisamchk --rq --tmpdir= /var/lib/mysql/tablog/TabEvents.MYI >> >> [root@uidsyslog001 mysql]# myisamchk --rq --tmpdir=/var/lib/mysql >> /var/lib/mysql/tablog/TabEvents.MYI >> check record delete-chain >> - recovering (with sort) MyISAM-table /var/lib/mysql/tablog/TabEvents.MYI >> Data records: 58354301 >> - Fixing index 1 >> Wrong bytesec: 0- 0- 0 at 15899573240; Skipped >> MyISAM-table '/var/lib/mysql/Syslog/SystemEvents.MYI' is not fixed because >> of errors >> Try fixing it by using the -safe-recover (-o), the --force (-f) option or >> by >> not using the --quick (-q) flag >> >> Then i tried the below one >> >> [root@> myisamchk --safe-recover --force --tmpdir=/var/lib/mysql >> /var/lib/mysql/tablog/TabEvents.MYI >> - recovering (with keycache) MyISAM-table '/var/lib/mysql >> /var/lib/mysql/tablog/TabEvents.MYI' >> Data records: 78918751 >> Wrong bytesec: 0- 0- 0 at 15899573240; Skipped >> Data records: 82882799 >> >> What might be the problem and how to make the table repair successfully. >> >> Guidance needed >> >> Thanks >> Ramesh >> > > > > -- > Thanks > Suresh Kuna > MySQL DBA >
MyISAM Repair table problem
Hi, I am trying to repair the table and i got this error I tried with myisamchk --rq --tmpdir= /var/lib/mysql/tablog/TabEvents.MYI [root@uidsyslog001 mysql]# myisamchk --rq --tmpdir=/var/lib/mysql /var/lib/mysql/tablog/TabEvents.MYI check record delete-chain - recovering (with sort) MyISAM-table /var/lib/mysql/tablog/TabEvents.MYI Data records: 58354301 - Fixing index 1 Wrong bytesec: 0- 0- 0 at 15899573240; Skipped MyISAM-table '/var/lib/mysql/Syslog/SystemEvents.MYI' is not fixed because of errors Try fixing it by using the -safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag Then i tried the below one [root@> myisamchk --safe-recover --force --tmpdir=/var/lib/mysql /var/lib/mysql/tablog/TabEvents.MYI - recovering (with keycache) MyISAM-table '/var/lib/mysql /var/lib/mysql/tablog/TabEvents.MYI' Data records: 78918751 Wrong bytesec: 0- 0- 0 at 15899573240; Skipped Data records: 82882799 What might be the problem and how to make the table repair successfully. Guidance needed Thanks Ramesh
Enabling slow log queries for particular db
Hi All How can I get MySQL to only 'log-slow-queries' on specific databases instead of globally? -- Ramesh
Re: Disable innodb status info in err log
Greetings. Try with the variable innodb_status_file. I wont get logged in mysqlerr.log file. On 17 March 2010 15:15, Shanmugam, Dhandapani wrote: > anand > > Do you use innodb engine at all further > -D > > -Original Message- > From: sanan...@gmail.com [mailto:sanan...@gmail.com] On Behalf Of Anand > Sent: Wednesday, March 17, 2010 3:00 PM > To: mysql@lists.mysql.com > Subject: Disable innodb status info in err log > > Hi All, > > Innodb status information is getting logged on to my mysql error log > file for every 15 seconds, can someone help in disabling it ? > > Thanks > Anand > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=rames...@gmail.com > > -- Ramesh
Re: how to update a entire column elements
Kindly draft you question clearly with scenario example, so that the solution should be clear. On 5 February 2010 16:20, MuraliKrishna wrote: > Hi I am in need to update a entire column elements with different values. > If > any body know the syntax please help me.. Regarding this.. Thanks in > advance > > > > By > > Muralikrishna > > > > -- Ramesh
Re: how to view all acounts in a database
Login to mysql with the command mysql -uroot -px -A use the database mysql mysql> \u mysql View the table name user mysql> show tables; To view the user mysql> select user from user; On 5 February 2010 17:45, Suresh Kuna wrote: > In the mysql prompt, execute the below > > use mysql ; select user from user ; > > will show all the accounts in a MySQL database. > > > On Fri, Feb 5, 2010 at 5:27 PM, ishaq gbola wrote: > > > Hi Guys, > > > > Which command can allow me view all accounts in a Mysql database > > > > > > > > > > > > > -- > Thanks > Suresh Kuna > MySQL DBA > -- Ramesh
Re: help me out for this problem...
See this link. Might me help for you http://answers.yahoo.com/question/index?qid=20070309043307AATLe9k On 5 February 2010 17:46, misiaQ wrote: > Instead of: > -> else 2003 > >-> where id between 1 and 6; > Try >-> else 2003 >-> end > -> where id between 1 and 6; > > Or maybe even: > mysql> update table1 >-> set year=case when id IN (1, 2, 4) then 2000 >-> when id IN(2, 4, 6) then 2001 >-> else 2003 >-> end > -> where id between 1 and 6; > > Good luck! > > Regards, > m > > -Original Message- > From: MuraliKrishna [mailto:murali_kris...@arthaoptions.com] > Sent: Friday, February 05, 2010 12:04 PM > To: mysql@lists.mysql.com > Subject: help me out for this problem... > > > > Here I have to update year column with reference to the row id > > > > > > mysql> update table1 > >-> set year=case when id=1 then 2000 > >-> when id=2 then 2001 > >-> when id=3 then 2000 > >-> when id=4 then 2001 > >-> when id=5 then 2000 > >-> when id=6 then 2001 > >-> else 2003 > >-> where id between 1 and 6; > > ERROR 1064 (42000): You have an error in your SQL syntax; check the manual > that > > corresponds to your MySQL server version for the right syntax to use near > 'where > > id between 1 and 6' at line 9 > > mysql> > > > > ------ > Urocze domki... > Zobacz >>> http://link.interia.pl/f25aa > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=rames...@gmail.com > > -- Ramesh
Re: Aborted_connects is incresing repidly
You can use this --max_connect_errors=9 to avoid this error 2009/12/30 Parikh, Dilip Kumar > Jetendra, > > Can u attach your my.cnf files and also your variable status (show > variable status). This is required because we need to tune some params. > > Thanks, > Dilipkumar > > -Original Message- > From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com] > Sent: Wednesday, December 30, 2009 11:43 AM > To: mysql@lists.mysql.com > Subject: Aborted_connects is incresing repidly > > Hi, > > My MySQL server Aborted_connects status is showing 8692 and is rapidly > increasing. > > What are reasons and how do i decrease the same? > > We are using connect() method in PHP code and have tried below command > > mysqladmin flush-hosts > > but still the value is same. > > > Thanks > Jeetendra Ranjan > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=rames...@gmail.com > > -- Ramesh
Re: compress/uncompress using java prepared statements
Hi, I am a bit confused by the below, hope I can get some clarification. In the database (mysql), I have image data stored in a blob. I can perform operations like: COMPRESS and UNCOMPRESS on it and the data is fine. Let's say I COMPRESS (ed) the data and then retrieve it use a SELECT UNCOMPRESS(IMAGE_DATA) FROM , when I get this using jdbc ResultSetMetaData rsmd = rs.getMetaData(); System.out.println("SHOW THE COLUMN TYPE: " + rsmd.getColumnType(1)); I am getting the Column type as "VARCHAR<http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Types.html#VARCHAR>", whereas if I don't compress the data and do a straight SELECT IMAGE_DATA ..., the resulting Column Type is a "LONGVARBINARY<http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Types.html#LONGVARBINARY> ". Can somebody explain the above? Why does this work fine in the database but I am not able to select the data into java properly? How could I conver it into a proper format? thanks, Ramesh On 4/19/06, Ramesh V <[EMAIL PROTECTED]> wrote: > > Hello, > > My configuration; > mysql-connector-java-3.1.12-bin.jar > mysql5018 > > > I am trying to get uncompressed data from mysql using: > SELECT UNCOMPRESS(FILE_DATA) FROM WHERE ; > > I am using PreparedStatement, I get the result set and do: rs.getBytes(1); > > For some reason, the UNCOMPRESS doesn't seem to be working. > > I also tried: SELECT UNCOMPRESS(COMPRESS(FILE_DATA)) FROM WHERE > ; > > The resulting byte[] array seems to be corrupt for some reason. > > When I manually UNCOMPRESS the data using the UPDATE stmt in the database > and then do: SELECT FILE_DATA FROM .via java, it works fine. > (Please note: data is not corrupt as I can uncompress it in the db and > retrieve it) > > Does it have to be done differently? Appreciate any suggestions. > > thanks, > Ramesh > >
Question: java/struts, utf8, mysql413
Hi All, [I tried posting this in mysql/java list but didn't get a response, so trying here. Sorry, if OT] I recently started experimenting with storing utf8 data on mysql 413 database server. the character set and all on the db server are properly set. When I submit a html form with option set as Content-Type: multipart/form-data, I am using the Live HTTP Headers in Firefox to check the data that is going to the server and it looks like this: 1a. DATA SENT TO SERVER WITH form option: Content-Type: multipart/form-data; === Accept-Language: en-us,en;q=0.5 Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Content-Type: multipart/form-data; boundary=---23281168279961 Content-Length: 1108 -23281168279961 Content-Disposition: form-data; name="id" 0 -23281168279961 Content-Disposition: form-data; name="name" ä™(r) - 3 1b. DATA SEEN ON SCREEN AFTER SAVE: === ä™(r) - 3 1c. DATA SEEN IN MYSQL - SELECT HEX(NAME), NAME FROM TABLE1 === C3A4E284A2C2AE202D2033, ä™(r) - 3 2a. DATA SENT TO SERVER WITHOUT form option: Content-Type: multipart/form-data; === Accept-Language: en-us,en;q=0.5 Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Content-Type: application/x-www-form-urlencoded Content-Length: 242 id=0&name=%C3%A4%E2%84%A2%C2%AE+-+3 2b. DATA SEEN ON SCREEN AFTER SAVE === äâ¢Â(r) - 3 2c. DATA SEEN IN MYSQL - SELECT HEX(NAME), NAME FROM TABLE1 === C383C2A4C3A2C284C2A2C382C2AE202D2033, äâ¢Â(r) - 3 I am using the standard jdbc driver with the option: ?useUnicode=true&characterEncoding=UTF-8 In the html page, I do have (and I confirmed the same in FireFox, view page info) Can somebody please explain what's going on here and what I can do to make this work without using the multipart/form-data all the time in form. Also, the weird thing is when I search using the jsp pages for 'ä™(r)%', the rows that I get are of the second type above, i.e: äâ¢Â(r) and not something that matches "ä™(r)". thanks, Ramesh
Re: Bulk Upload.
Hello All, I have a strange situation while doing Bulk upload (using LOAD DATA FILE). I have a database which has 60 records, when I try to insert 1 more records it is taking around 50-55 seconds to complete the task (I feel this is much higher than the normal timings). I notice a strange thing that time taken to upload 1 records reduces to 10 to 12 sec after I run a big query (a query that needs full table scan) on that table. Can someone explain why this happens... I run MySQL 4.1.5 Gamma, on windows 2003 Server OS. Regards, Ramesh Confidentiality Notice: This transmittal is a confidential communication. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error and that any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify this office immediately by reply and immediately delete this message and all of its attachments, if any.
Re: Read past Equivalent in MySQL
I am using InnoDB only. But, it's not skipping locked rows. regards Ramesh On Fri, 13 May 2005 12:11:12 +0200, Martijn Tonies <[EMAIL PROTECTED]> wrote: Yes. Martijn is correct. I am trying to skip locked rows and get the next unlocked row available. Reading uncommited data will cause unexpected problems. I don't want to do that. Is there a way to do this? Use InnoDB and you don't _have_ to skip past locked records :-) With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com -- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Read past Equivalent in MySQL
Yes. Martijn is correct. I am trying to skip locked rows and get the next unlocked row available. Reading uncommited data will cause unexpected problems. I don't want to do that. Is there a way to do this? Regards Ramesh On Fri, 13 May 2005 11:54:11 +0200, Martijn Tonies <[EMAIL PROTECTED]> wrote: Yes, that's what i said. He is trying to ovverride data consistency, and read uncommitted is so possible. So why not use it if it solves the problem. else, read uncommitted sould be droped from mysql. I don't think he is trying to override data consistency... with MS SQL, "read past" wil simply skip the locked records and return a resultset without em. With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com -- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Read past Equivalent in MySQL
Hi Mathias, Thanks a lot for your comments. In MS SQL we have something which can achieve this very simply: select Top 1 * from Table1 with (updlock,readpast) I am looking for something exactly similar to this in MySQL. Creating temp tables will not work for me as the no of users for the system could be as high as 500. Regards, Ramesh G On Fri, 13 May 2005 08:19:32 +0200, <[EMAIL PROTECTED]> wrote: Hi, you're ooking for the opposite of what can be done. One can select in share mode or for update : http://dev.mysql.com/doc/mysql/en/innodb-locking-reads.html this prevents data from being incoherent. If you want skip waiting for locks, you can make for each user a temp table containing the result of the select without for update : - create temporary table tempo select ... from table - update tempo - update table where - drop tempo even then, the table will be locked for the update statement. But you can test it. Mathias Selon Ramesh G <[EMAIL PROTECTED]>: Hi All, Is there a way by which I can tell the Mysql to ignore the rows that are locked by someone else and take the next available record. The problem is, I have a Query like this: Select * from Table1 where Fld1=2 FOR UPDATE Limit 1 I will have multiple clients running this same query with the same where clause. For the second instance of the query mysql seems to wait till the transaction of the first instance gets completed. This makes this query slow as the time taken for the transaction to complete is somewhere between 1 and 1.5 seconds. Regards, Ramesh G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Read past Equivalent in MySQL
Hi All, Is there a way by which I can tell the Mysql to ignore the rows that are locked by someone else and take the next available record. The problem is, I have a Query like this: Select * from Table1 where Fld1=2 FOR UPDATE Limit 1 I will have multiple clients running this same query with the same where clause. For the second instance of the query mysql seems to wait till the transaction of the first instance gets completed. This makes this query slow as the time taken for the transaction to complete is somewhere between 1 and 1.5 seconds. Regards, Ramesh G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1.3 Java/UTF8 support question
Hi Gleb, The problem was with the JDBC Connect string, earlier it was; jdbc:mysql://localhost:1/db1?useUnicode=true&characterEncoding=utf8 I changed that to: jdbc:mysql://localhost:1/db1?useUnicode=true&characterEncoding=UTF-8 and it works now. thanks, Ramesh On Fri, 26 Nov 2004 13:53:43 +0200, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > Hello. > > What output produced > > show variables like '%char%'; > > show variables like '%colla%'; > > You should also set utf8 as server character set. > > See: > > http://dev.mysql.com/doc/mysql/en/Charset-defaults.html > > > > > Ramesh Vadlapatla <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > > > In my.cnf, I have: > > > [mysql] > > > default-character-set=utf8 > > > > > > When I connect via mysql client and try to run a query which has a > > > "CONCAT" string function, it works fine and I get the proper output. > > > Example: SELECT CONCAT ('a', ' - ', 'b') = a-b > > > > > > Now, I am trying to do make this work via Java and: > > > I use this JDBC Driver: mysql-connector-java-3.0.10-stable-bin.jar > > > Conn. String: > > jdbc:mysql://localhost:1/db1?useUnicode=true&characterEncoding=utf8 > > > > > > I get the same error as I would have without the above > > > "default-character-set=utf8", i.e: > > > ERROR 1270 (HY000): Illegal mix of collations > > > (utf8_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), > > > (utf8_general_ci,IMPLICIT) for operation 'concat' > > > > > > How do I fix this, so that even the Java Client understands to use the > > > utf8 character set and I don't have to put the _utf8 in my sql > > > statement? > > > > > > Appreciate your help. > > > > > > thanks, > > > Ramesh > > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ><___/ www.mysql.com > > -- > 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]
MySQL 4.1.3 Java/UTF8 support question
Hi, In my.cnf, I have: [mysql] default-character-set=utf8 When I connect via mysql client and try to run a query which has a "CONCAT" string function, it works fine and I get the proper output. Example: SELECT CONCAT ('a', ' - ', 'b') = a-b Now, I am trying to do make this work via Java and: I use this JDBC Driver: mysql-connector-java-3.0.10-stable-bin.jar Conn. String: jdbc:mysql://localhost:1/db1?useUnicode=true&characterEncoding=utf8 I get the same error as I would have without the above "default-character-set=utf8", i.e: ERROR 1270 (HY000): Illegal mix of collations (utf8_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (utf8_general_ci,IMPLICIT) for operation 'concat' How do I fix this, so that even the Java Client understands to use the utf8 character set and I don't have to put the _utf8 in my sql statement? Appreciate your help. thanks, Ramesh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql SQL Help
Hi, Need a SQL/Design help. I have a table as follows: ORDER_HISTORY -- ORDER_ID | ORDER_NAME | ORDER_AMOUNT | ORDER_DATE -- 10 | Order 1| 20.00| 10-Jan-2003 11 | Order 2| 200.00 | 15-Jan-2003 12 | Order 3| 250.00 | 25-Jan-2003 13 | Order 4| 260.00 | 30-Mar-2003 14 | Order 5| 320.00 | 10-Jan-2004 I want to write a SQL which generates a weekly report from the ORDER_HISTORY table and shows it as: WEEKLY_DATE | CUMULATIVE AMOUNT -- 10-JAN-2003 | 20 17-JAN-2003 | 220 24-JAN-2003 | 220 31-JAN-2003 | 490 07-FEB-2003 | 490 Similarly another table without a Cumulative: WEEKLY_DATE | AMOUNT -- 10-JAN-2003 | 20 17-JAN-2003 | 200 24-JAN-2003 | 0 31-JAN-2003 | 250 07-FEB-2003 | 0 My thought process currently is to first get all the date intervals within the min and max dates of ORDER_DATE with a 1 WEEK addition to each min date and then for each of these intervals, I can then get the AMOUNT and add it to up to the previous amount if cumulative or just leave it if not cumulative. I am trying to find an elegant solution to implement this and not have too many trips to the database, i.e once to get each interval of date between the min and max and then for each interval go to the db again to get the amount. Is there any function which will return all the starting dates of each week between two dates? Appreciate any help or links to prior solutions or any book on this topic. thanks ___ Join Excite! - http://www.excite.com The most personalized portal on the Web! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: jUDDI DataSource Connection Problem (Cannot create PoolableConnectionFactory)
Thanks to those that responded. The problem is solved there was a password mismatch between MySQL (what I had set up) and jUDDI. I changed the password in MySQL and it now works fine. BTW, to the person that asked, Axis worked fine all along. VC Ramesh <[EMAIL PROTECTED]> wrote: happyjuddi.jsp gives me the following error: (full text of the page enclosed at end of message) jUDDI DataSource Check + Got a JNDI Context!+ Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)- DB connection was not aquired. (Cannot create PoolableConnectionFactory)- SELECT COUNT(*) FROM PUBLISHER failed (null)I am using the latest versions of the respective software (Tomcat 5.0.16, jUDDI 0.8.0, MySQL 4.0.17, Java SDK j2sdk1.4.2.03, JDBC driver mysql-connector-java-3.0.9-stable-bin.jar) on Windows 2000. I have tried setting juddi.useConnectionPool to True but that didn't resolve the issue. I have followed the instructions in a couple of archived messages I unearthed on this problem; but nothing seems to work for me. Thanks for any suggestions/help. -- Ramesh [EMAIL PROTECTED] the happyjuddi.jsp output page - jUDDI Happiness PagejUDDI.org jUDDI Happy jUDDI! jUDDI Dependencies: Class Files & Libraries Looking for: org.juddi.registry.Registry +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\lib\juddi.jar Looking for: javax.xml.soap.SOAPMessage +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\lib\saaj.jar Looking for: javax.xml.rpc.Service +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\lib\jaxrpc.jar Looking for: org.apache.axis.transport.http.AxisServlet +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\lib\axis.jar Looking for: org.apache.commons.discovery.Resource +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\lib\commons-discovery.jar Looking for: org.apache.commons.logging.Log +Found in: c:\jakarta-tomcat-5.0.16\bin\commons-logging-api.jar Looking for: org.apache.log4j.Layout +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\lib\log4j-1.2.8.jar Looking for: com.ibm.wsdl.factory.WSDLFactoryImpl +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\lib\wsdl4j.jar Looking for: javax.xml.parsers.SAXParserFactory +Found in an unknown location Looking for: javax.activation.DataHandler +Found in: c:\jakarta-tomcat-5.0.16\common\lib\activation.jar jUDDI Dependencies: Resource & Properties Files Looking for: log4j.properties +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\classes\log4j.properties Looking for: juddi.properties +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\classes\juddi.properties jUDDI DataSource Check + Got a JNDI Context! + Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB) - DB connection was not aquired. (Cannot create PoolableConnectionFactory) - SELECT COUNT(*) FROM PUBLISHER failed (null) jUDDI Properties juddi.adminEmailAddress: [EMAIL PROTECTED] juddi.adminURL: http://localhost:8080/juddi/admin juddi.authFactory: org.juddi.auth.simple.SimpleAuthenticatorFactory juddi.dataSource: java:comp/env/jdbc/juddiDB juddi.dataStoreFactory: org.juddi.datastore.jdbc.JDBCDataStoreFactory juddi.inquiryURL: http://localhost:8080/juddi/inquiry juddi.jdbcDriver: com.mysql.jdbc.Driver juddi.jdbcPassword: juddi juddi.jdbcURL: jdbc:mysql://localhost/juddi juddi.jdbcUser: juddi juddi.maxMessageSize: 2097152 juddi.maxNameElementsAllowed: 5 juddi.maxNameLength: 255 juddi.operatorName: jUDDI.org juddi.operatorSiteURL: http://localhost:8080/juddi juddi.publishURL: http://localhost:8080/juddi/publish juddi.transportClass: org.juddi.transport.axis.AxisTransport juddi.useConnectionPool: false juddi.uuidgenFactory: org.juddi.uuidgen.jvm.JavaUUIDGenFactory Platform: Apache Tomcat/5.0.16 - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
jUDDI DataSource Connection Problem (Cannot create PoolableConnectionFactory)
happyjuddi.jsp gives me the following error: (full text of the page enclosed at end of message) jUDDI DataSource Check + Got a JNDI Context!+ Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)- DB connection was not aquired. (Cannot create PoolableConnectionFactory)- SELECT COUNT(*) FROM PUBLISHER failed (null)I am using the latest versions of the respective software (Tomcat 5.0.16, jUDDI 0.8.0, MySQL 4.0.17, Java SDK j2sdk1.4.2.03, JDBC driver mysql-connector-java-3.0.9-stable-bin.jar) on Windows 2000. I have tried setting juddi.useConnectionPool to True but that didn't resolve the issue. I have followed the instructions in a couple of archived messages I unearthed on this problem; but nothing seems to work for me. Thanks for any suggestions/help. -- Ramesh [EMAIL PROTECTED] the happyjuddi.jsp output page - jUDDI Happiness PagejUDDI.org jUDDI Happy jUDDI! jUDDI Dependencies: Class Files & Libraries Looking for: org.juddi.registry.Registry +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\lib\juddi.jar Looking for: javax.xml.soap.SOAPMessage +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\lib\saaj.jar Looking for: javax.xml.rpc.Service +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\lib\jaxrpc.jar Looking for: org.apache.axis.transport.http.AxisServlet +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\lib\axis.jar Looking for: org.apache.commons.discovery.Resource +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\lib\commons-discovery.jar Looking for: org.apache.commons.logging.Log +Found in: c:\jakarta-tomcat-5.0.16\bin\commons-logging-api.jar Looking for: org.apache.log4j.Layout +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\lib\log4j-1.2.8.jar Looking for: com.ibm.wsdl.factory.WSDLFactoryImpl +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\lib\wsdl4j.jar Looking for: javax.xml.parsers.SAXParserFactory +Found in an unknown location Looking for: javax.activation.DataHandler +Found in: c:\jakarta-tomcat-5.0.16\common\lib\activation.jar jUDDI Dependencies: Resource & Properties Files Looking for: log4j.properties +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\classes\log4j.properties Looking for: juddi.properties +Found in: c:\jakarta-tomcat-5.0.16\webapps\juddi\WEB-INF\classes\juddi.properties jUDDI DataSource Check + Got a JNDI Context! + Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB) - DB connection was not aquired. (Cannot create PoolableConnectionFactory) - SELECT COUNT(*) FROM PUBLISHER failed (null) jUDDI Properties juddi.adminEmailAddress: [EMAIL PROTECTED] juddi.adminURL: http://localhost:8080/juddi/admin juddi.authFactory: org.juddi.auth.simple.SimpleAuthenticatorFactory juddi.dataSource: java:comp/env/jdbc/juddiDB juddi.dataStoreFactory: org.juddi.datastore.jdbc.JDBCDataStoreFactory juddi.inquiryURL: http://localhost:8080/juddi/inquiry juddi.jdbcDriver: com.mysql.jdbc.Driver juddi.jdbcPassword: juddi juddi.jdbcURL: jdbc:mysql://localhost/juddi juddi.jdbcUser: juddi juddi.maxMessageSize: 2097152 juddi.maxNameElementsAllowed: 5 juddi.maxNameLength: 255 juddi.operatorName: jUDDI.org juddi.operatorSiteURL: http://localhost:8080/juddi juddi.publishURL: http://localhost:8080/juddi/publish juddi.transportClass: org.juddi.transport.axis.AxisTransport juddi.useConnectionPool: false juddi.uuidgenFactory: org.juddi.uuidgen.jvm.JavaUUIDGenFactory Platform: Apache Tomcat/5.0.16 - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
INSERT INTO FROM same table failing
Hi, In mysql 4.014, the below INSERT statement works fine: INSERT INTO TEST_TABLE SELECT 20, name FROM TEST_TABLE WHERE id = 10 But in mysql 4.1, it fails, I get a message: Error Code : 1066 Not unique table/alias: 'TEST_TABLE' (10 ms taken) Question: Is this a problem with 4.1 or is it supposed to fail? thanks, Ramesh Table is: CREATE TABLE TEST_TABLE (id mediumint(9) NOT NULL, name varchar(255)) TYPE = InnoDB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Inner join question!
Hi Tore, Thank you so much. You are correct, I had duplicate records in the file. I haven't finish cleaning up the table. Once I finish cleaning and run the query and if I still duplicate, I will let you know. Till then, thank you so much for the answer. Unni --- Tore Bostrup <[EMAIL PROTECTED]> wrote: > The only reason I could see for this would be if you > have duplicates (across > date num1 num2 time) in both tables, or > quadruplicates in one. > > You join looks correct, so take a closer look at > your data. Try running the > following queries: > > SELECT A.date, num1, num2, A.time, Count(*) > FROM A > GROUP BY A.date, num1, num2, A.time > HAVING Count(*) > 1 > > SELECT B.date, num1, num2, B.time, Count(*) > FROM B > GROUP BY B.date, num1, num2, B.time > HAVING Count(*) > 1 > > > HTH, > Tore. > > - Original Message - > From: "Ramesh Pillai" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, February 27, 2003 10:36 PM > Subject: Inner join question! > > > > All, > > > > I have two tables like the following > > > > table A > > date num1 num2 time > > > > table B > > date num1 num2 time > > > > When I run a query like the following > > > > select * from A as a inner join B as b > > on a.num1 = b.num1 and a.date=b.date and > a.num2=b.num2 > > and a.time=b.time > > > > I am getting the results repeated 4 times, could > > someone tell me why I am getting 4 rows and how > can I > > elliminate it? > > > > Thanks. > > Ramesh > > > > __ > > Do you Yahoo!? > > Yahoo! Tax Center - forms, calculators, tips, more > > http://taxes.yahoo.com/ > > > > > - > > 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 > __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ - 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
Inner join question!
All, I have two tables like the following table A date num1 num2 time table B date num1 num2 time When I run a query like the following select * from A as a inner join B as b on a.num1 = b.num1 and a.date=b.date and a.num2=b.num2 and a.time=b.time I am getting the results repeated 4 times, could someone tell me why I am getting 4 rows and how can I elliminate it? Thanks. Ramesh __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ - 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
PLS HELP TO ME
Hi, This is ILANGO RAMESH.from singapore.now i am doing one credit card project.now we are planning to using database MYSQL. now i want some dbouts.i am newer in database side.can u help me. now i am purchasing MYSQL DATABASE SERVER.OR I AM DOWNLOADING MYSQL SERVER ON SITE. INCASE DOWNLOADING IT'S ENOUGH HOW MANY DATA'S(BYTES) STORING IN DATABASE. PLS HELP TO ME. NOW I AM START WITH MY PROJECT.PLS HELP TO ME.PLS SEND MAIL TO ME.AS SOON AS POSSIBLE. THANKS RAMESH.I __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com - 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
Regarding : Directory CheckSum Error ---- Urgently Required
Hi, I am facing problem while installing the mysql software in sun solaris Operating System. i downloaded the mysql file from www.mysql.com site and uploaded into the server in the binary format and trying to extract the tar file using gunzip file. The file name is : mysql-3.22.25-solaris7-x86.pkg.tgz This file size is :3122 KB. the command which i used was: shell> gunzip < mysql-3.22.25-solaris7-x86.pkg.tgz | tar xvf - I will be thankful if you could send me the solution as soon as possible. Thanks & Regards Y.Veera Ramesh - 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