The next issue of MySQL Magazine is now available for download. Get it
while it is hot! At forty-two great pages it is our biggest and best
issue yet. This issue is anchored by the first annual MySQL Usage
Survey results.
Downloads at the MySQL Magazine homepage: http://www.mysqlzine.net
Thanks
Hey everyone!! Just wanted you to know that it's that time. The
summer issue of MySQL Magazine will be coming out July the 15th. That
means that it is time to start gathering the articles. If you have
interest in having your words read by thousands of people and having
fame and fortune come
Mike wrote:
I would like to move from 32-bit to 64-bit MySQL within the next year.
Unfortunately, there is not a lot of documentation on migration or anything
else regarding 64bit MySQL.
My current setup consists of one master and two slaves (all using 32bit and
MySQL 5.0). I am looking to add
Olaf Stein wrote:
Probably not
AFAIK it should work in theory if you have no floating point columns but I
would not try it.
Why cant you take a dump, you can do it table by table, you will have some
downtime though.
One option might be to use a 64bit slave and make that the master and then
add
A simple rsync should do the trick. How long will depend on how much
data you have. I would just shut down the server, copy over the data
directory and start the new server up. Should be a piece of cake.
Keith
David Ruggles wrote:
I have a MySQL 5.x box and I am thinking about moving it
Hey everyone,
I just posted the Spring issue of the MySQL Magazine. This issue
contains a great group of articles that you will want to read. In
addition, Sheeri Cabral did a fabulous job with a new layout for the
magazine. It is as always FREE!!.
Available for download from
15, 2008 at 2:20 PM, B. Keith Murphy [EMAIL PROTECTED] wrote:
Hey everyone,
I just posted the Spring issue of the MySQL Magazine. This issue contains
a great group of articles that you will want to read. In addition, Sheeri
Cabral did a fabulous job with a new layout for the magazine
When it selects values from the myisam table it is locking the entire
table.
Saravanan wrote:
Hi Lists,
i have created a procedure. It selects values from a myisam table and updates
an innodb table one by one ( not as huge update it clearly use where clause).
but whenever I run the
Sorry I can't recommend anything offhand, but this type of message does
not need to go to the internals mailing list.
Thanks,
Keith
Haitham Kaddoura wrote:
Hi,
does anyone use the or know a data mining package in MySQL?
--
Keith Murphy
editor: MySQL Magazine
for a job, you could hardly
go wrong with it, IMO.
[...]
Yeah, I think that I'm going for the certification, although I can't
imagine what kind of job I could land -- junior DB admin? I don't
have a college degree :(
-Thufir
--
B. Keith Murphy, CMA
Paragon Consulting Services
http
, from small to
quite big (tables with about 2M rows). I've got a SAS disk array and I was
wondering what the best configuration could be:
1) raid 10
2) raid 5
3) a combination (e.g., raid10 for the data and raid 5 for the logs).
Any suggestion or link?
Thanks,
Luca
--
B. Keith Murphy
will resync from last
known state. I believe that if the logging on master was switched off, it
will have no record of the changes made to database and I will need top
recopy the database, but just to confirm or if there is any simpler way.
Thanks
--
B. Keith Murphy
Paragon Consulting
deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
--
B. Keith Murphy
Paragon Consulting Services
http://www.paragon-cs.com
850-637-3877
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
submissions on php development with MySQL.
Hope to hear from you soon!
keith
--
B. Keith Murphy
Paragon Consulting Services
http://www.paragon-cs.com
850-637-3877
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
I just posted the latest edition of MySQL Magazine. It is available for
free download from http://www.mysqlzine.net.
Take a look!
Keith
--
B. Keith Murphy
Paragon Consulting Services
http://www.paragon-cs.com
850-637-3877
--
MySQL General Mailing List
For list archives: http
in
this communication.
--
B. Keith Murphy
Paragon Consulting Services
http://www.paragon-cs.com
850-637-3877
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
serious thought into automating some
things. I was wondering what experience others have had with any
technologies (I am modestly familier with expect and have touched
dsh).
Thoughts??
thanks,
keith
--
B. Keith Murphy
Paragon Consulting Services
http://www.paragon-cs.com
850-637-3877
??
thanks,
keith
--
B. Keith Murphy
Paragon Consulting Services
http://www.paragon-cs.com
850-637-3877
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED
to scale efforts so
I don't have to manually do things.
thanks,
Keith
B. Keith Murphy wrote:
Martin,
Martin Gainty wrote:
3 ideas come to mind-
cron and or cruisecontrol for off-hours scripting
ant for handling cross-platform scripting
maven for implementing dependency checking as well
and are much more compact. These tools (and a
number of others) are located at maatkit.sourceforge.net.net.
Hope that helps.
Keith
--
B. Keith Murphy
Paragon Consulting Services
http://www.paragon-cs.com
850-637-3877
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
PROTECTED]
--
B. Keith Murphy
Paragon Consulting Services
http://www.paragon-cs.com
850-637-3877
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What versions of MySQL are you using on both the master adn the slaves?
Keith
Michael Stearne wrote:
We have replication set up for 1 master and 4 slaves. When resynced
everything appears to work fine. Come back a couple hours later and
the machines are out of sync. The only thing I can think
simple that I suspect something else. But then again, I don't
know what you mean by out of sync :)
On Nov 28, 2007 4:32 PM, B. Keith Murphy [EMAIL PROTECTED] wrote:
What versions of MySQL are you using on both the master adn the slaves?
Keith
Michael Stearne wrote:
We have replication set
bruce wrote:
hi...
a quick question that i haven't found an answer to.
i can use replicate-do-db=foo in a my.cnf file for replication, to
replicate the master foo db on the slave. but this requires that i use/have
a my.cnf set on the slave.
is there a way to dynamically set this
This has probably already been over-talked about :) but I will throw my
two cents in. I would be very much opposed to a situation where changes
made on-the-fly are stored permanently in the my.cnf file. If I decide
to keep a change to a server setting I am very much capable of doing it
I would echo what Dan says. In addition, from the slave server, you
might look at running the new mysql-parallel-dump tool that Baron
Schwartz has developed. It essentially does a dump with a thread
running (by default) for each CPU core you have. A dual core box will
run two threads and
Michael Stearne wrote:
Is mysql-table-sync design to be used as a fix for when your
replication is out of sync OR can it be used instead of replication?
Thanks,
Michael
You need to use replication not mysql-table-sync for replication.
mysql-table-sync is use to get it back in sync.
.
- Original Message
From: B. Keith Murphy [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, November 16, 2007 10:29:17 AM
Subject: innodb rollback question
I have something to throw out. I just got done importing 140 million
rows from a myisam table to a innodb table. While it worked I had
I have something to throw out. I just got done importing 140 million
rows from a myisam table to a innodb table. While it worked I had a
thought about 3/4ths of the way through. What if the transaction had
been canceled about 130 million rows in? It would have taken weeks to
roll back.
Ryan,
show slave status after it stops copying should give you some type of
error information about the failure. What does it show?
Keith
Ryan Klein wrote:
I am having an issue that I cannot determine the cause. We have a
master server that is actually a production server and a slave
In production we use both reiserfs and xfs. I am migrating our data
partitions for mysql because it has faster write rates than reiserfs.
You need to stop using fedora and at least use CentOS. Fedora is not
stable for production work.
Just my two cents :)
Keith
Ali Nebi wrote:
Hi,
i
systems I have come across for MySQL Production.
On 10/28/07, *B. Keith Murphy * [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
In production we use both reiserfs and xfs. I am migrating our data
partitions for mysql because it has faster write rates than reiserfs.
You need to stop
Hey everyone,
I am starting on putting together the Winter issue of the MySQL
Magazine. This will be our third issue and it is getting better each
time!
Here is your opportunity to contribute to the community. I am accepting
ideas/outlines/proposals for articles for this issue through
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
blog: http://blog.paragon-cs.com
(o) 919-433-0786
(c) 850-637-3877
Recover your files first and then you can see where you can go. I
suppose you now have backup plans in place now?
Keith
David Winslow wrote:
Hey,
Environment:
Windows 2003 server
Mysql 5.0 server
Problem:
Our server crashed and the c drive was formatted. Unfortunately we did not
Thanks everyone for the replies. The problem revolved around '%' vs
'localhost'. To me, it seems logical that '%' would include localhost..not
really true. So, I have it figured out.
thanks,
Keith
- Original Message -
From: B. Keith Murphy [EMAIL PROTECTED]
To: mysql mysql
.
thanks,
Keith
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
blog: http://blog.paragon-cs.com
(o) 919-433-0786
(c) 850-637-3877
Just wanted to let everyone know that the second issue of the MySQL
magazine has been uploaded. It is available from
http://www.paragon-cs.com/mag/mysqlmag.html
Our featured articles include:
MySQL Maintenance script -a multi-threaded tool for database maintenance
MySQL Table Checksum How-To
need to take to make one of the slaves as a stand alone
master db.
regards
anandkl
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
blog: http://www.paragon-cs.com/wordpress
(o) 919-433-0786
(c) 850-637-3877
://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
blog: http://www.paragon-cs.com/wordpress
(o) 919-433-0786
(c) 850-637-3877
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
blog: http://www.paragon-cs.com/wordpress
(o) 919-433-0786
(c) 850-637
.
Why this mysqld can't support large memory usage?How to improve it?
Thanks!
--jen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian
-Wide-Deployment-tf4265688.html#a12139896
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
B. Keith Murphy
Database Administrator
about potential future storage engines in mysql, or will
there be myisam as the one and only feature blown one?
Thanks in advance,
Christian Parpart.
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
(o) 919-433-0786
(c) 850
% myisam are static reference tables can be
done in advance).
thanks!
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
(o) 919-433-0786
(c) 850-637-3877
,
Keith
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
(o) 919-433-0786
(c) 850-637-3877
. If you want to
send me some ideas for articles you can either reply to this email address or
bmurphy at paragon-cs.com.
Thanks again,
Keith
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
(o) 919-433-0786
(c) 850-637-3877
file name. Is there some way to automate this data import?
Thanks,
Keith
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
(o) 919-433-0786
(c) 850-637-3877
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
(o) 919-433-0786
(c) 850-637-3877
/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
(o) 919-433-0786
(c) 850-637-3877
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
(o) 919-433-0786
(c) 850-637-3877
I know there is a tool out there to grab the user info from the mysql database
and store it like versioning control. I thought it was in Baron's toolkit but
unless I have had too much caffeine and can't read I don't see it on his
website. What am I thinking of?
Thanks,
keith
--
B. Keith
I think it was Baron's toolkit I was thinking of...
the command mysql-show-grants seems to do the trick.
Thanks,
Keith
- Original Message -
From: B. Keith Murphy [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Wednesday, June 27, 2007 4:11:54 PM (GMT-0500) America
Everyone,
I have just uploaded the first issue MySQL Magazine to
http://paragon-cs.com/mag/issue1.pdf
Please take a look at it. There is a great deal of information here and
I think it is worth some time.
Feedback is always welcome.
thanks,
Keith Murphy
--
MySQL General Mailing List
So here is the brief situation. We have a coraid (www.coraid.com) SAN
unit - the 1520 I believe. It is ATA-over-ethernet.
Right now we have a about 500 gigs of data spread across five servers.
To simplify things I would like to implement the coraid on the backend
of these servers. Then
Have you considered replicating to a backup server and then dumping from
it?
No matter your processors with a 100gb db it is going to take a
significant amount of time.
Keith
Ananda Kumar wrote:
Hi All,
We have database of around 100GB, and planning to take dump using
mysqldump.
Can you
Sometimes partitioning is absolutely necessary. If you can't run a
cluster - how else can you really scale writes to the database? Some
companies can't use clustering because in 5.0.x (the non-beta release)
clustering is all done in memory - all tables have to be in memory (just
like the old
OK. Going to try this again. After reading through these emails I
think I have learned a little more about the way you are thinking.
I DO NOT want to start some kind of flame war.
However, I disagree very strongly with what you are saying. Yes, you
are right, sharding does require more
Halid Faith wrote:
I use mysql4.1.22, php4.4.6 and apache2.0.59.
I want to put an quota for each databases and mysql users. How can I
do that
mysql will limit each database's memory usage? Because some mysql users
sometimes use much memory while doing a sql query.
Also How can I put an quota
I have had exactly the kind of trouble you are talking about. Sorry I
didn't see the messages until just now. Had to manually remove crap too
even though I purged (rpms - centos I think). Hopefully this will help
others down the road.
Keith
John Kebbel wrote:
Even though I
Baron Schwartz wrote:
Hi,
Tim Milstead wrote:
Hello,
Is it possible to enforce data formatting in fields using something
like a regular expression?
varchar is great but does not stop someone putting in the wrong
reference number.
I suspect the answer is no, you have to do it at a higher
advertisers /sponsors and use that to
pay for articles. Just remember that this a way that you can give back
to the community.
Thanks,
Keith
B. Keith Murphy wrote:
Hey everyone,
I have been considering putting together a e-zine for MySQL as my way
to give back to the community. I
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
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 et
64 matches
Mail list logo