OESF Portables Forum
Model Specific Forums => Sharp Zaurus => Zaurus - pdaXrom => Topic started by: pmf on November 06, 2004, 02:11:48 pm
-
I have made my MySQL 4.1.17 packages available in the unstable-feed.
mysql-client
mysql-server
To start the server: /etc/rc.d/init.d/mysqld start
To stop it: /etc/rc.d/init.d/mysqld stop
The default user is 'nobody'; the postinst script sets permissions accordingly.
If you decide to create a dedicated user/group, do a chown -R user:group /opt/mysql/var
Don't expect good performance, it is MySQL.
-
Don't expect good performance, it is MySQL.
Is this what you mean by poor performance?
Someone please correct me if I'm wrong, but this looks like mysqld is taking up 12MB ram, which is 20% of the memory... that's not good
When I had the cacko rom flashed on my 760, I had mysql running on it, and I don't remember seeing this kinda of performance (it was much less resource intensive)... granted the cacko rom doesn't have top to prove it.. but it didn't 'feel' this slow...
-
Mine is bad as well. I think that's a mysql issue though. Checking on my server and SQL is taking up 13mb's there as well.
-
Don't expect good performance, it is MySQL.
Is this what you mean by poor performance?
Someone please correct me if I'm wrong, but this looks like mysqld is taking up 12MB ram, which is 20% of the memory... that's not good
You can always play around with the values in /etc/my.cnf and decrease buffer/logfile sizes and/or the number of spawned child processes. Note that there is no way to decrease the memory-footprint below 4MB, since the mysqld-binary is of that size.
If you feel like trying it out, I recommend this page for further configuration of MySQL (http://dev.mysql.com/doc/mysql/en/Server_parameters.html).
These options will have to be added to the /etc/rc.d/init.d/mysqld script.
If you find a configuration that both scales and is memory conservative, I will happily include it in the package instead of the current configuration (which is simply the "tiny" configuration of the source-distribution).
(If you really care about size and performance, use SQLite (as soon as they switch to PHP 5.0.x, this will become the default database for most hosting companies)).