[B! mysql][Linux] Glnã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Gln id:Gln

mysqlã¨Linuxã«é–¢ã™ã‚‹Glnã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{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}}

Red Hat Enterprise Linux 7ã§ã‚‚MySQLã«ä»£ãˆã¦MariaDBã‚’æŽ¡ç”¨ | ã‚¹ãƒ©ãƒ‰ Linux
2013å¹´ç¬¬2å››åŠæœŸã«å‡ºè·äºˆå®šã®Red Hat Enterprise Linux(RHEL) 7ã§ã¯ã€MySQLã«ä»£ãˆã¦MariaDBã‚’æŽ¡ç”¨ã™ã‚‹ãã†ã (ITWireã®è¨˜äº‹ã€ The Registerã®è¨˜äº‹ã€ æœ¬å®¶/.)ã€‚ MariaDBã¯ã€MySQLã‚’ãƒ•ã‚©ãƒ¼ã‚¯ã—ãŸãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã€ç¾åœ¨ã®ã¨ã“ã‚MySQLã¨å®Œå…¨ãªäº’æ›æ€§ãŒã‚ã‚‹ã€‚Red Hatã®Radek VokÃ¡iæ°ã«ã‚ˆã‚Œã°ã€MySQLã‚ˆã‚ŠMariaDBã®æ–¹ãŒãƒ‘ãƒƒãƒã‚„æ©Ÿèƒ½è¿½åŠ ãªã©ã®ã‚³ãƒ³ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚‚å®¹æ˜“ã«ãªã‚‹ã¨æœŸå¾…ã—ã¦ã„ã‚‹ã¨ã®ã“ã¨ã€‚ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ãƒ™ãƒ¼ã‚¹ã®Linuxãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯MySQLã‹ã‚‰MariaDBã¸ã®ç§»è¡ŒãŒé€²ã‚“ã§ã„ã‚‹ãŒã€ä¼æ¥å‘ã‘ã®ãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚‚MariaDBã¸ã®ç§»è¡ŒãŒé€²ã‚€ã‚‚ã®ã¨ã¿ã‚‰ã‚Œã‚‹ã€‚
Gln 2013/06/20
MariaDB

mysql

Linux

DB
ãƒªãƒ³ã‚¯
Installing LAMP On Ubuntu For Newbies
Installing LAMP On Ubuntu For NewbiesIn this guide, I will show you how to install a LAMP system. LAMP stands for Linux, Apache, MySQL, PHP. The guide is intended to help those who have very little knowledge of using Linux. ** UPDATE ** The tutorial below is for Ubuntu 11.x and 12.x. If you are seeking for a LAMP tutorial for the current Ubuntu version, then please use this guide: https://www.howt
Gln 2013/03/02
ubuntu

LAMP

tutorials

mysql

php

apache

linux
ãƒªãƒ³ã‚¯
Fedora 19ã§ã¯MySQLã«ä»£ãˆã¦MariaDBã‚’æŽ¡ç”¨ | ã‚¹ãƒ©ãƒ‰ IT
5æœˆã«ãƒªãƒªãƒ¼ã‚¹ãŒäºˆå®šã•ã‚Œã¦ã„ã‚‹Fedora 19ã§ã¯ã€MySQLã«ä»£ãˆã¦MariaDBãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¨ãªã‚‹ã€‚MariaDBã¯MySQLã®ã‚ªãƒªã‚¸ãƒŠãƒ«é–‹ç™ºè€…ã®ä¸€éƒ¨ãŒãƒ•ã‚©ãƒ¼ã‚¯ã—ãŸãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã€æ—¢ã«Mageia version 2ã§æŽ¡ç”¨ã•ã‚Œã¦ãŠã‚Šã€3æœˆãƒªãƒªãƒ¼ã‚¹äºˆå®šã®openSUSE 12.3ã«ã‚‚æŽ¡ç”¨ã•ã‚Œã‚‹ã“ã¨ãŒæ±ºã¾ã£ã¦ã„ã‚‹( Fedora Projectã®Wikiã€ The H Openã®è¨˜äº‹)ã€‚ ç¾çŠ¶MySQLã¨MariaDBã«ã¯å®Œå…¨ãªäº’æ›æ€§ãŒã‚ã‚‹ãŸã‚ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã¨ã£ã¦ã¯ç‰¹ã«å½±éŸ¿ã¯ç™ºç”Ÿã—ãªã„ã€‚ãŸã ã—ã€ä»Šå¾Œé–‹ç™ºãŒé€²ã‚€ã«ã¤ã‚Œã¦äº’æ›æ€§ãŒä½Žä¸‹ã™ã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚Fedoraã§MariaDBãŒæŽ¡ç”¨ã•ã‚Œã‚‹ã“ã¨ã§ã€å°†æ¥çš„ã«ã¯Red Hat Enterprise Linuxã§ã‚‚MariaDBãŒæŽ¡ç”¨ã•ã‚Œã‚‹ã“ã¨ã«ãªã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã€‚
Gln 2013/02/06
Fedora

