InnoDB | Forum profile

Aftab, aren't those two synonyms? Recommend checking for errors after each call to mysql_query. Perhaps there is an error that you missed. Such as spelling error in mysql_query("START TRANACTION")

UPDATE: One more. I've read that it better to use innodb_file_per_table if there are a small number of tables in DB. How much table is this? I have about 150 tables in my DB. If it suitable for my case, how to set this parameter on exist DB? first take backup using mysqldump edit my.cnf add the following innodb_file_per_table =1 restart drop database create database restore database That is it

Hi, can you tell me where the user connection handler threads open the data files in the source code? I read the code and find that in the fil_io functions, the function fil_node_prepare_for_io will be called, and in this function, fil_node_open_file is called, the functions that involed with the operation of open or create the data files are os_file_create_simple_no_error_handling ( for innodb_file_per_talbe data files) and os_file_create,...

kevin foote Wrote: ------------------------------------------------------- > > Just now via /etc/security/limits.conf I've set > the following for mysql user > > mysql hard memlock 524288 > > This should give that user ~ 5G available to pure > RAM > OK that turned out very wrong.. I set the memlock setting and adjusted the hugepages type stuff in sysctl.conf #vm.nr_hugepages =...

Thanks for all the valuable information Rick! I converted a single table to use InnoDB, the conversion took 0.09s since it has 8000 rows in it, most of work is done on that specific table I guess, that's the user table. Just by converting I can say that I notice a performance difference, probably because of the way the two engines perform lockings. But still, 25 concurrent users may cause my web server to respond in more than 12 seconds,...

Thanks Rick but I am not sure I follow. I do not have any buttons on my site that change settings and this was not an issue until upgrading. Now, I get tons of errors related to the Procedure Cache. It looks like there is something wrong with the threading and a request to run a stored procedure comes in and the processing for that starts and then another request for the same stored procecure comes in and they are getting each other...

I think you are missing one key step here. i.e. mysql_query("START TRANSACTION", $this->connection); mysql_query("BEGIN", $this->connection); . . Regards, Aftab Edited 1 time(s). Last edit at 12/03/2009 07:43AM by Aftab Khan.

The InnoDB team is pleased to announce the availability of InnoDB Plugin 1.0.6. This new release includes a number of bug fixes and improvements, see the InnoDB Plugin Change History or the online ChangeLog for details. As usual, the InnoDB Plugin 1.0.6 can be downloaded from the download page . Notice that the previous version released by Innobase was 1.0.4. An intermediate version 1.0.5 is distributed by Sun inside MySQL 5.1.41. Please...

Hi, is there a possibility to monitor the usage of the buffer pool in more detail, so that indicators like the number of occupied pages and the cache hit ratio are reported separately for index pages and data pages? The reason for my question is this: I always had the imagination, that the index pages would somehow have a higher priority or "stickiness" in the innodb buffer pool. From what I have read in the mysql...