Hello Jeremy,
I have a curious issue here, maybe someone can help.
I have a single process that inserts data into tables that contain
purely logging information. This table is then searched by our Care
department to troubleshoot issues. I am looking for the best way to
store this
Martijn Tonies wrote:
Hello Jeremy,
I have a curious issue here, maybe someone can help.
I have a single process that inserts data into tables that contain
purely logging information. This table is then searched by our Care
department to troubleshoot issues. I am looking for the best way to
On Wed, 19 Jan 2005 [EMAIL PROTECTED] wrote:
Hi,
Is replication of database is possible in MySQL 4.0.21?.
Yes.
If not from which version it is available?. Could any one of you please
provide some helpful information about how to do the replication?.
Steve,
Below is output from the mysql_fix_privilege_tables script:
You can safely ignore all 'Duplicate column' and 'Unknown column' errors
because these just mean that your tables are already up to date.
I would not worry about the Duplicate Key error, because that is likely
the same case as
Hi list,
The following sql statement takes 3 mintues to complete the query. How
can I improve its speed?
select DISTINCT i.basename from inventory i, transaction t, customer c
where i.prodcode = t.prodcode and c.custcode = t.custcode and i.basename
is not NULL and i.prodname is not NULL and
Sam,
Can you send the output of the following:
#explain your query\G
Clint
From: sam wun [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: sub query is extermely slow
Date: Wed, 19 Jan 2005 20:02:37 +0800
Hi list,
The following sql statement takes 3 mintues to complete the query. How can
I
Clint Edwards wrote:
Sam,
Can you send the output of the following:
#explain your query\G
Thanks for the suggestion, here is the output of the explain query:
mysql explain select DISTINCT i.basename from inventory i, transaction
t, customer c where i.prodcode = t.prodcode and c.custcode =
Sam,
Can you send the following information:
When was the last time 'analyze table table_name' (inventory, transaction,
customer) was executed?
OS:
MySQL Version:
Available Ram:
Output from 'SHOW CREATE TABLE table_name' (inventory, transaction, and
customer):
Output from SHOW VARIABLES LIKE
I would like for logged-in site visitors to be able to submit comments to be
appended to my database records. I've seen some databases that use a
post-it-note style system. What might be the best way to go about this.
The following conditions apply:
Multiple users may post comments on the same
Have you tried using mysqld_safe --user=mysql
'mysql' being the name of the user you want mysqld to run as.
-Eric
On Tue, 18 Jan 2005 20:33:38 -0800, Russ [EMAIL PROTECTED] wrote:
I'm having trouble getting myslqd to run as a user other than root when it is
started by mysqld_safe. I folowed
Hello.
Is replication of database is possible in MySQL 4.0.21?.
Yes.
from which version it is available?.
3.23.15
Could any one of you please provide
some helpful information about how to do the replication?.
See:
Martijn Tonies [EMAIL PROTECTED] wrote on 01/19/2005 03:33:32 AM:
Hello Jeremy,
I have a curious issue here, maybe someone can help.
I have a single process that inserts data into tables that contain
purely logging information. This table is then searched by our Care
department
Sam,
Can you create an index on transaction.date, then run your query again? If
that is not better send me the output of 'explain query' again.
This index may not be a good idea, depending on how many transaction are in
the table on a specified date.
Clint
From: sam wun [EMAIL PROTECTED]
To:
Clint Edwards wrote:
Sam,
Can you create an index on transaction.date, then run your query
again? If that is not better send me the output of 'explain query'
again.
This index may not be a good idea, depending on how many transaction
are in the table on a specified date.
May I ask how to add
Check ALTER statement in MySQL doc. It explains how to add/modify an index
after a table has been created.
-Original Message-
From: sam wun [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 19, 2005 10:00 AM
Cc: mysql@lists.mysql.com
Subject: Re: sub query is extermely slow
sam wun [EMAIL PROTECTED] wrote on 01/19/2005 07:02:37 AM:
Hi list,
The following sql statement takes 3 mintues to complete the query. How
can I improve its speed?
select DISTINCT i.basename from inventory i, transaction t, customer c
where i.prodcode = t.prodcode and c.custcode =
I have a curious issue here, maybe someone can help.
I have a single process that inserts data into tables that contain
purely logging information. This table is then searched by our Care
department to troubleshoot issues. I am looking for the best way to
store this
Shawn,
Thank you very much for your tips.
I´ll do that.
Ronan
- Original Message -
From: [EMAIL PROTECTED]
To: Ronan Lucio [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, January 18, 2005 6:36 PM
Subject: Re: Doubt about Performance
Ronan Lucio [EMAIL PROTECTED] wrote on
I think it might also be better to remove the function date(tt.date) if
possible ie change
date(tt.date) = 2005-01-31
to
tt.date = correct date format
This will remove the function on the tt table field which I believe will
force a full table scan on what is probably the largest table?
Andy
Hello.
Systems call bind() calls only one time for IP socket and one time
for socket file (from sql/mysqld.cc). So you can specify only one IP
address. Use firewall to suppress undesirable connections.
Cere Davis [EMAIL PROTECTED] wrote:
Hi everyone,
I would like to bind mysqld
CREATE TABLE userComments
(
-- comments_id int unsigned NOT NULL DEFAULT 0 AUTO INCREMENT,
commenter_id int unsigned not NULL default 0,
commented_id int unsigned not null default 0,
relationship tinyint unsigned not null default 0,
comment TEXT NOT NULL default '',
PRIMARY KEY
I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't start
up.
In the console I get these messages:
The database cluster will be initialized with locale C.
creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok
creating directory
At 3:21 PM -0800 1/18/05, Dathan Pattishall wrote:
Somehow your table was zero'ed out, i.e. TRUNCATE / DROP-CREATE.
MYD - data of the table
MYI - index of the table
Frm - TABLE definition
I hope you have a backup.
Ewwch.
I may have a backup. I definitely have the data. Unfortunately, there
Hi Vicki,
If you have a backup of the .MYD file, you should be able to copy this
over the existing one and run myisamchk -r to rebuild the index.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 -
Alex Majora wrote:
I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't
start up.
In the console I get these messages:
The database cluster will be initialized with locale C.
creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok
creating directory
Michael Stassen wrote:
That doesn't appear to be mysql.
Now that I look closely, that must be a database for RMDB. Sorry I got the
two confused.
Are you sure mysqld is running? You got a shutdown message right before
this.
Apparently, it's not running, as there is no mysqld process running in
The postmaster is a Postgres daemon, and pg_shadow is the user table for
postgres.
Clint
From: Michael Stassen [EMAIL PROTECTED]
To: Alex Majora [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: mysql.sock file exists, but still cannot connect to server
Date: Wed, 19 Jan 2005 17:42:34
Hi all
I recently installed SUSE linux and I am running MySQL 4.0.21
The way system is configured, /var ran out of disk space.
I have RAID installed and /data is on raid. So I created a new folder mysql
in /data
and copied all the files from /var/lib/mysql to this folder. I renamed
Is there a workaround for bug 5686?
http://bugs.mysql.com/bug.php?id=5686
We use Debian Linux testing and MySQL 4.1.8
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I've got a DB design issue here, and I would like to hear your views on
this problem.
I've got a website where people can post comments on various ressources :
news, articles, polls, and so on. So every comments are in a table with a
field for the ressource type (news=1,polls=2, and so
Was there a reply to this post? If so, I could have (did) missed it. Can
you please resend?
Rgds
Paul.
Shawn, what language(s) are you using to parse this? Could you share the
code?
Thanks,
Dave Merrill
I prefer to parse the results of a SHOW CREATE TABLE... query. It's
rather trivial to
Additionally, this is what I get when I try to launch mysqld manually:
$ sudo ./bin/mysqld_safe
[1] 2058
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file
/usr/local/mysql/data/whitestar.alpha.net.pid
050119 17:13:12 mysqld ended
Is there a way
Alex Majora wrote:
Michael Stassen wrote:
That doesn't appear to be mysql.
Now that I look closely, that must be a database for RMDB. Sorry I got
the two confused.
Are you sure mysqld is running? You got a shutdown message right
before this.
Apparently, it's not running, as there is no mysqld
Details should be in the .err file in the data directory
(/usr/local/mysql/data/whitestar.alpha.net.err, in your case).
Michael
Alex Majora wrote:
Additionally, this is what I get when I try to launch mysqld manually:
$ sudo ./bin/mysqld_safe
[1] 2058
Starting mysqld daemon with databases from
Where would I find the tablename.InnoDB files ?
As in the error below that I receive when check table is run against the
table:
mysql check table ACL;
+-+---+--+---+
| Table | Op| Msg_type | Msg_text
[EMAIL PROTECTED] wrote:
I would simplify it by converting everything to us explicit (not
implicit) JOIN statements,skipping unnecessary type conversions, and
logically merging your conditions. Here is your original query,
slightly reformatted.
SELECT DISTINCT i.basename
FROM inventory i,
On Wednesday, January 19, 2005 9:14 PM Michael Stassen wrote:
Details should be in the .err file in the data directory
Here's the contents of the file:
050119 17:30:02 mysqld started
050119 17:30:02 [Warning] Setting lower_case_table_names=2 because file
system
for
How can I set character set as UTF-8 for mysqldump command?
When I try this, I get an error -
mysqldump --default-character-set=UTF-8 -uNAME -pXXX mydb mydb.sql
mysqldump: Character set 'UTF-8' is not a compiled character set and is not
specified in the 'C:\mys
ql\\share\charsets\Index' file
38 matches
Mail list logo