Re: Query time taken on disk

Satendra, Google "show profile" as it may give you all the information that you need. There is a lot more details in the performance_schema if you want to dig into it, but it can be quite difficult to get out. Here is one place to start if you want to pursue that angle: http://www.markleith.co.uk

Re: Stored Procedure help

I would second what m. dykman says. There is no reason I can think of that you would even be doing the order by clause. keith On Sun, Jul 13, 2014 at 11:16 PM, yoku ts. wrote: > Would you try this? > > CREATE PROCEDURE `reset_sortid` (IN category INT(11)) > BEGIN > SET @a = 0; >

Re: Archive Engine Question

n). Beginning with MySQL 5.0.15, the engine also supports CHECK TABLE<http://dev.mysql.com/doc/refman/5.0/en/check-table.html>. There are several types of insertions that are used: You tell my why a customer who wants to place AUDIT information in a table might want that? Keith Murphy http://

Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6

1 > > It weird because If I upgrade 5.1 right over 5.0 without doing a > mysqldump, and then do a mysqlcheck it works, except for 5 tables, and > triggers, so trying to think of the best way to get to 5.1 > > On Fri, Feb 15, 2013 at 12:39 PM, Keith Murphy > wrote: > >

Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6

While it might be GA I would not recommend that you deploy it for a while. ... at least several point releases. There will be new bugs uncovered as it moves out to a wider audience. Upgrade to 5.5 (through 5.1) first as it is quite proven. Slave 5.6 off it and test. Be patient. Save yourself some

Re: user last activity and log in

One small correction. Init-connect doesn't require a restart of MySQL. I was thinking of init-file. So that's even better. On Thursday, October 4, 2012, Keith Murphy wrote: > My friend Dave Holoboff wrote this up some time ago: > > > http://mysqlhints.blogspot.com/2

Re: user last activity and log in

irly clean solution. Minimal load, easy to query for your last connection time and how often connections are made by a user. Again, requires a restart to enable (and disable) . Oh, and users with "super" privileges won't be logged. Thanks, Keith ---------- Keith Murphy S

Re: How often the slave to pull data from master?

Yes, the slave oulls On Jul 26, 2012 4:17 AM, "Zhigang Zhang" wrote: > Hello: > > > > I haven't read the source code of mysql ,but as I know ,the slave get data > from master server, rather than the master push data to slave. > > > > I think there is a timer to do this. > > > > Who can tell me th

Re: How often the slave to pull data from master?

Yes, the slave pulls from the master. The slave io thread reads the information effectively as soon as it is written to the master's binary log. Keith On Jul 26, 2012 4:17 AM, "Zhigang Zhang" wrote: > Hello: > > > > I haven't read the source code of mysql ,but as I know ,the slave get data > fro

Re: error log rotation problem

, 2011 at 12:57 PM, Prabhat Kumar wrote: > this will help you > http://adminlinux.blogspot.com/2009/09/mysql-log-file-rotation.html > > On Fri, Aug 12, 2011 at 9:43 AM, Paul DuBois wrote: > >> >> On Aug 11, 2011, at 2:30 PM, Keith Murphy wrote: >> >> >

error log rotation problem

Hey everyone, I have run across something that has me stumped. I have some systems that have very large error logs because we haven't moved from statement-based to mixed-based replication yet so they get a lot of warnings logged. I need to rotate the error logs and have started looking at it doing

Re: Is upgrading from 4.X to 5.X really that easy?

s why stop at 5.0 and > not > just go straight to 5.1.48? This is a single box, no replication or > clustering > going on ;-) Also all the data is in MyISAM, zero InnoDB :-) > > Thanks again for the advice :-) > > Nunzio > > > > > __

Re: Is upgrading from 4.X to 5.X really that easy?

MySQL rightly says you should dump and reload. As William said, you should read the release notes for every release between your current release and the target release. I have done this several times. I am currently planning a migration from 4.1.22 to 5.1.49 with a brief stop at 5.0 along the way.

Re: Myisam advantages

Since everyone keeps bringing up Innodb's shared tablespace, I will point out that Innodb has a "file-per-table" option where each table has it own tablespace. This helps with management issues. While there is still a central datafile it doesn't contain table data and is much smaller than if you us

Re: tcpdump mysql ?

You should look at www.hackmysql.com. He has a sniffed program strictly for Mysql. Should do what you want. HTH Keith On Apr 20, 2010 5:48 AM, "Brent Clark" wrote: Hiya I tried getting the following command running from the following youtube clip. http://www.youtube.com/watch?v=Zofzid6xIZ4 L

Re: optimization

convert all of the spamassassin, > drupal, and mediawiki tables to innodb too? Or just my own database? What > about the mysql database itself? I wouldn't convert those tables, would I? > > - Original Message - From: "Keith Murphy" > To: > Sent: Tuesday

Re: optimization

♫ I would recommend the same to you about reading High Perf. MySQL as Baron, et al wrote a great book about performance on MySQL. That being said, it has been my experience that in 99% of client cases they don't really need to run two different types of tables. If I were you, I would use InnoDB exc

