MySQL for Hosting Providers - how do they manage ?

MySQL for Hosting Providers - how do they manage ?

Computing 95 percentile in MySQL

Computing 95 percentile in MySQL

A quick way to get memcached status

http://www.mysqlperformanceblog.com/2008/11/26/a-quick-way-to-get-memcached-status/

echo stats | nc 127.0.0.1 11211

watch "echo stats | nc 127.0.0.1 11211"

超簡單 very simple merb upload file

http://blog.vixiom.com/2007/06/29/merb-on-air-drag-and-drop-multiple-file-upload/
http://iceskysl.1sters.com/?action=show&id=368&page=1
http://www.mikeperham.com/2007/10/02/file-uploads-in-merb-versus-rails/
<br />class Attachment<br /> include DataMapper::Resource<br /><br /> property :id, Serial<br /> property :filename, String<br />end<br />
<br />class Upload < Application<br /><br /> # ...and remember, everything returned from an action<br /> # goes to the client...<br /> def index <br /> render<br /> end<br /><br /> def upload<br /> puts params.inspect<br /> #new user file object<br /> @upload = Attachment.new<br /> @upload.filename = params[:file][:filename]<br /><br /> # save<br /> if @upload.save<br /> FileUtils.mv params[:file][:tempfile].path, "#{Merb.root}/public/upload/#{params[:file][:filename]}"<br /> else <br /> false<br /> end<br /> end<br />end<br />
<br /><%= form :action => url(:controller => "upload", :action => "upload") do %><br /> <%= file_field :file, :label => "Filename" %><br /> <%= submit "Create" %><br /><% end =%><br />

幹 竟然這樣寫

<br /> if request.xhr?<br /> headers["Content-Type"] = "text/javascript" # render js<br /> js = if uis.auth?<br /> "alert('#{message}'); window.location.reload();"<br /> elsif uis.errors.size > 0<br /> "alert('#{message}'); YouHolder.PartnerUser.set_im('#{uis.account}', '#{uis.im_provider}');"<br /> else<br /> "alert('#{message}'); YouHolder.PartnerUser.confirm_im('#{uis.account}', '#{uis.im_provider}');"<br /> end<br /> render :text => js<br /> else<br /> flash[:notice] = message<br /> redirect_to :action => :authenticate<br /> end<br />

How to reset a lost mysql root password

http://www.simplehelp.net/2008/11/26/how-to-reset-a-lost-mysql-root-password/

upload file in rails

http://www.tutorialspoint.com/ruby-on-rails/rails-file-uploading.htm
http://manuals.rubyonrails.com/read/chapter/79
http://manuals.rubyonrails.com/read/chapter/78
http://manuals.rubyonrails.com/read/chapter/77
http://www.practicalecommerce.com/blogs/post/432-Multiple-Attachments-in-Rails
http://izumi.plan99.net/blog/index.php/2007/04/07/ruby-on-railss-handling-of-uploaded-files/

About the uploaded file object

While the uploaded file is a special beast,it is not difficult to use. The object
rails receives are processed by a CGI object. The object that CGI returns to Rails
isn’t actually a file object, but it’s close enough for our purposes.
Details from the CGI class documentation

... the value is not a string, but an IO object, either an IOString for small files,
or a Tempfile for larger ones.
This object also has the additional singleton methods:
local_path(): the path of the uploaded file on the local filesystem
original_filename(): the name of the file on the client computer 
content_type(): the content type of the file

<br />class UserController < ApplicationController<br /> ...<br /> def save_picture<br /> @user = User.find(@params['user']['id'])<br /> File.open("#{RAILS_ROOT}/public/pictures/#{@user.id}.jpg", "wb") do |f| <br /> f.write(@params['picture_file'].read)<br /> end<br /> redirect_to :action => 'show', :id => @user.id<br /> end<br /> ...<br />end<br />
<br />class Content < ActiveRecord::Base<br /> def file=(incomming_file)<br /> @temp_file = incomming_file<br /> @filename = incomming_file.original_filename<br /> @content_type = incomming_file.content_type<br /> end<br /><br /> def after_save<br /> if @temp_file<br /> logger.debug("saving '#{RAILS_ROOT}/media/#{@filename}'")<br /> File.open("#{RAILS_ROOT}/media/#{@filename}", "wb") do |f| <br /> f.write(@temp_file.read)<br /> end<br /> end<br /> end<br /> end<br />
<br />def sanitize_filename(file_name)<br /> # get only the filename, not the whole path (from IE)<br /> just_filename = File.basename(file_name) <br /> # replace all none alphanumeric, underscore or perioids with underscore<br /> just_filename.sub(/[^\w\.\-]/,'_') <br />end<br />