Superuser

Autor Thema: Konfig-Datei fuer mysqld  (Gelesen 26347 mal)

Offline signal_15

  • Sobl Master
  • ****
  • Beiträge: 426
    • Rechenzentrum Amper
Konfig-Datei fuer mysqld
« am: 09. April 2009, 14:54:37 »
Hi,

habe hier einen mysqld laufen und kann nicht sagen wo die 'my.cnf' liegt. ein 'find / -name my.cnf' findet rein gar nichts. und im startup skript steht auch nur 'mysqld --user=mysql'. ich finde auch keine 'my.ini'.

wie finde ich heraus mit welcher konfig der daemon laeuft?

ct,

sonnenblen.de - Das unabhängige Sun User Forum

Konfig-Datei fuer mysqld
« am: 09. April 2009, 14:54:37 »

Offline meik

  • Sobl Bachelor
  • ***
  • Beiträge: 187
Re: Konfig-Datei fuer mysqld
« Antwort #1 am: 09. April 2009, 15:02:16 »
Hi,

habe hier einen mysqld laufen und kann nicht sagen wo die 'my.cnf' liegt. ein 'find / -name my.cnf' findet rein gar nichts. und im startup skript steht auch nur 'mysqld --user=mysql'. ich finde auch keine 'my.ini'.

wie finde ich heraus mit welcher konfig der daemon laeuft?

ct,

Ich gehe mal von Solaris aus, unter Linux gibts aber vergleichbare Befehle:

  • mit pargs schauen, welche Parameter der Prozess übergeben bekommen hat
  • mit pfiles in den laufenden Prozess rein schauen, ob es ein offenes Filehandle zur my.cnf gibt

Offline signal_15

  • Sobl Master
  • ****
  • Beiträge: 426
    • Rechenzentrum Amper
Re: Konfig-Datei fuer mysqld
« Antwort #2 am: 09. April 2009, 15:26:26 »
wow, 'pargs' bringt mir das selbe wie ein freundliches 'ps -ef'.-)
ismine/Download# ps -ef | grep sql
   mysql 25718     1  0   Nov 06 ?       701:52 /usr/local/mysql/libexec/mysqld --user=mysql
ismine/Download# pargs 25718
25718:  /usr/local/mysql/libexec/mysqld --user=mysql
argv[0]: /usr/local/mysql/libexec/mysqld
argv[1]: --user=mysql

