Jack Bates schrieb:
Given columns a, b, and c, where I GROUP BY a, how do I get the value of
column b in each group which corresponds to the maximum value of column
c?
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
--
Sebastian Mendel
--
MySQL General Mailing Lis
Les Schaffer schrieb:
We are having a small technical glitch about which we would like to have
some insight:
our application needs to start mysqld-nt as a Windows service after
which we fairly quickly try to make connections to the Server. we are
using the python wrappers, MySQLdb, and we suc
[EMAIL PROTECTED] schrieb:
I have the following table:
explain domain_payments;
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-+---+
| Invid | int(11) |
Hi,
FreeBSD 7 should offer much better performance for MySQL. The FreeBSD
kernel developers have found ways to relieve some of the kernel
bottlenecks which permit multithreaded applications to operate much
better.
Regards,
Antony.
On 3 Jun 2008, at 03:43, VeeJay wrote:
Hi Guys
I need
Hi,
Check out this link for Java stored procedures with MySQL
http://forge.mysql.com/wiki/ProjectPage_External_Language_Stored_Procedures
It is probably what you are looking for. I have some more info on my
blog at http://antbits.blogspot.com/
For more information, you can email Eric Herman
Hi,
Break up the file into small chunks and then import one by one.
On Wed, Jun 4, 2008 at 10:12 PM, Simon Collins <
[EMAIL PROTECTED]> wrote:
> Dear all,
>
> I'm presently trying to import the full wikipedia dump for one of our
> research users. Unsurprisingly it's a massive import file (2.7T)
I have the following table:
explain domain_payments;
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-+---+
| Invid | int(11) | | | 0 |
We are having a small technical glitch about which we would like to have
some insight:
our application needs to start mysqld-nt as a Windows service after
which we fairly quickly try to make connections to the Server. we are
using the python wrappers, MySQLdb, and we successfully bring up the
On 5 Jun 2008, at 00:41, Phil wrote:
Just a very quick guess but is innobd engine running ?
SHOW STATUS like '%inno%'
Output shown below. I've just finished importing the backup file again
(into a different DB) and it's ignored the engine=innodb on each
create table and has used MyISAM ins
Just a very quick guess but is innobd engine running ?
SHOW STATUS like '%inno%'
On Wed, Jun 4, 2008 at 6:44 PM, Stut <[EMAIL PROTECTED]> wrote:
> On 4 Jun 2008, at 23:10, Stut wrote:
>
>> HELP!!
>>
>> Our database just died. SHOW TABLE STATUS shows the message in the status
>> line for every ta
On 4 Jun 2008, at 23:10, Stut wrote:
HELP!!
Our database just died. SHOW TABLE STATUS shows the message in the
status line for every table except the one that's MyISAM - the rest
are InnoDB.
Is there any way to rebuild the .frm files for the InnoDB tables?
Can anyone help? I know I haven
HELP!!
Our database just died. SHOW TABLE STATUS shows the message in the
status line for every table except the one that's MyISAM - the rest
are InnoDB.
Is there any way to rebuild the .frm files for the InnoDB tables?
-Stut
--
http://stut.net/
--
MySQL General Mailing List
For list arc
Given columns a, b, and c, where I GROUP BY a, how do I get the value of
column b in each group which corresponds to the maximum value of column
c?
I have a table which contains some translated records. Column a is the
record id, column b is a translated field e.g. the title, and column c
is a lan
Simon,
As someone else mentioned, how are you loading the data? Can you
post the SQL?
You have an Id field, so is that not the primary key? If so, the
slowdown could be maintaining the index. If so, add up to 30% of your
available ram to your key_bufer_size in your my.cnf file
Hi Simon,
How ur doing this import into ur table.
On 6/4/08, Simon Collins <[EMAIL PROTECTED]> wrote:
>
> Dear all,
>
> I'm presently trying to import the full wikipedia dump for one of our
> research users. Unsurprisingly it's a massive import file (2.7T)
>
> Most of the data is importing into
Dear all,
I'm presently trying to import the full wikipedia dump for one of our
research users. Unsurprisingly it's a massive import file (2.7T)
Most of the data is importing into a single MyISAM table which has an id
field and a blob field. There are no constraints / indexes on this
table.
In the last episode (Jun 04), Abhayjeet Singh Grewal said:
> Thanks Martin,
>
> I looked at the link, but I guess I was not able to put my question
> in the right way.
>
> Basically I have a Java Package and I want to call that package from
> MYSQL function or procedure.
I don't think that's poss
On 4 Jun 2008, at 15:53, Ben Clewett wrote:
As far as I am aware, the index's are built on import.
It may be that the key-buffer or innodb-buffer (depending on
engine), and the query cache, are all cold. May take a day or so to
build them up depending on size and load.
Other than that the
As far as I am aware, the index's are built on import.
It may be that the key-buffer or innodb-buffer (depending on engine),
and the query cache, are all cold. May take a day or so to build them
up depending on size and load.
Other than that there must be some external difference. Is it the
Hi,
I just finished restoring a 22gig SQL dump but the server is not
performing anywhere near where it should be. I'm assuming this is
because it's still rebuilding indexes on the imported tables.
Is there any way to see the indexing status so I can gauge how far
it's got?
Thanks.
-Stu
Hello all!
I have a little problem with mysql
I got in an inheritance a database in tar archive (/var/lib/mysql/db_name
in db_name.tar.gz)
I only put this db (in /var/lib/mysql/) on another server an restart mysql
daemon
show databases; shows that database imported... but I am not sure in e
co
Hi all !
VeeJay wrote:
[[...]]
At my job, I am going to build a Web Server with
1. FreeBSD 7.0-RELEASE amd64
2. Apache 2.2.8
3. PHP 4.4.8 (or may be PHP5, what do you suggest?)
Server's hardware configuration is as follow:
2 x Quad Core Xeon E5450 3.0GHz,2x6MB,1333FSB
16GB (8x2GB Dua
use ports please.
On Tue, May 27, 2008 at 11:57 AM, kalin m <[EMAIL PROTECTED]> wrote:
> hi all.. i cant see a package
> for freebsd 7 on the mysql site. which onw should i build 6 or 5.1?
>
> thanks...
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To uns
Thanks Martin,
I looked at the link, but I guess I was not able to put my question in the
right way.
Basically I have a Java Package and I want to call that package from MYSQL
function or procedure.
Any help would be much appreciated.
Thanks,
Abhay
On Tue, Jun 3, 2008 at 9:32 PM, Martin <[EMAIL
Hi All,
I have released PrimeBase XT (PBXT) 1.0.03 Alpha and it is available
for download from http://www.primebase.org/download.
I have also posted binary plugins for a few platforms, in particular:
32-bit and 64-bit Linux and Mac OS X (x86). These plugins can be
loaded at runtime by the
25 matches
Mail list logo