Re: tmp tables

Victor, Don't want to butt in, and not trying to be rude, but he gave you advice. You don't seem inclined to take it. How else can he, or anyone else, help you? Clearly you don't understand some fundamental issue about relational databases. If you can't just accept his suggestion to put all carts

Free online training class on MySQL backups and recovery.

Hey everyone, I just posted new blog post about an online training class I will be doing January the 13th. This class will cover backups, recovery and disaster planning. It is completely free with no strings attached. If you are interested, take a look at the blog post here: http://www.paragon-cs.

Re: How to not lock anything?

Writers do block readers. Just at the row level vs the table level of MyISAM. It's just much less likely for writers to block readers. keith On Tue, Dec 15, 2009 at 11:57 AM, Perrin Harkins wrote: > On Mon, Dec 14, 2009 at 8:32 PM, D. Dante Lorenso > wrote: > > I have an "items" table that is

Re: the mystery of the missing mysql.sock file

ly not the server. > > Why do you keep it in /tmp, btw ? My guess would be that someone (or some > process) decided it was time to clean /tmp out. > > > On Tue, Dec 15, 2009 at 4:46 PM, Keith Murphy wrote: > >> Take one perfectly functional production server running 5.0.7

the mystery of the missing mysql.sock file

Take one perfectly functional production server running 5.0.77. It has been up and running under load for quite some time. I am using xtrabackup for backups and suddenly three or four days ago backup stop running. Investigation shows that the socket file '/tmp/mysql.sock' is no longer there. The m

Nov/Dec 2009 Issue of Open Source Database Magazine released!!

Exciting news! The next issue of Open Source Database Magazine (http://www.osdbzine.net) is now available. This information-packed issue has over 60 pages of information including: * Firebird’s Road Trip and What’s New with 2.5 * Coding Corner: Trees – Where’s the Performance? * PostgreSQL’s tsve

Call for articles for Fall Issue of Open Source Database Magazine

OSDB Magazine blog post here: http://www.osdbzine.net/wordpress/?p=3 I need to hear from you by October the 5th with any proposals and the article needs to be completed and turned in by October the 30th. Looking forward to hearing from you. Keith Murphy -- Editor Open Source Database Magazine

MySQL Magazine -- Winter 2009 issue released

Hey everyone, This is one of the largest issues so far. In addition, it has some of the best content we have ever had. The articles are all in-depth with some exciting new information: * *Introduction to XtraDB*: an overview of the new XtraDB storage engine along with benchmarks and

Re: Virtualizing MySQL

Check out Giuseppe Maxia's MySQL Sandbox program. It is a very easy way to run however many MySQL servers you want with separate config files and such .. heck..even separate versions if you want (one 5.0, one 5.1, one 6.0). It is available here: https://launchpad.net/mysql-sandbox Will take yo

MySQL Magazine Fall 2008 Issue Released!

The next issue of MySQL Magazine has been uploaded to the website at http://www.mysqlzine.net. It is a free pdf magazine about MySQL administration and development. Download it while it's hot! thanks, Keith -- Editor MySQL Magazine http://www.mysqlzine.net -- MySQL General Mailing List For

MySQL Magazine Summer Issue Released

to everyone who contributed. I couldn’t have done it without you all!! Keith Murphy -- Editor MySQL Magazine [EMAIL PROTECTED] http://www.mysqlzine.net (850) 637-3877 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Call for Articles for MySQL Magazine - Summer Issue

DBA work on MySQL or software development around MySQL will be considered. -- Keith Murphy editor: MySQL Magazine http://www.mysqlzine.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Migration from 32-bit to 64-bit MySQL

18 gb isn't too big to do a mysqldump. And I really wouldn't advise you trying to do a binary copy. You are just asking for trouble. Plan ahead and you can do this on a slave without any problem, import the data on the new server and sync it back up without any problems. -- Keith

Re: Migration from 32-bit to 64-bit MySQL

RAM. I would just dump the database from the 32-bit platform and import it into the 64-bit server. Keith -- Keith Murphy editor: MySQL Magazine http://www.mysqlzine.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: How hard is it to move from on server to another?

he same IP address. Thanks, David Ruggles CCNA MCSE (NT) CNA A+ Network EngineerSafe Data, Inc. (910) 285-7200 [EMAIL PROTECTED] -- Keith Murphy editor: MySQL Magazine http://www.mysqlzine.net -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: Spring 2008 MySQL Magazine released!!

Brown wrote: On Tue, Apr 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 n

Spring 2008 MySQL Magazine released!!

://www.mysqlzine.net or http://www.paragon-cs.com/mag. thanks and enjoy!! Keith Murphy -- Keith Murphy editor: MySQL Magazine http://www.mysqlzine.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: procedure locks all statemens

better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- Keith Murphy editor: MySQL Magazine http://www.mysqlzine.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: MySQL for Datamining

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

Re: Certified MySQL Associate (CMA) certification value

have at least a baseline of knowledge. If you're looking 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 :

Re: suggestion for disk configuration

, 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 M

Re: mysql replication

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

Re: turn a slave back into its own master

_ Looking for last minute shopping 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-63

MySQL Magazine Spring Issue -- Call for Articles

have some 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.

MySQL Magazine - Winter Issue released

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

Re: Red Hat EL and Datbase Setup

vity contained 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]