mysql

MariaDB

linux

DB
ãƒªãƒ³ã‚¯
2013å¹´2æœˆ5æ—¥ã€€FedoraãŒMariaDBã«ãƒªãƒ—ãƒ¬ãƒ¼ã‚¹ã€MySQLã¯ã“ã‚Œã‹ã‚‰ã©ã†ãªã‚‹ï¼Ÿ | gihyo.jp
Linux Daily Topics 2013å¹´2æœˆ5æ—¥FedoraãŒMariaDBã«ãƒªãƒ—ãƒ¬ãƒ¼ã‚¹ã€MySQLã¯ã“ã‚Œã‹ã‚‰ã©ã†ãªã‚‹ï¼Ÿ ã“ã“æœ€è¿‘ã€Linuxãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã®MySQLã‹ã‚‰MariaDBã¸ã®ãƒªãƒ—ãƒ¬ãƒ¼ã‚¹ãŒæ¢ã¾ã‚‰ãªã„æµã‚Œã¨ãªã£ã¦ã„ã‚‹ã€‚ã¨ãã«å…ˆæœˆç™ºè¡¨ã•ã‚ŒãŸã€openSUSEã¨Fedoraã¨ã„ã†2ã¤ã®å¤§ããªãƒ‡ã‚£ã‚¹ãƒˆãƒãŒæ¬¡ã®ãƒªãƒªãƒ¼ã‚¹ï¼ˆopenSUSE 12.3ã€Fedora 19ï¼‰ã‹ã‚‰MariaDBã‚’æŽ¡ç”¨ã™ã‚‹ã¨ã„ã†ãƒ‹ãƒ¥ãƒ¼ã‚¹â”€ã“ã‚Œã‚‰ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ç•Œéšˆã«å°ã•ããªã„è¡æ’ƒã‚’ã‚‚ã£ã¦è¿Žãˆã‚‰ã‚ŒãŸã“ã¨ã¯è¨˜æ†¶ã«ã‚ãŸã‚‰ã—ã„ã€‚ ã”å˜çŸ¥ã®æ–¹ã‚‚å¤šã„ã¨æ€ã†ãŒã€MariaDBã¯MySQLã®ãƒ•ã‚¡ã‚¦ãƒ³ãƒ€ãƒ¼ã§ã‚ã‚‹Michael "Monty" WideniusãŒä¸å¿ƒã¨ãªã£ã¦é–‹ç™ºã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®RDBMSã§ã‚ã‚‹ã€‚MySQLã‹ã‚‰ãƒ•ã‚©ãƒ¼ã‚¯ã—ãŸãƒ—ãƒãƒ€ã‚¯ãƒˆã§ã‚ã‚‹MariaDBã¯MySQLã®ä»£æ›¿ã¨ãªã‚‹ã“ã¨ã‚’ç›®æŒ‡ã—ã¦ãƒ‡ã‚¶ã‚¤ãƒ³ã•
Gln 2013/02/05
linux

mysql

rdb

Fedora

MariaDB

Oracle
ãƒªãƒ³ã‚¯
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å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
Gln 2012/09/12
PostgreSQL

linux

database

performance

MySQL

æ¯”è¼ƒ
ãƒªãƒ³ã‚¯
ã†ã‚‹ã†ç§’ã®ã‚ã¨ã«MySQLãªã©ã®CPUä½¿ç”¨çŽ‡ãŒé«˜é¨°ã™ã‚‹ä»¶ã«ã¤ã„ã¦ - SH2ã®æ—¥è¨˜
2012å¹´7æœˆ1æ—¥ã®ã†ã‚‹ã†ç§’ã®ã‚ã¨ã«ã€MySQLã‚„Javaãªã©ã®CPUä½¿ç”¨çŽ‡ãŒé«˜é¨°ã™ã‚‹äº‹è±¡ãŒå ±å‘Šã•ã‚Œã¦ã„ã¾ã™ã€‚ CPU %user %nice %system %iowait %steal %idle 08æ™‚30åˆ†01ç§’ all 0.02 0.00 0.02 0.04 0.00 99.91 08æ™‚40åˆ†01ç§’ all 0.02 0.00 0.02 0.08 0.00 99.88 08æ™‚50åˆ†01ç§’ all 0.02 0.00 0.02 0.03 0.00 99.92 09æ™‚00åˆ†01ç§’ all 0.11 0.00 0.13 0.04 0.00 99.72 09æ™‚10åˆ†01ç§’ all 23.02 0.00 29.09 0.11 0.00 47.78 09æ™‚20åˆ†01ç§’ all 23.11 0.00 29.08 0.06 0.00 47.75 09æ™‚30åˆ†01ç§’ all 22.85 0.00
Gln 2012/07/02
Linux

