Ratheesh K J wrote:
Hello all,
I am required to analyze all the tables of our system. I need to know the key
parameters that should be taken into consideration for analysis. I am not speaking
about ANALYZE TABLE . I am required to manually look into all table
structures and pin point problems
If i was you i'd start reading the manual. Look under the optimization
chapter. Also, brush up on database normalization and look into how
exactly the tables are being used - run explains on the sql statements
that are used with the tables and see how you can optimize index usage.
Ratheesh K J
Hello all,
I am required to analyze all the tables of our system. I need to know the key
parameters that should be taken into consideration for analysis. I am not
speaking about ANALYZE TABLE . I am required to manually look into
all table structures and pin point problems ( if any ).
So it wo
Looks like drupal had an error when doing the backup - mysql is
complaining over the fact that your backup.sql file contains a html
formated fatal error message.
Kaushal Shriyan wrote:
Hi ALL
I have taken backup of http://mydomain.com/?q=admin/database through
drupal 4.6.3 by selecting all t
Hi ALL
I have taken backup of http://mydomain.com/?q=admin/database through
drupal 4.6.3 by selecting all tables and it asked me to save as
backup.sql.
Now when i run
[EMAIL PROTECTED] root]# mysql -u kaushal -h bdc31096e.in.office.aol.com -p
drupal < /home/kaushal/drupal/backup.sql
Enter pass
At 11:10 PM 8/2/2006, Peter Brawley wrote:
Barry
>It would make life easier if I could also show a column
>with the cumulative count for each month.
Set @cum - 0;
Select
Monthname(DatePaid) Month,
Year(DatePaid) Year,
Count(*) as Registrations,
Extract(Year_Month from DatePaid
Barry
>It would make life easier if I could also show a column
>with the cumulative count for each month.
Set @cum - 0;
Select
Monthname(DatePaid) Month,
Year(DatePaid) Year,
Count(*) as Registrations,
Extract(Year_Month from DatePaid) AS Monindex,
@cum := @cum + Count(*) AS
Back with another registration db question:
Have a convention database which tracks people as they register all year
long; the actual convention is held in October. I've got a fairly simple
query which shows how many people registered in each calendar month--useful
to compare to prior year to
just to clarify to Brent, the songs lists the original artist and album. the
CD table is for the information for a NEW mix CD. that CD contains the
tracks listed in the tracks table, which point back to the individual songs.
the reason the tracks are not listed in the songs table, is because they
Yes, I did so...
I will check the other configuration.
Thanks,
Kenji
On 8/2/06, Dilipkumar <[EMAIL PROTECTED]> wrote:
Hi,
First reset slave and then change master to script run it.
Thanks & Regards
Dilipkumar
- Original Message -
From: "Kenji HIROHAMA" <[EMAIL PROTECTED]>
To: "Dilipku
At 05:27 PM 8/2/2006, you wrote:
Hi!
I'm getting a lot of pushback on using mysql for full-text searching on
over 30,000,000 documents. It's starting to slow down when using more than
10-15 keywords. Is there an alternative anyone is using?
I don't want to replace the database, but I do need
Forgive the mess I present you, this is a strangely done site with a even
stranger structure and methodology that I am trying to work with.
The basic idea is one website has multiple websites in it. So if you place
an order with website A, orders_A is where the data is stored, if you place
an ord
It depends what you need and how your data looks.
Say you have a table with 4 columns:
col1 has 1000 dictinct values
col2 has 1 dictinct values
col3 has 100 dictinct values
col4 has 10 dictinct values
In this case:
select col1,col2 from tbl where col1=... and col2=...
Having a single
Hi,
up to now my idea of how MySQL uses indexes was, that when I have a WHERE
clause with several fields and I have an index on each field, MySQL chooses
one index (from which it thinks that it will return the fewest rows when
matched again the condition) and uses this index to "select" a couple o
Sorry, but that's how I was normally trained to use SQL and to name
variables. I know netiquette, it's just how I was trained on the system.
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 2006 11:35 AM
To: John Meyer
Cc: mysql@lists.mysql.com
Sub
You can tune the fulltext search in a few ways using the config, try
read up on the various server variables that has to do with fulltext
indexing. Other than that there is always the option of upgrading the
hardware :)
[EMAIL PROTECTED] wrote:
Hi!
I'm getting a lot of pushback on using mysq
On Wed, 2006-08-02 at 11:13 -0600, John Meyer wrote:
> I have two tables:
>
>
> MEMBERS:
> MEM_ID
> ...
>
> GROUPS:
> GRO_ID:
> ...
>
> And one joiner
>
> MEM_GRO:
> MEM_ID, GRO_ID
>
>
> I want to print out a list like this
>
> GROUP_NAME, NUMBER_OF_MEMBERS
>
> Even when the number of memb
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco wrote:
> The question is, how do I query this? Say I want all records from table
> T whose COLOR property value is ORANGE.
>
> The only thing I can come up with (and I'm no SQL expert and this looks
> wrong to me) is the following:
>
> SELECT *
>
Rob Munsch,
I am a member of the Nabble project. This is regarding a bad post by user
"itguy321".
Just want to explain a few things. Nabble is a free mailing list
archive/gateway that works like Gmane. Users can browse, search, and post
via Nabble's web interface and the post will be forwarded
hi..
i have FC3, with 4.1.13, i also have FC4 with 4.1.20. however, i can't seem
to find 5.0.x RPMs for FC3/4. do i have to go ahead and build this from
source for the FC3/4 boxes that i have...
thanks
-bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
Hi!
I'm getting a lot of pushback on using mysql for full-text searching on over
30,000,000 documents. It's starting to slow down when using more than 10-15
keywords. Is there an alternative anyone is using?
I don't want to replace the database, but I do need to speed up the keyword
search.
Bruce
>tried to get to the link...saw that it's 'localhost'!!
Sorry! http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
PB
-
bruce wrote:
hi peter...
tried to get to the link...saw that it's 'localhost'!!
what's the real/actual url...
-bruce
-Original M
Yeah, I just figured it out ten minutes ago, one of those stupid little
oversites on my part.
-Original Message-
From: Martin Jespersen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 2006 3:40 PM
To: John Meyer
Cc: mysql@lists.mysql.com
Subject: Re: Doing a join
select g.GROUP_NAM
select g.GROUP_NAME, count(mg.MEM_ID) as NUMBER_OF_MEMBERS from GROUPS g
left join MEM_GRO mg using(GRO_ID) group by g.GRO_ID
John Meyer wrote:
I have two tables:
MEMBERS:
MEM_ID
...
GROUPS:
GRO_ID:
...
And one joiner
MEM_GRO:
MEM_ID, GRO_ID
I want to print out a list like this
GROUP_N
RAID 10 = good choice.
I've worked a lot more with MyISAM, where OPTIMIZE TABLE does lock it
for the duration. I note that for InnoDB, OPTIMIZE TABLE is mapped to
ALTER TABLE, and so I expect it will be locked for the duration as
well. Perhaps someone else can confirm - all my InnoDB tables rig
hi peter...
tried to get to the link...saw that it's 'localhost'!!
what's the real/actual url...
-bruce
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 2006 2:15 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: logic/db qu
Bruce,
my question, how can i come up with a sql query that will list all the
children (and children's children...) of a top level item?
This is an edge list tree model, ID being the child node, parentID being
the parent node, the row denoting the edge between ID and parentID.
Unless you kno
itguy321 wrote:
(garbage snipped)
http://www.ecora.com/ecora/products/documentor.asp
Full original spam source at end, for the benefit of our CCs.
Reports sent, omitting the MySQL hosts obviously. Ignoring the bogus
yahoo address, the actual sender and the spamvertised host have been
se
I've dealt with this in terms of Books and Titles. Those two are separate:
one title can have many book editions published in it. Also, you can have a
book with multiple titles (anthology, for instance).
I suppose it is possible for album not to be the same as cd title,
particularly if you have o
hi...
i have a tbl
fooTBL
name
parentID
ID
so a name can have might have a parentID, as well as an ID. 'name's are
associated with other 'name's via the parentID. in other words, if a name's
parentID == a name's ID, name1 is the parent of name2.
ie
nameparentID
I'm not sure why you split out track, track is really kind of an attribute of a song. Especially since you have artist and album
with the song. Wouldn't album be the same as cd title? I'm not quite getting the logic of your schema.
It would have been helpful if you provided your current query.
A
Mee too.
""John Meyer"" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]@gmail.com...
You know this might be a little bit more convincing if you gave the name of
the product and a little bit more personal reason why you recommended it
other than "check out brand x product" I vote
You know this might be a little bit more convincing if you gave the name of the
product and a little bit more personal reason why you recommended it other than
"check out brand x product" I vote this is spam.
-Original Message-
From: itguy321 [mailto:[EMAIL PROTECTED]
Sent: Wednesday, A
I have two databases that effect each other when triggers get excecuted.
There is a schedules database that updates registration database. The
problem I have is with the enrolled, attended, waitlisted, completed,
cancelled, etc. booleans values. The registration db has triggers on it that
enforce
Though I understand very well that it has been discussed lots of time
before but I don't have time to browse through the previous archives
and dig out the stuff I need. So, guys, I would be thankful if you
could give me your valuable advice that I need right now.
I just need to know
I'd recommend RAID 10 - with 4 disks instead of 2, you'll roughly
double performance over RAID 1, both for reading and writing.
You might also look at 6 disks - 4 73's in RAID 10 for your data, plus
2 smaller, slower less expensive disks in RAID 1 (18 gb or 36 gb
maybe) for your boot disks.
As f
--On August 2, 2006 5:25:51 PM +0800 wangxu <[EMAIL PROTECTED]> wrote:
I have a problem about the performance of federated engine. The
mysql5.0 reference manual says that the FEDERATED tables do not work with
the query cache, aren't they? How about the query cache used by the
federated eng
I have two tables:
MEMBERS:
MEM_ID
...
GROUPS:
GRO_ID:
...
And one joiner
MEM_GRO:
MEM_ID, GRO_ID
I want to print out a list like this
GROUP_NAME, NUMBER_OF_MEMBERS
Even when the number of members is 0, how do I do that?
--
MySQL General Mailing List
For list archives: http://lists.mys
http://downloads.mysql.com/archives.php?p=mysql-5.0
On 8/1/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
n> http://dev.mysql.com/downloads/
> Look for "older releases"
Thanks but I want an older _build_ of the 5.0 release, not an older
release.
--
MySQL General Mailing List
For list archi
Tripp, YMMV, but I'm a firm believer that keeping things as simple as
possible pays big dividends.
I believe the advice to spread out IO tasks among different disks is
good advice, when dealing with direct-attached disks you deal with
directly (i.e. not part of a RAID). The setup and maintenance
MySQL,
After thinking hard on the subject, I realise the server in question was
running a data set from an InnoDB HotBackup. (Which is on trial so I
have no support.)
The source machine is a PowerPC IBM. The crashing server is an Intel
Pentium. The difference being that one is big-endian,
Dear MySQL,
I am getting an unexpected crash in MySQL 5.1.6, with nothing written to
the log.
This happens with InnoDB tables and an Foreign Key error.
Tables are something like:
CREATE TABLE tax (
`type` varchar(8) NOT NULL,
PRIMARY KEY (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CR
> [EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/
--opt
> drupal
> mysqldump: Got error: 1: Can't create/write to file
> '/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when
> executing 'SELECT INTO OUTFILE'
Change the owner of that directory so the mysql serve
Thanks Ravi. That definitely did help.
However, the scenario that I wish to monitor is when there are a lot of
sleeping threads, it is peak-hour, and the number of threads is dangerously
near to the max_connections value. Hence, I would want to log similar
information as described in the blog, but
Hello folks.
How do I determine what is the safest value that I can set for
max_connections in my.cnf? The default value of 100 is proving to be a
shortfall during some cases of peak hour traffic.
Could you point me to a resource available if any?
1. Our server is RHEL 3, 2*3.00 GHz, 4GB
I am getting the below error
[EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/ --opt
drupal
mysqldump: Got error: 1: Can't create/write to file
'/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when
executing 'SELECT INTO OUTFILE'
Change the owner of that direct
Hi ALL
I am getting the below error
[EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/ --opt
drupal
mysqldump: Got error: 1: Can't create/write to file
'/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when
executing 'SELECT INTO OUTFILE'
Thanks and Regards
Kaush
Simo Sentissi schrieb:
Hello there
I just finished installing mysql 5 on my linux server and I reset the root
password as an initial post-install setting.
now that i try to connnect from other machines in the network I always get a
message similar to the following:
C:\Documents and Settings\m
They are user defined properties.
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 01, 2006 8:11 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Query Help for Loosely Couple Properties
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco wrot
Hello there
I just finished installing mysql 5 on my linux server and I reset the root
password as an initial post-install setting.
now that i try to connnect from other machines in the network I always get a
message similar to the following:
C:\Documents and Settings\msentissi>mysql -u root -h
Have you checked out MyConnector/NET and the MySqlException class?
-Original Message-
From: Asif Lodhi [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 2006 6:17 AM
To: mysql@lists.mysql.com
Subject: Database Return Errors
Hi,
I am developing a VB6 app with a MySQL-5.0.22/WinXP bac
Hi,
I am developing a VB6 app with a MySQL-5.0.22/WinXP backend. I have
skimmed the Stored Procedures/Triggers docs and it looks like I can
define custom error-names or number - though I have also seen the
"Handlers" in the same doc.
The question is: Can I get the error-codes or error-names th
Hi,
First reset slave and then change master to script run it.
Thanks & Regards
Dilipkumar
- Original Message -
From: "Kenji HIROHAMA" <[EMAIL PROTECTED]>
To: "Dilipkumar" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, August 02, 2006 3:29 PM
Subject: Re: Relay Log Lost on Slave
Hi Dilip
Hi Dilipkumar,
I checked the output of show slave status, and memorize;
RELAY_MASTER_LOG_FILE, and EXEC_MASTER_LOG_POS.
Then,
change master to
master_log_file='xx,
master_log_pos=xx;
However, still I get the same error message.
Umm.
Kenji
On 8/2/06, Dilipkumar <[EMAIL PROTECTED]> wrot
I have a question about the query against to the federated engine tables.
As the following example:
"select Id,name from e01_system.category"
Note: the "e01_system.category" is a federated table.
I select only tow fields from the federated table "category" with the above
sq
How does the federated engine table work when the query statement include a
join substatement, it joins a local table with innodb engine and a federated
table. How does the server deal with the query substatement like this?
I have a problem about the performance of federated engine. The mysql5.0
reference manual says that the FEDERATED tables do not work with the query
cache, aren't they? How about the query cache used by the federated engine in
the mysql5.1?
If the query cache cann't be used with the fede
On Wednesday 02 August 2006 09:28, Asif Lodhi wrote:
> Hi,
>
> Though I understand very well that it has been discussed lots of time
> before but I don't have time to browse through the previous archives
> and dig out the stuff I need. So, guys, I would be thankful if you
> could give me your valu
Hi,
Though I understand very well that it has been discussed lots of time
before but I don't have time to browse through the previous archives
and dig out the stuff I need. So, guys, I would be thankful if you
could give me your valuable advice that I need right now.
I just need to know
Hi,
Yes Aborted connects will start increasing than the connections.
Thanks & Regards
Dilipkumar
- Original Message -
From: "��?��╁��" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, August 02, 2006 11:34 AM
Subject: One question about mysql_close
Hi,
I have a question about Mysql C libr
Hi,
I have a question about Mysql C library function "mysql_close". If my
program doesn't invoke mysql_close before exiting, is there any side
effect?
I don't know whether this is the proper list I should send email for this
topic. If I should send my email to another topic, which list is be
61 matches
Mail list logo
