Memory problem.
Error 12 = Cannot allocate memory
Marc.
-Message d'origine-
De : Cliff Daniel [mailto:[EMAIL PROTECTED]
Envoyé : jeudi 21 avril 2005 07:43
À : mysql@lists.mysql.com
Objet : UNIONS 'Got error 12 from storage engine'
Have a query that consists of 10 unions. For a
Hi Douglas, all!
Am Mi, den 20.04.2005 schrieb [EMAIL PROTECTED] um 17:33:
Is the online documentation for 4.0.x available? I was working with
dates a while back. As it happens 4.1 added the very function I wanted.
But that was not marked as added in 4.1, nor should be be as that would
be an
Hi Roger,
You are ok, there was an index problem in one table, they name of the rows
wasn't equal and MySQL didn't recognize they as the same index. I have
changed the row name and now is working fine, but I have a little question,
How can I use indexes with different names in it's tables?
Thanks for your lengthy responses everyone. I ended up using sequences
which are available with PEAR MDB2 and DB, so i get the currentID + 1
while inserting, but as you say another entry could have gone in during
the process, but this happens during the insert stage. I might have to
revert
Hello.
Are you sure that there are no official binaries for you platform?
If you have an uncommon OS, process of building MySQL from source could
be hard. I suggest you to use gmake instead of make.
I am in the process of building MySQL version 4.1.11 as an upgrade from
4.0.16. This
Hello.
I'm not sure if it is possible to find on-line documentation for 4.0.x
version, but you can download the old release, documentation is shipped
with it. Archives are at:
http://downloads.mysql.com/archives.php
[EMAIL PROTECTED] wrote:
Is the online documentation for 4.0.x
I'm not sure if you're a novice to databases in general or just MySQL but if
you aren't quite sure what a join is, I suspect you must be new to
relational databases in general.
In that case, may I recommend that you seriously consider devoting some time
to learn SQL? This is the language used by
Willie Gnarlson [EMAIL PROTECTED] wrote on 04/20/2005 05:46:25
PM:
On 4/20/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Willie Gnarlson [EMAIL PROTECTED] wrote on 04/20/2005
01:56:03 PM:
On 4/20/05, Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Apr 20), Willie Gnarlson
Hi,
we have the problem, that queries generated by JBoss or our code which
runns under JBoss will be not cached by MySQL. The same query sendet from
an external application or MySQLFront will be cached by the same MySQL.
I'm using JBoss 3.2.5 with JDBC 3.0.16 and MySQL 4.0.23a.
Any idea why?
The problem is something fairly simple but yet MySQL seems to make this
complicated. Essentially, find a list of customers who have not bought product
X ever. (Customers have orders, orders have order line items). All 3 coworkers
independently arrived at the same sql which failed to work.
Hello,
I have created some databases and tables, a while back, as a new user. I
believe when the system was installed it asked me fora root username and
password. And I set one.
I have some databases, and I would like to find out two things:
1) Who owns what database and its tables: Is there
At 9:44 -0500 4/21/05, Scott Purcell wrote:
Hello,
I have created some databases and tables, a while back, as a new
user. I believe when the system was installed it asked me fora root
username and password. And I set one.
I have some databases, and I would like to find out two things:
1) Who
From: James Nobis
SELECT DISTINCT Customer.id, Customer.name
FROM Customer
LEFT JOIN `Order` ON Customer.id = Order.customer_id
INNER JOIN OrderLines ON Order.id = OrderLines.order_id
AND OrderLines.product_id =9
WHERE Order.customer_id IS NULL
I expect customers to have placed at least one
Greetings,
I am running Mysql 3.23. Is there an sql statment that will allow me
programmatically
to retrieve the names of the tables in a database ?
thanks,
Darryl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
At 10:22 -0500 4/21/05, Darryl Hoar wrote:
Greetings,
I am running Mysql 3.23. Is there an sql statment that will allow me
programmatically
to retrieve the names of the tables in a database ?
http://dev.mysql.com/doc/mysql/en/show-tables.html ?
--
Paul DuBois, MySQL Documentation Team
Madison,
At 11:22 AM 4/21/05, Darryl Hoar wrote:
I am running Mysql 3.23. Is there an sql statment that will allow me
programmatically to retrieve the names of the tables in a database ?
show tables;
Yes, this is an SQL statement!
--
MySQL General Mailing List
For list archives:
http://dev.mysql.com/doc/mysql/en/show-tables.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I'm having a problem with query running very slowly. I run similar
queries on other tables all the time that perform as expected, and
this query used to run fine until I removed an explicit LEFT JOIN and
let the optimizer decide in what order to join two of the tables.
That fixed some
James Nobis [EMAIL PROTECTED] wrote on 04/21/2005
10:44:07 AM:
The problem is something fairly simple but yet MySQL seems to make this
complicated. Essentially, find a list of customers who have not
bought product
X ever. (Customers have orders, orders have order line items). All
3
There is nothing wrong with what MySQL is doing. Your query is
incorrect for what you are looking for. Step through your query and
you'll see your error.
SELECT DISTINCT Customer.id, Customer.name
FROM Customer
LEFT JOIN `Order` ON Customer.id = Order.customer_id
You now have a list of the all
In the last episode (Apr 21), Scott Gifford said:
I'm having a problem with query running very slowly. I run similar
queries on other tables all the time that perform as expected, and
this query used to run fine until I removed an explicit LEFT JOIN and
let the optimizer decide in what order
Thanks everyone for such quick and thorough responses!
Quoting [EMAIL PROTECTED]:
James Nobis [EMAIL PROTECTED] wrote on 04/21/2005
10:44:07 AM:
The problem is something fairly simple but yet MySQL seems to make this
complicated. Essentially, find a list of customers who have not
bought product
X
Dto. Sistemas de Unitel wrote:
Hi Roger,
You are ok, there was an index problem in one table, they name of the rows
wasn't equal and MySQL didn't recognize they as the same index. I have
changed the row name and now is working fine, but I have a little question,
How can I use indexes with
You don't understand me, I refer that if in a table I use productos.prod_id
and in other table indexes.id if I can use this two fields like the same
index, because when I named the two equal, the index start to work fine.
Thanks
-Mensaje original-
De: Roger Baklund [mailto:[EMAIL
Thank you for the clear statement of policy. I had in fact forgotten
about the manual that comes with the installation. It however is
packaged as one rather large html or text file (my system is FreeBSD).
The web site is a far superior reference because of the file format.
Doug
On Thu, 21 Apr
I´ve installed MYSQL CONTROL CENTER 0.9.4 beta,
when i tried to test the aplication, i get this error ERROR 2005: Unknow
MYSQL Server Host 'abc'/(11001).
Thanks, i'm waiting your answer as soon as possible.
Ercilio
-
Yahoo! Acesso Grátis:
On 4/21/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Willie Gnarlson [EMAIL PROTECTED] wrote on 04/20/2005 05:46:25 PM:
On 4/20/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Willie Gnarlson [EMAIL PROTECTED] wrote on 04/20/2005
01:56:03 PM:
On 4/20/05, Dan Nelson [EMAIL
On 4/21/05, Willie Gnarlson [EMAIL PROTECTED] wrote:
(...)
It actually seems slower. The separate tables from a previous try look
like this:
CREATE TABLE `ET` (
`ET` double NOT NULL default '0',
PRIMARY KEY (`ET`),
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
That table has 4781
Willie Gnarlson [EMAIL PROTECTED] wrote on 04/21/2005 01:39:15
PM:
On 4/21/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Willie Gnarlson [EMAIL PROTECTED] wrote on 04/20/2005
05:46:25 PM:
On 4/20/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Willie Gnarlson [EMAIL PROTECTED]
hi
I've got a problem with a crushed innodb table (as i think)
When I'm trying to make a backup, something like this appears:
mysqldump: Error 2013: Lost connection to MySQL server during query
when dumping table `adstats` at row 34342;
trying to check table:
mysql check table adstats extended;
I've been seeing some weirdness w/ MySQL and InnoDB over the past few days.
I have a database that's entirely using InnoDB. The database is roughly
4.5G (one datafile) and contains a little over 50 tables. The web
applications that hit this database do about 85-90% reads and 10-15% writes.
I could understand this simple SQL statement:
SELECT
Associates.LastName + ', ' + Associates.FirstName as name,
Production.Hours,
Production.Quantity
FROM
production,
Associates
WHERE
Associates.ID=Production.OID;
Would produce full name in table.
However when I used left join
Hello, we have a web based application where the mysql server runs on a
separate box from the code. The 2 boxes are on the same subnet so there
really shouldn't be any latency issues(emphasis on shouldn't .) but we're
trying to track down some timeout glitches in the application. I was
wondering
For starters, compare timings between running a query between the
machines and one local to the machine. Use the command line client, not
your web server. See if there is a significant time difference. If
there is, there is probably something wrong on your network. If not,
then you should
At 03:20 PM 4/21/05, Scott Hamm wrote:
However when I used left join (trying to learn it) I issued this command:
SELECT
QA.OperatorID,
QA.QAID,
QA.BrandID,
QA.Batch,
QA.KeyDate,
Batch.[Order],
Batch.Errors,
Batch.Comments
FROM
Andy McCurdy wrote:
I've been seeing some weirdness w/ MySQL and InnoDB over the past few days.
I have a database that's entirely using InnoDB. The database is roughly
4.5G (one datafile) and contains a little over 50 tables. The web
applications that hit this database do about 85-90% reads
On 4/21/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Willie Gnarlson [EMAIL PROTECTED] wrote on 04/21/2005 01:39:15
PM:
On 4/21/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Willie Gnarlson [EMAIL PROTECTED] wrote on 04/20/2005
05:46:25 PM:
On 4/20/05, [EMAIL PROTECTED] [EMAIL
Hello,
Currently I am using sysklogd-sql to store syslog messages in a MySQL
4.0.24. The current number of rows is around 3,799,700.
The table layout is as follows:
ID
machine
facility
priority
date1
message
Now ID is the primary key and it had one index called hostname
containing
I have a field that has been given to me as all uppercase, they are City
names, some are more than one word.
I need to run a update to:
replacewith
then lowercase them all, then uppercase the first letter and any first
letter after a space.
--
Michael Gale wrote:
When I run the following:
`Select DISTINCT machine from syslog WHERE date1 (NOW() - INTERVAL 1
hour);' it takes 9min to complete.
If I use Explain it says the query is using index hostname, should
it not be using the index hostdate which contains fields machine and
date1
Hi,
I updated my 4.0 install to 4.1 and now NONE of my
databases and tables show up at all.
Im on OS X.3.9.
All the files are there in the data folder, permissions are
set, what did I do wrong ? Any suggestions as to how to get it
back ?
M i l e s.
--
MySQL General Mailing List
For list archives:
I forgot to mention: we're running mysql version 4.0.23-standard-log --
Official MySQL-standard binary. Here's the innodb status output during a
problematic period.
=
050421 15:29:46 INNODB MONITOR OUTPUT
=
Per second
Dto. Sistemas de Unitel wrote:
You don't understand me, I refer that if in a table I use productos.prod_id
and in other table indexes.id if I can use this two fields like the same
index, because when I named the two equal, the index start to work fine.
There should be no problem with joining two
Hi,
For years i've been using MySQL 3.23, but now that i'm about to
reinstall my company's web server, i've decided that it's time to go to 4.1
I've read quite a few things in the web about migrating the databases,
*including the mysql one*, but each article i read, pointed me in a
different
Hello,
Thanks to all who applied but I was able to get access to the log file
today. The server was shutting down and it seemed to be a performance
problem.
I increased the RAM in the server and adjusted the Innodb settings to
take advantage of this.
Now everything is much better.
Michael
45 matches
Mail list logo