¥Ï¡¼¥É¥Ç¥£¥¹¥¯¥á¥ó¥Æ¥Ê¥ó¥¹

¥Ï¡¼¥É¥Ç¥£¥¹¥¯¤Î¿ÇÃÇ¡¢ÊªÍý¥Õ¥©¡¼¥Þ¥Ã¥È¡¢ÀŲ»²½¡¢Linux¡¢¥µ¡¼¥Ð¡¼¡¢MySQL¤Ê¤É¤¬¥á¥¤¥ó¤À¤Ã¤¿¤Î¤Ç¤¹¤¬¡¢¤½¤Î¸å¹­¤¬¤ê¡¢¥«¥á¥é¤ä¥Ï¡¼¥É¥¦¥§¥¢¤ÎÅê¹Æ¤âÁý¤¨¤Æ¤­¤Þ¤·¤¿¡£ ¥â¥Ð¥¤¥ë¥Ç¥Ð¥¤¥¹¤Ï¡¢MacBookAir(13·¿)¡¢iPad Air2¡¢¥Ý¥á¥é DM100(¥­¥ó¥°¥¸¥à)¡¢OLYMPUS STYLUS XZ-2¤Ê¤É¡£ ¤³¤ì¤é¤ò»È¤¤¤Ê¤¬¤é¡¢¥Ö¥í¥°¤ò¹¹¿·¤·¤Æ¤¤¤Þ¤¹¡£

¥¿¥°¡§Êѹ¹



¥Û¥¹¥È̾¤ÏDebian¤Î¥¤¥ó¥¹¥È¡¼¥ë»þ¤ËÀßÄꤹ¤ë¤¬¡¢¸å¤ÇÊѹ¹¤·¤¿¤¯¤Ê¤ë¤³¤È¤¬¤¢¤ë¡£

¥Û¥¹¥È̾¤Ï¥³¥Þ¥ó¥É¤ò»ÈÍѤ·¤Æ¤¤¤ë»þ¤Ë

root@host:~#

¤Î¤è¤¦¤Ëɽ¼¨¤µ¤ì¤ë¤Î¤Ç¡¢ÌܤËÉÕ¤¯µ¡²ñ¤¬Â¿¤¤¡£