und pfiles bringt mir nichts nuetzliches.-(
ismine/Download# pfiles 25718
25718:  /usr/local/mysql/libexec/mysqld --user=mysql
  Current rlimit: 500 file descriptors
   0: S_IFCHR mode:0666 dev:136,0 ino:3263 uid:0 gid:3 rdev:13,2
      O_RDONLY|O_LARGEFILE
   1: S_IFCHR mode:0666 dev:136,0 ino:19597 uid:0 gid:0 rdev:24,4
      O_RDWR|O_LARGEFILE
   2: S_IFCHR mode:0666 dev:136,0 ino:19597 uid:0 gid:0 rdev:24,4
      O_RDWR|O_LARGEFILE
   3: S_IFREG mode:0660 dev:136,0 ino:221698 uid:103 gid:103 size:18874368
      O_RDWR|O_LARGEFILE
   4: S_IFREG mode:0600 dev:136,15 ino:4740 uid:103 gid:1 size:0
      O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE
   5: S_IFREG mode:0600 dev:136,15 ino:1514957 uid:103 gid:1 size:20
      O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE
   6: S_IFREG mode:0600 dev:136,15 ino:1514959 uid:103 gid:1 size:0
      O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE
   7: S_IFREG mode:0600 dev:136,15 ino:1514960 uid:103 gid:1 size:0
      O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE
   8: S_IFREG mode:0660 dev:136,0 ino:221699 uid:103 gid:103 size:5242880
      O_RDWR|O_LARGEFILE
   9: S_IFREG mode:0660 dev:136,0 ino:221700 uid:103 gid:103 size:5242880
      O_RDWR|O_LARGEFILE
  10: S_IFSOCK mode:0666 dev:283,0 ino:56730 uid:0 gid:0 size:0
      O_RDWR
        sockname: AF_INET 0.0.0.0  port: 3306
  11: S_IFREG mode:0600 dev:136,15 ino:1514961 uid:103 gid:1 size:0
      O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE
  12: S_IFSOCK mode:0666 dev:283,0 ino:6062 uid:0 gid:0 size:0
      O_RDWR
        sockname: AF_UNIX /tmp/mysql.sock
  14: S_IFREG mode:0660 dev:136,0 ino:221845 uid:103 gid:1 size:18432
      O_RDWR|O_LARGEFILE
  15: S_IFREG mode:0660 dev:136,0 ino:225792 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
  16: S_IFREG mode:0660 dev:136,0 ino:225795 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
  17: S_IFREG mode:0660 dev:136,0 ino:221815 uid:103 gid:1 size:12288
      O_RDWR|O_LARGEFILE
  18: S_IFREG mode:0660 dev:136,0 ino:221875 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
  19: S_IFREG mode:0660 dev:136,0 ino:225816 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
  20: S_IFREG mode:0660 dev:136,0 ino:221851 uid:103 gid:1 size:3072
      O_RDWR|O_LARGEFILE
  21: S_IFREG mode:0660 dev:136,0 ino:221852 uid:103 gid:1 size:736
      O_RDWR|O_LARGEFILE
  22: S_IFREG mode:0660 dev:136,0 ino:225706 uid:103 gid:1 size:10240
      O_RDWR|O_LARGEFILE
  23: S_IFREG mode:0660 dev:136,0 ino:225810 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
  24: S_IFREG mode:0660 dev:136,0 ino:221872 uid:103 gid:1 size:3072
      O_RDWR|O_LARGEFILE
  25: S_IFREG mode:0660 dev:136,0 ino:221896 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
  26: S_IFREG mode:0660 dev:136,0 ino:221863 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
  27: S_IFREG mode:0660 dev:136,0 ino:221846 uid:103 gid:1 size:48176
      O_RDWR|O_LARGEFILE
  28: S_IFREG mode:0660 dev:136,0 ino:225811 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
  29: S_IFREG mode:0660 dev:136,0 ino:221854 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
  30: S_IFREG mode:0660 dev:136,0 ino:225801 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
  31: S_IFREG mode:0660 dev:136,0 ino:225802 uid:103 gid:1 size:1428
      O_RDWR|O_LARGEFILE
  32: S_IFREG mode:0660 dev:136,0 ino:225793 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
  33: S_IFREG mode:0660 dev:136,0 ino:221860 uid:103 gid:1 size:3072
      O_RDWR|O_LARGEFILE
  34: S_IFREG mode:0660 dev:136,0 ino:221855 uid:103 gid:1 size:26
      O_RDWR|O_LARGEFILE
  35: S_IFREG mode:0660 dev:136,0 ino:225789 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
  36: S_IFREG mode:0660 dev:136,0 ino:225796 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
  37: S_IFREG mode:0660 dev:136,0 ino:225691 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
  38: S_IFREG mode:0660 dev:136,0 ino:225742 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
  39: S_IFREG mode:0660 dev:136,0 ino:225692 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
  40: S_IFREG mode:0660 dev:136,0 ino:221873 uid:103 gid:1 size:1528
      O_RDWR|O_LARGEFILE
  41: S_IFREG mode:0660 dev:136,0 ino:221861 uid:103 gid:1 size:56
      O_RDWR|O_LARGEFILE
  42: S_IFREG mode:0660 dev:136,0 ino:225743 uid:103 gid:1 size:53
      O_RDWR|O_LARGEFILE
  43: S_IFREG mode:0660 dev:136,0 ino:225817 uid:103 gid:1 size:1132
      O_RDWR|O_LARGEFILE
  44: S_IFREG mode:0660 dev:136,0 ino:221869 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
  45: S_IFREG mode:0660 dev:136,0 ino:221830 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
  46: S_IFREG mode:0660 dev:136,0 ino:221897 uid:103 gid:1 size:3164
      O_RDWR|O_LARGEFILE
  47: S_IFREG mode:0660 dev:136,0 ino:225798 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
  48: S_IFREG mode:0660 dev:136,0 ino:225804 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
  49: S_IFREG mode:0660 dev:136,0 ino:225805 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
  50: S_IFREG mode:0660 dev:136,0 ino:225807 uid:103 gid:1 size:8192
      O_RDWR|O_LARGEFILE
  51: S_IFREG mode:0660 dev:136,0 ino:225808 uid:103 gid:1 size:1580
      O_RDWR|O_LARGEFILE
  52: S_IFREG mode:0660 dev:136,0 ino:225707 uid:103 gid:1 size:1336864
      O_RDWR|O_LARGEFILE
  53: S_IFREG mode:0660 dev:136,0 ino:225774 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
  54: S_IFREG mode:0660 dev:136,0 ino:225712 uid:103 gid:1 size:20480
      O_RDWR|O_LARGEFILE
  55: S_IFREG mode:0660 dev:136,0 ino:225813 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
  56: S_IFREG mode:0660 dev:136,0 ino:225799 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
  57: S_IFREG mode:0660 dev:136,0 ino:225780 uid:103 gid:1 size:5120
      O_RDWR|O_LARGEFILE
  58: S_IFREG mode:0660 dev:136,0 ino:225781 uid:103 gid:1 size:248
      O_RDWR|O_LARGEFILE
  59: S_IFREG mode:0660 dev:136,0 ino:221857 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
  60: S_IFREG mode:0660 dev:136,0 ino:225718 uid:103 gid:1 size:13312
      O_RDWR|O_LARGEFILE
  61: S_IFREG mode:0660 dev:136,0 ino:221858 uid:103 gid:1 size:348
      O_RDWR|O_LARGEFILE
  62: S_IFREG mode:0660 dev:136,0 ino:225736 uid:103 gid:1 size:53248
      O_RDWR|O_LARGEFILE
  63: S_IFREG mode:0660 dev:136,0 ino:225777 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
  64: S_IFREG mode:0660 dev:136,0 ino:221864 uid:103 gid:1 size:1404
      O_RDWR|O_LARGEFILE
  65: S_IFREG mode:0660 dev:136,0 ino:225745 uid:103 gid:1 size:5120
      O_RDWR|O_LARGEFILE
  67: S_IFREG mode:0660 dev:136,0 ino:225786 uid:103 gid:1 size:6144
      O_RDWR|O_LARGEFILE
  68: S_IFREG mode:0660 dev:136,0 ino:225775 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
  69: S_IFREG mode:0660 dev:136,0 ino:221864 uid:103 gid:1 size:1404
      O_RDWR|O_LARGEFILE
  70: S_IFREG mode:0660 dev:136,0 ino:221818 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
  71: S_IFREG mode:0660 dev:136,0 ino:225719 uid:103 gid:1 size:3804
      O_RDWR|O_LARGEFILE
  72: S_IFREG mode:0660 dev:136,0 ino:225746 uid:103 gid:1 size:72
      O_RDWR|O_LARGEFILE
  73: S_IFREG mode:0660 dev:136,0 ino:225778 uid:103 gid:1 size:644
      O_RDWR|O_LARGEFILE
  74: S_IFREG mode:0660 dev:136,0 ino:221824 uid:103 gid:1 size:24576
      O_RDWR|O_LARGEFILE
  75: S_IFREG mode:0660 dev:136,0 ino:221825 uid:103 gid:1 size:45844
      O_RDWR|O_LARGEFILE
  76: S_IFREG mode:0660 dev:136,0 ino:225763 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
  77: S_IFREG mode:0660 dev:136,0 ino:221866 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
  78: S_IFREG mode:0660 dev:136,0 ino:225787 uid:103 gid:1 size:3572
      O_RDWR|O_LARGEFILE
  79: S_IFREG mode:0660 dev:136,0 ino:225814 uid:103 gid:1 size:176
      O_RDWR|O_LARGEFILE
  80: S_IFREG mode:0660 dev:136,0 ino:225713 uid:103 gid:1 size:13588
      O_RDWR|O_LARGEFILE
  81: S_IFREG mode:0660 dev:136,0 ino:225764 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
  82: S_IFREG mode:0660 dev:136,0 ino:221884 uid:103 gid:1 size:3072
      O_RDWR|O_LARGEFILE
  83: S_IFREG mode:0660 dev:136,0 ino:221876 uid:103 gid:1 size:1416
      O_RDWR|O_LARGEFILE
  84: S_IFREG mode:0660 dev:136,0 ino:221885 uid:103 gid:1 size:4508
      O_RDWR|O_LARGEFILE
  85: S_IFREG mode:0660 dev:136,0 ino:221893 uid:103 gid:1 size:3072
      O_RDWR|O_LARGEFILE
  86: S_IFREG mode:0660 dev:136,0 ino:225737 uid:103 gid:1 size:42700
      O_RDWR|O_LARGEFILE
  87: S_IFREG mode:0660 dev:136,0 ino:225771 uid:103 gid:1 size:3072
      O_RDWR|O_LARGEFILE
  88: S_IFREG mode:0660 dev:136,0 ino:221839 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
  89: S_IFREG mode:0660 dev:136,0 ino:225772 uid:103 gid:1 size:168
      O_RDWR|O_LARGEFILE
  90: S_IFREG mode:0660 dev:136,0 ino:225822 uid:103 gid:1 size:3072
      O_RDWR|O_LARGEFILE
  91: S_IFREG mode:0660 dev:136,0 ino:225819 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
  92: S_IFREG mode:0660 dev:136,0 ino:225820 uid:103 gid:1 size:112
      O_RDWR|O_LARGEFILE
  93: S_IFREG mode:0660 dev:136,0 ino:225823 uid:103 gid:1 size:240
      O_RDWR|O_LARGEFILE
  94: S_IFREG mode:0660 dev:136,0 ino:225825 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
  95: S_IFREG mode:0660 dev:136,0 ino:225694 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
  96: S_IFREG mode:0660 dev:136,0 ino:221812 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
  98: S_IFREG mode:0660 dev:136,0 ino:225695 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
  99: S_IFREG mode:0660 dev:136,0 ino:225715 uid:103 gid:1 size:6144
      O_RDWR|O_LARGEFILE
 100: S_IFREG mode:0660 dev:136,0 ino:221894 uid:103 gid:1 size:231
      O_RDWR|O_LARGEFILE
 101: S_IFREG mode:0660 dev:136,0 ino:225716 uid:103 gid:1 size:72
      O_RDWR|O_LARGEFILE
 103: S_IFREG mode:0660 dev:136,0 ino:221831 uid:103 gid:1 size:432
      O_RDWR|O_LARGEFILE
 104: S_IFREG mode:0660 dev:136,0 ino:221890 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
 105: S_IFREG mode:0660 dev:136,0 ino:221840 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
 106: S_IFREG mode:0660 dev:136,0 ino:221870 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
 107: S_IFREG mode:0660 dev:136,0 ino:221891 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
 108: S_IFREG mode:0660 dev:136,0 ino:221887 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
 109: S_IFREG mode:0660 dev:136,0 ino:225826 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
 110: S_IFREG mode:0660 dev:136,0 ino:221878 uid:103 gid:1 size:3072
      O_RDWR|O_LARGEFILE
 111: S_IFREG mode:0660 dev:136,0 ino:221879 uid:103 gid:1 size:1148
      O_RDWR|O_LARGEFILE
 112: S_IFREG mode:0660 dev:136,0 ino:221821 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
 113: S_IFREG mode:0660 dev:136,0 ino:221842 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
 114: S_IFREG mode:0660 dev:136,0 ino:221843 uid:103 gid:1 size:80
      O_RDWR|O_LARGEFILE
 115: S_IFREG mode:0660 dev:136,0 ino:221813 uid:103 gid:1 size:100
      O_RDWR|O_LARGEFILE
 116: S_IFREG mode:0660 dev:136,0 ino:221816 uid:103 gid:1 size:5312
      O_RDWR|O_LARGEFILE
 117: S_IFREG mode:0660 dev:136,0 ino:221819 uid:103 gid:1 size:1396
      O_RDWR|O_LARGEFILE
 118: S_IFREG mode:0660 dev:136,0 ino:221888 uid:103 gid:1 size:220
      O_RDWR|O_LARGEFILE
 119: S_IFREG mode:0660 dev:136,0 ino:221867 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
 123: S_IFREG mode:0660 dev:136,0 ino:221833 uid:103 gid:1 size:3072
      O_RDWR|O_LARGEFILE
 124: S_IFREG mode:0660 dev:136,0 ino:221773 uid:103 gid:1 size:3072
      O_RDWR|O_LARGEFILE
 125: S_IFREG mode:0660 dev:136,0 ino:221774 uid:103 gid:1 size:3444
      O_RDWR|O_LARGEFILE
 126: S_IFREG mode:0660 dev:136,0 ino:225783 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
 127: S_IFREG mode:0660 dev:136,0 ino:221846 uid:103 gid:1 size:48176
      O_RDWR|O_LARGEFILE
 128: S_IFREG mode:0660 dev:136,0 ino:221899 uid:103 gid:1 size:1024
      O_RDWR|O_LARGEFILE
 130: S_IFREG mode:0660 dev:136,0 ino:221881 uid:103 gid:1 size:3072
      O_RDWR|O_LARGEFILE
 131: S_IFREG mode:0660 dev:136,0 ino:221882 uid:103 gid:1 size:6404
      O_RDWR|O_LARGEFILE
 132: S_IFREG mode:0660 dev:136,0 ino:221788 uid:103 gid:1 size:16384
      O_RDWR|O_LARGEFILE
 133: S_IFREG mode:0660 dev:136,0 ino:221789 uid:103 gid:1 size:21416
      O_RDWR|O_LARGEFILE
 134: S_IFREG mode:0660 dev:136,0 ino:221834 uid:103 gid:1 size:98
      O_RDWR|O_LARGEFILE
 135: S_IFREG mode:0660 dev:136,0 ino:221836 uid:103 gid:1 size:3072
      O_RDWR|O_LARGEFILE
 137: S_IFREG mode:0660 dev:136,0 ino:221837 uid:103 gid:1 size:91
      O_RDWR|O_LARGEFILE
 138: S_IFREG mode:0660 dev:136,0 ino:221827 uid:103 gid:1 size:3072
      O_RDWR|O_LARGEFILE
 139: S_IFREG mode:0660 dev:136,0 ino:221828 uid:103 gid:1 size:704
      O_RDWR|O_LARGEFILE
 140: S_IFREG mode:0660 dev:136,0 ino:221900 uid:103 gid:1 size:21
      O_RDWR|O_LARGEFILE
 141: S_IFREG mode:0660 dev:136,0 ino:225828 uid:103 gid:1 size:2048
      O_RDWR|O_LARGEFILE
 142: S_IFREG mode:0660 dev:136,0 ino:221822 uid:103 gid:1 size:273
      O_RDWR|O_LARGEFILE
 143: S_IFREG mode:0660 dev:136,0 ino:225829 uid:103 gid:1 size:44
      O_RDWR|O_LARGEFILE
 144: S_IFREG mode:0660 dev:136,0 ino:225784 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE
 145: S_IFREG mode:0660 dev:136,0 ino:225790 uid:103 gid:1 size:0
      O_RDWR|O_LARGEFILE

ct,

Offline tassilo

  • Sobl Master
  • ****
  • Beiträge: 437
    • Freie Jobbörse rund um Linux
Re: Konfig-Datei fuer mysqld
« Antwort #3 am: 13. April 2009, 09:45:30 »
hi

imho werden die defaultwerte genommen die mysql zur "compilierzeit" mitbekommen hat und dann mir den werten aus der config datei überschrieben. also würd ich sagen wenn keine config gefunden wird rennt er mit diesen defaultwerten.
mich wundert es aber das mysql ohne config startet ohne nicht mal zu meckern...

ansonsten log dich doch in mysql ein und lass dir die ganzen settings anzeigen...

und wenn es wirklich keine config gibt dann erzeug einfach eine und gib die bei den init script an.

grüße

tassilo