Hi Keith,
This would be a great start to have an e-zine mag for Mysql. Let me see how
I can be of helpful in this regard.
Regards,
S.Mugunthan
[EMAIL PROTECTED]
-Original Message-
From: B. Keith Murphy [mailto:[EMAIL PROTECTED]
Sent: Friday, April 27, 2007 9:55 AM
To: Kevin Spencer
Cc: m
Hi Scott,
This would be a great start to have an e-zine mag for Mysql. Let me see how
I can be of helpful in this regard.
Regards,
S.Mugunthan
[EMAIL PROTECTED]
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Friday, April 27, 2007 8:38 AM
To: MySql
Subject: Re: MyS
Kevin Spencer wrote:
On 4/26/07, Mike OK <[EMAIL PROTECTED]> wrote:
I read the Google blog post regarding these patches. They admit using
MySQL for some internal data storage needs but not in the general search
system.
Still, that leaves many other applications. Groups, gmail, reader,
news e
This sounds a lot like what I'm attempting. I tried a proprietary database
and got around 30k queries/second, compared to MySQL's of only 1-1.5k
queries /second. I'm torn between using the Windows proprietary database
(still has some minor buggy parts) on each webserver or going with MySQL
5.
> Hey everyone,
>
> I have been considering putting together a e-zine for MySQL as my way to
> give back to the community. I was curious as to what type of interest
> there would be in this. I am thinking something quarterly to start with
> and probably 15 - 20 pages. Nothing huge. Topics woul
Hey everyone,
I have been considering putting together a e-zine for MySQL as my way to
give back to the community. I was curious as to what type of interest
there would be in this. I am thinking something quarterly to start with
and probably 15 - 20 pages. Nothing huge. Topics would vary f
# cat /etc/cron.mysql/20-purgemasterlogs
#!/bin/sh
/usr/bin/mysql --defaults-file=/root/.my.cnf -e 'show master logs; purge
master logs before date_sub(now(), interval 30 day); show master logs;'
>/var/log/20-purgemasterlogs.log 2>&1
This purges anything older than 30 days.
HTH,
Tim
> -Origi
On 4/26/07, Mike OK <[EMAIL PROTECTED]> wrote:
I read the Google blog post regarding these patches. They admit using
MySQL for some internal data storage needs but not in the general search
system.
Still, that leaves many other applications. Groups, gmail, reader,
news et al...
--
Kevin.
--
So, I take it since I do not have a slave at all, I could safely just
disable this feature altogether?
If I do not need point in time recovery, and the once every 12 hour dump I
do across all databases is ok with me, I suppose I can just disable said
feature? Heck, some of these boogers are a GB
Issuing a 'reset master' will purge all of the logs as well. I wouldn't
just rm them, as they are being tracked in the index file.
If you aren't running a slave, then these files are only good for data
recovery purposes. Say a DBA goes crazy and deletes all of the databases
mid-day (too much s
On Thu, April 26, 2007 18:38, Baron Schwartz wrote:
> Hi,
>
> Imran Chaudhry wrote:
>> I'm wondering if any of you can assist with an interesing SQL
>> query. I have a single table within a database, the relevant fields of
>
> Try IF or CASE expressions:
>
> SELECT foo, count(*), sum(case when fo
Hi
I read the Google blog post regarding these patches. They admit using
MySQL for some internal data storage needs but not in the general search
system. Here is the link to the blog post
http://google-code-updates.blogspot.com/2007/04/google-releases-patches-that
-enhance.html
Mike O'Kro
I am getting this message from mysql. We had our binlog directory full.
What is the resolution?
Error 2002 (HY000) Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
This message is intended only for the use of the Addressee and
> Yes -- sorry for being so general. You can use the binlogs for a)
> replication b) replaying changes since your last backup so you get
> point-in-time recovery. If you have no replication slaves, just delete
> everything older than your latest backup. You can just use 'rm'. If
> you use PUR
The smaller Dells, like the 28xx and 18xx series, are exactly what I
consider commodity hardware. Other companies (Sun, HP, Gateway, IBM, Apple,
others) make comparable equipment at comparable prices.
Whether you need to spend the money on redundant power supplies and a
redundant drive setup is
Hi Scott,
Scott Haneda wrote:
In the short term, see the manual page for PURGE MASTER LOGS. In the
long term, write a cron job.
innotop (http://sourceforge.net/projects/innotop) also has a new
feature, unreleased because I just wrote it a few hours ago, which will
help you figure out which bin
> In the short term, see the manual page for PURGE MASTER LOGS. In the
> long term, write a cron job.
>
> innotop (http://sourceforge.net/projects/innotop) also has a new
> feature, unreleased because I just wrote it a few hours ago, which will
> help you figure out which binlogs can be purged sa
Hi,
Scott Haneda wrote:
Running mysql 4, just poked into data and see I have gigs and gigs of
hostname-bin.xxx log files.
How does one maintain these, can someone point me to relevant data on what
to do about drive space being lost to these?
thanks
See attached message I just sent to another
Hi,
Imran Chaudhry wrote:
I'm wondering if any of you can assist with an interesing SQL
query. I have a single table within a database, the relevant fields of
which are defined as:
CREATE TABLE tableA
(
domain text,
mime text
);
Where "domai
Running mysql 4, just poked into data and see I have gigs and gigs of
hostname-bin.xxx log files.
How does one maintain these, can someone point me to relevant data on what
to do about drive space being lost to these?
thanks
--
-
Scott
I'm wondering if any of you can assist with an interesing SQL
query. I have a single table within a database, the relevant fields of
which are defined as:
CREATE TABLE tableA
(
domain text,
mime text
);
Where "domain" is a domain, such as:
go
Hello,
Brown, Charles wrote:
Hello All. My bin.log directory is getting full with bin.log files. We
are running out of space. What can I do in the short term? Is there a
command that I can issue that will get rid of old bin log files not
needed?
In the short term, see the manual page for PURGE
Gerald L. Clark wrote:
James Tu wrote:
I was a little to quick with the send button.
Can you do a query like this:
(I know that the * syntax is not correct, but is there something
equivalent to it?
SELECT from cars
WHERE
make=5 AND
model=* AND
body_color=7 AND
tire_type = *
Hello All. My bin.log directory is getting full with bin.log files. We
are running out of space. What can I do in the short term? Is there a
command that I can issue that will get rid of old bin log files not
needed?
This message is intended only for th
James Tu wrote:
I was a little to quick with the send button.
Can you do a query like this:
(I know that the * syntax is not correct, but is there something
equivalent to it?
SELECT from cars
WHERE
make=5 AND
model=* AND
body_color=7 AND
tire_type = * AND
hub_caps_type =
Hi,
I'm trying to build MySQL 4.1.22 on a VPS where it looks like our
available memory could be as low as 32MB, and compilation is erroring
out partway through with a "virtual memory exhausted: cannot allocate
memory" message.
I tried invoking configure with the "--with-low-memory" flag, and th
What exactly are examples of “commodity servers”? I know what characteristics
they have, but could somebody point out several examples that’d be used in a
MySQL scale-out? e.g. What do you use?
Also, would these servers be 1U or other configurations that take up very
little room in a rack?
Would
I was a little to quick with the send button.
Can you do a query like this:
(I know that the * syntax is not correct, but is there something
equivalent to it?
SELECT from cars
WHERE
make=5 AND
model=* AND
body_color=7 AND
tire_type = * AND
hub_caps_typ
On Wednesday 25 April 2007 23:14, you wrote:
> try this:
>
>
> update table1, table2
> set table1.value = table2.value
> where table1.id = table2.id
Thanks for the replies... It was late evening when I tried to figure out how
to do this.
Today I found the answer myself, which is exactly as descr
Hi,
When I try mysql_upgrade I get a connection problem,
$ mysql_upgrade -p
Enter password:
/usr/bin/mysqlcheck: Got error: 1045: Access denied for user
'root'@'localhost' (using password: YES) when trying to connect
Error executing '/usr/bin/mysqlcheck --check-up
most likely you just need to redirect STDERR to tee as well so it's not
a mysql problem:
mysql -u -p -f << eof 2>&1 | tee ttt.txt
...
assuming it's Bourne or ksh, don't remember what's csh for 2>&1
Regards,
Michael
-Original Message-
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
S
Martjin, I've run various versions of MySQL from 3.2 through 5.1 on various
platforms (Mac OS X, FreeBSD, RedHat/Fedora Linux, Windows, Solaris),
exporting and importing as needed, and haven't encountered any problems.
I've even transferred the MyISAM tables between machines in a few cases,
rather
I must have misunderstood, then. I thought the Greek characters were more
than one byte.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: nikos [mailto:[EMAIL PROTECTED]
> Sent
Hi All,
I have written a script to connect to mysql and all the command results is
spooled into a file.
But when an error occurs in mysql, it stops at that point and does not
proceed to the next command, also these error command is not written to the
output file.
Can you please tell me what i nee
Hi there,
I have recently upgraded from mysql 4.0 to 4.1.x
Now I am facing an error while issuing this delete command:
# delete report images in db
$stmt= "
DELETE
FROM
$DB.$T21
USING
$DB.$T21 AS rp,
$DB.$T13 AS r
WHERE
Dear list,
My company wants to migrate MySQL 5.0.18 from SPARC/Solaris 8 to
Intel/RedHat Enterprise Linux 4 update 4.
Are there any incompatibilities or snags to be expected (expect from the
endian issue, which will be solved by exporting/importing the data)?
Thank you for your time,
Martijn
36 matches
Mail list logo