(root»þ¤Ï¡Ö#¡×¡¢°ìÈ̥桼¥¶»þ¤Ï¡Ö$¡×)

¥Û¥¹¥È̾¤òÊѹ¹¤¹¤ë¤Ë¤Ï¡¢

/etc/hostname

¤È

/etc/hosts

¤ò³«¤¤¤ÆÊÔ½¸¤¹¤ë¡£

¤½¤·¤Æ¡¢¥Í¥Ã¥È¥ï¡¼¥¯¤òºÆµ¯Æ°¡£

/etc/init.d/networking restart

ÅöÁ³¤À¤¬¡¢root¤Ç¤Ê¤¤¤ÈÁàºî¤Ç¤­¤Ê¤¤¤Î¤ÇÃí°Õ¡£

Debian GNU/LinuxÅ°ÄìÆþÌçÂè3ÈÇ SargeÂбþ
ÉðÆ£ ·ò»Ö
æƱ˼Ò
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 98,378

[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



phpMyAdmin 3.4.11.1deb2

phpMyAdmin¤Îɸ½à¤Î¥Ç¥¶¥¤¥ó(¥Æ¡¼¥Þ/¥¹¥¿¥¤¥ë)¤Ï¡¢¤¤¤Ä¤·¤«pmahomme¤È¤¤¤¦¤â¤Î¤ËÊѹ¹¤Ë¤Ê¤Ã¤Æ¤¤¤ë¡£

pmahomme
pmahomme

¤·¤«¤·¡¢Á°¤Î¥Æ¡¼¥Þ(Original)¤Ë´·¤ì¤Æ¤¤¤ë¾ì¹ç¡¢Original¤ÎÊý¤¬¤¤¤¤¤³¤È¤â¤¢¤í¤¦¡£

Original
Original

¥Æ¡¼¥Þ¤Ï¡¢¥Û¡¼¥à¤Ë¤¢¤ë ³°´Ñ¤ÎÀßÄê¡ä¥Æ¡¼¥Þ/¥¹¥¿¥¤¥ë ¤«¤éÊѹ¹¤Ç¤­¤ë¡£

phpMyAdmin

­¡¤Ç¥Û¡¼¥à¤ËÈô¤Ó¡¢­¢¤Ç¥Ç¥¶¥¤¥ó¤òÁªÂò¤¹¤ë¡£

³°´Ñ¤ÎÀßÄê¡ä¥Æ¡¼¥Þ/¥¹¥¿¥¤¥ë

¤³¤ì¤ò¡¢É¸½à¤ÇOriginal¤Ë¤¹¤ë¤Ë¤Ï¡¢

/var/www/phpmyadmin/libraries

¤Ë¤¢¤ë

config.default.php

¤Î¥Õ¥¡¥¤¥ëÃæ¤Î°Ê²¼¤òOriginal¤Ë½ñ¤­´¹¤¨¤ë¡£

/**
* set up default theme, if ThemePath not empty you can set up here an valid
* path to themes or 'original' for the original pma-theme
*
* @global string $cfg['ThemeDefault']
*/
$cfg['ThemeDefault'] = 'pmahomme';

¢­

$cfg['ThemeDefault'] = 'Original';

¤Ê¤ª¡¢¥Æ¡¼¥Þ¤Î¥Õ¥¡¥¤¥ë·²¤Ï

/var/www/phpmyadmin/themes

¤Ë³ÊǼ¤µ¤ì¤Æ¤ª¤ê¡¢Â¾¤Î¥Æ¡¼¥Þ¤âÇÛÉÛ¤µ¤ì¤Æ¤¤¤ë¡£

Ê£¿ô¤Î¥µ¡¼¥Ð¡¼¤ò»ý¤Ã¤ÆÊ£¿ô¤ÎphpMyAdmin¤ò°·¤¦¾ì¹ç¡¢»î¸³¥µ¡¼¥Ð¡¼¤ÎDB¤È»×¤Ã¤ÆDROP¤·¤¿¤é¡¢¼Â¤Ï¼Â±¿ÍÑ¥µ¡¼¥Ð¡¼¤ÎDB¤Ç¤¢¤Ã¤¿¡¢¤È¤Ê¤ë¤Èº¤¤ë¡£

¤É¤Á¤é¤ÎDB¤Ç¤¢¤ë¤«Ê¬¤«¤ê¤ä¤¹¤¯¤¹¤ë¤¿¤á¡¢»î¸³¥µ¡¼¥Ð¡¼¤È¼Â±¿ÍÑ¥µ¡¼¥Ð¡¼¤ÎphpMyAdmin¤Î¥Æ¡¼¥Þ¤òÂ礭¤¯ÊѤ¨¤Æ¤ª¤¯¤È¤è¤¤¤À¤í¤¦¡£

phpMyAdmin¤Îº¸¾å¤Ë¤Ï¥¯¥ê¥Ã¥¯¤¹¤ë¤È¥Û¡¼¥à¤ËÈô¤Ö¥í¥´¤¬¤¢¤ë¤¬¡¢¤³¤ì¤ò¡Ö»î¸³¥µ¡¼¥Ð¡¼¡×¤È¤«¡Ö¼Â¥µ¡¼¥Ð¡¼¡×¤È¤«¤ËÊѤ¨¤Æ¤ª¤¯¤Èʬ¤«¤ê¤ä¤¹¤¤¤À¤í¤¦¡£

Original¤Î¾ì¹ç¤Ï

http://192.168.0.10/phpmyadmin/themes/original/img/logo_left.png

¤¬º¸¾å¤Î¥í¥´¤Ç¤¢¤ê¡¢pmahomme¤Ç¤Ï

http://192.168.0.10/phpmyadmin/themes/pmahomme/img/logo_left.png

¤Ç¤¢¤ë¡£

¤Ê¤ª¡¢phpMyAdmin¤Ç¥Æ¡¼¥Ö¥ëÁªÂò¸å¤Ë¡ÖSQL¡×¤ò¥¯¥ê¥Ã¥¯¤¹¤ë¤È¡Ö¥Ç¡¼¥¿¥Ù¡¼¥¹ xxx ¾å¤Ç¥¯¥¨¥ê¤ò¼Â¹Ô¤¹¤ë¡×¤³¤È¤¬¤Ç¤­¤ë¤¬¡¢¤³¤Îɸ½à¤ÎSQLʸ(SELECT * FROM @TABLE@ WHERE 1)¤âÊѹ¹²Äǽ¤À¡£

¾åµ­¤Îconfig.default.php¤Î³ºÅö²Õ½ê¤ò½ñ¤­´¹¤¨¤ë¡£

/**
* Default query for table
*
* @global string $cfg['DefaultQueryTable']
*/
$cfg['DefaultQueryTable'] = 'SELECT * FROM @TABLE@ WHERE 1';

¥¤¥ó¥Ý¡¼¥È¤ÎºÇĹ¥µ¥¤¥º¤Ï¤ÎÊѹ¹¤Ï¤³¤ì¤é¤ÎÀßÄê¤Ç¤Ï¤Ç¤­¤Ê¤¤¤Î¤Ç¡¢

phpMyAdmin¤Ç¤Î¥¤¥ó¥Ý¡¼¥È¥Õ¥¡¥¤¥ë¤ÎºÇŤòÊѹ¹(Debian)¤ò»²¾È¤Î¤³¤È¡£
[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



key_buffer_size¤È¤Ï¡¢index¤Î¾ïÃóÎÌ¡£

¤³¤ì¤¬¥Ç¥Õ¥©¥ë¥È¤Ç¤Ï8MB¡©¤È¾®¤µ¤¹¤®¤ë¤Î¤Ç¡¢¤³¤ì¤òÄ´À°¤¹¤ë¡£

# ¥Ï¡¼¥É¥¦¥§¥¢¤¬ìÔÂô¤Ë¤Ê¤Ã¤¿¤È¤â¤¤¤¨¤ë¡£

­¡ ¥³¥Þ¥ó¥É¤Çroot¤Ç¥í¥°¥¤¥ó

­¢ MySQL¤Ë¥í¥°¥¤¥ó

mysql -u root -p

MySQL¤Ë¥í¥°¥¤¥ó¤¹¤ëºÝ¤Î¥Ñ¥¹¥ï¡¼¥É¤Ï­¡¤Î¥â¥Î¤Ç¡£

­£ key_buffer_size¤ÎÃͤòÄ´¤Ù¤ë

show variables like 'key_buffer_size' ;

+-----------------+----------+
| Variable_name | Value |
+-----------------+----------+
| key_buffer_size | 16777216 |
+-----------------+----------+
1 row in set (0.00 sec)

¤³¤Î»þ¤Î/etc/mysql/my.cnfÃæ¤Îµ­½Ò¤Ï

key_buffer = 16M

¤È¤Ê¤Ã¤Æ¤¤¤ë¡£

MySQL¤Î¥Ð¡¼¥¸¥ç¥ó¤Ë¤è¤Ã¤Æ¡©¤Ïkey_buffer_size¤È¤Ê¤Ã¤Æ¤¤¤ë¤³¤È¤â¤¢¤ë¡£

·å¶èÀÚ¤ê¤Ï

16,777,216(bytes)

¤Ê¤Î¤Ç¡¢¤³¤ì¤Ï

16(M)777(K)216(bytes)

¤Ç¤¢¤ê¡¢16MB¡£

¤È¤¤¤¦¤³¤È¤Ï¡¢my.cnfÃæ¤Îµ­½Ò¤Ç¡Ö16M¡×¤È¤¤¤¦É½¸½¤ÇOK¡©

­¤ my.cnf¤ò½ñ¤­´¹¤¨¤ÆUpload¤¹¤ë¡£

key_buffer = 512M

­¥ MySQL¤«¤é¥í¥°¥¢¥¦¥È¡£

mysql > exit

­¦ MySQL¤òºÆµ¯Æ°¤¹¤ë¡£

/etc/init.d/mysql restart

ºÆÅٰʲ¼¤ÇÃͤò³Îǧ¤¹¤ë¡£

show variables like 'key_buffer_size' ;

+-----------------+-----------+
| Variable_name | Value |
+-----------------+-----------+
| key_buffer_size | 536870912 |
+-----------------+-----------+
1 row in set (0.00 sec)

536,870,912(bytes)

536(M)870(K)912(bytes)

¤Ê¤ª¡¢»ä¤ÎÌäÂê¤Ë¤Ê¤Ã¤Æ¤¤¤ë´Ä¶­¤Ç¤Ï¡¢512M¤Ë¤·¤Æ¤â1M(1,048,576bytes)¤Ë¤·¤Æ¤âÊѲ½¤Ï¤Ê¤«¤Ã¤¿¡£

¾¤ÎÀßÄê¤ä¡¢SQLʸ¤Î¸«Ä¾¤·¤Ê¤É¤¬É¬Íפˤʤ롣

¤È¤ê¤¢¤¨¤º¤Ï256M(268,435,456bytes)¤Ë¤·¤Æ¤ª¤¤¤¿¡£

¤¢¤Þ¤êÂ礭¤¯¤·²á¤®¤ë¤È¥á¥â¥ê¤ò°µÇ÷¤¹¤ë¤Î¤Ç¡¢DebianüËö¤¬ÅëºÜ¤¹¤ëÁí¥á¥â¥êÍÆÎ̤γÎǧÊýË¡¤Ë¤è¤êÁí¥á¥â¥ê¤ò³Îǧ¤Î¾å¡¢Å¬Î̤ò³ä¤ê¿¶¤í¤¦¡£

¼ÂÁ©¥Ï¥¤¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹MySQL Âè3ÈÇ
Baron Schwartz Peter Zaitsev Vadim Tkachenko
¥ª¥é¥¤¥ê¡¼¥¸¥ã¥Ñ¥ó
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 56,487

[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯

¤³¤Î¥Ú¡¼¥¸¤Î¥È¥Ã¥×¥Ø