MySQL Community Server 5.5.32 has been released

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_

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> repai

Re: MyISAM Repair table problem

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 >>

MyISAM Repair table problem

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

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

Thanks in > advance > > > > By > > Muralikrishna > > > > -- Ramesh

Re: how to view all acounts in a database

> > > > > > > > > > > -- > Thanks > Suresh Kuna > MySQL DBA > -- Ramesh

Re: help me out for this problem...

> > 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

dra 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

abase 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

Question: java/struts, utf8, mysql413

at'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.

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

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

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 P

Re: Read past Equivalent in MySQL

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 pr

Read past Equivalent in MySQL

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

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 20

MySQL 4.1.3 Java/UTF8 support question

t;, 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 i

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-20

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]>

jUDDI DataSource Connection Problem (Cannot create PoolableConnectionFactory)

x27;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

INSERT INTO FROM same table failing

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!

; > 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, >

Inner join question!

, 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

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

Regarding : Directory CheckSum Error ---- Urgently Required

oon 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 P