Hi,
Unfortunately I dint check SHOW PROCESSLIST as I was overwhelmed with the
state of the server and had to bring back the old version online, but the
reverse DNS lookups could be the reason, but surprisingly it was infact
serving some client requests
, also is there a way to stop mysql from
I don't know if this is relevant to you - but I had exactly
the same experience when upgrading to MySQL v4.1. It turned out
that MySQL was trying to do reverse DNS lookups before authenticating
the connecting hosts - and was failing slowly on each because the database
machine didn't have external n
I need to do an import of mysql data that I dumped from an older mysql server
the older server is running version 4.1.8 official mysql rpm. The new server
is running the version of mysql that comes with Fedora Core 3. The problem Im
having is with the Charsets that are in the older version. Is t
Hello.
My $0.05 :)
If you find out the unique queries (they often contain date and time),
add SQL_NO_CACHE to SELECT statement - this will decrease the number
of inserts of unique queries.
Brent Baisley <[EMAIL PROTECTED]> wrote:
> You tripled the amount of memory assigned to the cac
Hello.
What is SHOW PROCESSLIST reporting when the server is reaching the
max_connections limit?
Kishore Jalleda <[EMAIL PROTECTED]> wrote:
>Hi All,
> Last night I upgraded our Master server to 4.1.14 standard log from 4.0.17,
>I upgraded the slave a week ago and the replication wa
Hello.
Tools like mytop or mysqladmin (with -r option) don't produce
a high load on the server. You might be interested in --sleep option
for mysqladmin and --delay for mytop.
James Black <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> We have a produ
Privet!
Usually there is a number in the brackets after an error message. What
is this number?
Vlad Shalnev <[EMAIL PROTECTED]> wrote:
> Hi all
>
> Problem description
>
> OS: Solaris 9
>
> Mysql: 4.1.8
>
> Periodically I get error message "can't get stat of xxx.MYD" for tabl
Hello.
For a pity in your case it won't help.
>Hi Gleb,
>I am sorry i forgot to metion the storage engine we are using, its
>innodb. The below option is only for myisam engine.
>
> Innodb stores data and index in the same file as per documentation.
> Can you please correct me if i a
Wigs @Claw wrote:
Hi guys , sorry for responding if this message is a bit off topic!
Id have to say that you are assuming no glitches come into play with
that response.
I just recently had to do a Red Hat install , with Apache , MySQL and
the works. The install of Redhat ran into some iss
On Fri, 16 Sep 2005 10:32:23 -0400
[EMAIL PROTECTED] wrote:
> You asked basically two questions:
>
> a) what are the differences between ORACLE SQL plus and MYSQL?
> depends on how they are with MySQL already. One well-known point on
how
> MySQL and Oracle differ is in how to define a JOIN in
Jeff wrote:
-Original Message-
From: Jeff McKeon
Sent: Friday, September 16, 2005 13:19
To: Devananda
Cc: mysql@lists.mysql.com
Subject: RE: Circular Replication
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Friday, September 16, 2005 11:55
To: Jeff
Cc:
Hi all,
Im researching switching a production database system to use UUID's instead of
AUTO_INCREMENT columns for various ids. I've looked at various MySQL
documentation, and it seems to be what i want.
This change will really affect 2 separate database servers. Both are using
InnoDB tables. O
Brian Dunning wrote:
I got a 12-hour invoice from a consultant who was tasked to do the
following:
- Install a Red Hat machine from absolute scratch for PHP/MySQL/Apache
- Copy over some MySQL databases
- Have mod_rewrite working via htaccess, and have wildcard DNS
I'm a programmer, not a
I got a 12-hour invoice from a consultant who was tasked to do the
following:
- Install a Red Hat machine from absolute scratch for PHP/MySQL/Apache
- Copy over some MySQL databases
- Have mod_rewrite working via htaccess, and have wildcard DNS
I realize there are a billion different variabl
> -Original Message-
> From: Jeff McKeon
> Sent: Friday, September 16, 2005 13:19
> To: Devananda
> Cc: mysql@lists.mysql.com
> Subject: RE: Circular Replication
>
>
> > -Original Message-
> > From: Devananda [mailto:[EMAIL PROTECTED]
> > Sent: Friday, September 16, 2005 11:55
>
> -Original Message-
> From: Devananda [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 16, 2005 11:55
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: Circular Replication
>
>
> Jeff wrote:
> >
> > Am I correct in this setup process:
> >
> > Server A exists
> > Server B to be
Jeff wrote:
Am I correct in this setup process:
Server A exists
Server B to be built
Stop Server A, take snapshot, record Master info.
Start Server A
Setup server B, Install snapshot from A
Set B up as a master
Set B up as a slave to A
Set A up as a slave to B, no need for binlog file or pos
I'm using it with four machines (geographically separate) and it works fine.
Stefan
Am Friday 16 September 2005 17:31 schrieb Jeff:
> Does anyone use circular replication with MySQL 4.x? For instance:
>
> A to B
> B to A
>
> I know it's possible as long as you're carefull with your client
> ap
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 16, 2005 11:34
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: Circular Replication
>
>
> In the last episode (Sep 16), Jeff said:
> > Does anyone use circular replication with MySQL 4.x?
In the last episode (Sep 16), Jeff said:
> Does anyone use circular replication with MySQL 4.x? For instance:
>
> A to B
> B to A
>
> I know it's possible as long as you're carefull with your client
> applications and the way they write/update the db. Just wondering if
> anyone has had succes
Does anyone use circular replication with MySQL 4.x? For instance:
A to B
B to A
I know it's possible as long as you're carefull with your client
applications and the way they write/update the db. Just wondering if
anyone has had success or problems with this type of situation.
Thanks,
Jeff
On Fri, 2005-09-16 at 14:02 +0100, Mark Leith wrote:
> http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
>
perfect, thank you.
tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Phong Nguyen <[EMAIL PROTECTED]> wrote on 09/15/2005 10:56:57 AM:
> All,
>
> Could you please tell us what are the differences
> between ORACLE SQL plus and MYSQL SQL? We developed
> application using ColdFusion with Oracle. Now I like
> to point my application to mysql database. How do I
> fix m
Hi,
always reply to the list, you'll get better answers.
2005/9/16, OKAN ARI <[EMAIL PROTECTED]>:
> My actual DB isoptimized well about field types. I am using tinyint If i
> need etc;)
> But my problem is about examining logs, because
>
> 1. I dont' want to know how to reach mysql logs? Can you
Hi,
> Could you please tell us what are the differences
> between ORACLE SQL plus and MYSQL SQL? We developed
"oracle sql plus" is a client side application to execute SQL statements.
"oracle sql" is Oracles version of standard SQL (which is not standard)
and "mysql sql" is MySQLs version of sta
All,
Could you please tell us what are the differences
between ORACLE SQL plus and MYSQL SQL? We developed
application using ColdFusion with Oracle. Now I like
to point my application to mysql database. How do I
fix my application to work with Mysql?
Thankyou
__
2005/9/16, OKAN ARI <[EMAIL PROTECTED]>:
> I have a web site that have 100unique users online at the same time. I will
> optimize DB structure.
>
> 1. Is there anysource about mysql optimization and performance tricks?
you might want to look here :
http://dev.mysql.com/doc/mysql/en/query-speed.h
I have a web site that have 100unique users online at the same time. I will
optimize DB structure.
1. Is there anysource about mysql optimization and performance tricks?
2. I can change the DB type, which is the best for high mysql traffic web
sites, innoDB or MyIsam?
Thanks
You may want to think about doing this the opposite way around also, and
look at pushing the data from Oracle in to MySQL. Oracle has something
called "heterogeneous services", which allows you to define ODBC datasources
as valid entries in the tnsnames.ora file. Then you could simply create a
job
"Vicente" <[EMAIL PROTECTED]> wrote on 09/16/2005 07:45:22 AM:
> Hola,
>
> Tengo una base de datos realizada con MySQL y desearía generar informes
> mediante Crystal Reports XI. Al intentar conectar a MySQL via ODBC
3.51.10
> me sale el siguiente error:
> Logon Failed
> Details: ADO error Code 0
You can achieve this with the WITH ROLLUP option of GROUP BY. Although you
would probably have to perform a trick on the "date" column to have the NULL
value that WITH ROLLUP would return to return as "total" - i.e
IFNULL(date,'Total') as a quick (and dirty) example, as this doesn't work
too well o
Hi,
I'm sure I read somewhere about a new function that would give the
totals of all columns, ie if i have 2 cols, numberOfOrders valueOfOrders
for a range of dates i can get something like the following
Date numberOfOrdersvalueOfOrders
01-09 4 20.00
02-09 6
>Take a look at the GROUP_CONCAT function, under "functions for use with
>GROUP BY clauses" in the MySQL manual. You'll need MySQL 4.1+ AFAIK.
Thanks a lot Jasper, that is EXACTLY what I was looking for !
Cheers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
Hola,
Tengo una base de datos realizada con MySQL y desearía generar informes
mediante Crystal Reports XI. Al intentar conectar a MySQL via ODBC 3.51.10
me sale el siguiente error:
Logon Failed
Details: ADO error Code 0x8000fff
Source: Provider
Description: Error catastrófico
Native Error: -21474
Hi James,
You can do this
show engine innodb status\G ---this will show how many
insert/deletes/updates/reads happening per second and also how much of
Buffer is being used and how many queries are currently running and how many
are in queue.
show processlist---This will give the list of SQL
Hi Gleb,
I am sorry i forgot to metion the storage engine we are using, its innodb.
The below option is only for myisam engine.
Innodb stores data and index in the same file as per documentation.
Can you please correct me if i am wrong.
regards
anandkl
On 9/15/05, Gleb Paharenko <[EMAIL PROTE
Henri-Maxime Ducoulombier wrote:
I have a question regarding the possibility of creating a string from a
resultset directly using an SQL command. I'm not sure if this is possible.
Here is what I have:
A table with links between articles and category in a catalog.
For ArticleID #1, I have say 3 c
Jasper Bryant-Greene wrote:
Vlad Shalnev wrote:
Periodically I get error message "can't get stat of xxx.MYD" for
tables that are symbolic link to tables on different database on
the same file system. Error disappear after executing "flush
tables".
Why are you doing this? You can access tabl
Hello there,
I have a question regarding the possibility of creating a string from a
resultset directly using an SQL command. I'm not sure if this is possible.
Here is what I have:
A table with links between articles and category in a catalog.
For ArticleID #1, I have say 3 categories, and I woul
I have two configuration database for my application and I need to have some
tables with same data and some tables with different data.
Jasper Bryant-Greene wrote:
Vlad Shalnev wrote:
Periodically I get error message "can't get stat of xxx.MYD" for
tables that are symbolic link to tables on d
40 matches
Mail list logo