はてなブックマーク

ネット回線を変えたら、サーバーにssh出来ず、ssh_exchange_identification: read: Connection reset by peer になった時の対応MacSSHさくらVPS 前置き チョット前に自宅のネット回線をADSLに戻しました。 そしたら、さくらVPSにsshできなくなってしまいました。 その時の対応です。 状況 PC: MacBookPro (Mavericks) サーバー: さくらVPS(CentOS 6.5) ssh出来ていた時の回線: WiMAX(レンタル) 現在の回線: ADSL エラーメッセージ Macからサーバーにssh仕様としたらこんなメッセージが出ました。 watashi% ssh -v sakuradev OpenSSH_hoge, OSSLShim hogehoge dd mm yyyy debug1: Reading conf

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?

Postgresでパスワードを忘れました。 やばいやばいと思いつつ、アンインストールしなきゃかなぁ...ヽ(´Д｀ヽ)(/´Д｀)/ｲﾔｧ～ とか思っていたら、意外となんとかなりました。 環境は - Vagrant 1.6.5 - Virtual Box 4.3.16 - CentOS6.5 - Postgres: psql 8.4.20, server 9.3 です。 アクセス権限の変更 & パスワードなしでのログインを可能に アクセス権限ファイルを修正 まずはpg_hba.confを探して編集します。

まずこんなテーブルを作るとします。ここに毎月10万件以上のレコードが入ってくる予定です。 1レコードが57byteなので、月に5.7Mbyte、プライマリーキーを入れると60Mbyteくらいが入ってきます。 年間にすると720Mbyteなので、まぁデータ量的には余裕だと思うのですが、 100万レコードを超えるとレスポンスが鈍化するという印象があります。 というわけで、MySQLにあるパーティショニング機能を使い、データを振り分けたいと思います。 【参考】DB設計時のサイズ見積もり | よねのはてな テーブル作成 注意する点として、パーティショニングのキーにしたいカラムを、プライマリーキーに含める必要があるようです。 なので、オートインクリメントのカラムがあるテーブルだと辛い。構成を考えなおした方がいいかも。 CREATE TABLE `list_rtx` ( `member_id` var