[B! MySQL] hazisarashiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hazisarashi id:hazisarashi

MySQLã«é–¢ã™ã‚‹hazisarashiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (14)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

MySQLã§ãƒ‡ãƒ¼ã‚¿é ˜åŸŸã‚’ã‚·ã‚¹ãƒ†ãƒ ã¨åˆ¥diskã«ã™ã‚‹ãªã‚‰tmpdirã‚‚è¨å®šã—ãŸæ–¹ãŒã„ã„ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
æŸæ‰€ã«300ãƒ›ã‚¹ãƒˆä»¥ä¸Šã‚’2å¹´ã»ã©ç›£è¦–ã—ã¦ã„ãŸZabbixã®MySQLãŒã‚ã‚Šã¾ã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ãŒ100GBãã‚‰ã„ã«ãªã£ã¦ãƒ¡ãƒ¢ãƒª8GBã®ãƒ›ã‚¹ãƒˆã§ã¯disk IOãŒè¾›ããªã£ã¦ããŸã®ã§ã€ç§»è¡Œã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚æ™®æ®µã¯ãã‚“ãªã«ã§ã‚‚ãªã„ã®ã§ã™ãŒã€housekeeperãŒå‹•ä½œã—ã¦å¤ã„ãƒ‡ãƒ¼ã‚¿ã‚’æ¶ˆã—ã«è¡Œãã¨ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã«ä¹—ã£ã¦ã„ãªã„éƒ¨åˆ†ã«èªã¿ã«è¡Œã£ã¦é‡ã„ã®ã§ã™ã€‚ ã“ã®éš›æŠ˜è§’ãªã®ã§ Intel S3700 (ã‚µãƒ¼ãƒç”¨ã®SSD) ã‚’ãŠã”ã‚Šã€ Zabbix-1.8 ã‹ã‚‰ 2.0 ã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ MySQL-5.0.77 ã‹ã‚‰ MySQL-5.6.11 ã«å¤‰æ›´ ã‚·ã‚¹ãƒ†ãƒ ã¯ HDD ã§ /dev/sda1 ãƒ‡ãƒ¼ã‚¿ã¯ SSD ã§ /dev/sdb1 ã‚’ /data ã«ãƒžã‚¦ãƒ³ãƒˆ ã¨ã„ã†æ§‹æˆã§ç§»è¡Œã®æ¤œè¨¼ã‚’è¡Œã£ã¦ã„ãŸã¨ã“ã‚â€¦ MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒå¤§ããä¸ŠãŒã‚‹ã®ã§ mysqldump ã‚’å–å¾—ã—ã¦ restore å¾Œã€pat
hazisarashi 2013/04/29
MySQL

ssd
ãƒªãƒ³ã‚¯
è¤‡æ•°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®MySQLã‚’ç®¡ç†ãƒ»å®Ÿè¡Œã§ãã‚‹mysqlenvä½œã£ãŸ - tumblr
ä¸»ã«é–‹ç™ºç’°å¢ƒã§MySQLã‚’è¤‡æ•°ãƒãƒ¼ã‚¸ãƒ§ãƒ³åŒæ™‚ã«å‹•ã‹ã—ãŸã„ã¨ã„ã†ã“ã¨ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ãªã®ã§è¤‡æ•°ç’°å¢ƒã§ã‚‚å‹•ãã‚„ã¤ä½œã‚Šã¾ã—ãŸã€‚ https://github.com/shim0mura/mysqlenv åå‰ã‹ã‚‰åˆ†ã‹ã‚‹ã‚ˆã†ã«rbenvã®ã‚³ãƒžãƒ³ãƒ‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã‚’çœŸä¼¼ã¦ã„ã¾ã™ã€‚ ã™ã§ã«ã‚ã‚‹kamipoã•ã‚“ã®ä½œã£ãŸmysql-buildã¯å½“æ™‚ã®ruby-buildã‚’ã»ã¨ã‚“ã©ã‚³ãƒ”ã£ã¦ããŸã¨ã®ã“ã¨ãªã®ã§ã€ãã‚Œã‚’çœŸä¼¼ã—ã¦rbenvã‚’ã»ã¼ä¸¸ã€…ãƒ‘ã‚¯ã‚ã†ã‹ã¨æ€ã£ãŸã‘ã©ã€ã‚½ãƒ¼ã‚¹è¦‹ãŸæ„Ÿã˜çœŸä¼¼ã‚‹ã®ã«æ™‚é–“æŽ›ã‹ã‚Šãã†ãªã®ã§ã‚³ãƒžãƒ³ãƒ‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã¨ã‹è¤‡æ•°ã‚³ãƒžãƒ³ãƒ‰ã®å®Ÿè¡Œãƒ•ãƒãƒ¼ã‚‰ã¸ã‚“ã®æŠ½è±¡çš„ã«ä½¿ãˆãã†ãªéƒ¨åˆ†ã ã‘çœŸä¼¼ã¦é©å½“ã«å®Ÿè£…ã—ã¾ã—ãŸã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« $ git clone git://github.com:shim0mura/mysqlenv.git ãŠå¥½ããªãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«cloneã—ãŸã‚ã¨ã¯ä»¥ä¸‹ã‚’.bashrcã«ã§ã‚‚
hazisarashi 2013/04/18
ã“ã‚Œã¯æ»ã«ãŸã„ï½—

