JD™ Posted March 5, 2015 Report Share Posted March 5, 2015 Do you want/need both forums running once duplicated, or is one a backup, or is it a migration of sorts? Quote Link to comment Share on other sites More sharing options...
Greetings Posted March 5, 2015 Report Share Posted March 5, 2015 Need both forums running. This I can do, it's about setting the duplicate to run off the copied database if I'm correct. Just can't figure out how to copy such a massive database. Quote Link to comment Share on other sites More sharing options...
Muel Posted March 5, 2015 Author Report Share Posted March 5, 2015 (edited) You can't have any downtime at all? That will make things tricky... Look into replication, just came out in MySQL 5.6. Adds the ability to replicate a DB while it's still running. (Assuming you're using MySQL). Edited March 5, 2015 by Muel Quote Link to comment Share on other sites More sharing options...
Greetings Posted March 5, 2015 Report Share Posted March 5, 2015 (edited) You can't have any downtime at all? That will make things tricky... Look into replication, just came out in MySQL 5.6. Adds the ability to replicate a DB while it's still running. (Assuming you're using MySQL). Downtime isn't a huge issue but would it actually happen? The forum which is online should continue running as it is since all I'm doing is copying the database, no? I need a forum copy with users and posts to test integration into Wordpress. edit: yeah, using MySQL, not sure which version. Will check the replicate function, cheers Edited March 5, 2015 by Greetings Quote Link to comment Share on other sites More sharing options...
Muel Posted March 5, 2015 Author Report Share Posted March 5, 2015 Taking a mysqldump (which is what phpmyadmin uses to export db) usually causes downtime and is bound to for a 500mb db. Plus if you schedule down time you can take a dump of the db and be sure no data has changed until you bring your site back up. Quote Link to comment Share on other sites More sharing options...
Greetings Posted March 5, 2015 Report Share Posted March 5, 2015 Oh I see. Wasn't aware taking a dump affected the site. Is there any way I can upload the DB via FTP or SSH? phpMyAdmin will timeout and I think the size limit is 130meg. Quote Link to comment Share on other sites More sharing options...
forteh Posted March 6, 2015 Report Share Posted March 6, 2015 (edited) I just accidentally asus p67 sabretooth and 2500k oops edit: 130 quid for both, I can recover 90+ by selling my old cpu, board and some spare ram to a mate at work to play around with solidworks at home so all in all not a hugely expensive upgrade Edited March 6, 2015 by forteh Quote Link to comment Share on other sites More sharing options...
forteh Posted March 11, 2015 Report Share Posted March 11, 2015 (edited) Got the 2500k set up, currently sat at a 4.5ghz overclock, peaked at 66°C after 15 minutes of prime95, cpu fan never got more than 60% and I don't have the 2x140mm fans feeding cold air to it Voltage is only 1.3v so it looks to be a good cpu for overclocking! Run a quick benchmark in arma3 on high settings and fps has bumped up by about 20% so far, something started smelling hot and then I realised that the gpu is passively cooled at the moment (the 2x140mm fans also cool the gpu) and was sitting at 85° Very, very pleased so far, cost of the upgrade (including a new 550w gold antec psu) is about 30 quid Edited March 11, 2015 by forteh Quote Link to comment Share on other sites More sharing options...
MadManMike Posted March 12, 2015 Report Share Posted March 12, 2015 (edited) Processors are a minefield. Browsing for a new / second hand i5 or i7, prices vary from £70 to £300. I'm looking at the lower end of the scale, but I don't want something crap - It needs to outperform a Phenom II 965 Quad Core Black Edition. Any suggestions / assistance appreciated... EDIT: Up to £500+ actually for some i7's... mother of god! Edited March 12, 2015 by MadManMike Quote Link to comment Share on other sites More sharing options...
forteh Posted March 12, 2015 Report Share Posted March 12, 2015 Do you want to overclock? What motherboard are you using? If you're really on a tight budget an i5 750 (first gen core i5) will clock up to 4ghz with a suitable motherboard/psu and can be picked up for 35 quid, I just got an i5 2500k (second gen core i5, the K denotes the ability to overclock it) because it came up at a very good price and overclocks exceptionally well. The 2500k chips are going for around 80-90 quid at the moment on ebay. i5 6xx series is first gen dual core (clarkdale) i5 7xx series is first gen quad core (lynnfield) i7 8xx series is first gen quad core with hyperthreading (lynnfield) i7 9xx series is first gen quad core with hyperthreading (bloomfield) 90% of the first gen have locked multiplier but can still be overclocked because the baseclock isn't linked to other busses in the system. i5 2xxx series is second gen quad core (sandybridge) i7 2xxx series is second gen quad core with hyperthreading (sandybridge) i5 3xxx series is third gen quad core (ivybridge) i7 3xxx series is third gen quad core with hyperthreading (ivybridge) i5 4xxx series is fourth gen quad core (haswell) i7 4xxx series is fourth gen quad core with hyperthreading (haswell) Typically the difference between i5 and i7 is 100mhz or so faster base clock speed and hyperthreading, overclocking will make up the speed difference and hyperthreading is only usefull if your software uses a lot of multithreading (encoding, rendering etc.). The sandybridge processes have a soldered heat spreader compared to a conventional thermal paste on the ivybridge/haswell, this resulted in the sandybridge processors running cooler and able to withstand more power when overclocking resulting in higher core speeds attainable. If you buy a processor without a K suffix you will only have limited overclocking ability (about 80-100mhz extra if you push it). What do you want it to do? Quote Link to comment Share on other sites More sharing options...
MadManMike Posted March 12, 2015 Report Share Posted March 12, 2015 I need to buy a motherboard too, so if you can recommend a package that would be even better. Not interested in overclocking. It'll be used mainly for photo editing, video editing and also some games - GTA 5 once it's released. I don't want a huge spec gaming machine, just something with a bit more grunt than my current setup. As with all things, I'd like as cheap as possible, without being useless Quote Link to comment Share on other sites More sharing options...
forteh Posted March 12, 2015 Report Share Posted March 12, 2015 (edited) I bet GTA5 is gonna need some heft behind it. What's your budget? Given that you're not interested in overclocking you would be best going for the fastest non K processor, an i5 3570 has a base speed of 3.4ghz and will automatically turbo boost up to 3.6ghz when all 4 cores are loaded and up to 3.7 for 3 cores and 3.8 for 1-2 cores loaded. I don't know what price they command second hand but worth watching. http://www.ebay.co.uk/itm/Intel-Core-i5-3570-Processor-3-4GHZ-/231501065203?pt=LH_DefaultDomain_3&hash=item35e689ebf3 Referencing this for the processors What ram do you currently have? What size case do you have? You will need a socket1155 motherboard to run a sandybridge/ivybridge (like the 3570 above), as you're not looking to overclock an H61 chipset board will be more than sufficient. That said if you can pick up a P67 or Z77 board it will allow you to upgrade to a K chip and overclock at a later date if you should so desire. http://www.ebay.co.uk/itm/ASRock-H61M-DGS-Motherboard-Socket-1155-mATX-Intel-Core-i7-i5-i3-DDR3-/181686447751?pt=LH_DefaultDomain_3&hash=item2a4d5b2e87 Edited March 12, 2015 by forteh Quote Link to comment Share on other sites More sharing options...
MadManMike Posted March 12, 2015 Report Share Posted March 12, 2015 I don't know to be honest, my ideal would be a second hand processor and motherboard around the £150 mark. I'll be selling my motherboard and processor as a package so hopefully I'll get £50-60 for that, which is funding my second hand graphics card I've sourced Quote Link to comment Share on other sites More sharing options...
forteh Posted March 12, 2015 Report Share Posted March 12, 2015 (edited) There you go! overclockable, decent motherboard in budget http://www.ebay.co.uk/itm/Intel-i5-2500K-3-3GHz-6MB-Cache-LGA-1155-CPU-Asus-P8Z68-V-LE-Motherboard-/221712913981?pt=LH_DefaultDomain_3&hash=item339f1e963d edit: don't forget the K chiops command a premium second hand so will hold their value, don't worry about buying old kit, intel haven't made massive increases in performance between 2nd and 4th gen processors. Edited March 12, 2015 by forteh Quote Link to comment Share on other sites More sharing options...
MadManMike Posted March 12, 2015 Report Share Posted March 12, 2015 That looks good... It's a 29 days listing so hopefully it'll still be on there when my funds are available (Which is in roughly 29 days!) At least I know what I should be looking for now, thanks for the explanation on types Quote Link to comment Share on other sites More sharing options...
forteh Posted March 12, 2015 Report Share Posted March 12, 2015 (edited) I bet it won't be Payday Rainbird loan for 150 quid? Edited March 12, 2015 by forteh 1 Quote Link to comment Share on other sites More sharing options...
MadManMike Posted March 12, 2015 Report Share Posted March 12, 2015 Just saw one of your earlier edits, I've added that processor to my watch list - hopefully it'll go cheap Quote Link to comment Share on other sites More sharing options...
forteh Posted March 12, 2015 Report Share Posted March 12, 2015 (edited) Aye, sorry for the edits Ideal case go for a K chip and either a P or Z series chipset motherboard, an H chipset board won't overclock a K chip anywhere near as well and you will be crippling the cpus potential. The H chipset is intended for home users and HTPC type set ups where overclocking and high power stability aren't required; the H chipset can make use of an integrated GPU on the processor. The P chipset is intended for performance use and generally has a more robust power system and BIOS in order to support overclocking; the P chipset cannot make use of an integrated GPU on the processor. The Z chipset combines the features of the P chipset with the ability to use the integrated GPU. Generally the people overclocking the cpu would have a seperate GPU anyway so the additionaly functionality of the Z board is somewhat pointless imho. The above applies to the socket1155 boards (2nd and 3rd gen core processors), I'm not sure if the same applies for the socket1150 boards (4th gen core processors). Personally I would look towards a K processor so you can overclock in the future, GTA is likely to be relatively CPU bound so the more horsepower you can get from the processor the more your GPU can work to deliver fps. Edited March 12, 2015 by forteh Quote Link to comment Share on other sites More sharing options...
MadManMike Posted March 12, 2015 Report Share Posted March 12, 2015 Very useful info, thanks I'll post up some links when I get closer to having available funds. Cheers, I appreciate the assistance - you can spend hours on Google and find out absolutely nothing of any use. Quote Link to comment Share on other sites More sharing options...
forteh Posted March 14, 2015 Report Share Posted March 14, 2015 (edited) This 2500k is incredible, currently stress testing at 5ghz, peak temperature in prime95 so far is 72°C, the temperature limit is 99°C so bags of thermal headroom I am right on intels safe max core voltage of 1.52v though, super happy with the results so far edit: 2 minutes later it BSODs, increased the PLL voltage to see if that stabilises it. Was running on the 1.8v standard, aparantly up to 1.9v may be required to stabilise the highest overclocks so I'm now testing it at 1.85v Edited March 14, 2015 by forteh Quote Link to comment Share on other sites More sharing options...
forteh Posted March 15, 2015 Report Share Posted March 15, 2015 (edited) That looks good... It's a 29 days listing so hopefully it'll still be on there when my funds are available (Which is in roughly 29 days!) At least I know what I should be looking for now, thanks for the explanation on types 221715381807 It's been relisted on eBay on the number above edit: relisted again with an even cheaper price! http://www.ebay.co.uk/itm/Intel-i5-2500K-3-3GHz-6MB-Cache-LGA-1155-CPU-Asus-P8Z68-V-LE-Motherboard/221716118395?_trksid=p2047675.c100011.m1850&_trkparms=aid%3D222007%26algo%3DSIC.MBE%26ao%3D1%26asc%3D20140107083358%26meid%3Db91dea0db87948c99268c6fde940df05%26pid%3D100011%26rk%3D1%26rkt%3D2%26sd%3D221715381807 Gotta drive to Aylesbury though :/ Edited March 15, 2015 by forteh Quote Link to comment Share on other sites More sharing options...
MadManMike Posted March 15, 2015 Report Share Posted March 15, 2015 221715381807 It's been relisted on eBay on the number above edit: relisted again with an even cheaper price! http://www.ebay.co.uk/itm/Intel-i5-2500K-3-3GHz-6MB-Cache-LGA-1155-CPU-Asus-P8Z68-V-LE-Motherboard/221716118395?_trksid=p2047675.c100011.m1850&_trkparms=aid%3D222007%26algo%3DSIC.MBE%26ao%3D1%26asc%3D20140107083358%26meid%3Db91dea0db87948c99268c6fde940df05%26pid%3D100011%26rk%3D1%26rkt%3D2%26sd%3D221715381807 Gotta drive to Aylesbury though :/ Bummer, that looks like a bargain - not 4 hours of driving bargain though Quote Link to comment Share on other sites More sharing options...
HippY Posted March 16, 2015 Report Share Posted March 16, 2015 anyone does/likes C programming here? As a preparation for competition I am doing a game with scrolling landscape and lives with an 64*64 LED array and PIC chip Anyone interested in the final product? still WIP Quote Link to comment Share on other sites More sharing options...
forteh Posted March 16, 2015 Report Share Posted March 16, 2015 I did a little c programming at uni 18 years ago, I hated it; my brain just isn't wired up right to program computers About the only coding I do is excel macros Quote Link to comment Share on other sites More sharing options...
HippY Posted March 16, 2015 Report Share Posted March 16, 2015 I did a little c programming at uni 18 years ago, I hated it; my brain just isn't wired up right to program computers About the only coding I do is excel macros It is embedded C, what I love about it, is that you are not creating a code for the sake of code, but first you design the circuit, then you use the code to make the circuit work in ways that would not be possible/would be extremely hard with just dumb devices I am okay with programming but my heart is at PCB design Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.