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
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
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
Hi Maurice,
Yep, it's very very confusing these days. Unfortunately for all of us,
MySQL's sales organization seems happy with the situation. Blame them.
And, yes, you're correct, compared to MySQL Enterprise, 5.0.45 is indeed
out of date now. The releases are sequential, but the
Hi Maurice,
You say the MySQL data wasn't on the stuck volume, but were the InnoDB logs?
What is the disk configuration?
It sounds to me like bad hardware/software, which, unfortunately MySQL
and InnoDB cannot protect you from...
Regards,
Jeremy
Maurice Volaski wrote:
Some processes on a
Hi David,
This sounds strange, and should NOT occur because of a server_id conflict.
Regards,
Jeremy
David Schneider-Joseph wrote:
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
Hi Shawn, Lucio,
SELECT STRAIGHT_JOIN
FROM ...
LEFT JOIN ...
WHERE ...
...
Just to correct a point here... if a query uses only LEFT JOIN or RIGHT
JOIN, the join order is fixed by the query's order itself, so using
STRAIGHT_JOIN should have no effect whatsoever. Equally important,
Hi Krishna,
No, nothing like what you're asking for exists free or open source.
Look into Groundwork and Nagios, though they will not do any really
fancy monitoring directly out of the box, with a bit of configuration
you can get most of what you want.
Regards,
Jeremy
Krishna Chandra
On Fri, 14 Sep 2007, Jeremy Cole wrote:
Just to correct a point here... if a query uses only LEFT JOIN or RIGHT JOIN,
the join order is fixed by the query's order itself, so using STRAIGHT_JOIN
should have no effect whatsoever. Equally important, since the join order is
but experimentally
Krishna Chandra Prajapati wrote:
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.
You get what you pay for.
Try mysqlreport, nagios, and innotop.
Baron
--
Hi,
I have an address stored as a serialized array
address[0] = my street;
address[1] = Edinburgh;
address[2] = Scotland;
This is what I have. I want if it is possible to extract all the UNIQUE
towns from my database.
This is what the on of the entires looks like in my database.
Hi All,
I'd like to restrict queries using the username of the user that
issued the query. I know about the available user restrictions in the
database, but they seem limited to whole tables and columns. What I
need is limiting the access on row level. If I can access the
username, I'd
Ross Hulford wrote:
Hi,
I have an address stored as a serialized array
address[0] = my street;
address[1] = Edinburgh;
address[2] = Scotland;
This is what I have. I want if it is possible to extract all the UNIQUE
towns from my database.
This is what the on of the entires looks like in my
Hi All,
I have create a user on server 192.168.1.10 by the command below.
grant all on test .* to 'test'@'192.168.1.%' identified by 'test';
flush privileges;
after fewday i don't want the user to access the test database. So i have
given a revoke command as below
mysql revoke all privileges on
Krishna Chandra Prajapati wrote:
Hi All,
I have create a user on server 192.168.1.10 by the command below.
grant all on test .* to 'test'@'192.168.1.%' identified by 'test';
flush privileges;
after fewday i don't want the user to access the test database. So i have
given a revoke command as
Peter Teunissen wrote:
Hi All,
I'd like to restrict queries using the username of the user that issued
the query. I know about the available user restrictions in the database,
but they seem limited to whole tables and columns. What I need is
limiting the access on row level. If I can access
Hi,
I have narrowed the query - I just want to return the FIRST instance of
each ticket, ie the Source. Here is the table:
CREATE TABLE `Thedata1` (
`Source` varchar(15) collate latin1_general_ci NOT NULL default '',
`Close_Time` datetime NOT NULL default '-00-00 00:00:00',
Jeremy,
We observed thousands of errors in the logs of one of our slave
servers suggesting that it was making repeated failed connections to
our master.
Example:
070905 20:15:21 [Note] Slave: received end packet from server,
apparent master shutdown:
070905 20:15:21 [Note] Slave I/O
Morning All-
I connect to Mysql 4.0.13 using mysql_connect AND returned handle is not
false
then I call access to mysql_select_db which always returns NULL and causes
Exception
I also tried mysql_connect with supplied 4th param as DB with no joy
The DB name is uppercase..does this matter?
I think you want to use a GROUP BY query. Try this article:
http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/
Baron
Weston, Craig (OFT) wrote:
Hi,
I have narrowed the query - I just want to return the FIRST instance of
each ticket, ie the Source. Here
Has anyone else been having problems sending mail to mysql-
[EMAIL PROTECTED]
I tried it with two mail accounts (one at work and also GMail)
I get this as a response...for some reason it doesn't seem to be
getting to the list at all. The mail servers are somehow taking that
address and
Hi all,
First sorry my bad english :)
I having a problem with a large join with 10 tables with 70Gb of text data,
some joins executed by index but some others not.
I´m work with HP SERVER (Proliant NL-150) a 2 Xeon 2 Duo with 3Gb Ram and
RAID 0.
When executed to a client with small datasets
Jim wrote:
Can these be legally run without a license?
They ARE licensed: under the GPL.
http://www.gnu.org/copyleft/gpl.html
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thank you Jay and Baron for your help.
This e-mail, including any attachments, may be confidential, privileged or
otherwise legally protected. It is intended only for the addressee. If you
received this e-mail in error or from someone
Can these be legally run without a license?
Is the only difference that MySQL AB doesn't publish links to the current
version on their web page, instead purposely choosing to leave the
community version several revisions behind?
Yeah, I'm a little confused.
- Original Message -
At 12:26 PM -0400 9/14/07, Martin Gainty wrote:
Morning All-
I connect to Mysql 4.0.13 using mysql_connect AND returned handle is not false
then I call access to mysql_select_db which always returns NULL and
causes Exception
I also tried mysql_connect with supplied 4th param as DB with no
MySQL Ver 8.41 Distrib 5.0.27
Intel Xeon
3.60 GHz
2.0 G of RAM
Windows Server 2003
Service Pack 1
The following query will sometimes work and sometimes fail. When it
fails it kills the mysqld service and requires it to be restarted.
Sometimes if I add additional id's to
Hi,
Your English is fine :) Your queries don't look too bad. It could be
there are no good indexes. Have you tried running EXPLAIN on them?
What version of MySQL are you using? You can also try profiling the
queries (by hand with SHOW STATUS, or more easily with MySQL Query
Profiler) to
I am running this query:
SELECT group_post_mod_option.option_id,
group_post_mod_option.option_name,
COUNT(group_post_moderation.group_post_moderation_option) AS count
FROM group_post_mod_option
LEFT OUTER JOIN group_post_moderation ON
(group_post_mod_option.option_id
Hi everyone,
all of a sudden today, I keep getting the error mentioned in the subject
when I open the dbase in phpmyadmin..
I have a dbase with 14 tables. When I open it in phpmyadmin, it will
list all the tables until it reaches the table orderpc and then stops
right there.
I went into
From: Matt Gordon
Sent: Friday, September 14, 2007 6:37 PM
To: Daevid Vincent
Subject: Trailing space thing to post to mysql list
I searched Google and didn't find anything obvious.
Here is minimal SQL to reproduce the problem.
#
# Running mysql 5.0.41
#
[EMAIL PROTECTED] ~]# perror 13
OS error code 13: Permission denied
check permissions that it is read/write for the mysql user
On 9/14/07, Haig Dedeyan [EMAIL PROTECTED] wrote:
Hi everyone,
all of a sudden today, I keep getting the error mentioned in the subject
when I open the dbase in
At 7:00 PM -0700 9/14/07, Daevid Vincent wrote:
From: Matt Gordon
Sent: Friday, September 14, 2007 6:37 PM
To: Daevid Vincent
Subject: Trailing space thing to post to mysql list
I searched Google and didn't find anything obvious.
Here is minimal SQL to
Thanks Mike.
Thanks Mike. Don't know why the permissions were read only all of a
sudden but that was the problem.
Haig
Mike Zupan wrote:
[EMAIL PROTECTED] ~]# perror 13
OS error code 13: Permission denied
check permissions that it is read/write for the mysql user
On 9/14/07, Haig
Naz,
That query logic runs without a error on the server I have to hand
(5.0.37), but it has three issues:
(i) unless there is an exceptionless 1:1 relationship between
group_post_mod_option.option_id and group_post_mod_option.option_name,
results for the latter column will be meaningless
35 matches
Mail list logo