dave
I believe group is a reserved word. change to grp.
david
-Original Message-
From: Dave M G [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 04, 2006 8:55 AM
To: mysql@lists.mysql.com
Subject: Re: Exporting utf-8 data problems
Thank you for the advice.
In
chris
I chased this down a while back.
you are correct. 4G is max on 4.0 4.1 versions
of mysql. I don't know about 5.0 though.
I looked at the source for sql/mysqld.cc
line 4170
UINT_MAX32
someone else found docs that said monty had
done this since myism tables had issues
deep inside the
solaris box with 16 Gbytes of memory
os using 5.8, mysql at 4.0.20_64bit
with key_buffer_size set to 6144m, the mysqld crashes
and re-starts (mysql_safe) under heavy load (1day to 1week).
prior to this, key_buffer_size set to 1.5G and no crashes since
early 2004.
the process size is 2G even
bertrand
i went to tab delimited fields for the same reason:
commas in text is often done, tabs is rarely done.
david
-Original Message-
From: Bertrand Gac [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 21, 2004 12:09 AM
To: mysql
Subject: Importing Excel Data in MySql
the statement is taking 3 hours and counting.
optimize TABLE tablename
normally this takes 30 minutes or so.
boss wants to kill this thread.
does that mean the table will end up corrupt?
any input helpful.
david
hrdw: solaris 4cpu, running version 8
mysql version
matt
the issue is insert speed, I get 150k-1M records daily, of
these, only
5-10 % are new records, I load the EBCDIC file into a temp table, and
then do insert ignore into historytable select * from temp table
Since you have a temp table created (no keys I assume), use the command
matt
1) inserts using this format is much faster:
INSERT INTO table (col1, col2) VALUES (val1,val2), (val3,val4)
is much faster then single row insert. My experience is
2.5 hrs vs.. 36 hrs.
2) The PACK_KEYS=1 may be hurting you. I've never used it.
3) There may be a cache somewhere
All
Hardware: Solaris 4 cpu, 16G ram, 900MHz, ver 5.8
MySQL: 4.0.20 binary install, 32 bit version
Admin install, I maintain the my.cnf, and do db admin.
Installed a production db (10 million rows) with no
problems. However, can only open 20 or so connections
to mysqld. The error is:
ERROR
John
Try
select field, count(*)
from db.table
group by field;
David
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Monday, May 24, 2004 10:37 AM
To: MySQL List
Subject: Query question
Hi,
I have a table which I want to select data from
Jack
you must have a compound index in your table:
ALTER Table ifInOctets_137 add INDEX i_id_dtime(id,dtime);
In your SELECT statement, change
USE INDEX (dtime)
to
USE INDEX (i_id_dtime)
Let us know how it works.
David
-Original Message-
From: Jack Coxen [mailto:[EMAIL
filter: select, mysql
Solaris 3.23.40 connections using perl, jdbc, odbc.
Yesterday, we experienced a rare mysqld failure where all connections
where in the state=Opening table. Normally our 200+ connections
are in state=sleep. The Time field from command
show processlist
showed each
Eric
Try putting the HAVING clause after group by. I believe
having is the last clause (may be LIMIT).
David
-Original Message-
From: Eric Ellsworth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 8:01 AM
To: [EMAIL PROTECTED]
Subject: Syntax Check: Group BY with Joins
Gregory
mysql,select,query
I agree with Joe, use multiple-column index. Much more efficient.
All queries should be sub 5-10 seconds or less.
David
-Original Message-
From: Gregory Newby [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 11:53 AM
To: [EMAIL PROTECTED]
mysql, query
I have a situation come up where we want one slave to act
as backup for two different databases located in two
different hosts. Can this be done?
The master setup is easy. The slave setup is unclear.
Can I have two sets of master-host, master-user, and
master-password,
Jonathon
We are using odbc and jdbc to link up from notes to mysql.
David
-Original Message-
From: Jonathan Villa [mailto:[EMAIL PROTECTED]
Sent: Monday, September 15, 2003 1:43 PM
To: [EMAIL PROTECTED]
Subject: Lotus Notes/Script...
Has anyone every connected Lotus
Dudes Dudetts
filter: mysql, select, sql
mysql version: 3.23.49
jdbc version: 2.0.14
development os: win2k
production os: solaris
Problem:
During a reboot of mysqld, the perl connections survived
and the jdbc connections did not. My definition of survived is
that the connections
Mustafa
Try this command from the client window:
show processlist;
You must be logged in from root to list all connections.
If you are logged in as normal user, only those connections
which you have privileges are listed.
David
How i list connected users(active) to mysql server?
kees
How do you measure spiked queries/s?
All I see is average queries/s from the status command.
I can see the calculation based on uptime in seconds and
total queries in that time. But that's average. My boss
wants avg and skipped on a web site.
David
-Original Message-
From:
Guru's
Problem is type SMALLINT needs to be MEDIUMINT (MyISAM).
column: id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT
My solution is to use the following ALTER statement:
ALTER TABLE messages CHANGE id
id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT
My question is: what happens to the
Gurus
I'm having trouble understanding the column type SET.
To explain my problem, I'll create a table, populate
it, and do selects.
mysql CREATE TABLE settest( chain SET( A, B, C ) NOT NULL,
UNIQUE INDEX ichain( chain ) );
mysql INSERT INTO settest SET chain=A,C;
mysql
Hasan
Try typing your select statement in a text editor.
Open a mysql client connection and copy paste. This
gets around the problem.
For multiple sql statements, put them in a file and
redirect it to the mysql client:
shell mysql -u hasan -p file.sql
David
-Original Message-
From:
Inandjo
Try setting the variable connection_timeout to 300 seconds.
That way, the mysqld will close the connection automatically.
Set the variable in file my.cnf.
David
-Original Message-
From: Inandjo Taurel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 9:54 AM
Fibilt
try:
SELECT id, concat(lname, fname) as name, count(*) as cnt
FROM table1
GROUP BY name
HAVING cnt 1;
This is close anyhow.
David
-Original Message-
From: Phillip S. Baker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 1:17 PM
To: [EMAIL
Steve
Try: SELECT MAX(field_timestamp) from table1;
David
-Original Message-
From: Steve Buehler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 5:21 PM
To: mysql; PHP
Subject: time stamp
I am using PHP with MySQL and have a timestamp field in my db
table. What
Ben
It would appear that the deletion of rows may be a problem.
After deleting rows older than 6 months, do you optimize the
table?
As I understand it, mysql does not delete delete, only marks
a bit for every row thats deleted. That way, delete speed is
fast. However, it slows down queries and
Bhavin
I'm doing queries to one table with 4 other smaller tables.
The large table is 12-14 million records. With an index,
the table select is 13-15 seconds. With a compound index,
the delay is sub one second. Use explain to verify which
index is being used. Read the manual to tune your
mike0
MYI is the index's
MYD is the data
Can't think why it would suddenly grow in size.
Try the CHECK TABLE command to get more detail.
David
-Original Message-
From: //mikezero/ [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 08, 2002 12:37 PM
To: [EMAIL PROTECTED]
Subject:
Andy
2) Locks are by thread. If thread dies, so does
it's lock.
David
-Original Message-
From: Andy Sy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 12:03 PM
To: [EMAIL PROTECTED]
Subject: Auto-increment across multiple tables / Atomicity of update
statements
Guy
No. Requires multiple inserts.
David
-Original Message-
From: Defryn, Guy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 4:55 PM
To: [EMAIL PROTECTED]
Subject: insert into multiple tables??
Is it possible to insert data into different tables with one insert
Mike
Try moving the datadir to your home partition.
This is a variable in the my.cnf config file.
I just did this on an NT box. You will have
to stop mysql, change the config file, move
your current data dir to new location and
restart mysql.
David
-Original Message-
From: Mike Mike
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 12:59 AM
To: Lopez David E-r9374c
Cc: Mysql List (E-mail)
Subject: table lock - which connection id own's it
Hi!
Lopez == Lopez David E-r9374c [EMAIL PROTECTED] writes:
Lopez AntiSpam - mysql, sql, query
Lopez Version: 3.23.49a, MyISAM, NT
AntiSpam - mysql, sql, query
Version: 3.23.49a, MyISAM, NT, Solaris
My app is 150 daemons writing logs to mysql. The main
table is of fixed size but depends on four other tables
for foreign keys (hash tables). These tables are uploaded
once to the daemon at start-up. Occasionally, a new entry
Keith
What about placing the output of the select in a
temporary table in mysql space and making
a second selection from the temp table. That would
get you what you want.
1) CREATE TEMPORARY TABLE tmp ...
2) INSET into tmp SELECT ...
3) SELECT ... FROM tmp ...
Just a thought
David
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 8:47 AM
To: Lopez David E-r9374c; [EMAIL PROTECTED]
Subject: RE: select query optimization
i made the change, but it looks like it didn't speed the query up at all.
here are the results from the first explain:
mysql explain select
Steve
Have you tried using compound index:
INDEX( POOL, STATE )
Just a thought.
David
-Original Message-
From: Steve Katen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:13 AM
To: [EMAIL PROTECTED]
Subject: select query optimization
i am running a basic install of
Jeff
You can make a clean start but it takes work.
1) create new table clients_tmp - same fields - no indexes.
add a field and make it a simple integer - say idx_int
2) insert all the fields into client_tmp from clients
place the client.idx field into client_tmp.idx_int
a) At
Walter
Try adding to your select statement:
ORDER BY DESCRIPTION ASC
David
-Original Message-
From: Walter D. Funk [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 11:05 AM
To: [EMAIL PROTECTED]
Subject: How can I Sort by Relevance?
I have a query like this
select *
Anti-SPAM: mysql, query
Gurus
I'm new to replication. Set it up this weekend and has worked
flawlessly for several days. Then I used the command:
TRUNCATE TABLE tbl;
That worked in master, but was not replicated in slave.
No mention of this in manual. Using version 3.23.49 on
master and
Hank
Instead of dropping down to OS cp commands, insert the data from
table TBL_FLAT to TBL_INDX.
INSERT INTO TBL_INDX SELECT * FROM TBL_FLAT;
This will be valid in mysql. The insert will be fast since
only one insert statement. Let the list know if this works
for you. Or if your method is
Using MySQL 3.23.40
App is logging db with 130 clients to a central MySQL db
with 2 million events per day. Aged events of over 7 days
are no longer required. The central table is myisam type
with fixed size (datetime, enum and foreign keys only).
Selects are done infrequently while inserts are
40 matches
Mail list logo