Opened by Gustl at 2013-10-26 10:26
User since
2011-01-27
443 Artikel
BenutzerIn
![[Homepage]](/battie/theme/default/homepage.gif)
2011-01-27
443 Artikel
BenutzerIn
Hallo,
ich habe diesen RaspberryPi also 700MHz mit 512MB.
Zu deinen Tipps:
Also 329424, was sagt mir diese Zahl denn?
hdparm hab ich wohl nicht:
Wieviele Prozesse/Threads mysqld laufen lässt weiß ich nicht, wie lese ich das aus?
Ich erwarte nicht viel, aber ich möchte schon das Mögliche, wenns geht, herausholen. Wenn es nicht geht, bin ich auch so zufrieden. :)
Gruß
ich habe diesen RaspberryPi also 700MHz mit 512MB.
Zu deinen Tipps:
Code: (dl
)
1
2
root@raspberrypi:/home/pi# ps aux | grep /sbin/mysqld | grep -v grep | awk '{print $5}'
329424Also 329424, was sagt mir diese Zahl denn?
hdparm hab ich wohl nicht:
Code: (dl
)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
root@raspberrypi:/home/pi# perl /var/www/mysqltuner.pl
>> MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
[OK] Logged in using credentials from debian maintenance account.
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.31-0+wheezy1
[OK] Operating on 32-bit architecture with less than 2GB RAM
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 28B (Tables: 10)
[--] Data in InnoDB tables: 2M (Tables: 8)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 8
-------- Security Recommendations -------------------------------------------
[!!] User '@localhost' has no password set.
[!!] User '@raspberrypi' has no password set.
-------- Performance Metrics -------------------------------------------------
[--] Up for: 5h 49m 20s (1K q [0.048 qps], 64 conn, TX: 394K, RX: 148K)
[--] Reads / Writes: 100% / 0%
[--] Total buffers: 192.0M global + 2.7M per thread (151 max threads)
[!!] Maximum possible memory usage: 597.8M (136% of installed RAM)
[OK] Slow queries: 0% (0/1K)
[OK] Highest usage of available connections: 1% (2/151)
[OK] Key buffer size / total MyISAM indexes: 16.0M/123.0K
[!!] Key buffer hit rate: 75.0% (8 cached / 2 reads)
[!!] Query cache efficiency: 11.6% (107 cached / 919 selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 69 sorts)
[OK] Temporary tables created on disk: 25% (110 on disk / 435 total)
[OK] Thread cache hit rate: 96% (2 created / 64 connections)
[OK] Table cache hit rate: 25% (64 open / 248 opened)
[OK] Open file limit used: 6% (68/1K)
[OK] Table locks acquired immediately: 100% (328 immediate / 328 locks)
[OK] InnoDB data size / buffer pool: 2.8M/128.0M
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Reduce your overall MySQL memory footprint for system stability
Enable the slow query log to troubleshoot bad queries
Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
query_cache_limit (> 1M, or use smaller result sets)
Wieviele Prozesse/Threads mysqld laufen lässt weiß ich nicht, wie lese ich das aus?
Ich erwarte nicht viel, aber ich möchte schon das Mögliche, wenns geht, herausholen. Wenn es nicht geht, bin ich auch so zufrieden. :)
Gruß