Re: Lost connection to MySQL server - need help.
We had a similar issue a bit back - and although it sounds similar - based on your followups it probably isnt, but will just toss this out there anyhows. We were experiencing connection timeouts when load would ramp up. Doing some digging we learned that our firewall between the servers bandwidth would get consumed by a large wordpress load - and this in essence backed up the rest of the requests until they timed out. We fixed that load issue which reduced the data passing through and have expereinced a significant performance boost in our app let alone reduction of these timeout issues On Sat, Oct 12, 2013 at 12:56 PM, Reindl Harald wrote: > > > Am 12.10.2013 19:45, schrieb Jørn Dahl-Stamnes: > > On Saturday 12 October 2013 17:36, Reindl Harald wrote: > >> so someone did "optimize table" on a large table > >> you do yourself not a favour restarting the server in such a moment > > > > 7 hours before the server was shut down, we did a alter table to add a > primary > > key to a table that is read-only from the web application. > > which means the table is most likely completly copied > in a temp file and depending on the table size this > takes time - you killed the alter table i guess > >
Re: Best Practice: Timezones and web development
Wanted to thank everyone for the insights for some of this date/time issues! Pretty much what I was looking at, just wanted a little confirmation! I will also need to research that PHP function - Thanks - Chris On 3/6/07, Marcus Bointon <[EMAIL PROTECTED]> wrote: On 6 Mar 2007, at 17:12, David T. Ashley wrote: > Best practice is that all times maintained in a database (or > anywhere on the > server) are UTC, and are only converted to local timezone and/or > adjusted to > daylight savings time as required to display data for a specific user. Exactly right. > Now, as far as the best way to implement the two paragraphs above > (especially with DST), I have not a clue. I do this using the date extension that was updated in PHP 5.1. I store the string representation of the time zone, for example 'Europe/ London', and set that as the time environment whenever a session is started using: http://www.php.net/manual/en/function.date-default- timezone-set.php After that it all just magically works - whenever you call date() and friends, it's all corrected for the time zone. A slightly harder question is how to get the user's time zone in the first place. You can take a wild guess according to their IP, but it could well be wrong. Next you could use Javascript to find out the local time and get an offset, but then you have no way of getting DST info, and it doesn't tell you where they really are. Finally, you can just ask - I've made the time zone a user preference, and most systems I've seen do the same. Marcus -- Marcus Bointon Synchromedia Limited: Creators of http://www.smartmessages.net/ [EMAIL PROTECTED] | http://www.synchromedia.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[X-POST] PHP script to make sure MySQL is up?
On 3/1/07, Brian Dunning <[EMAIL PROTECTED]> wrote: Is there such a thing as a PHP script that I can put on a cron job to run every minute and make a test query, and upon failure, restart the service and maybe send an email to Rackspace support? I don't know how you'd check that the query was refused due to too many can't php report back what the error message is when it makes a conenction? test for the error, and go from there connections, and I also don't know how PHP would restart the MySQL service. you can give php permission to run a shell script that kicks off a service restart Thanks... :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Best Practice: Timezones and web development
Does anyone have any resources, guides, insight into the best practice for storing date/time information when developing a custom web app? I am mainly concerned with how the TZ should be stored? Should it go in as UTC and the code accounts for the user TZ? How does one handle tracking the users Daylight Savings etc Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: load sharing
On 2/26/07, Chris W <[EMAIL PROTECTED]> wrote: Can someone here give some insight and suggest other options I could look into? you could replicate all the data between web/application servers, and use the local store as a read-only database, and push all your updates to a central update 'master' server. You could also play with multiple-master replication. -- Chris W KE5GIX "Protect your digital freedom and privacy, eliminate DRM, learn more at http://www.defectivebydesign.org/what_is_drm"; Gift Giving Made Easy Get the gifts you want & give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Duplicating contents of DB within same DB with different prefix
On 2/22/07, Istvan Hubay Cebrian <[EMAIL PROTECTED]> wrote: Hi everyone, Say I have a DB named... well... "database1", this db has the following tables: What I want to do is copy each of the tables (exactly as they are, including primary keys, data, etc) but at the same time change the prefix to something else (ie: eng_) so that I would end up with: Anyway of accomplishing this? Ideally without having to state each of the tables names. And also that this would work so that you could only duplicate tables that have a certain prefix, so: duplicate only tables that start with "pt_" and change prefix to "es_" for example. a suggestion - could you replicate to another server and not worry about the prefix? or is having a different prefix a requirement (as opposed to a separate server or even database) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
multiple nistances at boot with mysqld_multi or other
I am trying to get a few instances of mysql running at boot time - and I have come across the command mysqld_multi. Seems to have a lot of documentation about kicking those off via command line - but not much on setting it up to start at boot. anyone have any insight into this? Either using mysqld_multi or a different startup script? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Saving Image in Database [again]
Starting to build a new schema, and one of the items is image storage In the past I have always used filesystem storage. Was wondering if I could get a conversation started on the pros/cons of database storage verse filesystem Thanks! -- -- please respond to the list .. if you need to contact me direct cgmckeever is the account prupref.com is the domain http://www.prupref.com";>Simply Chicago Real Estate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Persistent Corruption [UPDATE]
thanks for everyone help/suggestions -- I wound up swapping the media, and what was corrupt prior, seems to be all nice and happy now -- so - as suggested, looks to be that the drive was starting to fault On 7/31/05, Chris McKeever <[EMAIL PROTECTED]> wrote: > Thanks for all the help - I tried the dump as suggested, and it still > corrupted...waiting on the new drive to come and then I will try > replacing that .. I hope that I dont have to move to a new kernel!! > > > > On 7/29/05, Terence <[EMAIL PROTECTED]> wrote: > > Also check your kernel version. We had the same problems running on the > > old RH 7.3 kernel (2.4.17 was it?) After upgrading to RH9 it was fine. > > > > Chris McKeever wrote: > > > MySQL 4.0.16 > > > > > > I am having this annoying persistent corruption issue, and am > > > wondering if anyone has any suggestions. I have two tables that > > > refuse to stay clean. After a myisamchk (below) they show corruption. > > > I run a myisamchk -r, they get fixed, and the next day, they are once > > > again corrupt. > > > > > > Finally, I did a mysqldump, dropped the tables, imported the data from > > > the dump, and the next day - corrupt. > > > > > > I am at a loss, I thought the brute force method should clean it. > > > > > > I dont think it is the applicaiton itself, since there are an > > > identical 24 tables (alphabet) that do not have this issue. > > > > > > Any help would be appreciated - Chris > > > > > > Checking MyISAM file: EmailMessage_c.MYI > > > Data records: 79196 Deleted blocks: 22 > > > myisamchk: warning: 1 clients is using or hasn't closed the table properly > > > - check file-size > > > - check key delete-chain > > > - check record delete-chain > > > - check index reference > > > - check data record references index: 1 > > > - check record links > > > myisamchk: error: Record-count is not ok; is 79197Should be: 79196 > > > myisamchk: warning: Found 457872 deleted space. Should be 459588 > > > myisamchk: warning: Found 79507 partsShould be: > > > 79506 parts > > > MyISAM-table 'EmailMessage_c.MYI' is corrupted > > > Fix it using switch "-r" or "-o" > > > > > > > > > > > > Checking MyISAM file: EmailMessage_j.MYI > > > Data records: 39907 Deleted blocks: 91 > > > myisamchk: warning: 1 clients is using or hasn't closed the table properly > > > - check file-size > > > - check key delete-chain > > > - check record delete-chain > > > - check index reference > > > - check data record references index: 1 > > > - check record links > > > myisamchk: error: Record-count is not ok; is 39909Should be: 39907 > > > myisamchk: warning: Found 719032 deleted space. Should be 742328 > > > myisamchk: warning: Found 89 deleted blocks Should be: 91 > > > myisamchk: warning: Found 40195 partsShould be: > > > 40193 parts > > > MyISAM-table 'EmailMessage_j.MYI' is corrupted > > > Fix it using switch "-r" or "-o" > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > -- > please respond to the list .. if you need to contact me direct > cgmckeever is the account > prupref.com is the domain > > http://www.prupref.com";>Simply Chicago Real Estate > -- -- please respond to the list .. if you need to contact me direct cgmckeever is the account prupref.com is the domain http://www.prupref.com";>Simply Chicago Real Estate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Persistent Corruption
Thanks for all the help - I tried the dump as suggested, and it still corrupted...waiting on the new drive to come and then I will try replacing that .. I hope that I dont have to move to a new kernel!! On 7/29/05, Terence <[EMAIL PROTECTED]> wrote: > Also check your kernel version. We had the same problems running on the > old RH 7.3 kernel (2.4.17 was it?) After upgrading to RH9 it was fine. > > Chris McKeever wrote: > > MySQL 4.0.16 > > > > I am having this annoying persistent corruption issue, and am > > wondering if anyone has any suggestions. I have two tables that > > refuse to stay clean. After a myisamchk (below) they show corruption. > > I run a myisamchk -r, they get fixed, and the next day, they are once > > again corrupt. > > > > Finally, I did a mysqldump, dropped the tables, imported the data from > > the dump, and the next day - corrupt. > > > > I am at a loss, I thought the brute force method should clean it. > > > > I dont think it is the applicaiton itself, since there are an > > identical 24 tables (alphabet) that do not have this issue. > > > > Any help would be appreciated - Chris > > > > Checking MyISAM file: EmailMessage_c.MYI > > Data records: 79196 Deleted blocks: 22 > > myisamchk: warning: 1 clients is using or hasn't closed the table properly > > - check file-size > > - check key delete-chain > > - check record delete-chain > > - check index reference > > - check data record references index: 1 > > - check record links > > myisamchk: error: Record-count is not ok; is 79197Should be: 79196 > > myisamchk: warning: Found 457872 deleted space. Should be 459588 > > myisamchk: warning: Found 79507 partsShould be: 79506 > > parts > > MyISAM-table 'EmailMessage_c.MYI' is corrupted > > Fix it using switch "-r" or "-o" > > > > > > > > Checking MyISAM file: EmailMessage_j.MYI > > Data records: 39907 Deleted blocks: 91 > > myisamchk: warning: 1 clients is using or hasn't closed the table properly > > - check file-size > > - check key delete-chain > > - check record delete-chain > > - check index reference > > - check data record references index: 1 > > - check record links > > myisamchk: error: Record-count is not ok; is 39909Should be: 39907 > > myisamchk: warning: Found 719032 deleted space. Should be 742328 > > myisamchk: warning: Found 89 deleted blocks Should be: 91 > > myisamchk: warning: Found 40195 partsShould be: 40193 > > parts > > MyISAM-table 'EmailMessage_j.MYI' is corrupted > > Fix it using switch "-r" or "-o" > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- -- please respond to the list .. if you need to contact me direct cgmckeever is the account prupref.com is the domain http://www.prupref.com";>Simply Chicago Real Estate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Persistent Corruption
On 7/28/05, Dan Tappin <[EMAIL PROTECTED]> wrote: > I was running into this all the time. > > I actually had myisamchk running on a regular basis (live) via cron > which I think was actually causing the corruption. > > By chance are you running myisamchk on the live tables?? I was - but not after all this crap started, but I still get those errors even after a rebuild I ran the > REPAIR TABLE... on each table, shut down mysql THEN ran myisamchk > again and my 127 errors seem o be gone (so far). > I think I am going to put in a new harddrive and hope for tbe best > What OS are you running BTW? > RedHat 7.3 > Dan T > > On Jul 28, 2005, at 8:45 AM, Chris McKeever wrote: > > > MySQL 4.0.16 > > > > I am having this annoying persistent corruption issue, and am > > wondering if anyone has any suggestions. I have two tables that > > refuse to stay clean. After a myisamchk (below) they show corruption. > > I run a myisamchk -r, they get fixed, and the next day, they are once > > again corrupt. > > > > Finally, I did a mysqldump, dropped the tables, imported the data from > > the dump, and the next day - corrupt. > > > > I am at a loss, I thought the brute force method should clean it. > > > > I dont think it is the applicaiton itself, since there are an > > identical 24 tables (alphabet) that do not have this issue. > > > > Any help would be appreciated - Chris > > > > Checking MyISAM file: EmailMessage_c.MYI > > Data records: 79196 Deleted blocks: 22 > > myisamchk: warning: 1 clients is using or hasn't closed the table > > properly > > - check file-size > > - check key delete-chain > > - check record delete-chain > > - check index reference > > - check data record references index: 1 > > - check record links > > myisamchk: error: Record-count is not ok; is 79197Should > > be: 79196 > > myisamchk: warning: Found 457872 deleted space. Should be 459588 > > myisamchk: warning: Found 79507 partsShould > > be: 79506 parts > > MyISAM-table 'EmailMessage_c.MYI' is corrupted > > Fix it using switch "-r" or "-o" > > > > > > > > Checking MyISAM file: EmailMessage_j.MYI > > Data records: 39907 Deleted blocks: 91 > > myisamchk: warning: 1 clients is using or hasn't closed the table > > properly > > - check file-size > > - check key delete-chain > > - check record delete-chain > > - check index reference > > - check data record references index: 1 > > - check record links > > myisamchk: error: Record-count is not ok; is 39909Should > > be: 39907 > > myisamchk: warning: Found 719032 deleted space. Should be 742328 > > myisamchk: warning: Found 89 deleted blocks Should > > be: 91 > > myisamchk: warning: Found 40195 partsShould > > be: 40193 parts > > MyISAM-table 'EmailMessage_j.MYI' is corrupted > > Fix it using switch "-r" or "-o" > > > > > > -- > > -- > > please respond to the list .. if you need to contact me direct > > cgmckeever is the account > > prupref.com is the domain > > > > http://www.prupref.com";>Simply Chicago Real Estate > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- -- please respond to the list .. if you need to contact me direct cgmckeever is the account prupref.com is the domain http://www.prupref.com";>Simply Chicago Real Estate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Persistent Corruption
On 7/28/05, Dobromir Velev <[EMAIL PROTECTED]> wrote: > Hi, > Isn't there some information in the MySQL error log about what might have > caused the corruption. Normally this would happen when disk or memory problem > occurs. > thanks for the reply - from the .err file: 050722 5:20:24 read_next: Got error 127 when reading table ./atmail/EmailDatabase_c 050722 5:23:28 read_next: Got error 127 when reading table ./atmail/EmailDatabase_c 050722 5:23:29 read_next: Got error 127 when reading table ./atmail/EmailDatabase_c however, that was days ago, and since i ran the repairs, as well as the dump -> reinsert > > On Thursday 28 July 2005 17:45, Chris McKeever wrote: > > MySQL 4.0.16 > > > > I am having this annoying persistent corruption issue, and am > > wondering if anyone has any suggestions. I have two tables that > > refuse to stay clean. After a myisamchk (below) they show corruption. > > I run a myisamchk -r, they get fixed, and the next day, they are once > > again corrupt. > > > > Finally, I did a mysqldump, dropped the tables, imported the data from > > the dump, and the next day - corrupt. > > > > I am at a loss, I thought the brute force method should clean it. > > > > I dont think it is the applicaiton itself, since there are an > > identical 24 tables (alphabet) that do not have this issue. > > > > Any help would be appreciated - Chris > > > > Checking MyISAM file: EmailMessage_c.MYI > > Data records: 79196 Deleted blocks: 22 > > myisamchk: warning: 1 clients is using or hasn't closed the table properly > > - check file-size > > - check key delete-chain > > - check record delete-chain > > - check index reference > > - check data record references index: 1 > > - check record links > > myisamchk: error: Record-count is not ok; is 79197Should be: 79196 > > myisamchk: warning: Found 457872 deleted space. Should be 459588 > > myisamchk: warning: Found 79507 partsShould be: 79506 > > parts MyISAM-table 'EmailMessage_c.MYI' is corrupted > > Fix it using switch "-r" or "-o" > > > > > > > > Checking MyISAM file: EmailMessage_j.MYI > > Data records: 39907 Deleted blocks: 91 > > myisamchk: warning: 1 clients is using or hasn't closed the table properly > > - check file-size > > - check key delete-chain > > - check record delete-chain > > - check index reference > > - check data record references index: 1 > > - check record links > > myisamchk: error: Record-count is not ok; is 39909Should be: 39907 > > myisamchk: warning: Found 719032 deleted space. Should be 742328 > > myisamchk: warning: Found 89 deleted blocks Should be: 91 > > myisamchk: warning: Found 40195 partsShould be: 40193 > > parts MyISAM-table 'EmailMessage_j.MYI' is corrupted > > Fix it using switch "-r" or "-o" > > > > > > -- > > -- > > please respond to the list .. if you need to contact me direct > > cgmckeever is the account > > prupref.com is the domain > > > > http://www.prupref.com";>Simply Chicago Real Estate > > -- > Dobromir Velev > [EMAIL PROTECTED] > http://www.websitepulse.com/ > -- -- please respond to the list .. if you need to contact me direct cgmckeever is the account prupref.com is the domain http://www.prupref.com";>Simply Chicago Real Estate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Persistent Corruption
MySQL 4.0.16 I am having this annoying persistent corruption issue, and am wondering if anyone has any suggestions. I have two tables that refuse to stay clean. After a myisamchk (below) they show corruption. I run a myisamchk -r, they get fixed, and the next day, they are once again corrupt. Finally, I did a mysqldump, dropped the tables, imported the data from the dump, and the next day - corrupt. I am at a loss, I thought the brute force method should clean it. I dont think it is the applicaiton itself, since there are an identical 24 tables (alphabet) that do not have this issue. Any help would be appreciated - Chris Checking MyISAM file: EmailMessage_c.MYI Data records: 79196 Deleted blocks: 22 myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check record links myisamchk: error: Record-count is not ok; is 79197Should be: 79196 myisamchk: warning: Found 457872 deleted space. Should be 459588 myisamchk: warning: Found 79507 partsShould be: 79506 parts MyISAM-table 'EmailMessage_c.MYI' is corrupted Fix it using switch "-r" or "-o" Checking MyISAM file: EmailMessage_j.MYI Data records: 39907 Deleted blocks: 91 myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check record links myisamchk: error: Record-count is not ok; is 39909Should be: 39907 myisamchk: warning: Found 719032 deleted space. Should be 742328 myisamchk: warning: Found 89 deleted blocks Should be: 91 myisamchk: warning: Found 40195 partsShould be: 40193 parts MyISAM-table 'EmailMessage_j.MYI' is corrupted Fix it using switch "-r" or "-o" -- -- please respond to the list .. if you need to contact me direct cgmckeever is the account prupref.com is the domain http://www.prupref.com";>Simply Chicago Real Estate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using Soundex
On Mon, 23 Aug 2004 00:25:36 -0500, Debbie Woods
<[EMAIL PROTECTED]> wrote:
> I am building a search feature with Cold Fusion and need to have similar
> string matches included in the search results. I have a search form field
> called hsname. I am trying to use the SOUNDEX function in my query like
> this:
> SELECT *
> FROM accounts
> WHERE SOUNDEX(hsname) = SOUNDEX('#form.hsname#')
>
for CF - make sure to have #form.hsname#
> If I enter Eisen into the search field, it should return one record if
> SOUNDEX is working right. However, it doesn't return any records. If I hard
> code Eisen into the search query like this (instead of the variable):
>
> WHERE SOUNDEX(hsname) = SOUNDEX('Eisen')
>
> SOUNDEX works as it should. Is there a problem with my SQL syntax? Or does
> it not work with variables?
>
> Thanks
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: A new Machine
On Sun, 22 Aug 2004 16:40:24 -0700, Mike Wexler <[EMAIL PROTECTED]> wrote: > Chris McKeever wrote: > > >On Sat, 21 Aug 2004 10:18:06 -0700, Info <[EMAIL PROTECTED]> wrote: > > > > > >>After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the > >>piggy bank and build a new linux mysql server. Here's my problem: I have, at > >>present, two rather large databases. (A: 4Million records in one table, 15 > >>Million in another; B: 1.5Million and 5Million) The databases are relatively > >>static. That is, they they are updated by batch processes twice per year or so. > >>They are realatively well normalized. (I'd say well, but that would be bragging. > >>:) > >> > >>The business is a "harvest type" of operation, I ignore them for months then beat > >>them to death for 120 days. > >> > >>I'm not rich, but what hardware and distro do you experts suggest? (My current > >>Win2K server is a dual p3-650, 1gb with the databases on 2 36gb U160 10K drives. ) > >> I've got no problem moving the drives out of that system (especially since I > >>just bought a new one...)-- (I'd put my redhat 8 on it this afternoon, except > >>it also runs my exchange server and that's a different migration...) > >> > >> > >> > > > >I would say it has more to do with what you are doing with the > >database (query request wise) than the size --- > > > >I'd up the memory to 2GB and Just go with a single PIV 2.8 > >I'd suggest not buying a 'server' from a company, becuase they are > >typically just really heavy desktops... > >as for drives, I would raid 5 with at least 100GB - migrate towards > >SATA if you can > > > > > RAID 5 is the wrong answer. If reliability is a big deal do mirroring. > Otherwise get as much memory as you can afford and use any money left > over to get the fastest disk drives you can afford. If you have multiple > disks, spread things between different drives. OS on one, swap on > another, indices on another, data on another, etc. > > if you have all those drives, how are you going to mirror? you can always set up a replication server for data mirroring realtime or do the hot backup nightly and tar the files...RAID5 will get you back through a drive failure - > > >make sure that what ever apps you have running will be easily migrated > >to making the calls against MySQL - some of the SQL is different (ie > >LIMIT instead of TOP, no stored procedures, different foreign key > >relationships, etc..) > > > > > > > > > > > >>sign me... > >>Fed up at the Beach... > >>[EMAIL PROTECTED] > >> > >>-- > >>MySQL General Mailing List > >>For list archives: http://lists.mysql.com/mysql > >>To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > >> > >> > >> > >> > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: A new Machine
On Sat, 21 Aug 2004 10:18:06 -0700, Info <[EMAIL PROTECTED]> wrote: > After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the piggy > bank and build a new linux mysql server. Here's my problem: I have, at present, > two rather large databases. (A: 4Million records in one table, 15 Million in > another; B: 1.5Million and 5Million) The databases are relatively static. That is, > they they are updated by batch processes twice per year or so. They are realatively > well normalized. (I'd say well, but that would be bragging. :) > > The business is a "harvest type" of operation, I ignore them for months then beat > them to death for 120 days. > > I'm not rich, but what hardware and distro do you experts suggest? (My current > Win2K server is a dual p3-650, 1gb with the databases on 2 36gb U160 10K drives. ) > I've got no problem moving the drives out of that system (especially since I just > bought a new one...)-- (I'd put my redhat 8 on it this afternoon, except it also > runs my exchange server and that's a different migration...) > I would say it has more to do with what you are doing with the database (query request wise) than the size --- I'd up the memory to 2GB and Just go with a single PIV 2.8 I'd suggest not buying a 'server' from a company, becuase they are typically just really heavy desktops... as for drives, I would raid 5 with at least 100GB - migrate towards SATA if you can make sure that what ever apps you have running will be easily migrated to making the calls against MySQL - some of the SQL is different (ie LIMIT instead of TOP, no stored procedures, different foreign key relationships, etc..) > sign me... > Fed up at the Beach... > [EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: configuration questions - newbie getting up-to-speed
I also found out that mysqld --help provides a whole lot more of the information that I was looking for than just mysql --help! whoops > -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 11, 2003 5:15 PM > To: Chris McKeever; [EMAIL PROTECTED] > Subject: Re: configuration questions - newbie getting up-to-speed > > > At 17:04 -0500 6/11/03, Chris McKeever wrote: > >Sorry from the low-level posts, but I am trying to get my > grips around some > >simple set-up configuration. > > > >- What exactly does basedir do? It defauts to / which to me > means it is at > >the 'base' of the filesystem. Why/when would you need to > change it (since > >you would only be moving it up levels - or down depending > how you look at > >it). > > It's the base (root) directory of your MySQL installation. If it's > defaulting to / on your system, I'd guess that you have a system > that doesn't place all the MySQL-related files under a single > directory. > Another typical value is /usr/local/mysql, or C:\mysql on Windows. > > I wouldn't worry about changing it if you have no particular > reason to. > > > > >- What does server-specific options mean (as in placing the > my.cnf for > >server-specific)? Isnt mysql running on the server itself > and the global > >my.cnf handles that? Or is this for something in regards to multiple > >daemons running? > > Yes, multiple servers. You can run several servers on a given machine > (I have several dozen different ones on one of my systems), > and you need > to supply server-specific values for several of the options > to keep them > from interfering with each other. For example, the TCP/IP port they > listen to must be different for each server. > > > > >- Am I correct ot assume the MYSQL 4.0 default to using > innodb data files? > > Yes. See: > > http://www.mysql.com/doc/en/Nutshell_4.0_features.html > > > > >- Is there documentation (or the ability) to specifiy different data > >directories for different database systems. > > Huh? > > > > >I found a nice howto that is pretty low-level: > >http://astro.temple.edu/~kumar/MySQLRepPro/Installing_MySQL.htm > >which got me going with a few questions, but the couple > questions I can't > >figure out. > > > >Once again, if anyone can point to some other online howto's > and basic > >administration, that would be great > > > >Thanks > > > >Chris > > > -- > Paul DuBois, Senior Technical Writer > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > Are you MySQL certified? http://www.mysql.com/certification/ > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
configuration questions - newbie getting up-to-speed
Sorry from the low-level posts, but I am trying to get my grips around some simple set-up configuration. - What exactly does basedir do? It defauts to / which to me means it is at the 'base' of the filesystem. Why/when would you need to change it (since you would only be moving it up levels - or down depending how you look at it). - What does server-specific options mean (as in placing the my.cnf for server-specific)? Isnt mysql running on the server itself and the global my.cnf handles that? Or is this for something in regards to multiple daemons running? - Am I correct ot assume the MYSQL 4.0 default to using innodb data files? - Is there documentation (or the ability) to specifiy different data directories for different database systems. I found a nice howto that is pretty low-level: http://astro.temple.edu/~kumar/MySQLRepPro/Installing_MySQL.htm which got me going with a few questions, but the couple questions I can't figure out. Once again, if anyone can point to some other online howto's and basic administration, that would be great Thanks Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
my.cnf
I have been plowing through the mysql.com resources for something regarding the run-time configuration options as well as the my.cnf. In particular, I am trying to move the entire information store to a separate hard-drive. This line confuses me: ---> Note that this is the directory that was specified at configuration time, not the one specified with --datadir when mysqld starts up! It is from: http://www.mysql.com/doc/en/Option_files.html DATADIR is the MySQL data directory (typically `/usr/local/mysql/data' for a binary installation or `/usr/local/var' for a source installation). Note that this is the directory that was specified at configuration time, not the one specified with --datadir when mysqld starts up! (--datadir has no effect on where the server looks for option files, because it looks for them before it processes any command-line arguments.) If anyone can explain that line, possibly point me to a good reference to the my.cnf and runtime options, I would be most appreciative. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
