Eben <[EMAIL PROTECTED]> wrote on 06/05/2008 02:44:42 PM:
> I have the following tables:
>
> table1
> ---
> id1
> some_field
>
> table2
> ---
> id
> id1
> score
>
> table3
> ---
> id
> id1
> score
>
> I then have the following query:
> SELECT table1.id,SUM(table2.score) as table2_s
Hi,
I have the following problem:
mysql Ver 14.12 Distrib 5.0.51a, for portbld-freebsd6.3 (i386) using 5.0
080605 15:33:26 - mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly bui
Hi,
I have the following problem:
080605 15:33:26 - mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardwa
What you need, basically, is to combine two queries, one of which addresses
t1 and t2 while the other addresses t1 and t3. Create two views similar to
your first query and then join the two views on t1.id and you'll get what
you're after.
hth,
Arthur
On Thu, Jun 5, 2008 at 3:44 PM, Eben <[EMAIL
I have the following tables:
table1
---
id1
some_field
table2
---
id
id1
score
table3
---
id
id1
score
I then have the following query:
SELECT table1.id,SUM(table2.score) as table2_score
FROM table1, table2
WHERE table1.some_field = 'value'
AND table2.id1 = table1.id
GROUP BY table
Even more when you compare to a script executing the inserts, instead the
mysql client...
Olaf
On 6/5/08 12:06 PM, "mos" <[EMAIL PROTECTED]> wrote:
> At 10:30 AM 6/5/2008, you wrote:
>> Simon,
>>
>> In my experience load data infile is a lot faster than a sql file htrough
>> the client.
>> I
Olaf, Mike
Thanks for the input, the blob data is just text, I'll have a go at
using the load data command
Regards
Simon
mos wrote:
At 10:30 AM 6/5/2008, you wrote:
Simon,
In my experience load data infile is a lot faster than a sql file
htrough
the client.
I would parse the sql file an
At 10:30 AM 6/5/2008, you wrote:
Simon,
In my experience load data infile is a lot faster than a sql file htrough
the client.
I would parse the sql file and create a csv file with just the columns of
your table and then use load data infile using the created csv file
Olaf
Olaf,
Using a
Simon,
In my experience load data infile is a lot faster than a sql file htrough
the client.
I would parse the sql file and create a csv file with just the columns of
your table and then use load data infile using the created csv file
Olaf
On 6/5/08 4:52 AM, "Simon Collins" <[EMAIL PROTECTED]>
Sebastian Mendel wrote:
did you take a look add the MySQL log?
there you can see what MySQL is doing, with times
perhaps i wasn't clear earlier. we checked the logs, and we see that
Innodb is started and accepting connections sometimes 1-6 seconds AFTER
we see the Windows ServiceManager repo
Hi!
MySQL is an open-source product. That allows anyone to contribute
patches and new features from the community.
In time, when the feature is mature, it may be included in some future
version.
Documentation on this feature is very limited because the (2) people
behind the project have o
>-Original Message-
>From: Les Schaffer [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, June 04, 2008 9:23 PM
>To: mysql@lists.mysql.com
>Subject: mysqld-nt Windows service: delay btwn svc running and accepting
>conx
>
>We are having a small technical glitch about which we would like to have
>s
Thanks Everybody,
I went through the project and was a little dissapointed with MySQL not
supporting Java natively as yet. Let's hope we include this support in
coming future.
Also, there is not enough documentation for the project mentioned:
http://forge.mysql.com/wiki/ProjectPage_External_Langua
Hi Simon,
what kind of table you are using. If it is myisam you can increase the max size
of table by changing the following variable
myisam_data_pointer_size = 7
as default it should be 6.
Please let me know if that helps you.
Thanks,
Saravanan
--- On Thu, 6/5/08, Simon Collins <[EMAIL PR
Hi All,
We have proc which create around 7 table, inserts data , creates indexes and
then run analyze table command.
The analyze table command on 7 tables are taking around 18 hrs. They are
myisam table.
The db server has 8 cpu, 16gb RAM, with both innodb and myisam.
Is there a way we can improve
I can do - if the load data infile command definitely improves
performance and splitting the file does the same I have no problem with
doing this. It just seems strange that it's problems with the way the
import file is configured. I thought the problem would be somehow with
the table getting
You could load the data into several smaller tables and combine them
into a merged table which would have no real effect on the schema.
Ade
Simon Collins wrote:
I'm loading the data through the command below mysql -f -u root -p
enwiki < enwiki.sql
The version is MySQL 5.0.51a-community
I've
Simon,
Why dont u split the file and use LOAD DATA INFILE command which would
improve the performance while loading into an empty table with keys
disabled.
regards
anandkl
On 6/5/08, Simon Collins <[EMAIL PROTECTED]> wrote:
>
> I'm loading the data through the command below mysql -f -u root -p e
Hi Marti,
Thanks for the info, i had read this doc. Just wanted to confirm.
So based on doc, sort_buffer_size is also used by myisam tables using group
by or order by in their select statement, does it help in creating indexes
also for myisam tables.
regards
anandkl
On 6/5/08, Martijn Tonies <[E
I'm loading the data through the command below mysql -f -u root -p
enwiki < enwiki.sql
The version is MySQL 5.0.51a-community
I've disabled the primary key, so there are no indexes. The CPU has 2
cores and 2 Gigs memory.
The import fell over overnight with a "table full" error as it hit 1T (
Sorry, should've sent an update last night. That was indeed the
problem. It's fixed now.
Thanks to everyone who helped.
-Stut
--
http://stut.net/
On 5 Jun 2008, at 09:04, Ben Clewett wrote:
It could be the size of your InnoDB log files. Or something else
which stops InnoDB running.
I o
It could be the size of your InnoDB log files. Or something else which
stops InnoDB running.
I once changed server and by mistake changed the size of the
innodb_log_file_size. The result was that InnoDB could not start and
instead dissabled its self. Therefore every table I created became M
Hi,
> Is sort_buffer_size works only for innodb or both myisam and innodb.
>
> Or should i use myisam_sort_buffer_size for myisam
According to:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
myisam_sort_buffer_size:
The size of the buffer that is allocated when sorting MyIS
Hi All,
Is sort_buffer_size works only for innodb or both myisam and innodb.
Or should i use myisam_sort_buffer_size for myisam
Hi,
I am looking for a query which can give all the dates of months. Inputs are
year and month.
--
Krishna Chandra Prajapati
25 matches
Mail list logo
