Tag Info

New answers tagged

0

To change innodb_log_file_size do following Stop MySQL gracefully. Check the error log and make sure it was "Normal shutdown", no crashes, no errors etc. Move existing ib_logfile* to safe place. You will need them if you want to roll back Change innodb_log_file_size in my.cnf to the new value Start MySQL. InnoDB will notice there are no ib_logfile* and ...


0

Why don't your input parameters match the type for the table? Why would you want to keep the wrong types there and perform any casts or conversions at all (whether implicit or explicit)? Why are you converting anything to FLOAT, of all things? To address specific questions: My query says [low] is being converted from int to numeric but that doesn't seem ...


0

Your key_buffer_size is way too big. Since your MyISAM indexes is that small, set it to 128K. You need to open my.cnf and add this under the [mysqld] group header [mysqld] key_buffer_size = 128K; You don't need to restart mysql. Just run this SET GLOBAL key_buffer_size = 1024 * 128; Give it a Try !!! Based on the mysqltuner output, you can drop the ...


0

I Think bitwise operator are the best way to implement user permission. Here I am showing how we can implement it with Mysql. Below is a sample tables with some sample data: Table 1 : Permission table to store permission name along with it bit like 1,2,4,8..etc (multiple of 2) CREATE TABLE IF NOT EXISTS `permission` ( `bit` int(11) NOT NULL, `name` ...



Top 50 recent answers are included