> Hello all,
> I want to suggest one thing relating to MySQL Tools for 5.0(Administrator,
> Query browser etc.) -
> A new feature can be added to use command line options to synchronize
> structure and data, data transfer in many formats and scheduling above
tasks
> on windows/linux and other OS.
Thank you for this info, but it just seems make a simple question a
matter of confusion.
It tells us that MySQL is being marketed under two editions, but nowhere
does it say that the current release of each is matched bugfix for bugfix
and the version difference is just arithmetic.
Since commun
Hi Bullington,
MySQL Monitering Service is a paid one. There is any open source free
software which can moniter mysql heaths and tells the changes need to be
done on system variables.
Regards,
Prajapati
On 9/13/07, J.R. Bullington <[EMAIL PROTECTED]> wrote:
>
> You can also try the MySQL Monito
In the last episode (Sep 13), Maurice Volaski said:
> I just learned that the current version of MySQL is 5.0.48, described here
> http://dev.mysql.com/doc/refman/5.0/en/releasenotes-es-5-0.html and
> available from
> http://download.dorsalsource.org/files/b/5/165/mysql-5.0.48.tar.gz
The curren
Hello.
i am using Redhat EL3 linux. and mysql version is 3.23.49a-Max
but sometime will shutdown suddenly. when i read the mysql log file
have found as below.
please help me.. tks
Roy
InnoDB: Assertion failure in thread 143396 in file mem0pool.c line 345
InnoDB: We intentionally generate a
Hi Folks,
I am having problems trying to use the GET_LOCK and IS_FREE_LOCK
commands. I am trying to put together a queue manager. The theory is
that is would scan for queues, check for a lock and if the lock if free
then start the queue. When the queue process starts it should use
GET_LOCK
I just learned that the current version of MySQL is 5.0.48, described
here http://dev.mysql.com/doc/refman/5.0/en/releasenotes-es-5-0.html
and available from
http://download.dorsalsource.org/files/b/5/165/mysql-5.0.48.tar.gz
When I search this list, I see no mention of it or the previous
rele
It certainly seems that 5.0.44 and 5.0.45 are unstable. I have logged
this as bug http://bugs.mysql.com/bug.php?id=31008
A 64-bit Gentoo Linux box had just been upgraded from MySQL 4.1 to
5.0.44 fresh (by dumping in 4.1 and restoring in 5.0.44) and almost
immediately after that, during which t
Also, if a significant number of your records have the 'active'
attribute assigned to 1, hte query optimizer will see it as more
efficient to do a full table scan rather go through all the
indirection layers the index imposes.
- michael
On 9/13/07, Les Fletcher <[EMAIL PROTECTED]> wrote:
> If I
If I am not mistaken, group by only uses an index if the index is first
used as part of the where clause and is compared to a constant. You'd
need a two column index for this query:
INDEX(active,food)
The 'active' part would be used in the where clause, and the second part
( "food" ) could t
I have an index on `food` and on `active`, how come the result of the
EXPLAIN doesn't show the query using an index? I'm concerned that as
the query time will grow with the table.
My Query:
SELECT `food` , COUNT( `food` ) AS 'population'
FROM `users`
WHERE `active`=1
GROUP BY `food`
LIMIT 0
>
> > How do you go about creating the tunnel?
> There are lots of good tutorials online:
> http://www.google.com/search?q=create+ssh+tunnel
>
Excellent. My thanks to you and to everyone who participated in this
thread!
thnx,
Christoph
>
> Again, you can get absolutely ANY client to connect over an SSH tunnel.
> You create the tunnel with your SSH client, then use the tunnel to
> carry your traffic. So you don't need to use an unfamiliar or non-free
> program to do this. (Any program that offers a connect-over-SSH option
> is v
Christoph Boget wrote:
You're not going to get anything to connect over SFTP, because it is a
file transfer protocol layered on top of SSH. SSH is a generic protocol
that can create a secure tunnel between two untrusted computers, and any
kind of data can ride on this protocol. The same is not
Christoph Boget wrote:
There are lots of GUIs for connecting to MySQL databases. MySQL provide
some (MySQL Query Browser and MySQL Administrator) but I prefer Toad:
http://www.quest.com/toad-for-mysql/
I tried MySQL Administrator but couldn't get it to connect over SSH/SFTP.
I'll take a look a
>
> There are lots of GUIs for connecting to MySQL databases. MySQL provide
> some (MySQL Query Browser and MySQL Administrator) but I prefer Toad:
> http://www.quest.com/toad-for-mysql/
I tried MySQL Administrator but couldn't get it to connect over SSH/SFTP.
I'll take a look at toad-for-mysql a
Christoph Boget wrote:
I did a search and couldn't find anything like what I'm looking for and
though I doubt something like this does exist, I figured I'd ask anyway. Is
there a client (not phpMyAdmin) that can connect to a server (that is
running MySQL) using SSH and connect to the database th
Hello all,
I want to suggest one thing relating to MySQL Tools for 5.0(Administrator,
Query browser etc.) -
A new feature can be added to use command line options to synchronize
structure and data, data transfer in many formats and scheduling above tasks
on windows/linux and other OS.
If these feat
>
> > > SSH or SFTP. The only way we can access the MySQL database on that
> server
> > > is either use phpMyAdmin (which I don't particularly care for; not to
> > > disparage the hard work of the developers, it's just a matter of
> personal
> > > preference) or use the command line.
> > Use the m
Christoph Boget wrote:
I did a search and couldn't find anything like what I'm looking for and
though I doubt something like this does exist, I figured I'd ask anyway. Is
there a client (not phpMyAdmin) that can connect to a server (that is
running MySQL) using SSH and connect to the database th
Christoph Boget wrote:
I did a search and couldn't find anything like what I'm looking for and
though I doubt something like this does exist, I figured I'd ask anyway. Is
there a client (not phpMyAdmin) that can connect to a server (that is
running MySQL) using SSH and connect to the database th
You could look at Navicat, a non-free interface, does SSH and so on.
http://navicat.com/index.html
This e-mail, including any attachments, may be confidential, privileged or
otherwise legally protected. It is intended only for the addres
I did a search and couldn't find anything like what I'm looking for and
though I doubt something like this does exist, I figured I'd ask anyway. Is
there a client (not phpMyAdmin) that can connect to a server (that is
running MySQL) using SSH and connect to the database that way? Right now,
the o
I have never seen this kind of behavior from MySQL but I have seen it
in the application layer (what language/framework are you using) when
an application, written with little thought to the implications of
race conditions or multi-processing considerations gets put under
load.
On 9/13/07, Krishna
Hi Craig,
would you mind posting the SHOW CREATE TABLE for the tables in question?
I'm having trouble determining what is the primary key for your
service ticket table...
Thanks,
-Jay
Weston, Craig (OFT) wrote:
Hello again,
I am having a duplication of results problem. I beli
Hello again,
I am having a duplication of results problem. I believe my
query (below) is giving me exactly what I deserve in writing it.
What it returns to me is a row for each status. What I would most want
would be a single row with the oldest status - IE the status datetime
that
Manivannan -
In a word, no. It's database software, not, um, cron. :)
There are scheduled events in 5.1, but that is more of a trigger-like
functionality than what you need, which is a scheduled task to save your
data somewhere. http://dev.mysql.com/doc/refman/5.1/en/events.html
You could loo
Thank you.
We had a situation recently where two slaves had a conflicting server
ID for several minutes, and shortly thereafter the master started
reporting errors which were indicative of data corruption while
executing queries. This happened as the CPU usage climbed very
rapidly, and u
Hi,
Is there any built-in backup scheduler for mysql database server? Yes, I can
use cron-tab in linux, but my env is windows. Also, I will be running mysql
server in different platforms. So, is there any built-in backup scheduler?
--
Manivannan Palanichamy
http://mani.gw.googlepages.com/index.
You can also try the MySQL Monitoring Service. It's a great tool that looks at
your server's health and tells you if any changes need to be made.
It's especially helpful in tuning your server variables, query cache, and index
usage. It also sends mail if you need / want it.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 13 September 2007 15:32
> To: mysql@lists.mysql.com
> Subject: MySQL DateTime Source on CentOS 5
>
>
> I'm running Apache/MySQL/PHP5 on a CentOS 5 server and have
> started to get
> some strange date and time i
Not quite what you're after but you might like to use...
http://dev.mysql.com/doc/refman/5.0/en/safe-updates.html
-Original Message-
From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
Sent: 13 September 2007 15:30
To: MySql
Subject: PROBLEM
Hi All,
There are many user accessing
--- Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> Is there is any script or tool that can diagnostic the mysql. It can check
> for the errors, give suggestion, give reports and send emails.
> It can check the mysql system variables and give suggestion.
>
You can use mysql-
I'm running Apache/MySQL/PHP5 on a CentOS 5 server and have started to get
some strange date and time inconsistencies between OS time and MySQL time
("now()").
1. MySQL Time:
[EMAIL PROTECTED] mysql -bA
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to s
Hi All,
There are many user accessing the production server and making a lots of
mistake, running wrong query (It occurs by mistake if they don't pay
attention) . There is any tools or script which can set autocommit=0;
whenever any user logged in. OR done some thing wrong which can be revert
back
Hi All,
Is there is any script or tool that can diagnostic the mysql. It can check
for the errors, give suggestion, give reports and send emails.
It can check the mysql system variables and give suggestion.
Thanks,
Prajapati
Hello David,
David Schneider-Joseph wrote:
Hi all,
What do you know about the effect of conflicting slave server IDs on the
master in general? And specifically, are you aware of any issues with
MySQL 5.0.27?
Your help is very much appreciated.
Thanks!
David
Repeating the same Server ID
Hi
I use mysql-5.0.45 on opensuse 10.2 linux x86.
The following reproducably breaks replication:
node A is master
node B is slave
A mysql> use anydb;
A mysql> drop view asdasdasd;
ERROR 1051 (42S02): Unknown table 'asdasdasd'
The name of the view does not matter. It does not exist, so mysql g
38 matches
Mail list logo