Re: automation question

ng 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 w

Re: automation question

> 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 > >

automation question

o put some 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 htt

Re: best practice MySQl backup onto tape

ter than a traditional dump/restore 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 l

Re: SQL analysis tool - open source?

.com/[EMAIL 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]

Re: Replication Falls Out Of Sync With LOAD DATA

a LOT. It's so 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? Ke

Re: Replication Falls Out Of Sync With LOAD DATA

of that could cause this is that we are inserting some data on the master (updates,inserts,deletes) using LOAD DATA INFILE. Does this cause a problem for replication? Thanks, Michael -- Keith Murphy editor: MySQL Magazine http://www.mysqlzine.net -- MySQL General Mailing List For

Re: preferred way to backup a 20GB MySQL database

mysql.com/[EMAIL PROTECTED] -- Keith Murphy editor: MySQL Magazine http://www.mysqlzine.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Spfile in Mysql......

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 myself

Re: mysql replication....

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 attribute/pa

Re: Replication vs. mysql-table-sync

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. keith

Re: innodb rollback question

erable failure. - 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 tabl

Re: Problem with master/slave replication

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 server

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 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. Th

Re: Mysql and filesystems question

file 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

Re: Mysql and filesystems question

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 wan

MySQL Magazine "Call for articles"

November the 9th. That gives you almost two weeks to get back to me about that great idea you have in your head. Articles will be due to be completed by December the 1st. If you aren't sure about an idea send me an email. Hope to hear from you soon! Keith Murphy Editor-Mysql Mag

Re: open_files_limit problem.

- 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 Parkway, 2nd Floor Durham, North Carolina 27713 blog: http://blog.paragon-cs.com (o) 919-433-0786 (c) 850-637-3877

Re: how to restore mysql database after Crash

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

Re: mysql user password funkyness

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"

mysql user password funkyness

---+ There are other privileges for the appropriate databases but they really aren't relevant. 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

MySQL Magazine Issue Two released

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

Re: make a slave db a master db

ster db, so what are the steps that i 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

Re: run out of memory

, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- 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 Mer

Re: run out of memory

chas trying to use lots of memory in 64-bit systems? Thanks Baron -- 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 Parkway, 2nd Floor Durh

Re: Enterprise Wide Deployment

e.com/Enterprise-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 Databa

Re: run out of memory

startup successfully. 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 Adm

Re: innodb to be removed? and...

find any trace in the net yet) and what 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-637-3877

Re: performance of extended insert vs. load data

of? FWIW these are 95% innodb (5% 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

speeding imports

hanks, Keith -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 (o) 919-433-0786 (c) 850-637-3877

Next MySQL Magazine --call for articles

. 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

mysqldump/restore

take the time to sit there and hit the up-arrow to retrieve the command and then type in the new 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

Re: off-topic unsubscribe concern

ists.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 (o) 919-433-0786 (c) 850-637-3877

Re: user backup tool

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" Sent: Wednesday, June 27, 2007 4:11:54 PM (GMT-

user backup tool

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

Re: toutrial needed

> Hertford College > Dep. of Engineering Science > Oxford -- 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 Parkway, 2nd Floor Durham, North Carolina 27713 (o) 919-433-0786 (c) 850-637-3877

Re: acquire mysql knowledge in short time

ist 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 (o) 919-433-0786 (c) 850-637-3877

determining if tables are being used

-- Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 (o) 919-433-0786 (c) 850-637-3877

Re: error after system setup/replication

al Message - From: "Juan Eduardo Moreno" <[EMAIL PROTECTED]> To: "Keith Murphy" <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Tuesday, June 5, 2007 4:24:22 PM (GMT-0500) America/New_York Subject: Re: error after system setup/replication Keith, When you

error after system setup/replication

This: 070605 15:07:27 InnoDB: Error: page 170144 log sequence number 71 2823728422 InnoDB: is in the future! Current system log sequence number 71 452597657. InnoDB: Your database may be corrupt. 070605 15:07:28 InnoDB: Error: page 61253 log sequence number 71 910331446 InnoDB: is in the futu

MySQL Magazine - Issue 1 available NOW!!!!

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

SAN backend for DB's

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 al

Re: Integrity on large sites

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 com

Re: Integrity on large sites

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 ol

Re: time taken by mysqldump

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

Re: How to limit usage of mysql server's memory/cpu for each databases ?

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 fo

Re: Deleted Root Account

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 complet

Re: Enforcing Data Format

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 le

Re: Summer issue - MySQL e-zine

. Otherwise, if you create a logo in some type of graphics format (png would be appreciated though) I can bring it into my layout work. If you have interest let me know and I will email you a pdf of the cover. thanks, Keith B. Keith Murphy wrote: Everyone, I have received quite a bit of

Summer issue - MySQL e-zine

some 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.

Re: FW: MySQL patches from Google

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

MySQL e-zine

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