MySQL
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
hazisarashi 2012/09/14
PostgreSQL

MySQL

RDBMS

db

æ¯”è¼ƒ
ãƒªãƒ³ã‚¯
Klikbet77 - Situs Autentik Togel Asian & Prediksi Akurat Lewat Odms Club
Klikbet77 - Situs Autentik Togel Asian & Prediksi Akurat Lewat Odms Club Klikbet77 adalah situs autentik togel Asian dengan prediksi akurat lewat ODMS Club. Menyajikan data real-time, analisis statistik mendalam, update pasaran lengkap, sistem aman, akses cepat, dan layanan profesional untuk pengalaman terpercaya.
hazisarashi 2012/07/06
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

è¨å®š

ãƒ¡ãƒ¢ãƒª
ãƒªãƒ³ã‚¯
MySQL :: MySQL 4.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 6.3.7.3 éžè¡¨ç¤ºã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«å¯¾ã™ã‚‹ GROUP BY
MySQL ã§ã¯ GROUP BY ã®ä½¿ç”¨ã‚’æ‹¡å¼µã—ã¦ã„ã¾ã™ã€‚GROUP BY éƒ¨åˆ†ã«ãªã„ã‚«ãƒ©ãƒ ã‚„è¨ˆç®—ã‚’ SELECT å¼ã§ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã“ã‚Œã¯ã€ãã®ã‚°ãƒ«ãƒ¼ãƒ—ã®ä½¿ç”¨å¯èƒ½ãªã‚ã‚‰ã‚†ã‚‹å€¤ã‚’è¡¨ã—ã¾ã™ã€‚ã“ã®æ©Ÿèƒ½ã«ã‚ˆã‚Šã€ä¸è¦é …ç›®ã«å¯¾ã™ã‚‹ã‚½ãƒ¼ãƒˆã‚„ã‚°ãƒ«ãƒ¼ãƒ—åŒ–ã‚’è¡Œã‚ãªã„ã“ã¨ã§ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ãŸã¨ãˆã°ã€æ¬¡ã®ã‚¯ã‚¨ãƒªã®å ´åˆã€customer.name ã‚’ã‚°ãƒ«ãƒ¼ãƒ—åŒ–ã™ã‚‹å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ mysql> SELECT order.custid,customer.name,MAX(payments) -> FROM order,customer -> WHERE order.custid = customer.custid -> GROUP BY order.custid; æ¨™æº– SQL ã§ã¯ã€customer.name ã‚’ GROUP BY ç¯€ã«çµ„ã¿è¾¼ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚MySQL
hazisarashi 2012/05/11
ã‚ãƒ¼ã‚„ã£ã±ã‚Šäºˆæ¸¬ä¸èƒ½ã®å€¤ãªã®ã‹ãã€‚

MySQL
ãƒªãƒ³ã‚¯
Sequel Pro
Full MySQL Support Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. Perfect Web Development Companion Whether you are a Mac Web Developer, Programmer or Software Developer your workflow will be streamlined with a native Mac OS X Application! Flexible Connectivity Sequel Pro gives you direct access to your MySQL Databases on local and remote se
hazisarashi 2012/05/08
MySQL

Mac

