Hi Dan,
try to create composite index on id, domain and score
ALTER TABLE ADD INDEX indexName (id, domain, score)
Dusan
- Original Message -
From: Dan Sashko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 01, 2004 4:26 AM
Subject: A Select improvement
Hi, anyone has
Mitul,
- Original Message -
From: Mitul Bhammar [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, November 30, 2004 7:38 AM
Subject: MIXING MYISAM AND INNODB
I'm using multiple dbs for my very high traffic
multiple sites.
One of my db (say parentDb) just maintains
Richard,
- Original Message -
From: Richard F. Rebel [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, November 30, 2004 6:11 PM
Subject: InnoDB Log and binlog files and Solid State Disk?
--=-JDf9WlMx8c01FXMbzrGw
Content-Type: text/plain
Content-Transfer-Encoding:
Lynn,
- Original Message -
From: Lynn Bender [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, November 30, 2004 9:22 PM
Subject: MySQL support for AMD64
I just received a box with the following specs:
Dual AMD64
8G ram
Two 3ware 2.4 terabyte RAID 5 arrays.
My company
Ady,
- Original Message -
From: Ady Wicaksono [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, December 01, 2004 6:43 AM
Subject: Adding Foreign Key
mysql alter table t_quiz_trivia add foreign key (client_id) references
t_client (client_id) on delete set default;
Thanks Mr Heikki
I try to remove ON DELETE SET DEFAULT
like this
mysql alter table t_quiz_trivia add foreign key (client_id) references
t_client(client_id);
I found new error
ERROR 1216 (23000): Cannot add or update a child row: a foreign key
constraint fails
Finally i found the error
1. DDL
Hello.
The first impression is that you forgot to convert character
columns. See:
http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
http://dev.mysql.com/doc/mysql/en/Charset-conversion.html
V. M. Brasseur [EMAIL PROTECTED] wrote:
Ever since we upgraded to 4.1.7, we've
Hello.
Usually such things are done in several steps using temporary table.
create temporary table memp(m int);
insert into memp select min(id) from emp;
select emp.* from emp,memp where id=m;
See:
http://dev.mysql.com/doc/mysql/en/example-Maximum-column-group-row.html
Hi,
I
Greetings,
I've been trying to find what privilege is needed to 'REPAIR TABLE'. I
couldn't find any usefull hint on the net or in the archives. Could
anyone help me out?
Thanks
Bgs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi!
I've been digging through the web for a few days, but I didn't get any
answers for my little question, so I try to ask it here:
For example I set the following character sets:
character_set_client = A
character_set_connection = B
character_set_database = C
character_set_results = D
I'm creating a search form, the query is dynamic.
Meaning user can select 1 or all options.
All options translates to about 40 where statements,
including 1 -3 full text searches.
Is this too many where statements ? Do I need to watch
out for anything.
Looking for any advice on this issue.
[EMAIL PROTECTED] wrote:
I need to get all the details of an employee whose salary is the lowest.
I can do like this in Oracle
select * from emp where id = (select min(id) from emp).
Can we have any alternative in MySQL for the above query, as sub queries
are not supported in MySQL 4.0.21
There is
Hello experts,
according the desprictions I have installed the phpMyAdmin (2.6.0-pl3) as
following:
shell su - enter
shell mv phpMyAdmin-2.6.0-pl3.tar.tar /usr/sbin/ enter
shell cd /usr/sbin/ enter
shell tar -zxf phpMyAdmin-2.6.0-pl3.tar.tar enter
shell rm phpMyAdmin-2.6.0-pl3.tar.tar
This may be a bit off-topic for the MySQL List but see below:
Gunter Götz wrote:
Hello experts,
according the desprictions I have installed the phpMyAdmin (2.6.0-pl3) as
following:
shell su - enter
shell mv phpMyAdmin-2.6.0-pl3.tar.tar /usr/sbin/ enter
shell cd /usr/sbin/ enter
shell tar -zxf
You could also do it like this:
select min(id) from emp;
Roger Baklund wrote:
[EMAIL PROTECTED] wrote:
I need to get all the details of an employee whose salary is the lowest.
I can do like this in Oracle
select * from emp where id = (select min(id) from emp).
Can we have any alternative in MySQL
Or.. Select * from emp order by id asc limit 0,1 if you want to fetch
all details.
-Original Message-
From: Jason McKnight [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 01, 2004 7:21 PM
To: [EMAIL PROTECTED]
Subject: Re: Reg SubQuery
You could also do it like this:
select
[EMAIL PROTECTED] wrote:
Or.. Select * from emp order by id asc limit 0,1 if you want to fetch
all details.
That was what I said, but lets take a closer look at what the original
poster asked:
I need to get all the details of an employee whose salary is the lowest.
Now, in his example he used
I don't have your configuration but I do have 2 servers running with
3ware controllers (800 or so megs in RAID 5 on each). They are stable
and performance is good. I don't run MySQL on these however. I also have
an AMD64 box running Fedora/AMD64/MySQL and everything is stable. My
AMD64 box is
Roger Baklund wrote:
That leaves us with the answer from Gleb Paharenko, except the insert
query should be insert into memp select min(salary) from emp;
... and the select should be:
select emp.* from emp,memp where salary=m;
He would get all employes with the lowest salary, as opposed to:
select
Hi List.
Please excuse the cross posting but I've been scouring the archives
and no joy as yet.
I'm trying to get Perl and MySQL using utf8 happily and I've followed
several tutorials but am not getting the same results.
I've got a load of utf8 characters like so (perl):
my %uni = (
I would recommend Raid 10 over Raid 5 even if it's kinda a big hit on your
storage cabality.
http://www.experts-exchange.com/Storage/Q_20640972.html
I'm successfully running a Master/Slave setup with the following machines:
Quad Opteron 64 / 32G RAM
Dual Opteron 64 / 16G RAM
Using gentoo
Someone else suggested that I remove all spaces before and after = and
between CONCAT and (...). This worked. Too bad the manual is not more
specific.
Thanks for your concern,
Tom
On Nov 30, 2004, at 7:14 PM, Michael Stassen wrote:
At this point, what you say you are doing should work, but
Hi list,
I have a question regarding mysql and innodb.
My current setup uses myisam and the db size is about 1.6 GB with two
table that each have about 500k rows. I perform alot of fulltext search
on these tables and they can sometimes take along time to finish and
when the table is locked
in MS SQL u can do it by the following query:
declare @transool varchar(20)
set @transool = 'opcofficelink'
begin transaction @transool
insert into Table1 (Sine_20_Sec, Sine_30_Sec) values (@Sine_20_Sec,
@Sine_30_Sec)
insert into Table2 (Sine_20_Sec, Sine_30_Sec) values (@Sine_20_Sec,
On Wed, 1 Dec 2004 14:16:40 +0100
Sergei Golubchik [EMAIL PROTECTED] wrote:
character_set_client = A
character_set_connection = B
character_set_database = C
character_set_results = D
character_set_server = E
character_set_system = F
F is always utf8
a table named table = G
a
I'm not sure if you have a problem with one large InnoDB table or one
large file. With InnoDB you can specify multiple files, limit the size
of each file and even specify the location of each file. So you could
limit your InnoDB files to say 1GB each (or lower/higher) and specify
which disk
Greetings,
While waiting for the repair table reactions I thought to ask a question
that hogged in my head for a while.
I have a db which has among others (including text fields) a timestamp
field and a counter field.
I want to make statistics from them, doing sum()s with conditions
- Original Message -
From: angie ahl [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, December 01, 2004 9:26 AM
Subject: Unicode (utf8) and MySQL (with Perl)
Hi List.
Please excuse the cross posting but I've been scouring the archives
and no joy as yet.
Fredrik Carlsson wrote:
Hi list,
I have a question regarding mysql and innodb.
My current setup uses myisam and the db size is about 1.6 GB with two
table that each have about 500k rows. I perform alot of fulltext search
on these tables and they can sometimes take along time to finish and
when
Bgs wrote:
[...]
I have a db which has among others (including text fields) a timestamp
field and a counter field.
I want to make statistics from them, doing sum()s with conditions
'timestampP1 and timestampP2' 'timestampP2 and timestampP3' and so on.
A trivial way would be to make a cycle for
You don't give a lot of details, but perhaps something like
SELECT SUM(IF(timestamp=P1 AND timestampP2,1,0)) period1,
SUM(IF(timestamp=P2 AND timestampP3,1,0)) period2,
SUM(IF(timestamp=P3 AND timestampP4,1,0)) period3,
...
FROM yourtable ...
would do the trick.
Thanks for the tips! I'll be playing with them tomorrow. I think with
this method, the processing time will drop from Nx to between 1x-2x pass
time. ('N' in my case is usually between 5 and 100).
Regards
Bgs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Roger Baklund wrote:
Fredrik Carlsson wrote:
Hi list,
I have a question regarding mysql and innodb.
My current setup uses myisam and the db size is about 1.6 GB with two
table that each have about 500k rows. I perform alot of fulltext
search on these tables and they can sometimes take along time
4.0.18 does not support subqueries. You need 4.1 for that. In 4.0.18,
you'd write this as a JOIN
SELECT t1.* FROM table t1
JOIN table t2 ON t1.id = t2.id
WHERE t2.one = 4;
By the way, I assume that was a made up example, as it really doesn't
require either a subquery or join:
SELECT
I wonder, if BETWEEN will work inside IF statement...
- Original Message -
From: Roger Baklund [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Bgs [EMAIL PROTECTED]
Sent: Wednesday, December 01, 2004 10:28 AM
Subject: Re: multi period sum() selects
Bgs wrote:
[...]
I have a db which has
You might want to consider the following site and collection of s/w
http://www.apachefriends.org
I have successfully installed XAMPP on both Windoze Linux from their
downloads.
On Wed, 01 Dec 2004 08:44:49 -0500, Jason McKnight
[EMAIL PROTECTED] wrote:
This may be a bit off-topic for the
Spaces on either side of = are not a problem, but you must not put a space
between the name of a function and the opening parenthesis. From the manual
http://dev.mysql.com/doc/mysql/en/Functions.html, Note: By default, there
must be no whitespace between a function name and the parenthesis
It will, but BETWEEN is inclusive of both endpoints, so there would be a
possibility of overlap with
SELECT SUM(IF(timestamp BETWEEN P1 AND P2,1,0)) period1,
SUM(IF(timestamp BETWEEN P2 AND P3,1,0)) period2,
SUM(IF(timestamp BETWEEN P3 AND P4,1,0)) period3,
...
I would like to try out MySQL on my UNIX account (Solaris).
I DO NOT HAVE root privilieges in UNIX. I only have a normal user
privilege.
I have installed MySQL on my user UNIX account.
Looks like I get the Server going and can also get the status from the
Server.
But, I get an error msg
I'm storing telephone number (US) in 10 digit
varchars. If I want to do a search on just the area
code, is there a way to limit it to just the first 3
digits of the string ?
Thank you
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I have a server that is Windows 2003 server. It is running php from IIS
6. I access the latest 4.0x MySQL and am having some trouble. My
database access is readonly. The user that I connect as has update
privileges (all privileges, actually). We checked the file permissions
to the Mysql
Hi,
MySQL Query Browser 1.1.2 and MySQL Administrator 1.0.15 have been
released.
MySQL Query Browser is a GUI query shell, intended to allow
execution of SQL queries from a Web browser alike easy to use
interface. It has such handy features as query history and
bookmarking, tabular visualization
--- Stuart Felenstein [EMAIL PROTECTED] wrote:
I'm storing telephone number (US) in 10 digit
varchars. If I want to do a search on just the area
code, is there a way to limit it to just the first 3
digits of the string ?
Thank you
Stuart
I'm trying something like this but still
Stuart Felenstein wrote:
I'm storing telephone number (US) in 10 digit
varchars. If I want to do a search on just the area
code, is there a way to limit it to just the first 3
digits of the string ?
I'm trying something like this but still getting back
the whole string:
select Telephone from
I have a new project I'm working for and I was
wondering if anyone could help me optimize my selects
for speed. I have a table with about 500,000 entries.
The table structure I'm using is (via my PHP
commands):
$sql = CREATE TABLE $store_data_table (
$store_data_column[sku]
Restart mysqld with the --skip-grant-tables option
and then try
Aman Raheja
Hossain, Ashfaq (Ashfaq) wrote:
Thanks.
But, it confuses the unix root with the mysql root.
I don't have the unix root previleges.
Am I doing something wrong?
Here is the error:
unix bin/mysql -uroot
ERROR 1045
--- sol beach [EMAIL PROTECTED] wrote:
Of course you do.
You are asking for all of Telephone to be returned.
Duh!
I'm trying something like this but still getting
back
the whole string:
select Telephone from SignUp
where
Left (SUBSTRING(Telephone,1,3), 3) LIKE '4%'
--- Roger Baklund [EMAIL PROTECTED] wrote:
It's a bit unclear what you are trying to do. Are
you trying to find all
numbers within a 3 digit area code, i.e. numbers
starting with some 3
digits? Or are you trying to find numbers with any
of the three first
digits equal to 4?
For the
--- Stuart Felenstein [EMAIL PROTECTED] wrote:
--- Roger Baklund [EMAIL PROTECTED] wrote:
Yes, I had not included in my original post I wanted
just the area code returned. It works -
select SUBSTRING(Telephone, 1 ,3) from SignUp
where
Left (Telephone, 3) LIKE '4%' ;
Thank you
Stuart
Have you tried connecting with this user directly from the MySQL monitor?
Hathaway, Scott L wrote:
I have a server that is Windows 2003 server. It is running php from IIS
6. I access the latest 4.0x MySQL and am having some trouble. My
database access is readonly. The user that I connect as
Brooks, this isn't an answer to your question, but a question to you
regarding what you have done.
I would like to do a query such as:
SELECT title FROM books WHERE title LIKE '%Francais%';
And in return get:
+--+
| title|
+--+
| Français |
+--+
Does the CHARACTER SET
Grant Giddens wrote:
I have a new project I'm working for and I was
wondering if anyone could help me optimize my selects
for speed. I have a table with about 500,000 entries.
The table structure I'm using is (via my PHP
commands):
$sql = CREATE TABLE $store_data_table (
Does anyone know where I can get the [latest] free version of MySchema?
Seems both brandosoftware.com fell off the edge of the world - MySchema
along with it.
Failing that I'm looking for a free/reasonable ERD tool.
Any/all suggestions welcome.
Thx Attila
--
MySQL General Mailing List
For
Can anyone explain how to setup a table that contains text in any
language for searching using english characters?
Let's say I want to search for the word Francais, but in the database
it is stored as Français.
Any help is appreciated
Andrew
--
MySQL General Mailing List
For list archives:
DBVisualizer, it's great and FREE
Attila Horvath wrote:
Does anyone know where I can get the [latest] free version of MySchema?
Seems both brandosoftware.com fell off the edge of the world - MySchema
along with it.
Failing that I'm looking for a free/reasonable ERD tool.
Any/all suggestions
At 01:09 PM 12/1/2004, you wrote:
DBVisualizer, it's great and FREE
DBVisualizer is free to try, but it costs $99.
http://www.minq.se/products/dbvis/
Mike
Attila Horvath wrote:
Does anyone know where I can get the [latest] free version of MySchema?
Seems both brandosoftware.com fell off the
On Wed, 1 Dec 2004, Rhino wrote:
I'm using mysql 4.1.7 and perl 5.8.1 on OS X 10.3
It also wouldn't hurt you to upgrade past all the minor updates of your
other components. That means 4.1.7 (check), 5.8.6, and 10.3.6. I'm sure
Perl had a lot of bug fixes or improvements after 5.8.1,
I am trying to find a list of people based on renewal dates, the logic of
the query would be:
Select everything from the db where the last renewal date is between a and
b, or if there is no last renewal date then where the signup date is between
a and b
The query that I have is something like:
Hi There,
I am having trouble installing MySQL on my system (Netra X1 - UltraSparc II
- FreeBSD 5). I can't find any documentation on how to install for this
system, nor can I find the binaries.
Thanks for any help!!
Richard
To answer your question, we need to pretend to be your MySQL server for a
second. You appear to be posing the following question to your server
SELECT playlist.name as playlist_name
, artist.name as artist
, artist.'.$language.' as bio
, artist.purchaseLink
,
Hi There,
I am having trouble installing MySQL on my system (Netra X1 - UltraSparc II
- FreeBSD 5). I can't find any documentation on how to install for this
system, nor can I find the binaries.
Thanks for any help!!
Richard
Fix your mysql privileges
http://dev.mysql.com/doc/mysql/en/GRANT.html
DVP
Dathan Vance Pattishall http://www.friendster.com
-Original Message-
From: Hossain, Ashfaq (Ashfaq) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 01, 2004 8:39 AM
To: [EMAIL PROTECTED]
In the last episode (Dec 01), Richard C Komatz said:
I am having trouble installing MySQL on my system (Netra X1 - UltraSparc II
- FreeBSD 5). I can't find any documentation on how to install for this
system, nor can I find the binaries.
cd /usr/ports/mysql41-server ; make install
should be
You don't need an IF only parentheses. This is almost a literal
translation of your exact statement
Select *
from db
where (last_renewal_date between '2004-11-01' and '2004-11-30')
or (last_renweal_date is null
AND signup_date between '2004-11-01' and '2004-11-30'
)
order by
I've got 3 amd64 machines running mysql. One with 32 gigs of memory and 2
with 16gigs. All of them are quad 848's. We use fedora core 2 on all of
our boxes.
2 of the boxes are pushing over 3000 queries per second. And one is over 4k
per second.
Personally, I have about 30 mysql boxes, and
cd /usr/ports/databases/mysql41-server make install clean
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Richard C Komatz [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, December 01, 2004 12:00 PM
Subject: Re: Help with installation: MySQL, FreeBSD 5, Sparc64
In
I ran mysqld with arguments --default-character-set=utf8 and
--default-collation=utf8_unicode_ci, and created a table with no collation
specification. I didn't test specifically with ç, but e and e-acute were
equivalent. For me this is was problem, but it sounds like for you it's the
desired
Brown, Brooks wrote:
I ran mysqld with arguments --default-character-set=utf8 and --default-collation=utf8_unicode_ci, and created a table with no collation specification. I didn't test specifically with ç, but e and e-acute were equivalent. For me this is was problem, but it sounds like for you
Andrew,
You can download a FREE version of MY dbPAL for MySQL at www.it-map.com
to help you out with this. My product is free, it does database and data
migrations, schema editing, data modeling, change management, database
documentation and has ETL tools in there as well.
We were listed
Hey,
I haven't used AMD64's, but we're running our production on a machine
with a 3ware 9508 running RAID10 with RHES 3. It's a beautiful setup.
The 3ware cards are an excellent choice, but as other posts say, use
RAID 10. If possible put your InnoDB logs onto a seperate array as
well.
out.
On
- Original Message -
From: Mike Morton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 01, 2004 2:47 PM
Subject: If statement in a where query
I am trying to find a list of people based on renewal dates, the logic of
the query would be:
Select everything from
Dana Henderson a écrit :
Andrew,
You can download a FREE version of MY dbPAL for MySQL at www.it-map.com
to help you out with this. My product is free, it does database and data
migrations, schema editing, data modeling, change management, database
documentation and has ETL tools in there as
I have 400 AMD 64 box 60 of which have 8 GB of data use for databases. Each
server does about 5K qps and many of our clusters do 30K qps. We use Suse
Enterprise Linux 8. I've done numerous benchmarks to know that AMD Operton
is a better platform over XEONS period.
DVP
Dathan Vance
Denys
No I get the same problem and I'm from U.S.! :-(
Attila
On Wed, 1 Dec 2004, denys wrote:
Date: Wed, 01 Dec 2004 22:02:47 +0100
From: denys [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: free ERD tool for MySql
Dana Henderson a crit :
Andrew,
Dan Sashko wrote:
Hi, anyone has suggestions what changes to make to allow this query to
run faster?
SELECT domain FROM tbl_1
WHERE
id 0 and id 2
domain = 12.221.190.111
AND score IS NOT Null
AND data LIKE %param=search
GROUP BY domain, data
--
every one of those WHERE clauses
Fredrik Carlsson wrote:
Hi list,
I have a question regarding mysql and innodb.
My current setup uses myisam and the db size is about 1.6 GB with two
table that each have about 500k rows. I perform alot of fulltext search
on these tables and they can sometimes take along time to finish and
when
This did not mean that's how you should work. I had this suggestion to
confirm my doubt that something in the user table of mysql is messed up
This was to allow you to setup a password for root or maybe another user
(who can create)
and then switch back to normal mysqld startup, to enable grant
On Wednesday 01 December 2004 16:34, [EMAIL PROTECTED] wrote:
To confirm that you would like
[EMAIL PROTECTED]
added to the mysql mailing list, please click on
the following link:
http://lists.mysql.com/s/mysql/41ae38de2b6fe004/fraser=georgetown.wehave.ne
t
This confirmation serves
or maybe it's me :)
Anyway here is my table
++--+
| RecordID | School |
| PID,AI,INT | Varchar|
++--+
| 108 | Columbia |
+|--+
| 108 | Princeton |
+|--+
| 108
Stuart Felenstein wrote:
[...]
But if in the where statment I add:
where School = Columbia and School = Stamford
Nothing is returned
The WHERE clause describes EACH of the rows you get in the result. No
one row can have a value in the School column equal to Columbia AND
Stamford at the same
There is nothing weird about that behavior. You asked for all of the rows
where the School column has both of two different values at the same time.
WHERE School='Columbia' and School='Stamford'
if School is 'Columbia' the first part is true but the second part can't
be and vice versa. Your
--- [EMAIL PROTECTED] wrote:
There is nothing weird about that behavior. You
asked for all of the rows
where the School column has both of two different
values at the same time.
I thought joins were difficult to comprehend ;)
Try an OR instead or use the IN() operator.
WHERE
Attila Horvath a crit :
No I get the same problem and I'm from U.S.! :-(
Attila
It was just a temporary problem, I tried it again just now and it worked.
Denys
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--- Roger Baklund [EMAIL PROTECTED] wrote:
The WHERE clause describes EACH of the rows you get
in the result. No
one row can have a value in the School column equal
to Columbia AND
Stamford at the same time. You should use OR
instead of AND.
Thank you Roger. That is one of the best
How did you deduce that the database server is the bottleneck? Are all
your processes running on the same machine?
Andrew Nelson wrote:
Hi,
I have a MySQL 3.23.55 server managing accounts on my exim mail server..
The table type on all tables MyISAM.. I have the MTA performing
various queries
Hi,
I have a MySQL 3.23.55 server managing accounts on my exim mail server..
The table type on all tables MyISAM.. I have the MTA performing various
queries
for each incoming email - determining mail aliases, vacation messages and
filtering rules etc but they're all pretty much SELECT
Hi all-
I'm using MySQL 4.1.7, trying to do a subquery that's apparently unsupported -
I'm hoping someone can provide a quick alternative for me.
I have a simple table Z with 3 columns, k1, k2, and total_amt, where k1 and k2
make up the primary key. I want to create a report that lists the the
isn't the where subquery would always return only one record if set of
(k1,k2) is a primary key?
I dont have 4.1+ installed to test on but if you remove 'limit 10' and run
it don't you get the same list as if you ran 'select k1,k2,total_amt from Z'
?
- Original Message -
From: Rick
Howdy all,
I've got a series of tables that are used to store a
user's session information. The main table is a very
simple table that stores a GUID and a last access
data-time value. All other tables use the guid as a FK
back to this main table.
The main table's schema is as follows:
CREATE
Hi,
It seems that all of my users can issue the SHOW DATABASES
command and receive a list of all databases even though their
Show_db_priv setting is N. I am running mysql 4.0.16.
The manual states As of MySQL 4.0.2, you will see only those
databases for which you have some kind of privilege, if
On Wednesday 01 December 2004 22:09, Fraser Campbell wrote:
The manual states As of MySQL 4.0.2, you will see only those
databases for which you have some kind of privilege, if you
don't have the global SHOW DATABASES privilege. so I see
two possibilities:
- users have the global SHOW
Hi Victor,
How did you deduce that the database server is the bottleneck? Are all your
processes running on the same machine?
Because 'ps -aux' shows it running at 94% of the CPU and when I
stop/start the mysql server, it seems to be ok again for another
hour.
Any ideas?
Andrew Nelson wrote:
The reason I ask is because eight select statements should not bog down
a production server. On the MySQL side, is anything being written to the
slow query log? On the application side is there any virus scanning or
similar activity being performed? Does iostat show any heavy reading or
The reason I ask is because eight select statements should not bog down a
production server. On the MySQL side, is anything being written to the slow
query log? On the application side is there any virus scanning or similar
activity being performed? Does iostat show any heavy reading or
hello,
Example : i hv a table containg date, flower, perfume,codeno,regno etc
There are some row which have only flower entries for a day. there are
some rows which have only perfume entries for a day.
some rows have both florwer and perfume entries for a day..ie same day
contains both
Check whether below query helps u ?
Select * from db where IFNULL(last_renewal_date,signup_date) between
'2004-11-01' and '2004-11-30'
Regards
--Yoge
Mike Morton wrote:
I am trying to find a list of people based on renewal dates, the logic of
the query would be:
Select everything from the db
Hi,
MySQL 5.0.2-alpha, a new version of the popular Open Source/Free Software
Database Management System has been released. It is now available in source
and binary form for a number of platforms from our download pages at
http://dev.mysql.com/downloads/ and mirror sites.
Note that not all
wow this is a massive feat, 5 will make many people proud, 4.1 has done
the same aswell as 4.0.Well done, if you need testers for solaris or OSX lemme
know. I also had a
question thoughregarding INNODB and fulltext searching, when is this going to
be made
available or if ever ? I'vehad to do
Hey everyone -
I just migrated a database from one server to another (4.0.18 official RPM
on RH ES 3) and now on the new server I'm running into a problem where
queries hang in state statistics as shown by 'mysqladmin processlist'. I
tried to see if there was something wrong with the queries
hi
i want to do a insert query which contains
utf 8 (japanese characters) characters in the database but surprisingly when i
done this it stores ??? and also when i retrieves it fails to give actual
picture
iam using mysql 4.1.b alpha using mysqlcc as
my editor and dos promt
looking for
1 - 100 of 102 matches
Mail list logo