bruce wrote:
Hi...
A mysql/Apache issue:
I get the following when I'm trying to run a test web site on an Apache
2.0/RH8.0 setup.
Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in
/var/www/html/dbid/mysql/database.php on line 17
Warning
Switching to another database isn't really an option. I didn't write the
package and I'm not good enough to port it to another database or to rewrite
it for a multiple machine architecture.
Probably the only non-RAID option I have (assuming I want to keep more than
3 months worth of data) would b
At 17:24 -0700 8/20/03, Michael S. Fischer wrote:
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 i
In the last episode (Aug 20), Kayra Otaner said:
> 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 data
At 9:54 -0400 8/19/03, Luc Foisy wrote:
Would anything happen to the database if I ran "myisamchk --silent
/usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first?
Yes, you may have unflushed changes still in the server's buffers.
Running myisamchk in that case can make the tables *in*cons
In the last episode (Aug 20), Dathan Vance Pattishall said:
> 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.
Affected how? The grown defect list is usually reserved for blocks
that were discovered to
Hi MySQL Fans ;-),
This time I am using 4.0.13-max (tar format from www.mysql.com) on Redhat 9.
When I issue the command mysqlbinlog it does not show me the whole
binary logfile but just the first line or so (below).
mysqlbinlog baby-bumble-bee-bin.09
# at 4
#030814 14:38:17 server id 1
Paul DuBois [mailto:[EMAIL PROTECTED] writes:
> At 15:18 -0700 8/20/03, Michael S. Fischer wrote:
> >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
At 17:00 -0300 8/20/03, Dyego Souza do Carmo wrote:
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 ???
HI
from the command line run
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER
ON database_name.*
TO [EMAIL PROTECTED]
IDENTIFIED BY 'password';
(you may want to give more restrictive privileges)
that should fix it - you don't have privileges set for the user
At 15:18 -0700 8/20/03, Michael S. Fischer wrote:
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/Miscellane
I would run the DB on a RAMDisk
http://www.ibiblio.org/mdw/linuxfocus/English/November1999/article124.html
Anyone else?
Martin
- Original Message -
From: "Kayra Otaner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 3:56 PM
Subject: MySQL 4.0.13 Memory problem
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 (1,2,3
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
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?
-
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
[] tru
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:
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
> -Ori
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 d
What does EXPLAIN SELECT 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: [EMA
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 d
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=
log-slave-updates
replicate-* =
-->-Original Message-
-->Fr
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
space
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 Dí
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...
InnoDB,MySQL,SQL
Hi...
A mysql/Apache issue:
I get the following when I'm trying to run a test web site on an Apache
2.0/RH8.0 setup.
Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in
/var/www/html/dbid/mysql/database.php on line 17
Warning: MySQL Con
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 PROT
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...
InnoDB,MySQL,SQL
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 proces
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 bette
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 provid
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 PROT
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; you'
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]
> Subj
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 PROTECTE
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 BENCH
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 tha
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 S
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.
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
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 repl
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 yo
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 i
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 i
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
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
source_for_inquiries_form|eq_ref|PRIMARY,contact_id|PRIMARY|3|in
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)
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)
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 yo
Nobody has any advice for this one?
Jeff
> -Original Message-
> From: Jeff McKeon
> Sent: Tuesday, August 19, 2003 8:22 AM
> To: [EMAIL PROTECTED]
> Subject: Replication question
>
>
> Hey all,
>
> I have 3 databases replicating (ver 3.23) A to B and B to C
>
> On C I want to modify
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
Fo
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 s
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]
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
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 Zawo
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 ke
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]
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 requi
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
>
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
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 contract
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
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
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
What are you defining as a huge performance hit?
Is the result set 20K records, or the base tables? How big are the base
tables?
Are the client and server on the same machine? Pulling 20K records across
the network could take some time. Formatting 20K records into a pull -down
list in access will
"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 v
> 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 FULL
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 upda
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 sta
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
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
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
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]
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 d
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 wi
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
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
cur
77 matches
Mail list logo