ã‚¢ãƒ—ãƒª
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
ä»Šå¹´èªã‚“ã å°èª¬ãƒ™ã‚¹ãƒˆ10(ãƒŸã‚¹ãƒ†ãƒªç·¨) ã•ã¦ã€ãã‚Œã§ã¯éžãƒŸã‚¹ãƒ†ãƒªç·¨ã«å¼•ãç¶šã„ã¦ä»Šå›žã¯ãƒŸã‚¹ãƒ†ãƒªç·¨ã§ã™ã€‚ä»Šå¹´ã®ãƒŸã‚¹ãƒ†ãƒªç•Œã®æœ€å¤§ã®ãƒˆãƒ”ãƒƒã‚¯ã¨ã„ãˆã°ãªã‚“ã¨ã„ã£ã¦ã‚‚é£›é³¥éƒ¨å‹å‰‡å¾©æ´»ã€‚æ•°å¹´å‰ã‹ã‚‰æ–°ä½œçŸç·¨ã‚„æ–‡åº«åŒ–ãªã©ã®å…†ã—ã¯ã‚ã‚Šã¾ã—ãŸãŒã€ã¤ã„ã«å‡ºãŸæ–°ä½œå¤§é•·ç·¨ï¼ã•ã‚‰ã«æ¥å¹´ä»¥é™ã‚‚ãƒã‚¤ãƒšãƒ¼ã‚¹ãªæ´»å‹•ãŒäºˆå‘Šã•ã‚Œã¦â€¦
hazisarashi 2012/05/07
Homebrew

MySQL
ãƒªãƒ³ã‚¯
Mac OS X 10.6 Snow Leopardã«MySQL Sandboxã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ - ç¥ˆã‚Œã€ãã—ã¦åƒã‘ ï½ž Ora et labora
Mac OS X 10.6.6 MySQL Sandbox 3.0.17 MySQL MySQL Community Server 5.5.10 Mac OS X ver. 10.6 (x86, 64-bit), Compressed TAR Archive ã“ã“ã‚’å‚è€ƒã«ã€rootã§CPANã‹ã‚‰MySQL Sandboxæœ¬ä½“ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å ´åˆã¯ã€ã“ã“ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ $ sudo cpan -i Test::More $ sudo cpan -i YAML $ sudo cpan -i MySQL::SandboxMySQL Sandboxæœ¬ä½“ã¯ä»¥ä¸‹ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¾ã™ã€‚ Installing /opt/local/lib/perl5/site_perl/5.8.9/MySQL/Sandbox.pm Installing /
hazisarashi 2012/05/06
MySQL

mysql sandbox
ãƒªãƒ³ã‚¯
Facebookã®ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³ã®ãƒ—ãƒãƒˆã‚¿ã‚¤ãƒ—ã¯4äººã®ç¤¾å“¡ãŒãŸã£ãŸä¸€æ™©ã§æ›¸ã„ãŸ | TechCrunch Japan
Featuring Prime Minister of Greece & top Euro tech voices!
hazisarashi 2012/01/06
Facebook

Timeline

MySQL

DB
ãƒªãƒ³ã‚¯
STF Distributed Object Storage - Home
Distributed Object Storage Made Easy! Use commodity hardware/software to build your own scala ble object storage! Learn more Â» What is STF? STF is a simple, yet very scala ble distribute storage system. STF powers sites like livedoor Blog, loctouch and many more, serving gigabytes after gigabytes of data. On one such system, it's serving 400Mbps of image at peak hours without a hitch. GET STF! STF i
hazisarashi 2011/12/22
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹

memcached

MySQL

apache

http

