Re: innodb rollback 30x slower than commit normal?

2009-05-09 Thread Simon J Mudd
nik...@doppelganger.com (Nikita Tovstoles) writes: We have a java-based webapp that talks to MySQL 5.1 INNODB in READ_COMMITTED. We use Hibernate and optimistic concurrency, so periodically concurrent write attempts cause app-level Exceptions that trigger rollbacks (and then we retry tx).

Re: Help with mysql query, multiple list

2009-05-09 Thread Simon J Mudd
abhishek@gmail.com (Abhishek Pratap) writes: I am kind of stuck with this query , cant expand my thinking. May this is a limitation. Here it is I have a database with many cols two of which are start and end position for an event. Now I have a list of event time stamps, I want to

splitting large tables vertically

2009-05-09 Thread Kyong Kim
I was wondering about a scale out problem. Lets say you have a large table with 3 cols and 500+ million rows. Would there be much benefit in splitting the columns into different tables based on INT type primary keys across the tables? The split tables will be hosted on a same physical instance

Still going in cicrles

2009-05-09 Thread michel
I set up MySQL and when I try to start it it fails telling me that I need to run 'mysql_upgrade'. When I run 'mysql_upgrade' it runs 'mysqlcheck' which is supposed to only be run when the server works ...

Re: Problems After MySql 5.1.34 - THANKS

2009-05-09 Thread Johnny Stork
Thanks to everyone that offered all the valuable suggestions. SImply replaced the shared-community with shared-compat and all seesm fine. Will live with, or deal with, the missmatch in php libraries later, but for now everything seems to work. Thanks again to everyone that offered such

Need MySQL Logo for public use.

2009-05-09 Thread Tim Johnson
Since MySQL is one of our tools, we would like to have a logo that we can use at our website. And we will use it to link back to the MySQL site. Can someone point me to MySQL logos that I can legitimately use? Thanks Tim -- MySQL General Mailing List For list archives:

Re: splitting large tables vertically

2009-05-09 Thread mos
Do the 3 tables have different column structures? Or do they all have the same table structure? For example, is Table1 storing only data for year 1990 and table 2 storing data for 1991 etc? If so you could use a merge table. (Or do you need transactions, in which case you will need to use