Software > Datenbanken
Konfig-Datei fuer mysqld
(1/1)
signal_15:
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,
meik:
--- Zitat von: signal_15 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,
--- Ende Zitat ---
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
signal_15:
wow, 'pargs' bringt mir das selbe wie ein freundliches 'ps -ef'.-)
--- Code: ---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
--- Ende Code ---
und pfiles bringt mir nichts nuetzliches.-(
--- Code: ---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
--- Ende Code ---
ct,
tassilo:
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
Navigation
[0] Themen-Index
Zur normalen Ansicht wechseln