perl

ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸
ãƒªãƒ³ã‚¯
MySQLã®ã‚³ãƒžãƒ³ãƒ‰ãŸã¡ - ã™ãŽã‚ƒãƒ¼ã‚“ãƒ¡ãƒ¢
http://mysql-casual.org/2011/11/mysql-casual-advent-calendar-2011.html ã®6æ—¥ç›®ã®è¨˜äº‹ã¨ã—ã¦æ›¸ã‹ã›ã¦ã„ãŸã ãã¾ã™ã€sugyanã§ã™ã€‚ å‹¢ã„ã§å‚åŠ è¡¨æ˜Žã—ã¦ã—ã¾ã„ã€ä»Šæ—¥æ…Œã¦ã¦ä¹…ã—ã¶ã‚Šã«MySQLã‚’è§¦ã‚Šã¾ã—ãŸã€‚ MySQLã§FizzBuzz ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã£ã¦ä½¿ã£ãŸã“ã¨ç„¡ã‹ã£ãŸã®ã§åˆã‚ã¦è§¦ã£ã¦ã¿ã¾ã—ãŸã€‚ DROP PROCEDURE IF EXISTS FizzBuzz; delimiter // CREATE PROCEDURE FizzBuzz(n INT) BEGIN DECLARE i INT DEFAULT 1; WHILE i <= n DO SELECT CASE WHEN i % 3 = 0 AND i % 5 = 0 THEN 'FizzBuzz' WHEN i % 5 = 0 THEN 'Buzz'
hazisarashi 2011/12/07
MySQL
ãƒªãƒ³ã‚¯
ã¯ã˜ã‚ã¦ã® MySQL ã§100ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹æ™‚ã«è¡Œã£ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚
MySQL ã®å‹‰å¼·ã‚’ã›ãšã«ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ç‰ã§ SQL ã‚’æ›¸ã‹ãšã« Web ã‚µã‚¤ãƒˆã‚’æ§‹ç¯‰ã—ã¦ã„ã¾ã—ãŸã€‚ãƒ‡ãƒ¼ã‚¿æ•°ã‚‚2ä¸‡ä»¶ç¨‹åº¦ã§ã—ãŸã®ã§ã€ãã“ã¾ã§å›°ã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸãŒã€ä»Šå›ž100ä¸‡å¼±ã®å•†å“ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†æ©Ÿä¼šãŒã§ããŸã®ã§ã€MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚„ç™ºè¡Œã™ã‚‹ SQL ã«ã¤ã„ã¦è¦‹ç›´ã™æ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯ MySQL ã‚’é«˜é€ŸåŒ–ã™ã‚‹ã®ã«è¡Œã£ãŸå¯¾ç–ãªã©å‹‰å¼·ã—ãŸã‚‚ã®ã‚’è‡ªåˆ†ç”¨ã«ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã—ãŸã€‚ æ¡ä»¶å¼ã§æ¯”è¼ƒã™ã‚‹ã‚«ãƒ©ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ã¦é«˜é€ŸåŒ– å•†å“ã‚³ãƒ¼ãƒ‰ã§å˜åœ¨ã—ãªã„å•†å“ã‚’è¦‹ã¤ã‘ã¦ã€å•†å“ã‚’DBã«ç™»éŒ²ã™ã‚‹ã¨ã„ã†å‡¦ç†ã‚’è¡Œã£ã¦ã„ã‚‹å ´åˆã€4ä¸‡ä»¶è¶…ãˆãŸã“ã‚ã‹ã‚‰å‡¦ç†ã«2ç§’ä»¥ä¸Šã‹ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¾ã™ã€‚12ä¸‡ä»¶è¶…ãˆãŸé ƒã«ã¯10ç§’ç¨‹åº¦ã‹ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€å•†å“ã‚³ãƒ¼ãƒ‰ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«å¯¾ã—ã¦ã‚«ãƒ©ãƒ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚‹ã“ã¨ã§0.2ç§’ã«çŸç¸®ã™ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚ MySQL ã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã«ã‚‚ä»¥ä¸‹ã®ã‚ˆ
hazisarashi 2011/10/26
MySQL
ãƒªãƒ³ã‚¯
å·¨å¤§ã§ãƒãƒ¼ã‚«ãƒ«ã«ä¿å˜ã§ããªã„ MySQL ã®ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’å¤–éƒ¨ã‚µãƒ¼ãƒãƒ¼ã« SSH ã§ä¿å˜ã™ã‚‹æ–¹æ³•
ã•ãã‚‰ã® VPS ã®20GBã«ãŽã£ã—ã‚Šè©°ã¾ã£ãŸ MySQL ã®ãƒ•ã‚¡ã‚¤ãƒ«ã€‚ã‚µãƒ¼ãƒãƒ¼ã‚’100GBã® VPS ã«ç§»è»¢ã™ã‚‹ã“ã¨ã«ãªã£ãŸã®ã§ã™ãŒã€phpMyAdmin ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã‚‚ã€ã©ã‚Œã ã‘è¨å®šã‚’å¤‰æ›´ã—ã¦ã‚‚2GBã¾ã§ã—ã‹å–ã‚Œãªã„ã€‚ãã‚Œã‚ˆã‚Šã‚‚ã€ã“ã‚Œã ã¨å¿ƒé…ãªã®ã§ mysqldump ã‚’ä½¿ã„ãŸã„ã¨æ€ã£ãŸã¨ã“ã‚ã€mysqldump ã‚’ãƒãƒ¼ã‚«ãƒ«ã«ä¿å˜ã—ãªãã¦ã‚‚ã€ãã®ã¾ã¾å¤–éƒ¨ã®ã‚µãƒ¼ãƒãƒ¼ã«ä¿å˜ã™ã‚‹æ–¹æ³•ã‚’è¦‹ã¤ã‘ã¾ã—ãŸã€‚ mysqldump ã®çµæžœã‚’ãã®ã¾ã¾åœ§ç¸®ã—ãŸã‚Šè»¢é€ã—ãŸã‚Šã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ä¾‹ | ãƒã‚·ãƒ£ãƒã‚°ã€‚ mysqldump ã‚’å¤–éƒ¨ã‚µãƒ¼ãƒãƒ¼ã«ä¿å˜ã™ã‚‹ mysqldump ã‚’ gzip ã§åœ§ç¸®ã—ã¦ SSH ã§ãã‚Œã‚’å¤–éƒ¨ã® VPS ã«è»¢é€ã—ã¾ã™ã€‚å¤‰æ›´ç‚¹ã¯ [PASSWORD] ã¨ [DB_NAME] ã§ã™ã€‚ã‚ã¨ SSH ã®éƒ¨åˆ†ã¯ã”è‡ªåˆ†ã®è»¢é€ã—ãŸã„ã‚µãƒ¼ãƒãƒ¼ã«åˆã‚ã›ã¦å¤‰æ›´ã—ã¦ãã ã•ã„ã€‚ã¡ãªã¿ã« [PASSWOR
hazisarashi 2011/10/11
MySQL

ssh
ãƒªãƒ³ã‚¯
ã‚„ã£ãŸãƒ¼JavaScriptã®å‹•ãMySQLã§ããŸã‚ˆãƒ¼ - æ„›ã¨å‹‡æ°—ã¨ç¼¶ãƒ“ãƒ¼ãƒ«
â€»ãƒã‚¿ã§ã™ â€»UDFã§ã™ Mysql 5.1 Plugin Development ä½œè€…: Andrew Hutchings,Sergei Golubchikå‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: Packt Publishingç™ºå£²æ—¥: 2010/08/30ãƒ¡ãƒ‡ã‚£ã‚¢: ãƒšãƒ¼ãƒ‘ãƒ¼ãƒãƒƒã‚¯è³¼å…¥: 1äºº ã‚¯ãƒªãƒƒã‚¯: 45å›žã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (2ä»¶) ã‚’è¦‹ã‚‹ ã—ã°ã‚‰ãç©ã‚“èªã—ã¦ã„ãŸã“ã®æœ¬ã‚’ã¡ã‚‡ã£ã¨çœºã‚ã¦ã¿ãŸã‚‰ã€MySQLã®UDFã£ã¦ç°¡å˜ã«ä½œã‚Œã‚‹ã‚“ã ãªãƒ¼ã€ã¨æ€ã£ãŸ && ãã†ã„ã‚„V8ã£ã¦ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¨ã—ã¦ç°¡å˜ã«ãƒªãƒ³ã‚¯ã§ãã‚‹ã¯ãšã ãªã€ã¨æ€ã„å‡ºã—ãŸ ã®ã§ã€ã¤ã„ã‚«ãƒƒã¨ãªã£ã¦ä½œã£ãŸã€‚ http://github.com/zentooo/mysqludf-jseval UDFã†ã‚“ã¬ï½Ž ã»ã¨ã‚“ã©â†‘ã®æœ¬ã®å—ã‘å£²ã‚Šã«ãªã‚‹ã‘ã©ã€ä¸€å¿œMySQLã®UDFã«ã¤ã„ã¦å‚™å¿˜éŒ²ä»£ã‚ã‚Šã«è»½ãç´¹ä»‹ã—ã¦ãŠãã¨ UDFã‚’è¿½åŠ ã™ã‚‹å ´åˆã€MySQLã®å†ã‚³ãƒ³ãƒ‘ã‚¤
hazisarashi 2011/09/26
javascript

ãƒã‚¿

MySQL
ãƒªãƒ³ã‚¯
1