Hello, by default, where is your swap file? Do I need to change it?  Do I need to change swap file size?

 

Thanks

 

I did not change anything about swap file neither location nor size. It depends to your usage and your ram. I have 4gb ram and i use mysql for xbmc database (800 movies, 2000-3000 episodes of tv series and some music files)

Whenever I try to apply a setting, I get this error:

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /usr/local/emhttp/plugins/mysql/mysqlctl.php on line 78

Hello,

 

I am revisiting on setting up MySQL on my unRAID system. I need to rebuild my Virtual Host and need to move the database from the VM to unRAID. I have your plugin installed and running. But I am not able to get the XBMC system to connect. Here is what I see in the error log:

 

140620 20:29:38 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended
140620 20:33:56 mysqld_safe Starting mysqld daemon with databases from /mnt/cache/Services/mysql
/usr/sbin/mysqld: /usr/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld)
140620 20:33:56 InnoDB: The InnoDB memory heap is disabled
140620 20:33:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140620 20:33:56 InnoDB: Compressed tables use zlib 1.2.5
140620 20:33:56 InnoDB: Using Linux native AIO
140620 20:33:56 InnoDB: Initializing buffer pool, size = 128.0M
140620 20:33:56 InnoDB: Completed initialization of buffer pool
140620 20:33:56 InnoDB: highest supported file format is Barracuda.
140620 20:33:56 InnoDB: Waiting for the background threads to start
140620 20:33:57 InnoDB: 5.5.30 started; log sequence number 1595675
140620 20:33:57 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140620 20:33:57 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140620 20:33:57 [Note] Server socket created on IP: '0.0.0.0'.
140620 20:33:57 [Note] Event Scheduler: Loaded 0 events
140620 20:33:57 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.30-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
140620 20:35:53 [Warning] IP address '192.168.1.39' could not be resolved: Name or service not known

 

Is there something I need to change or check?

Trying this one out too, at first had the same problem when trying to start manually with /etc/rc.d/rc.mysqld:

 

"Error! the server quit without updating pid file (/var/run/mysqld/mysqld.pid)"

 

Noticed there was no /etc/my.cnf file created. Tried again with Enable MySQL: Yes and hitting "Apply". Suddenly started as indicated by the instructions:

 

7) click apply (this should start your myqsl server if you choose "Enable MySQL:" "Yes")

 

Just posting for others like me who assume hitting "Save" followed by "Start" the first time will do the trick. Reading the instructions does help sometimes ...