Re: [GIG] $500 For Site Speed Improvement
On Wed, Mar 28, 2012 at 2:56 PM, Rich Jones r...@gun.io wrote: Hey folks! This gig just popped up on our system, thought it could be some easy money for anybody out there who knows Ruby/Rails and how to optimize queries! http://gun.io/contracts/67/improve-site-speed-for-startup Normally I wouldn't even respond to something like this -- so sorry in advance -- I just couldn't resist; seeing that $500.00 is a joke for what they are asking. I mean sure, implement some page/frag/action caching and get the site to be faster but really I would guess that a lot of the reason their site is so slow is due to implicit coupling as as a result of bad design. I can't tell you how many time's I've seen Rails sites with the absolute worse performance due to the fact that for every object loaded N number of additional objects are loaded (N+1, N+N) otherwise know as, bad inheritance in the rails world. Everybody wants to build a site quickly, the ubiquitous just get it out the door.. we'll fix it later but later rarely comes when it should. It usually comes when the pain threshold is unbearable or some developer decided it was okay to store everything in the session and the dreaded marshal data too short error keeps popping up and exploding, Maybe, it's the reporting queries that happen to have no index (doubt it) or possibly the fact that Object has_and_belongs_to :every_single_child_object_childs_childs_child ? For $500.00 I would take a look at the site and decide how much it would cost to fix. For $5000.00 I might wanna fix it. Who know's maybe they'll get lucky and someone will actually take the job and slap on a band aid. I'd be really shocked, if anybody with that level of true talent would even respond. Good Luck ! Thanks! -- Rich Jones Director, Gun.io -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
rollback..
I run update on the database which by my mistake updated all rows. Is it possible somehow go back to previous state before the update? _ Have fun customizing MSN Messenger learn how here! http://www.msnmessenger-download.com/tracking/reach_customize -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Deleted all users from MYSQL. What to do now?
By mistake I deleted all users in MYSQL. So, how can I login to the mysql? Is it possible to add a user to my.cnf file? Thanks _ Grab our best dial-up Internet access offer: 6 months @$9.95/month. http://join.msn.com/?page=dept/dialup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ignor table in replication: replicate-wild-ignore-table
I want to stop replication for one table in the database. According to the mysql documentation: I need to add the parameter (replicate-wild-ignore-table ) to the my.cnf file. I have some question. #1 In what database I should made the change to my.cnf? Slave or Master? #2 Than I should restart the database. I use Linux. So I just need to restart mysqld? Thank you _ Check your PC for viruses with the FREE McAfee online computer scan. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot login as root to mysql
I had an account mike to mysql. But somehow I change the password. So now I have just one access to the system as root. Trying to login to mysql as root with password and without password no success. Root password is: 123456. What I'm doing wrong? I cannot connect to MYSQL as root. [EMAIL PROTECTED] init.d]# mysql -h localhost -u root -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) [EMAIL PROTECTED] init.d]# mysql -h localhost -u root ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) [EMAIL PROTECTED] init.d]# _ Its our best dial-up Internet access offer: 6 months @$9.95/month. Get it now! http://join.msn.com/?page=dept/dialup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]