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
D
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 dire
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 ta
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 averag
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:
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
"
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:
replace " " with " "
then lowercase them all, then uppercase the first letter and any first
letter after a space.
--
---
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 (mach
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
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 an
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
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 check
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
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 (try
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.
Wh
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;
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 <[E
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
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 Nels
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: In
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 200
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 PROTECTE
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 different
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
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 ord
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 y
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
>
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 othe
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]
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://lists.mysql.com/m
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, Wis
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 PR
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 le
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 own
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 a
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. Then,
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?
Reg
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),
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 a
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
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
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 the
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?
Than
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
44 matches
Mail list logo
