I need to upgrade my current mysql installation . But now there is a problem
to run the setup.exe of installshield 5.x under windows xp sp1 or sp2. The
program hung after few seconds. In the memory remain active woexec, ntvdm
and setup, but the process is freezed. It is possibile to convert the
Marc,
what MySQL version you are using? Can you figure out what query is causing
the warning?
Have you possibly mixed .frm files so that MySQL may have wrong information
about column lengths?
I have now added the following diagnostic code to a future version on
InnoDB. It also explains what the
No one has replied to my post.
- Original Message -
From: I.P. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 18, 2003 1:01 PM
Subject: mysql 4.0.14 + replication + windows XP PROF
Hi, it's my story.
I have two 4.0.14 mysql server on one machine with win XP
I'm in the process of writing a Perl script to delete records out of a
database when the records are more than 90 days old. I'm running MySQL
version 4.0.12-standard. The db consists of around 620 MyISAM tables with
the following structure:
CREATE TABLE `ifInErrors_2` (
`id` int(11) NOT NULL
Two Questions:
Is the same query running directly on the linux server thru mysql is also very slow ?
Have you done a explain plan on the query ?
Marc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Daniel Rossi [EMAIL PROTECTED] wrote:
Can someone please tell me if my problem with the punctuation in a fulltext search
is a bug or limitation? Ultimately the users of the system i built do not want to
have to try using the + search then trying the * search for all the words which will
I'd say MySQL 2nd edition by Paul Dubois. It has the first 200 pages
with stuff you already know, but the next 800 pages are mysql specific.
Very good reference book and best practices guide.
The only thing it's missing is what I think should be in every book (and
is in virtually none). 5 pages
On Tue, Aug 19, 2003 at 01:52:26PM -0700, Sanya Shaik wrote:
I am unable to find any information about master-master replication. I
need to replicate 1 mysql server over to other as a standby master
server.
If the second server is merely standby, you probably want master/slave
rather than
On Tue, 19 Aug 2003 14:36:15 -0700
Jon Drukman [EMAIL PROTECTED] wrote:
I've got a library of PHP code whose first line is a mysql_connect
statement, like this:
$dbh=mysql_connect() or die(mysql connect failed: $php_errmsg);
Approximately 1% of the time it just fails, for no stated
It depends if you had any kind of query logging enabled (binary or text)
.. If you started safe_mysqld with -l (that's text logging of queries) ..
or configured my.cnf with bin-log (that's binary logging)..
You should be able to pipe/patch the logs against the database and let it
run all the
hmm well sorry to be unclear i know this works but it would return more
results than needed also i cant expect users to add this themselves, like
i
would have to add the astrerix to every word in that case like i do to get
all words ;\
I don't know the MySQL issues (I'm now using some
Soren O'Neill [EMAIL PROTECTED] wrote:
I keep getting a syntax error, when trying to run this query (perl script):
SELECT * FROM temp_hits WHERE url NOT IN SELECT * FROM hits
Ive tried with brackets around the last SELECT statement ... no better ...
Subselects are supported in version
So basically all the changes from those 18hrs were stored in logs and not
yet commited to the database? So maybe if I just commited the logs every
so often I wouldn't have this problem?
It depends if you had any kind of query logging enabled (binary or text)
.. If you started safe_mysqld
Select monthname(yourdatefield) as month, year(yourdatefield) as year,
count(*)
From yourtable
Group by year, month;
Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 ex 209
***The information contained in this communication is confidential. It
is intended only
When I write
select curtime();
It´s return the mysql´s system time, but I would like to change this time
(because it´s late 3 minutes)
Any ideas?
Thanks a lot
Sanya Shaik [EMAIL PROTECTED] wrote:
I am unable to find any information about master-master replication. I
need to replicate 1 mysql server over to other as a standby master
server.
Master-master? Do you mean circle replication A --- B or what ?
--
For technical support contracts, goto
Jan Josefowicz [EMAIL PROTECTED] wrote:
This version of mysqlbinlog can work properly only with 3.23 server binary logs.
is there a mysqlbinlog version that matches to MySQL 4.0.xx?
Version 2.3
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email
Vladimir Trebicky [EMAIL PROTECTED] wrote:
VR What do you mean didn't work properly'? What exactly was
VR wrong with mysql_fix_privilege_tables?
Sorry, cannot reproduce the error. The result was that some of the
tables were corrected, some not. Anyway, even old privilege tables
shouldn't
The limitation you are indicating is in the interface, which MySQL
really doesn't have. MySQL is a database engine, it's up to you to
design the interface with whatever tool you want (i.e. web interface).
For my full text search systems, which have a web interface, I have one
field for required
sorry this is only a test.
query MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
We've run out of disk space and would like to move either the entire MySQL system or
if possible move the databases. Can this be done without any difficulties?
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks Pty Ltd
http://www.mmtnetworks.com.au
I don't know the
I should appologize for my earlier post Another Replication
Problem. I had not properly analyzed the problem before posting.
Although I have been administering a MySQL database for about a year
now, replication is completely new to me. Sorry if I wasted anyone's
time.
Thanks to Jeremy
Well , what I want is the second server to take the place of the first one in case of
any problems with the master without having to come to a stand still
Jeremy Zawodny [EMAIL PROTECTED] wrote:On Tue, Aug 19, 2003 at 01:52:26PM -0700,
Sanya Shaik wrote:
I am unable to find any information
Another way to do it, create a temporary table load the content of your text file in
it, and then do your update crossing the two tables.
Marc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
We were affected by the power outage last week and I think people should
be aware - I'm not sure if it's fixed (I'm virtually certain it is not),
but the default rpm install of 4.0.12 has mysql starting up in runlevel
4 only. When our power was restored, RedHat went to runlevel 3 and
mysql never
Hi all,
I'm not receiving your emails since this morning at 7:30AM.
Are there some problems? Or maybe I have problems with my subscription but it's
strange.
Thanks in advance.
Dave.
-
L'Eco della Stampa, http://www.ecostampa.it
--
MySQL General Mailing List
On Wed, Aug 20, 2003 at 11:41:22PM +0800, Jon Miller wrote:
We've run out of disk space and would like to move either the entire MySQL system or
if possible move the databases. Can this be done without any difficulties?
Yes, if you can afford to turn off your server.
If you need to keep
When following query is pulled up, it takes about whole 1-2 minutes to come up.
inquiries table has 17000 records, contacts has about 7000,
individual_contacts has about 16000.
It has gotten worse once I upgraded to 4.0 and latest MyODBC.
Clients are separate machines (mix of Win98 and WinXP).
Result of EXPLAIN is:
table|type|possible_keys|key|key_len|ref|rows|Extra
inquiries|ALL|contact_id| | | |8253|Using filesort
individual_contacts|eq_ref|PRIMARY,indiv_contact_id|PRIMARY|3|inquiries.indiv_contact_id|1
On Wed, Aug 20, 2003 at 11:41:22PM +0800, Jon Miller wrote:
We've run out of disk space and would like to move either the entire
MySQL system or if possible move the databases. Can this be done
without any difficulties?
Yes. If you're on a Unix-like platform, you can symlink one or more
On Wed, Aug 20, 2003 at 10:54:28AM -0300, Fabio Bernardo wrote:
When I write
select curtime();
It?s return the mysql?s system time, but I would like to change this time
(because it?s late 3 minutes)
Then your system's time need to be updated correctly.
Any ideas?
Get your sysadmin to
Query takes 3.4 seconds to run on the server, but it takes 1-2minutes to run via
MyODBC 3.51.06 using passthrough (Access97 is the front end, but it has query
type that allows bypass of Access interpretation.
Two Questions:
Is the same query running directly on the linux server thru mysql is
When I send the query throuh comman line, it works perfect 3-4 seconds, but when
I do Access97 pass-through query, that is when it runs into 1-2 minutes.
It is almost as slow as using Access97 native query that goes through MyODBC, so...
That doesn't look too bad. Is the query that slow when
If you want the Oracle to answer a question for you, you *must*
have the words tell me or tellme somewhere in your subject line.
Capitalization doesn't matter.
If you are answering a question, you must have the word answer and
the Question ID in the subject. Usually you can get this by replying
Hi list,
Does any know how to do differential backups or does exist a tool that do
this kind of backups.
I have mysql 4.0.12 and use innodb tables, mysql is running on redhat 7.3
Greetings and thnx in advanced
_
MSN. Más Útil
Hi list,
Does anyone know how to do a differntial backup for mysql databases. Is it
possible?.
I use mysql 4.0.12 on a redhat 7.3 box.
Greetings and thnx in advanced
_
MSN Fotos: la forma más fácil de compartir e imprimir fotos.
On 20 Aug 2003 at 15:08, Tom O'Neill (MySQL User) wrote:
Is there any difference in speed between the following select
statements?
SELECT yada,yda FROM test WHERE id IN(1,2,3)
OR
SELECT yada,yda FROM test WHERE (id =1 or id = 2 or id =3)
You can put EXPLAIN in front of your SELECT
If the database cannot grow unbounded, and you have to prune the
database from time to time (no matter how much disk space you may have)
you will have to perform regular table defragmentation if you want to
minimize performance degradation.
So, you'll need to schedule periodic outages to do
This is trivial to benchmark yourself. Try:
BENCHMARK(10, SELECT yada, yada FROM test WHERE id IN(1,2,3))
And compare to
BENCHMARK(10, SELECT yada,yda FROM test WHERE (id =1 or id = 2 or id
=3))
See http://www.mysql.com/doc/en/Miscellaneous_functions.html for
documentation on the
That doesn't look too bad. Is the query that slow when you use the
command-line client alone (connected directly to the server), or is it
just when accessing the database through the ODBC tunnel?
--Michael
-Original Message-
From: Apollo (Carmel Entertainment) [mailto:[EMAIL
Sure, just shut down the database cleanly (mysqladmin shutdown), move
the data directory intact to the new filesystem, and start up again.
--Michael
-Original Message-
From: Jon Miller [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 8:41 AM
To: [EMAIL PROTECTED]
Subject:
You're going to need to architect more than just a master-slave
relationship to do what you want to do. All replication does is copy
commands from one MySQL server to the other; it does not create a
failover environment by itself.
Creating a failover environment is beyond the scope of MySQL;
As a Oracle followup question
Oracle supports Tablespaces
That is
2 or more logically separate entities for System Data and User Data
Does MySQL have Tablespace support?
Many Thanks,
Martin
- Original Message -
From: Adam Nelson [EMAIL PROTECTED]
To: 'Johnson, Michael ' [EMAIL
What would be a good way to deal with the following...
I have a form that has 5 checkboxes on it, lets say the checkboxes are for
categories, and more than one can be selected.
For example:
please tell is what brochure you want
[] car
[] boat
[] truck
[] SUV
[] beetle
I have been asked to
Victoria Reznichenko wrote:
Soren O'Neill [EMAIL PROTECTED] wrote:
I keep getting a syntax error, when trying to run this query (perl
script):
SELECT * FROM temp_hits WHERE url NOT IN SELECT * FROM hits
Ive tried with brackets around the last SELECT statement ... no better
...
On another mailing list, there is a discussion about whether or not
it is adequate/proper to manage the MySQL server process via a
watchdog script (namely, DJB's daemontools).
The point behind this watchdog script is to launch a service (such
as mysqld) in the foreground, and notice if that
Hello guys !!!
I have MySQL/InnoDB on Windows 2000 and i want to create a RAW
PARTITION to use InnoDB tablespace...
In Linux the configurarion is:
innodb_data_file_path = /dev/hda1:32Gnewraw
innodb_data_home_dir =
and in Windows 2000 ??
Tnks in advance...
log into the machine that runs the mysql server (usually as root user) and change the
time with 'date -s ...'
--
Yves Goergen
[EMAIL PROTECTED]
Please don't CC me (causes double mails)
-Ursprüngliche Nachricht-
Von: Fabio Bernardo [EMAIL PROTECTED]
An: Mysql (E-mail) [EMAIL PROTECTED]
Hello guys !!!
I have MySQL/InnoDB on Windows 2000 and i want to create a RAW
PARTITION to use InnoDB tablespace...
In Linux the configurarion is:
innodb_data_file_path = /dev/hda1:32Gnewraw
innodb_data_home_dir =
and in Windows 2000 ??
Tnks in advance...
Hi list,
Does any know how to do differential backups or does exist a tool
that do this kind of backups.
I have mysql 4.0.12 and use innodb tables, mysql is running on
redhat 7.3
Greetings and thnx in advanced
_
MSN. Más Útil Cada
Hi all,
I want to get your opinions on how to increase available/free memory and
performance on a heavy volume database server.
I have MySQL 4.0.13 running on RH 7.2 replicated to another RH 7.2 using
same MySQL version.
Recently our master database server (2 AMD Cpu + 2Gb memory + 2Gb swap
I think you also want what ever the standby master gets a write
/*assuming that the primary master where to go down or some other
reason*/ the submaster needs to replicate that insert so
In /etc/my.cnf
Use
log-bin
server-id=different int then the master
log-slave-updates
replicate-* = replicate
I've tried moving the database from one partition to another and now I'm getting the
following error:
# Starting mysqld daemon with databases from /data/mysql
030820 23:48:08 mysqld ended
When I issue #/ /usr/share/mysql/mysql.server start
Anyone have any idea what's gone wrong. I changed the
What does EXPLAIN SELECT query show? Have you read the chapter in the
manual on optimizing queries? Do you have all the proper indices set
up?
--Michael
-Original Message-
From: Apollo (Carmel Entertainment) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 2:52 PM
To:
I've notice that when grown defects (bad blocks on the disk caused by
usage over time) that my dedicated mysql server is adversely effected.
Since the action of Grown defects does not flush the table with a write
lock-that the block marked as bad will effect prior to that block
becoming a grown
In a word, no. The way MySQL organizes its datafiles is trivial by
comparison: one directory per database, two files per table (table.MYI
and table.MYD), one is the datafile, the other is the index file. MySQL
also does not preallocate space for its tables like Oracle does.
--Michael
You can do it if you can handle primary key violations and don't have
auto_increment columns in your tables. Race conditions can occur.
---Original Message-
--From: Sanya Shaik [mailto:[EMAIL PROTECTED]
--Sent: Wednesday, August 20, 2003 6:11 AM
--To: [EMAIL PROTECTED]
--Subject: Re:
At 03:30 PM 8/20/2003 -0700, Scott Haneda wrote:
What would be a good way to deal with the following...
I have a form that has 5 checkboxes on it, lets say the checkboxes are for
categories, and more than one can be selected.
For example:
please tell is what brochure you want
[] car
[] boat
[]
Should be fine as long as the column on C has a default and is not a
unique index.
---Original Message-
--From: Jeff McKeon [mailto:[EMAIL PROTECTED]
--Sent: Wednesday, August 20, 2003 6:05 AM
--To: MySql
--Subject: RE: Replication question
--
--Nobody has any advice for this one?
--
If you can't turn off your db use mysql_hotcopy and copy the data over
NFS
---Original Message-
--From: Brian Reichert [mailto:[EMAIL PROTECTED]
--Sent: Wednesday, August 20, 2003 2:24 PM
--To: Jon Miller
--Cc: [EMAIL PROTECTED]
--Subject: Re: moving MySQL
--
--On Wed, Aug 20, 2003 at
Hi there i am trying to work out the most efficient way to list say multiple
categories of entries, the database is quite large about 200 meg.
I would like to know if using join tables is more efficient than storing the keys in a
varchar field then within the second loop doing a where in
61 matches
Mail list logo