[ANNOUNCE] Let's Party! (table partitioner) 0.1 released

Let's Party! provides any database with table partitioning capabilities (as long as it is accessed using JDBC). Why table partitioning? Because: 1. If you put your partitions on different hard disks you will gain throughput 2. Scans of tables will require less time, because you will access less

distributed queries

Is there any way to issue a distibute query with mysql, such as SELECT * from mytab JOIN (SELECT * FROM another_server_on_another_machine.MYTAB2) ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: On the licensing once again

> If you develop a product, say, some kind of online shopping > system that you > distribute on a CD which installs Linux, Apache, MysQL, PHP and > your App and > distribute that, then you probably should be paying for a license. This is > because instead of you handing over full code (and it's rig

R: On the licensing once again

> If you develop a product, say, some kind of online shopping > system that you > distribute on a CD which installs Linux, Apache, MysQL, PHP and > your App and > distribute that, then you probably should be paying for a license. This is > because instead of you handing over full code (and it's rig

R: On the licensing once again

What if I sell a web site built using mysql? Do I need a license on my web server? > -Messaggio originale- > Da: Lachlan Mulcahy [mailto:[EMAIL PROTECTED] > Inviato: mercoledi 11 agosto 2004 13.14 > A: [EMAIL PROTECTED] > Oggetto: RE: On the licensing once again > > > Essentially the spi

R: Best table structure

> Would I be better keeping this format and inserting multiple rows on each > submit, or to have one row for all 81 variables ($name, 20 x > Position, 20 x > Artists, 20 x Titles, 20 x Labels.) > I know that the latter will be easier to query. Are you sure? Why? > Also, without maintenance, the

R: info about MySQL Server

try removing your client for the moment: can you try a load data infile and see at what speed mysql loads the rows? > -Messaggio originale- > Da: Alfredo Marchini [mailto:[EMAIL PROTECTED] > Inviato: venerdì 25 giugno 2004 18.21 > A: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; > [EMAIL PRO

R: R: connectorJ & huge table problem

> Leonardo, > > Earlier you said that a statement without a parameter ('?') works, but > one with a parameter doesn't. > > In both cases, are you still using a PreparedStatement? > > -Mark > yes, it is always a preparedstatement. If you need more details (or you want me to try something

R: R: R: connectorJ & huge table problem

> Next time you come over, maybe you can help hold him or take the shot. > He's such a pain to take pictures of, he walks right up to the camera. Mmmh... my English is very bad... I can't understand... is it a joke or just a mistake? -- MySQL General Mailing List For list archives: http://lis

R: connectorJ & huge table problem

> What happens if you use a nightly snapshot of Connector/J from > http://downloads.mysql.com/snapshots.php? I tried, but I still have the same problem: java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: 6 at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepa

R: R: connectorJ & huge table problem

> It looks as if you are being over-complex anyway. Isn't what you want > > SELECT * FROM PARTITIONED_B ORDER BY RAND() LIMIT 1 ; > > which picks a single random record. No, I have to know which is the ID I pick before doing the select (because I splitted my data, and when I access the splitted

R: connectorJ & huge table problem

rt a bug in a couple of days... > -Messaggio originale- > Da: Leonardo Francalanci [mailto:[EMAIL PROTECTED] > Inviato: martedì 22 giugno 2004 15.09 > A: Mysql > Oggetto: R: connectorJ & huge table problem > > > I have also weird results: > I access data

R: connectorJ & huge table problem

> A non-streaming connection will place the resultset in memory. With large > tables you can run out of memory and the application will stop. I get only 1 record per time (accessing by key), so I don't think it could be an issue. Thank you anyway! -- MySQL General Mailing List For list archi

R: connectorJ & huge table problem

> Dude. I wouldn't post your server ip here. ouch. Well, it's a LAN address! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

R: connectorJ & huge table problem

.executeQuery(); boolean c = false; while (rs.next()) { int g = rs.getInt(2); if (c) { // this shouldn't happen, because I'm selecting by ID, but it happens! System.out.println(m + " " + g); } c = true; } > -Messaggio originale- > Da: Leonardo Francalanc

R: connectorJ & huge table problem

> Are you using a streaming connection? ehm... how do I know? My conn string is jdbc:mysql://192.168.0.253:3000/LETSPARTY1?autoReconnect=yes where 192.168.0.253 is a machine on my LAN... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

connectorJ & huge table problem

I have a large table (64,000,000 rows). Everything was fine when the table was 16,000,000 rows, now connectorJ crashes: java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: 6 at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStateme nt.java:908) at

R: R: R: why CPU is high while disks are idle in a table scan???

gt; -Messaggio originale- > Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Inviato: martedi 22 giugno 2004 15.22 > A: Leonardo Francalanci > Cc: Mysql > Oggetto: Re: R: R: why CPU is high while disks are idle in a table > scan??? > > > > Well, this is a very uniq

R: R: why CPU is high while disks are idle in a table scan???

First: thank you for sparing so much time with me. > There are 3 major factors determining your performance: 1) the > speed of the > CPU, 2) the size if your RAM, and 3) the data transfer speed of > your disks. I thought that the size of tables in the db would have made a difference. >From the

R: R: why CPU is high while disks are idle in a table scan???

> Oh. You didn't say thta. :-) Well, I wrote " Doing a simple "SELECT SUM(MYFIELD) FROM MYTABLE" I noticed " but don't worry ;) > How much RAM does your machine have? If it's nearly all cached, > you'll be CPU bound rather than disk bound. 1Gb. I'm using Solaris 8. The SUM() works as expect

R: why CPU is high while disks are idle in a table scan???

Sorry, now it runs as espected (but I don't know what happened, maybe doing other queries I emptied out the cache) Thank you anyway for your replies. And: could somebody answer my previous question? I wrote: I have to deal with pretty big data, such a table (say BIG_TABLE) with 16.000.000 of r

R: why CPU is high while disks are idle in a table scan???

> Hard to say, but in a table scan the CPU does have a lot of work to > do. It needs to do about 16,000,000 comparisons (based on your info). Why comparison? It's a sum... And the table is not small: 272,000,000 bytes! And disk is very low (almost 0%) -- MySQL General Mailing List For list arc

why CPU is high while disks are idle in a table scan???

I'm doing some tests on a 16.000.000 rows table. Doing a simple "SELECT SUM(MYFIELD) FROM MYTABLE" I noticed that disks are at 0.1%, while cpu arrives up to 80%. How is that possible? My HDs are IDE. MySql has around 30Mb of ram, I thought it should read a lot from disk. Even doing lots of queries

performance splitting data

I have to deal with pretty big data, such a table (say BIG_TABLE) with 16.000.000 of rows. The table has just one primary index (a simple int). I thought that splitting data among multiple tables would have boosted performance, so I put my data in 16 different tables (everything is on one disk). T

R: R: query string make mysqld crash (mysqld 4.0.20)

ilto:[EMAIL PROTECTED] > Inviato: lunedi 14 giugno 2004 21.56 > A: Leonardo Francalanci > Cc: [EMAIL PROTECTED] > Oggetto: Re: R: query string make mysqld crash (mysqld 4.0.20) > > > Leonardo Francalanci wrote: > > I have a similar problem with a list of union(s) (see my

R: query string make mysqld crash (mysqld 4.0.20)

I have a similar problem with a list of union(s) (see my email, one hour before yours). It seems there is something in the way mysql parses the string that makes it crash. I tried with version 4.1.2 as well, but it keeps on crashing. > -Messaggio originale- > Da: Chambon [mailto:[EMAIL PRO

I: R: R: R: R: query string too long?

I still have this problem... should I submit a bug? -Messaggio originale- Da: Leonardo Francalanci [mailto:[EMAIL PROTECTED] Inviato: mercoledì 2 giugno 2004 14.19 A: [EMAIL PROTECTED] Oggetto: R: R: R: R: R: query string too long? > Test it on 4.1.2 and let me know if these quer

R: R: R: R: R: query string too long?

> Test it on 4.1.2 and let me know if these queries will crash > MySQL server. Yes, the query (SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS PARTITI

R: Unable to Programatically Create DB Connection

try adding a Class.forName("com.mysql.jdbc.Driver").newInstance() before DriverManager.getConnection(... It should register the mysql jdbc driver. > -Messaggio originale- > Da: Scott D. Spiegler [mailto:[EMAIL PROTECTED] > Inviato: martedi 25 maggio 2004 18.37 > A: [EMAIL PROTECTED] >

R: Large sample data sets for testing

Have you tried dbmonster? http://dbmonster.kernelpanic.pl/index.html It generates random data for you. > -Messaggio originale- > Da: Greg Willits [mailto:[EMAIL PROTECTED] > Inviato: venerdi 21 maggio 2004 21.17 > Cc: MySql > Oggetto: Large sample data sets for testing > > > Anyone know

R: R: R: R: query string too long?

> Test it on 4.1.2 and let me know if these queries will crash MySQL server. Mmh, I'm afraid I will have to wait for binaries... When do you think 4.1.2 binaries will be available? Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:/

R: R: R: query string too long?

> > v4.1.2? Where can I get it? > > > > You can install it from development source tree: > http://dev.mysql.com/doc/mysql/en/Installing_source_tree.html > > or wait when binaries will be available. I'll wait for binaries... At the moment even a query like (SELECT * FROM REGULAR_copy) U

R: R: query string too long?

> I tested it on with my test data for others PARTITIONED_*_* > tables on v4.1.2 and SELECT worked well. v4.1.2? Where can I get it? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

R: query string too long?

> Could you provide structure of tables and some data for testing? How? I tried to post a couple of zip files (2 mails, 10k each) but it doesn't work. Some data (and schema) CREATE TABLE IF NOT EXISTS PARTITIONED2_1 ( ID int(3) unsigned NOT NULL DEFAULT '0' , DATA1 timestamp , PRIMARY KEY (

query string too long?

I'm using MySql version 4.1.1. When I issue a query like (SELECT * FROM PARTITIONED_1_1 AS PARTITIONED, PARTITIONED2_1 AS PARTITIONED2 WHERE PARTITIONED2.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_2_1 AS PARTITIONED, PARTITIONED2_1 AS PARTITIONED2 WHE RE PARTITIONED2.ID=PARTITIONED.ID1)