MyTOP says this particular slave has been up 47 days, 2 hours... It's had
56M queries, of those 4,559 were slow... Not being a MySQL expert, I'm
not sure how to get slow queries/hour directly from MySQL.
You would use SHOW STATUS, but mytop did it for you :-)
Do you mean using a load
Is the Max edition of 4.0.7 necessary for a server with RAID.
Or can the standara edition be used?
By 'a server with RAID' you likely mean a server with a hardware
RAID array. In that case you can use any distribution. This is totally
independent of MySQL. Your only concern is to make your
Hi,
I'm trying to use to following HANDLER syntax :
HANDLER tbl_name READ index_name=(value1);
However I fail since I don't know what is 'index_name' for a PRIMARY KEY (I
already tried PRIMARY, `PRIMARY KEY`, and the column name without success).
Any idea ?
BTW, are HANDLER statements cached
David,
Oh, to be sure. And maybe we could even get the mysql.com folks to
prominently list a pointer to the off-site FAQ if they don't want to
maintain it or give out accounts to maintain it. I just wouldn't want
to
see it dropped if they don't jump on it at the start.
I agree. Will you
James,
something that can be based upon pages of htm and
emails that exists, and that can sit under a few web pages
using Htdig or alkaline or something...
Do these tools work better that the search tool (Mnogo search) at
http://lists.mysql.com/php/search.php? This thing sucks - I was looking
Terence, Rich,
I have tried:
LOAD DATA LOCAL INFILE lcopen1.txt INTO TABLE lcopen;
but it shows:
ERROR 1148: The used command is not allowed with this
MySQL version
This is because of security issues, as the manual says:
In MySQL 3.23.49 and MySQL 4.0.2, we added some new options to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan, et al --
...and then Stefan Hinz, iConnect (Berlin) said...
%
% David,
%
% see it dropped if they don't jump on it at the start.
%
% I agree. Will you set it up at http://justpickone.org/? (BTW, I like
Sure; it's the least I can do.
To the MySQL group!Happy 2003 and have a safe holiday season...
Hopefully this got past the filter LOL
Chuck
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello and hope that everybody on this list will pass a wonderful 2003 year,
Here's my worry:
I have 3 tables, one for genre, one for html and one for shockwave
html and shockwave have a foreign key genreID
I want to count for each genre how many html and shockwave entries have the
same genreID,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I need, I think, some pointers to basic JOIN tutorials. I don't really
know how to approach this query. I should say early on that I don't
expect the list to write my code for me, though any help anyone can send
is VERY much appreciated;
Hello All,
I have a need to build some user functionality (text search) that is
similar to the search functions available in most search engines. I would
like to have users input a search string and find the appropriate records
in MySql, for example:
database software development linux
Part
David,
I am unsure if I followed your example completely, but maybe this might
help. Not knowing your complete database structure, I am unsure if my
comments will be entirely valid but here goes.
I think you could achieve your goal if you think of your groups as
containing one or many clients.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Frank, et al --
...and then Frank Peavy said...
%
% David,
% I am unsure if I followed your example completely, but maybe this might
% help. Not knowing your complete database structure, I am unsure if my
% comments will be entirely valid but here
David,
Just some thoughts..
See my comments below...
A scheduling, or a booking, eventually has to have a class type (private
or one of many groups -- so I suppose I could simply make a group class
type 'private' and that type has only one slot), an instructor, a place,
a time slot, and the
Hi,
I have got 2 tables one of the is customers the other is bill. In the
customers table i store my customers informations. In the bill table i store
my billings. if i take a bill bill.direction=0, if i give a bill
bill.direction=1. And now i must take a report Like This..
Customer Code
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Frank --
...and then Frank Peavy said...
%
% David,
% Just some thoughts..
% See my comments below...
Thanks!
%
% A scheduling, or a booking, eventually has to have a class type (private
% or one of many groups -- so I suppose I could simply
Even so, that still doesn't answer the question of how to have data of
different magnitude in the same table. If I have one class with one
person and another with two people, how would I have a single record for
each which lists the client(s)?
Easy,
Your scheduling query results, as I said:
alkaline has been around awhile. the model is similiar
to mysql in that they have a commercial version that sustains them,
and a free version that sustains the rest of us.
there is not a doubt that its better than the php script you refer to
below...
By looking at your query and table description, I guess you can try
something like:
SELECT cus.`Code` AS `Customer Code`,
cus.`Name` AS `Customer`,SUM((1-bil.direction)*bil.Total) AS Loan,
SUM(bil.direction*bil.Total) AS Credit
FROM customer AS cus,
bill AS bil
WHERE bil.`Customer` = cus.`ID`
I was able to create the gid table with no problem under mysql 4.0.7
CREATE TABLE gid (
id INT(11) NOT NULL auto_increment,
groupname VARCHAR(128) NOT NULL,
passwd VARCHAR(128) NULL,
gidINT(11) NOT NULL,
username VARCHAR(128) NULL,
Can anyone help me?
I get this whenever I run ./configure --prefix=/usr/local/mysql
checking for termcap functions library... configure: error: No
curses/termcap library found
then configure quits. I'm really new to linux, so please give me the
lamans version of it ;)
If I am reading the documentation correctly, MySQL will not maintain a
UNIQUE INDEX across the tables that make-up a merged table. Does anyone
have any tips for maintaining a UNIQUE INDEX across tables that make up
a merged table?
Is there an easier way than running a SELECT statement on all of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Frank --
...and then Frank Peavy said...
%
% Even so, that still doesn't answer the question of how to have data of
% different magnitude in the same table. If I have one class with one
% person and another with two people, how would I have a
Hello.
On Wed 2003-01-01 at 15:38:23 -0500, [EMAIL PROTECTED] wrote:
If I am reading the documentation correctly, MySQL will not maintain a
UNIQUE INDEX across the tables that make-up a merged table.
Correct. Although it is called a UNIQUE index, the MERGE table doesn't
hold it's own index and
David,
Sure; it's the least I can do. Look for mysql.justpickone.org to be
in
the DNS tables by tomorrow. By then the
[EMAIL PROTECTED]
mailing list will be ready for subscriptions, too.
Fine. http://mysql.justpickone.org/ works :)
Now, what do we need to do to be able to update this FAQ?
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
I recently found this web-based front end and am extremely impressed by
it. Among other things,it lets you bookmark your sql queries.
http://eskuel.sourceforge.net/
-bill
Richard Nagle wrote:
what would be the easy to use, gui front end for
mySQL 3.23.53 (for Mac OS X )
Thanks Again,
Richard
Hi Frank,
the full text search from MySQL is probably what you are looking for. You
can read more about it in the online documentation.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Ful
ltext_Search
Cheers,
Pieter
- Original Message -
From: Frank Peavy
Well after 3 times installing mysql, finally
got it working (tks to those whom help)
now I need to take care of user and root.
first root.
mysql mysql -u root mysql
just want to confirm this is correct before I push enter.
mysql update user set password=password('tko')
where user='root';
I'm not following this threath.. but..
Use PHP to fetch mail from a mailbox, insert all questions into a database.
Create a searchtool to search the database.
No need to have way to many ppl as author. If you want you could have some
ppl maintaining a list of keywords per question or remove a
Title: ÌØ´óϲѶ
×â
´º½Ú°ÙÍò´óÐж¯ ËÍ
¡¡
Hi
Like the look of the way its taking shape.
I am not sure if there is existing faq software (I've checked sourceforge
and freshmeat without much luck) we could use, or if someone can do a better
job :) but I have a content management system written, together with a lot
of the search
OK I got files to upload to my MySQL server but now how do I retreive them
for distribution by email for instance.
When I do a query the filename looks something like:
/var/tmp//phptkYxkV
I'm not sure where that is but I need to retrieve that file and distribute
it...
Any suggestions would be
I really need your help, I installed MySQL and I can
connect to it through localhost but when trying to
access it from outside I get:
ERROR 2003: Can't connect to MySQL server on 'IP'
(111)
Any suggestions?
Someone suggested that the problem is because the
server has 2 nics (2 ips set up).
Hi
Is '111' the IP it is trying to connect on?
If so it is an invalid IP.
If the IP is valid how are you trying to connect?
Peter
---
Excellence in internet and open source software
---
Sunmaia
Birmingham
On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote:
I am not sure if there is existing faq software (I've checked
sourceforge and freshmeat without much luck)
Really?
That's a wheel I've seen re-invented many times. I know there's stuff
out there.
--
Jeremy D. Zawodny |
Hi
I was looking for a reasonably heavyweight php application, there are some
lightweight ones and some half finished ones and some perl ones, but none
that were what I was looking for.
Any suggestions would be appreciated, no point in reinventing the wheel.
Peter
On 1/1/03 2:31 PM, Richard Nagle [EMAIL PROTECTED] wrote:
Well after 3 times installing mysql, finally
got it working (tks to those whom help)
now I need to take care of user and root.
first root.
mysql mysql -u root mysql
just want to confirm this is correct before I push enter.
OK I got files to upload to my MySQL server but now how do I retreive them
for distribution by email for instance.
When I do a query the filename looks something like:
/var/tmp//phptkYxkV
I'm not sure where that is but I need to retrieve that file and distribute
it...
Any suggestions would be
The 111 is the error code that MySQL generates.
Check if your computer has a firewall, and make sure to enable port 3306
from external IPs
e.g. on redhat using ipchains-based firewall, add:
-A input -s 0/0 -d 0/0 3306 -p tcp -y -j ACCEPT
to your /etc/sysconfig/ipchains file (or however the
Hi!
How can I print the results to the printer in
Windows2000 environment? Is there any MySQL command
for this purpose? How about the MySQL Control Center?
I have tried to search for an answer, but mostly for
the unix system. Is there any simple solution since I
am not a programmer?
Terence
./myqld: Can't find file : './mysql/host.frm' (errno:13)
does anyone know how to solve this problem?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
42 matches
Mail list logo