MySQL
ãƒªãƒ³ã‚¯
ç‹¬å¦Linux : MySQLã§è©¦ã™ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¥é–€ã€Šãã®ï¼‘ã€‹
9æœˆ20 MySQLã§è©¦ã™ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¥é–€ã€Šãã®ï¼‘ã€‹ ã‚«ãƒ†ã‚´ãƒª:Ubuntu 10.04ã‚µãƒ¼ãƒãƒ¼æ§‹ç¯‰ å…ˆæ—¥ã€ç§‹è‘‰åŽŸã®æŸæ›¸åº—ã§ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã£ã¦é›£ã—ã„ã‚“ã ã‚ˆãâ€¦ã€ã¨ã“ã¼ã—ã¦ã„ã‚‹å¹´é…ã®æ–¹ã‚’è¦‹ã‹ã‘ã¾ã—ãŸã€‚æœ¬æ¥ã§ã¯Excelã§ååˆ†ãªã®ã§ã‚ã¾ã‚Šæ°—ã«ã—ãŸã“ã¨ã¯ãªã‹ã£ãŸã®ã§ã™ãŒã€èª¿ã¹ã¦ã¿ã‚‹ã¨ç¢ºã‹ã«ã„ã‚ã„ã‚ã¨é›£ã—ãã†ã§ã™ã€‚ MythTVãªã©ã‚’è©¦ã—ãŸã¨ãã«MySQLã®è¨å®šã‚’ã‚„ã£ãŸã“ã¨ãŒã‚ã‚Šã¾ã™ãŒã€å¿…è¦æœ€å°é™ã®ç¯„å›²ã§ã—ã‹ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ãã“ã§ã€æ”¹ã‚ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½¿ã„æ–¹ã‚’èª¿ã¹ã€ã„ã‚ã„ã‚è©¦ã—ã¦ã¿ã¾ã—ãŸã®ã§ã€ã¾ã¨ã‚ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ OpenOffice.org Baseã‚’MySQLã‚µãƒ¼ãƒã«æŽ¥ç¶šã—ãŸã¨ã“ã‚ã€‚æ˜¨æ—¥ã¾ã§ã€æ–‡å—åŒ–ã‘ãŒè§£æ¶ˆã§ããšã«è‹¦æˆ¦ã—ã¦ã„ã¾ã—ãŸã€‚ ãã‚‚ãã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã£ã¦ä½•ã§ã—ã‚‡ã†ï¼Ÿ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ã•ã¾ã–ã¾ãªæƒ…å ±ã‚’æ•´ç†ã™ã‚‹éš›ã€çŸã„æ–‡ã§ã¾ã¨ã‚ã¦ãƒ¡ãƒ¢ã«æ®‹ã—ãŸã‚Šã€Excelã‚„Calcãªã©ã®è¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆã§ä¸€
Gln 2010/10/07
mysql

OpenOffice

Linux
ãƒªãƒ³ã‚¯
ç‹¬å¦Linux : MySQLã§è©¦ã™ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¥é–€ã€Šãã®ï¼’ã€‹
10æœˆ4 MySQLã§è©¦ã™ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¥é–€ã€Šãã®ï¼’ã€‹ MySQLã®ç¶šãã§ã™ã€‚ä»Šå›žã¯æ—¢å˜ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’OpenOffice.org Baseã‚’ä½¿ã£ã¦èªã¿è¾¼ã¿ã€ã•ã‚‰ã«Calc(OpenOffice.orgã®è¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆ)ã‚„Writer(OpenOffice.orgã®ãƒ¯ãƒ¼ãƒ—ãƒã‚½ãƒ•ãƒˆ)ã§èªã¿è¾¼ã‚“ã ãƒ‡ãƒ¼ã‚¿ã‚’åˆ©ç”¨ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ MySQLã¨æŽ¥ç¶šã™ã‚Œã°ã€MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ MySQLã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’Calcã«æ›¸ãå‡ºã—ãŸã‚ˆã†ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’é¸æŠžã—ã¦ãƒ‰ãƒ©ãƒƒã‚°ï¼†ãƒ‰ãƒãƒƒãƒ—ã™ã‚‹ã ã‘ã§ã€ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã«è²¼ã‚Šä»˜ã‘ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ MySQLã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’Writerã«æ›¸ãå‡ºã—ãŸã‚ˆã†ã™ã€‚Calcã¨åŒæ§˜ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’é¸æŠžã—ã¦ãƒ‰ãƒ©ãƒƒã‚°ï¼†ãƒ‰ãƒãƒƒãƒ—ã™ã‚‹ã ã‘ã§ãƒ‡ãƒ¼ã‚¿ã‚’è²¼ã‚Šä»˜ã‘ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ãƒ¬ã‚¤ã‚¢ã‚¦ãƒˆã‚’è¨å®šã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã§ã™ã€‚ Baseã¨MySQLã®æŽ¥ç¶šMySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’Baseã§èªã¿è¾¼
Gln 2010/10/07
mysql

OpenOffice

Linux
ãƒªãƒ³ã‚¯
1