Matt Chatterley wrote:
One option would be to 'union' the two queries (assuming the columns are the
same type and length), allowing you to run one query string:
Select serial from blacklist where serial = x
Union
Select serial from seriallist where serial = x
Would return 1 or 2 rows, depending
Smartyone wrote:
The database used to work, but then something must have broke, because now it
is suddenly Read-Only (reports Read Only when I try to add a record using
MySQLCC).
Make sure the owner and group of the database files is set
to mysql.
--
MySQL General Mailing List
For list
I've got a query that I can't seem to get optimized, so I'm
hoping someone here can spot something I've missing!
Table has three columns:
CoordID int unsigned,
Zip_Lo char(9),
Zip_Hi char(9)
Table has 3 million records
indexes:
acg_lo (Zip_Lo)
acg_hi (Zip_Hi)
acg_combined (Zip_Lo, Zip_Hi)
Schmuck, Michael wrote:
I've got a big problem. My MySQL server has yesterday lost data since 20th
january.
Yesterday at about 14 o'clock we resartet the demon on our bsd server since
september 03. I belive the deamon
didn't wrote the data into the files. At the restart of the database he
Benjamin PERNOT wrote:
I want to get a list of all the parents with the age and the name of the older
child they've got. Let's say that a parent can't have 2 children with the same
age.
I can solve my problem by using multiple queries but that's not very clean and a
bit heavy (especially if
Balazs Rauznitz wrote:
However when the 'sex' column is involved:
mysql select count(*) from sex where id459000 and id =46 and sex = 'M';
+--+
| count(*) |
+--+
| 504 |
+--+
1 row in set (5.09 sec)
Any way to make this faster ?
Well, MySql can only use 1 index
Roger Baklund wrote:
Either way, I was surprised to see the like to be in the top
performers and left() to be last.
I suppose the LIKE operator is optimized for the case when it begins with a
constant:
mysql select BENCHMARK(1000, 'dfsfsdfs' like '%F%' );
1 row in set (3.43 sec)
MySql will
Nicholas Fitzgerald wrote:
go to the command prompt and use mysql or mysqladmin I get access
deniged for user @localhost. No root or anything like that. I don't
know where I screwed up, but I obviously screwed up something. Any ideas
out there on how I can get back in control of this
Christopher L. Everett wrote:
I'm using AMD K7 servers and don't need/want InnoDB so I want to compile
mysql from source and I was curious about what compiler flags to use, so
Without recompiling binaries, you can add
skip-innodb
skip-bdb
to your my.cnf file.
2. What compiler flags do the
Marc Dver wrote:
Based on the collective experiences of the members of this group, what
are the best methods for learning mysql, both from the perspective of
I attended the week-long Mysql training course, and it was excellent.
--
MySQL General Mailing List
For list archives:
Tibby wrote:
..and I want to get this with a single query:
+-++--+
| key | desc| value |
+-++--+
| 2 | book| 7 |
| 6 | pen | 7 |
+-++--+
I need to get only one row from col. DESC, the one with the highest VALUE.
Chris Nolan wrote:
This seems a bit confusing. On one hand, it says that updates don't
fail, but on the other hand it says they are stalled until ALTER TABLE
is done executing. Am I going blind/loosing my mind (a possibility I am
open to) or do others agree with me?
It looks perfectly correct.
Brandyn Riffle wrote:
What I'm trying to do is sort by a column with by pre-set criteria; I've
a political database with events with columns for the year, month, day,
and event. I'd like to order by months, (e.g. JAN, FEB, MAR, etc...)
after sorting by year. The sorting by year part was
At 14:42 -0400 12/12/03, Victor Medina wrote:
It happens that when a client tries to log into the db server using
passwords the server doesn't seems to authorize. Even the most recent
MyCC client fails to autorize users using passwords. Do I need to
compile the clients against the new server's
Corin Langosch wrote:
Hello,
thanks for your fast reply. even when i use
EXPLAIN SELECT * FROM `actions` ORDER BY datum LIMIT 10
the key isn't used. the query takes about 2s :-(
What does it show if you do a
show indexes from actions
---
If you are sure the optimizer is
Mark wrote:
Is there an easy way to determine the largest sql query I can
pass between a perl/C app to my MySQL database? It seems to wig
out around the 1 meg range but without resorting to trial and
error I'm not sure how to get an exact figure.
the max size would be limited by the variable
Uros Kotnik wrote:
Time for first SQL : 21 sec.
SELECT artists.name, cds.title, tracks.title FROM artists, cds, tracks
WHERE artists.artistid = cds.artistid AND artists.artistid =
tracks.artistid AND cds.cdid = tracks.cdid AND MATCH (artists.name)
AGAINST ('madonna'IN BOOLEAN MODE) AND
MATCH
Uros Kotnik wrote:
It makes sense, but Sergei G. said :
And are you sure the numbers are correct, the first query - the one
without IN BOOLEAN MODE - is faster ? I would expect the opposite.
I guess that for my DB I can't expect satisfied in boolena mode times
?
But also when searching without
Yves Goergen wrote:
(1) I want to start a (small, non-free) webhosting service and offer
webspace with PHP support and a MySQL database account. There will be some
standard tariffs that include a database account but I'm going to make them
available as extra upgrade, too, for a monthly fee. Do I
[EMAIL PROTECTED] wrote:
Thanks for the heads up on this. Unfortunately the only
varchar is the gbl_locus field, so I'm not sure how much this
would by me for the space.
Thanks again,
Brad Eacker ([EMAIL PROTECTED])
No, it wouldn't save you any space.
[EMAIL PROTECTED] wrote:
mysql create table gb_locus (
- gbl_id int primary key,
- gbl_fileID int,
- gbl_locus varchar(20),
- gbl_sizeint,
- gbl_datedate,
- gbl_phylum char(3),
-
Stéphane Bischoff wrote:
We are programming a Delphi application that interacts with the MySQL server
from Windows.
Normally we would need a client side licence ?
But if we use a set of components (from a third party) that allow us to
interact with the MySQL server without using the MySQL
Noamn wrote:
About a year ago, I set up mySQL on a computer running linux (probably
RH7.1). At the time I thought that I would investigate how I could use this
server in my business, but then I had more pressing issues and so neglected
the subject. Now that I have some spare times and correct
rubn ruvalcaba wrote:
I want to know how could solve the next replication scenario:
I have a master.
I have 5 slaves.
At start the slaves has a master snapshot.
Now imagine slave 1, inserts a record. When it gets connected to the
lan, it must replicate it's changes to the master.
No, a slave
Michael Burke wrote:
I'm using mysql on redhat 9 and wanted to enable the query log file.I
copied one of the example my.cnf files to /etc and added an entry: --log
to enable the log file but when I boot red hat I get a message that
If you are specifying the option on the command line, then you
karl james wrote:
Hey guys, (off Subject)
I want all emails that come from mysql list to go into a mysql folder
that I have setup for it, but no matter what rule I choose in Microsoft
outlook it doesn't work.
filter on the TO address. The list does not re-write the FROM address.
--
MySQL
Michael Burke wrote:
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
031201 20:00:49
Nev wrote:
We have just upgraded to a Pentium 4 - 3ghz , with 1 gb ram because
our last server was very slow.
What operating system?
Another related point, in the MySQL documentation it says in the
mysqladmin show extended status that the Select_full_join value should
be zero mine is very
Richard Bewley wrote:
Ok, but the slave would also replicate to the master? Is anyone using this
type of setup?
Both machines would be set up as both masters and slaves.
We tried it during the Mysql class I took a few weeks ago. Worked
fine, except for when there were conflicting updates.
Kriengkrai J. wrote:
-- System: MySQL 4.0.13, 4.0.16 on Linux x86
-- Table type: MyISAM, InnoDB
-- Description / How-To-Repeat:
-- 1. When I use
-- SELECT id, type FROM test.report ORDER BY type, id;
-- the result is in wrong order
-- --
-- ++-+
-- | id | type|
--
I'm building up a new MySQL server. The box specs are:
2U, Dual 3Ghz Xeon processors, 6 Gigs ram, 500 gigs of Raid 5
storage.
I'll have the hardware in my hands tomorrow. I've used RedHat
on all my previous linux servers. I'm planning on going with
Red Hat Enterprise Linux ES.
But, I've heard
31 matches
Mail list logo