I'm looking at the stats on one of our servers and trying to understand
why Handler_read_rnd_next is so high. It's 256.5M right now, which is
about 10x the total number of reported queries.
The machine is being used, almost entirely, for queries of the form:
select * from crumb
where link_id
and if I copy and paste it into my mysql client, it
is fast. I can execute the query first in mysql and then in the JDBC
client and I get the same so it is not caching. I've done a bit of
searching but found nothing - any ideas ?
Chris
On 7/22/05, Chris Faulkner [EMAIL PROTECTED] wrote
that the indexes are
possibly used. The query takes an age to run and looking at my log
indicates a full table scan.
I have also tried indexing just field1 and field3 separately but this
doesn't help. I have run an analyze.
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi
field2 is indexed. I have 2 indexes. One is on field1 and field2, the
second indexes field3 and field2.
You mean a separate index which only indexes field2 ? Ithought that
the type of query I am doing is a good reason for doing composite
indexes.
Chris
On 7/22/05, Eugene Kosov [EMAIL
there is someone with some wise ideas I can use allot of them
right now.
Thanks,
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Put a index on col3 and it will be faster. That's the only way as far as I
know.
--
Chris.
- Original Message -
From: Michael Monashev [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, July 20, 2005 3:04 PM
Subject: random rows selection
Hello,
How to select 5 random
On 7/18/05, Michael Stassen [EMAIL PROTECTED] wrote:
Hmmm... In that case, I have more questions. Log in as root and run
SHOW VARIABLES LIKE '%pass%';
DESC user password;
and post the results.
Also, was this a brand new installation, or an upgrade? If an upgrade, from
what
Sorry. While I am able to log in, I get the following:
| GRANT ALL PRIVILEGES ON *.* TO 'chris'@'localhost' IDENTIFIED BY
PASSWORD '*446CB892D3DFFDDC86BDDF26E4EB43158356DF64' WITH GRANT OPTION
|
after a restart, I get
| GRANT ALL PRIVILEGES ON *.* TO 'chris'@'localhost' IDENTIFIED BY
PASSWORD
Issuing the grant command yields an error:
mysql GRANT ALL ON test.* TO [EMAIL PROTECTED] IDENTIFIED BY PASSWORD
'testing';
ERROR 1105 (HY000): Password hash should be a 41-digit hexadecimal number
Also, I tried deleting and re-creating the 'chris' user, and the same
problems arose. However, I
On 7/14/05, Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
PASSWORD '3446cb892d3dffdd' WITH GRANT OPTION |
You're using passwords in old format. Is it possible that problem
somehow related to this. Are you connecting using mysql command line
client? What version it is?
I
I have mysql 4.1.12 installed on OSX 10.4, and have run into the
curious problem that mysql forgets my user password (but not my root
password) when I restart the server. When I attempt to log in, I get:
ERROR 1045 (28000): Access denied for user 'chris'@'localhost' (using
password: YES)
Yet
On 7/14/05, Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
What does
show grants for 'chris'@'localhost';
reports when you're logged as root?
I get the following:
| GRANT ALL PRIVILEGES ON *.* TO 'chris'@'localhost' IDENTIFIED BY
PASSWORD '3446cb892d3dffdd' WITH GRANT
Tried that. I get the following:
Oliver:~/Research/Right Whale chris$ mysql mysql -u root -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g
PROTECTED] wrote:
Michael Stassen wrote:
Danny Stolle wrote:
Chris Fonnesbeck wrote:
I have mysql 4.1.12 installed on OSX 10.4, and have run into the
curious problem that mysql forgets my user password (but not my root
password) when I restart the server. When I attempt to log in, I get
,
OrderDate DATE,
CHECK (JobType IN ('DesignOnly', 'DesignInstall', 'InstallOnly')),
PRIMARY KEY (JobId, CustomerId)
) TYPE=InnoDB;
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
? It seems there is only a source RPM available on dev.mysql.com, the
source tar ball will be good though.
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by... - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
--
MySQL General Mailing List
For list
I have a simple php script which runs the following query:
LOAD DATA INFILE 'datafile.txt' INTO TABLE LocationTEMPSR12 FIELDS
TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\r\n'
which generates the error:
File './mydabasename/datafile.txt' not found (Errcode: 2)
The simple php script
]
At 03:59 PM 6/7/05, Chris wrote:
I have a simple php script which runs the following query:
LOAD DATA INFILE 'datafile.txt' INTO TABLE LocationTEMPSR12 FIELDS
TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\r\n'
which generates the error:
File './mydabasename/datafile.txt
I guess I don't know why I can't
specify the location of my data file from
'/public_html/path_to_my_file/datafile.txt'
Thanks,
Chris
Michael Stassen [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Chris wrote:
I have been using LOAD DATA INFILE to load an ASCII data file into my
?
OBSERVATION: It appears the tmp directory must be in the database path
because, files uploaded to the tmp dir can be loaded using LOAD DATA INFILE.
Thanks for replies,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Syntax looks fine to me.
Sub-queries are only supported in 4.1.x+ , I'm guessing that's your problem.
Chris
Lieven De Keyzer wrote:
UPDATE account
SET role_id = (SELECT role_id FROM role WHERE rolename = admin)
WHERE username = test
This gives me an:
ERROR 1064 (0): You have an error
Export as CSV.
MySQL command line client.
Run a script with LOAD DATA INFILE.
Chris
On 5/23/05, Andrew Dixon - MSO.net [EMAIL PROTECTED] wrote:
Hi Adam.
I need to get all the data.
Andrew
Adam wrote:
Drew,
That's vague. Specifically what do you want from the Access
]|
++
| GRANT USAGE ON *.* TO 'root'@'192.168.0.8' |
++
1 row in set (0.00 sec)
However, when I try to connect from 192.168.0.8, I get an error (1045:
Access denied). What else do I have to do ?
Thanks
Chris
to improve the performance of index creation ?
Thanks
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
hi,
your need is:
select * from temp LIMIT 3,4;
-- 3 because you have to take the fourth and 4 because dist=3+1
That can't work as my initial query, because I don't know the location
of iTempID: 4 in the query result
to find the position 4, the query is :
mysql select
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
hi,
your need is:
select * from temp LIMIT 3,4;
-- 3 because you have to take the fourth and 4 because dist=3+1
This does not make sense. A SELECT without an ORDER BY returns the
rows in some undefined order. If
[EMAIL PROTECTED] wrote:
Chris [EMAIL PROTECTED] wrote on 05/10/2005 12:20:57 PM:
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
hi,
your need is:
select * from temp LIMIT 3,4;
-- 3 because you have to take the fourth and 4 because dist=3+1
please just give me some
answers
We're running FBSD 5.4-STABLE.
--
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
| pebbles |
| 7 | bart|
+-+-+
Of course, even if there is a ROW_NUMBER() function, It may not act as I
hope in the preceding query due to the sub-queries and/or HAVING clause.
Any help would be appreciated,
Thanks,
Chris
--
MySQL General Mailing List
For list archives: http
Temporary replication comes to mind fs hot copy as well (maybe)
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by... - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
- Original Message -
From: Brian Erickson [EMAIL PROTECTED]
To: mysql
setting of @iOrder or @mGroup0.
How do the User variables in an UPDATE statement act differently than in
a SELECT statement?
Thanks,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Somethign else to think about as well, look at this slight modification:
select pk from a left join b using (pk);
Now, it's not likely this is a valid query for your table structure,
but, in this instance, a.pk and b.pk are not necessarily the same. b.pk
could potentially be NULL while a.pk was
() + 2Hrs. All my dates in the
database are stored in GMT, so I only need to use NOW()-2H (which is the
same as DATE_SUB(CURDATE(),INTERVAL 2 HOUR)).
Can anyone help perhaps?
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by... - Douglas Adams
Found my problem...
Thanks anyways :)
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by... - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
- Original Message -
From: Chris Knipe [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, May
-data.html
Which has some more info you might find useful.
Chris
Homam S.A. wrote:
NOTE: I sent this message yesterday, but for some
reason it didn't show up in the list. If you've
already received it, I apologize for the
inconvenience.
So here it goes again:
I searched the online manual and all I could
on the FreeBSD DB Server shows that the
entire box is virtually idle (the load averages confirms) while the tests on
super-smack run. The worse I got was a load of 0.5 on the DB server with
close to 800 threads running
Any ideas please???
--
Chris.
--
MySQL General Mailing List
For list archives
=20
set-variable = wait_timeout=28800
set-variable = delayed_insert_limit=2000
set-variable = delayed_insert_timeout=1800
set-variable = delayed_queue_size=8000
set-variable = max_delayed_threads=32
--
Chris.
I love deadlines. I especially love the whooshing sound
% mysqld
76746 squid 960 90756K 38016K select 4:16 0.00% 0.00% squid
56725 pmx4 960 36524K 34908K select 0:01 0.00% 0.00% perl
56724 pmx4 960 36172K 34560K select 0:00 0.00% 0.00% perl
FreeBSD 5.4-STABLE, linuxthreads
--
Chris.
I love deadlines. I especially love
...
Thanks for the help
--
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 10:52 AM 5/3/05 -0700, [EMAIL PROTECTED] wrote:
'DBD::mysql::db selectrow_hashref failed: Access denied for user:
'[EMAIL PROTECTED]' (Using password: NO) at /var/www/html/cgi-bin/DBI/Role.pm
$ mysql -uroot -p
mysql CREATE DATABASE livejournal;
mysql GRANT ALL PRIVILEGES ON livejournal.* TO
maybe, errors you've received, Queries you ran to
convert the tables...
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You could try checkdate()...
chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Anoop
snip
You could try checkdate()...
/snip
Apologies for erroneous advice - I am evidently suffering from list psychosis...
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
If I understand your problem, MySQL allows you to use regular
expressions - so you could use the REGEXP function to remove the
spaces. Check out the mysql site...
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
, not really something you'd have to
deal with every day.
As long as it's not a shared server you're connecting from and MySQL is
set up to only allow connections from that server, it seems like it
should be good enough.
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
this helps
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
://dev.mysql.com/doc/mysql/en/variables.html to
see what use you can get out of them.
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
separately in the Query Browser, you wouldn't get
the results you expect. It would forget the value of @A because it
closes the connection each time. It's possible to keep the connection
open by Starting a transaction (even if you're using MyISAM tables).
Chris
--
MySQL General Mailing List
For list
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]
quite big over time...
Hope you can be of assistance again :)
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
One last question... A sub select may not perhaps speed
things up as well?
--
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, is how to get FlightType and FlightStatus to
indicate the values I NEED based on what the data in the query is doing. I
am GUESING this is going to be allot of JOINs, allot of GROUPs, and allot of
IFs. I may be wrong though.
--
Chris.
I love deadlines. I especially love the whooshing sound
I use = 0. It works for me.
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by... - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
- Original Message -
From: Emil Wilmanski [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, April 14
DepartureLocation ON tbl2.ArrivalID=tbl1.LocationID ORDER BY
tbl2.Time etc etc etc
I get
ERROR 1066 (42000): Not unique table/alias: 'tbl1'
Thanks.
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by... - Douglas Adams, 'Hitchhiker's Guide to the Galaxy
i have replication going between 2 boxes. the master crashed a few days
ago, and this morning i noticed that the slaves slave thread errored
out. the binary log and offset had changed on the master and the slave
couldn't sync up. i got the slave up and running again by changing the
log file
Hi all,
I've got 3 or 4 queries UNIONed together in a single query. I want to
GROUP the UNIONed result, by one field, and SUM() another field.
Is that possible in one query, or will I need to use temporary table and
group it from that?
Thanks,
Chris
--
MySQL General Mailing List
For list
Tom Crimmins wrote:
On Friday, April 01, 2005 19:27, Chris wrote:
Hi all,
I've got 3 or 4 queries UNIONed together in a single query. I want to
GROUP the UNIONed result, by one field, and SUM() another field.
Is that possible in one query, or will I need to use temporary table
and group it from
to the
manual, a multi-row INSERT is faster.
Thanks,
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
syntax expressions and din't
notice it. Of course I was looking for a keyword like MULTI or
something.. :\
Thanks everyone!
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear list,
Happy Easter if anyone else is working. This statement is returning a
syntax error when I insert the WHERE line:
--
SELECT
tasks.task_id,
tasks.name AS taskname,
tasks.deadline,
tasks.project_id,
Try using:
+dragon +ice +blue
I'm fairly sure that's in the FULLTEXT search portion of the online docs.
Chris
Ed Lazor wrote:
Hi,
How can I limit the results of a fulltext search to the entries that only
have the keywords I'm searching for?
I'm searching the title field of a product database and I
TRUNCATE TABLE would work too. That would automatically remove all rows
as well.
Chris
mel list_php wrote:
Hi,
I think you are looking for something like that:
ALTER TABLE auto_increment=1 (or whatever value you want)
melanie
From: Mário Gamito [EMAIL PROTECTED]
To: mysql@lists.mysql.com
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
Chris Mason
Anguilla
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005
AUTO_INCREMENT is not the same as newid().
Frankly, something like newid() would be very useful in MySQL.
--
Chris.
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, March 17, 2005 5:53 PM
Subject: Re: Ms Sql unique identifier field
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
Chris Mason
Anguilla
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 3/15/2005
--
MySQL
query in the bin log? This is the second time
in 3 days that it has happened now. Whilst we are on this, how do I tell
the slave to skip the query and proceed with the rest of the binlog...
Thanks to this now, we already have a MASSIVE backlog that needs to be
processed.
--
Chris
Chris Knipe wrote:
[..]
Sure, there is a syntax error in the query - yes. But why does the
master not put the complete query in the bin log? This is the
second time in 3 days that it has happened now. Whilst we are on this,
how do I tell the slave to skip the query and proceed
Chris Knipe wrote:
[..]
Sure, there is a syntax error in the query - yes. But why does the
master not put the complete query in the bin log? This is the
second time in 3 days that it has happened now. Whilst we are on this,
how do I tell the slave to skip the query and proceed
- Original Message -
From: Richard Lynch [EMAIL PROTECTED]
To: Chris Knipe [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Friday, March 11, 2005 12:08 AM
Subject: Re: replication errors
mysql SELECT COUNT(RadAcctId) FROM RadiusAccounting;
+--+
| COUNT(RadAcctId
aren't
read / written properly... That's the problem here, not the missing data...
For that I have backups.
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the entire list on the first page and then on all
subsequent pages using LIMIT()?
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
authentication... My guess
is that I more than likely just don't need to replicate that DB from the
master.
Would this be considered safe?? Or should I look at a third database server
for deployment?
--
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
.
I'll stop replicating mysql tables then... Thanks ;)
--
Chris.
- Original Message -
From: Gary Richardson [EMAIL PROTECTED]
To: Chris Knipe [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, March 09, 2005 6:23 PM
Subject: Re: safe way of replication?
I would probably
Hi,
Is two-way replication possible with MySQL 5.x? Any good sites / docs
describing this type of setup?
--
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: [EMAIL PROTECTED]
To: Chris Knipe [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, February 28, 2005 7:11 PM
Subject: Re: two-way replication
Chris Knipe [EMAIL PROTECTED] wrote on 02/28/2005 11:53:14 AM:
Hi,
Is two-way replication possible with MySQL
highly possible as this is the first database ive had to use with a
large number of records. I shall look into indexing part of databasing now.
Any suggested places to start that explains it helpfully ?
Regards
Chris Aitken
The Web Hub Designer and Programmer
Phone : 02 4648 0808
Mobile : 0411 132
understanding of nice is that it
puts mysql's cpu usage priority at the lowest. But if nothing else on the
box needs the CPU, it'll still run full and bring load over 5 making
sendmail crash anyway.
Any responses would be appreciated.
Regards
Chris Aitken
The Web Hub Designer and Programmer
probably come in useful for other scenarios too.
Would this be possible/feasible/useful to anyone else?
Thanks,
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
? It's really one of the biggest things stopping me from
switching wholly to InnoDB :(
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
)
Chris
J Wermont wrote:
Hi,
I'm new to MySQL and at this point, I'm just trying to insert rows
of data into a table.
When I insert a row of data that includes a field of type set
(corresponding to an HTML set of checkbox answers), only the first
item in the list gets inserted into the row
England serach come up blank.
Thanks,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear list,
My ColdFusion server tells me I have an error in my query syntax, but I
can't work out what it is - because I'm working with code that someone
very kindly gave me and I only have a vague idea of what the first
line's doing! Can anyone see the problem here?
SELECT
Thanks very much for the replies, guys. My version is 4.1.7-max.
The error message I get is:
--
Error Executing Database Query.
Syntax error or access violation: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near
On 31 Jan 2005, at 11:39 pm, Tom Crimmins wrote:
I think datediff only takes two arguments and you have three listed.
Nailed it! Thanks, Tom.
Best regards,
CK.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, or, at the very least, look into the bugs that were fixed in
4.1.8 and their workarounds.
Chris
Karam Chand wrote:
Hello,
I am running mysql 4.1.7 on Win2K.
I have two tables:
CREATE TABLE `child` (
`id` int(11) NOT NULL default '0',
`name` char(1) NOT NULL default
) Database 'egroupware' has a different name or does not exist, or
2) Table phpgw_links has a different name or does not exist
As Duncan said, maybe the EGW install was incorrect...
cheers
Chris Ramsay
-
Web Developer - The Danwood Group Ltd
.
On line 47:
datadir=/usr/local/mysql/data
Should that line be datadir=$basedir/data ?
I tried changing basedir to my new path, but it didn't quite work until
I changed that line. I'm mostly asking because it *seems* right, but I'm
essentially clueless and wanted to double check.
Thanks,
Chris
Hi! I never saw a follow-up to the post about SHOW SLAVE STATUS
hanging while LOAD DATA FROM MASTER is running as of about 4.0.20 on.
(http://lists.mysql.com/mysql/167238)
Is this a known bug? Or a feature?
thanks!
chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
start an application on the local machine.
I'm looking for recommendations on the easiest way to implement this
project. I would prefer a php like scripting language, I certainly wont be
able to do it in C or similar.
Chris Mason
--
No virus found in this outgoing message.
Checked by AVG Anti
Description:
config, build, and install went fine
died on sql-bench/run-all-tests
How-To-Repeat:
./run-all-tests --server=mysql --cmp=mysql,pg,solid --user=root
--password=myrootpwd --log
--socket=/engtools/local_advtech_develop/mysql-4.1.7/var/mysql.sock
Got error: 'Client does
I believe that 4.1.0 and 4.1.1 were doing things a bit differently than
4.1.2+ , so your problem is likely caused by that.
4.1.0 wasn't a production release, I'd suggest upgrading the client.
Of course, there might be something I'm missing...
Chris
Somashekara DM wrote:
Hi all,
I'm using MySQL
When specifying an index for TEXT and BLOB types, you must specify a length.
as an example...
CREATE TABLE test
(
sValue TINYTEXT NOT NULL,
UNIQUE KEY(sValue(90))
)
Denis Gerasimov wrote:
Hello,
Is that possible to ensure uniqueness for a TINYTEXT field?
I tried to create an index (with UNIQUE
Browser
1.1
Can anyone please explain?
Thanks.
Hassan
This was mentioned, briefly, on the MySQL GUI list:
http://lists.mysql.com/gui-tools/1563
I don't know any more than that.
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hola list,
Many thanks to all those who helped with my question about the schema.
Your kindness is sincerely appreciated.
I need to store passwords in my database, and I understand it's bad
form to store them anywhere in a readable format (I remember reading
once that if you call a company
Rhino wrote:
The primary key for the intersection table is the COMBINATION of EmpID
and
ProjID! Neither column by itself would make sense as the primary key
of the
table; the EmpID and ProjID need to be combined to form the primary
key. It
is now possible to store as many projects for an
Dear list,
Quick question. What's a reasonable length for a notes-type field? I
couldn't really find any guidelines on the web so I'm thinking of just
setting it to 65,535. Or is that ridiculously long?
Thanks list,
CK.
--
MySQL General Mailing List
For list archives:
:
people and projects. I want each project to have a list of people
that are authorised to view it. To my mind, the field ought to look a
bit like this:
--
Authorised list:
Chris Kavanagh
Joe Schmoe
Jane Doe
--
But fields can't hold multiple values, can they? And on my
something to look into. You would probably have much better luck
with a ColdFusion list
Chris
Steve Grosz wrote:
I am writing this by hand, and is being used within Coldfusion.
MySql is v 4.1.7 and I am connecting via ODBC.
Steve
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Your
from the rest of the table. Would the 31 character
index negate any need for MySQL to read the full column information?
This table will get heavy use, in checking to see if a String ID exists,
and creation if it doesn't.
Thanks,
Chris
--
MySQL General Mailing List
For list archives: http
then you can easily convert from one or the
other using the |FROM_UNIXTIME() or ||UNIX_TIMESTAMP() functions.
|
Chris
Eric Wagar wrote:
I am testing moving from a phpnuke site to a xoops site. In doing so, I am
trying to get the user table moved over.
I see in the phpnuke tables (which a similar table
701 - 800 of 2034 matches
Mail list logo