I should qualify my answer, to indicate something that may not apply
to the situation you have in mind.
If you're using myisamchk only to *check* tables, it operates in read-only
fashion. The problems occur if you're using it to repair tables, because
then if you have both myisamchk and the
Hi everyone,
I've got a very simple table which contains records of events. It's just
a table with 2 columns: an id and a timestamp. Every time this event
occurs, I insert a timestamp in the table.
I use this query to extract the number of events on each separate day:
SELECT COUNT(id) AS
Veritas might be a good solution. I'm trying to find out if a mounted
Veritas file system that stores only the snapshots while the data
resides locally is possible. If so then backing up the data could happen
every 5 min if necessary in my environment.
Does anyone know if the Veritas software
Hi all,
Thanks for the answers for Master-Master replication. Right now i want to try the
Master-Slave replication first and then do a circular replication.
Unfortunately, I am facing problems with updating slave automatically.
I started the slave and loaded the data from the master,
Cybot wrote:
Jesse Sheidlower wrote:
An example of a query is to get all the words (the cg.cw
field) in a particular alphabetical range that have been
added in some timespan (the sref.cd field). The cg table
has about 3M rows, and the sref table about 70,000; the
intervening tables are all
Thank you Paul.
whew! So just checking will not do anything to the database, in an case?
I am not really caring if it returns the # users still connected/ or table not closed
right warning. I am not really looking for that.
I am looking for warnings telling my that tables are corrupted...
The only thing I can add is check you hardware and OS platform.
Cheers
-Original Message-
From: Jesse Sheidlower [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 11:44 AM
To: Cybot
Cc: [EMAIL PROTECTED]
Subject: Re: Slow results with simple, well-indexed query
On Thu, Aug 21,
Here is a good URL, maybe it can help you to deploy your Master-Slave
solution.
URL: http://mysql.us.themoes.org/doc/en/Replication_HOWTO.html
Greetings
Mikel
From: Sanya Shaik [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Master-Slave Replication Date: Thu, 21 Aug 2003 12:50:31 -0700
Can you post your DDL to go along with your DML?
-Original Message-
From: Allen Weeks [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 4:51 PM
To: Jesse Sheidlower; Cybot
Cc: [EMAIL PROTECTED]
Subject: RE: Slow results with simple, well-indexed query
The only thing I can add is
Thanxs for the URLS, I'll check them out.
Greetings
Mikel
_
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.microsoft.com/es
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
At 16:32 -0400 8/21/03, Luc Foisy wrote:
Thank you Paul.
whew! So just checking will not do anything to the database, in an case?
I am not really caring if it returns the # users still connected/
or table not closed right warning. I am not really looking for that.
I am looking for warnings
Some make the laughing stock of MySQL with this code:
create database data_test ;
use data_test;
create table test3 (a date);
insert into test3 values (-1);
insert into test3 values ('1996-02-31');
insert into test3 values ('1996-67-31');
select * from test3;
I ran it
Hi!
On Aug 21, Luc Foisy wrote:
Thank you Paul.
whew! So just checking will not do anything to the database, in an case?
yes, but ONLY if you run myisamchk with --read-only flag.
I am not really caring if it returns the # users still connected/ or
table not closed right warning. I am not
[EMAIL PROTECTED] (Lefevre, Steven) writes:
I say go with RAID 5, on a controller card.
..
You get better performance than mirroring or regular drive, because
the data is spread out over your drives. It's not as good as disk
striping, though.
Ehh. Wrong. That is not how it works. If you
Hans van Harten unknowingly asked us:
Some make the laughing stock of MySQL with this code:
create database data_test ;
use data_test;
create table test3 (a date);
insert into test3 values (-1);
insert into test3 values ('1996-02-31');
insert into test3 values
Absolutely! I have multiple indexes. I think it might be a problem with ODBC
Are your tables indexed? http://www.mysql.com/doc/en/MySQL_indexes.html
Saqib Ali
-
http://www.xml-dev.com
-
Visit CARMEL MUSIC ENTERTAINMENT website
Same here.
Got 0's for the invalid dates, correct date for the other. What is wrong?
Adam Clauss
[EMAIL PROTECTED]
-Original Message-
From: Rajesh Kumar [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 1:35 PM
To: Hans van Harten
Cc: [EMAIL PROTECTED]
Subject: Re:
* Rajesh Kumar
Roger Baklund unknowingly asked us:
What would be a good way to deal with the following...
No, I did not. Scott Haneda asked the question. I replied. :) And I
recommended considering the SET column.
But for a couple of reasons, SET is not recommend.
1. It introduces
As per the manual that is correct.
The only correct date will be 1996-02-31.
what is the problem?
-Original Message-
From: Hans van Harten [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 4:09 PM
To: [EMAIL PROTECTED]
Subject: MySQL running out of date
Some make the laughing
Adam Clauss and Rajesh Kumar wrote:
Hans van Harten unknowingly asked us:
LOL
Some make the laughing stock of MySQL with this code:
create database data_test ;
use data_test;
create table test3 (a date);
insert into test3 values (-1);
insert into test3 values
for what i understand of this problem, it should not be possible an easy way.
once i have found an article on this on the internet, don't know where it was anymore.
(neither devshed nor phpbuilder)
but it was about JOINing the result with an 'integers table' that has all the needed
values from 1
Executing just the search on the word table, with no joins to the
table with the dates, is still slow:
Then it is not worth while to focus on anything else until you fix that.
Are the contents of this field always in lower case?
Is so, then change the column to a binary type. The explain says:
I agree it's unfortunate that the dates get stored. But some do seem to
prefer it this way.
To quote the manual at the bottom of:
http://www.mysql.com/doc/en/Using_DATE.html
If the date cannot be converted to any reasonable value, a 0 is
stored in the DATE field, which will be retrieved
how to separate each stop word in the list
A different word on each line.
-steve-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 15:53 -0300 8/21/03, Cleber Hostalácio de Melo wrote:
Hi,
I need to change the stop word file used by the MySQL in fulltext seach.
The documentation (www.mysql.com/doc/en/Fulltext_Fine-tuning.html)
explains how to inform to MySQL the new stop word file through the
ft_stopword_file variable.
On Thu, Aug 21, 2003 at 03:36:54PM -0700, Steven Roussey wrote:
Executing just the search on the word table, with no joins to the
table with the dates, is still slow:
Then it is not worth while to focus on anything else until you fix that.
Are the contents of this field always in lower
Interestingly, use of date_add() and date_sub() on 'odd' dates such as
Feb 31 does produce sane results.
Subtract one from 2000 Feb 31, and you'll get 2000-03-01.
This is sane!!??
PB
[mysql]
Kevin Fries wrote:
I agree it's unfortunate that the dates get stored. But some do seem
to prefer it this way.
To quote the manual at the bottom of:
http://www.mysql.com/doc/en/Using_DATE.html
If the date cannot be converted to any reasonable value, a 0 is
stored in the DATE field, which
Peter Brawley unknowingly asked us:
Interestingly, use of date_add() and date_sub() on 'odd' dates such as
Feb 31 does produce sane results.
Subtract one from 2000 Feb 31, and you'll get 2000-03-01.
This is sane!!??
This is where Unix Timestamps come into action (and perhaps rescue)!
To be sure
No, the contents can be of mixed case. Where does that leave things?
**Index the length of the entire column.** It then should not need to
have to do the filesort. Actually the binary option would not have
really helped. The explain should say 'Using Index'. Get back to me on
this and tell me
I will be out of the office starting 21/08/2003 and will not return until
08/09/2003.
I will respond to your message when I return. If you have any urgent
queries please contact Stuart Mclean
==
Disclaimer Notice
This
I'm attempting to normalize a database that was originally created as a
flat file. I want to extract distinct values from a table and insert
them as new entries into a new table. Unless I'm missing something,
INSERT doesn't allow you to SELECT data from another table for
insertion, and UPDATE
sorry to be vague but what is the ft_stopword_file i havent been able to be
up to speed on that variable.
At 15:53 -0300 8/21/03, Cleber Hostalácio de Melo wrote:
Hi,
I need to change the stop word file used by the MySQL in fulltext
seach.
The documentation
hi there, i am trying to remove values from a list menu if the join table doesnt have
keys when a key is selected for instance:
locations
locationID
locations_join
locationID shotlistID
SELECT SQL_NO_CACHE l.locationID , l.location FROM locations l LEFT JOIN
locations_join lj ON l.locationID =
Dan Jones unknowingly asked us:
I'm attempting to normalize a database that was originally created as a
flat file. I want to extract distinct values from a table and insert
them as new entries into a new table. Unless I'm missing something,
INSERT doesn't allow you to SELECT data from another
On Thu, 2003-08-21 at 20:09, Dan Jones wrote:
I'm attempting to normalize a database that was originally created as a
flat file. I want to extract distinct values from a table and insert
them as new entries into a new table. Unless I'm missing something,
INSERT doesn't allow you to SELECT
Hello,
I'm using a PHP API with MySql.
I can use the mysql_num_rows() function to find out the number of rows
in the resultset.
But does anyone know of a way to find out the number of seconds it took
to execute a particular query using PHP?
Why I need this is because, I would like to execute
Type show slave status to figure out what the problem is on the slave.
Type show full processlist on the master to see if the slave is
connected waiting for binlog updates.
Make sure the master is replicating..
Etc.
---Original Message-
--From: Sanya Shaik [mailto:[EMAIL PROTECTED]
At 17:56 -0400 8/21/03, Rajesh Kumar wrote:
Hello,
I'm using a PHP API with MySql.
I can use the mysql_num_rows() function to find out the number of
rows in the resultset.
But does anyone know of a way to find out the number of seconds it
took to execute a particular query using PHP?
Why I
Antony Dovgal wrote:
mysql_error is not set when mysql_connect fails, because there is no
actual mysql resource to get the error message from.
yes, there is no mysql resource at this moment.
just don't specify it and mysql_error() will tell something like Can't connect to local
MySQL server
Lefevre, Steven wrote:
I say go with RAID 5, on a controller card.
Mirroring just gives you backup, and you lose half your diskspace. It offers
no performance benefit, and actually the computer might have to work harder
to make sure the drives are in sync.
that is not true. mirroring gives you
At 10:12 +1000 8/22/03, [EMAIL PROTECTED] wrote:
sorry to be vague but what is the ft_stopword_file i havent been able to be
up to speed on that variable.
Read the page referenced below:
http://www.mysql.com/doc/en/SHOW_VARIABLES.html
It describes what the variable is for.
At 15:53 -0300
Glad that helped!
-M
- Original Message -
From: Dan Jones [EMAIL PROTECTED]
To: MySQL Mailing List [EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 5:46 PM
Subject: Re: Copying distinct data to a new table
On Thu, 2003-08-21 at 20:09, Dan Jones wrote:
I'm attempting to normalize a
On Thu, Aug 21, 2003 at 04:58:47PM -0700, Steven Roussey wrote:
No, the contents can be of mixed case. Where does that leave things?
**Index the length of the entire column.** It then should not need to
have to do the filesort. Actually the binary option would not have
really helped. The
GOD! OK, sorry, I wasn't quite expecting this:
Wow!
:)
But what's the explanation for this huge improvement? Again, I
was always told the opposite, and the Manual itself says: ...
Yes, and it is true (usually). But your EXPLAIN showed a filesort and
that is bad. What happens is that if
ft_stopword_file The file from which to read the list of stopwords for full-
text searches. All the words from the file will be used; comments are not
honored. By default, built-in list of stopwords is used (as defined in
`myisam/ft_static.c'). Setting this parameter to an empty string () will
funny i was just having the same problemo with mysql 3.22 on php3 the most painful
system to debug i hate it to bits, anyway mysql_error doesnt get returned on
permission or database connection errors, i wonder if that is soughted out in mysql4
?? maybe this is a php.net question
Jon Drukman
In the last episode (Aug 21), Jon Drukman said:
Lefevre, Steven wrote:
I say go with RAID 5, on a controller card.
Mirroring just gives you backup, and you lose half your diskspace.
It offers no performance benefit, and actually the computer might
have to work harder to make sure the
On Thu, Aug 21, 2003 at 06:58:29PM -0700, Steven Roussey wrote:
Jesse Sheidlower wrote:
Hmm. When I returned to the multiple-table query that started
this thread,
And it was slow. Yeah, one thing at a time. It makes it easier for
people reading this list now or in the future (if it
Hi all,
I pretty much set a fields default value to NULL if it not a required
field in my app. Just wondering if this is the way to go since I just
sort of guessed at this method ;)
- Charles
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
We are using MySql version 3.27.53 on a Red Hat Linux platform version
7.2. For the past couple of months we are noticing that the performance
of the server has gone down very badly. Every, single insertion is
taking a hell lot of time.The particular table has only 150,000 records.
Is there
Hi, is it possible to link databases within mysql? I have a access database that I
need to import into mysql this db consists of 4 other dbs linked together sharing a
common switchboard. Can I link the tables in one db to tables in another db?
thanks
Bob
Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create
an e-mailing list for our 5.6 million book club members. Unfortunately,
the import speed for importing records (at record number 150,000 the rate
is about 2,000 records per hour). We're running on the following:
P4
Creigh == Creigh Shank [EMAIL PROTECTED] writes:
Creigh Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution,
Creigh PHPList, to create an e-mailing list for our 5.6 million book
Creigh club members. Unfortunately, the import speed for importing
Creigh records (at record number 150,000 the
101 - 154 of 154 matches
Mail list logo