RE: MySQL On ipv6
Pramod: I want to know whether MySQL Server runs on ipv6 machine. Apparently, IPv6 is going to be a version 6 feature: http://bugs.mysql.com/bug.php?id=8836 Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL driven app on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Is LOAD INDEX INTO CACHE replicated?
Thank you for the answer. This makes sense. As such, the questions of preloading the key buffer in a replication system are probably resolved. I think I can safely put CACHE INDEX and LOAD INDEX INTO CACHE statements in the --init-file of both masters and slaves. tom On 11/29/09 8:39 AM, Johan De Meersman vegiv...@tuxera.be wrote: They're not data modification statements, so no, they're not replicated. On Sun, Nov 29, 2009 at 2:06 AM, Tom Worster f...@thefsb.org wrote: Are SQL statements like CACHE INDEX or LOAD INDEX INTO CACHE replicated? If so, is there a way to prevent that replication? If a slave mysqld restarts, wouldn't it need to execute CACHE INDEX and LOAD INDEX INTO CACHE statements from its --init-file? And if a master mysql restarts, would the slave execute CACHE INDEX and LOAD INDEX INTO CACHE statements the master reads from its --init-file and writes to the big-log? tom -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
error creating table
Hi, I'm developing a CMS, in which I have 3 tables user, roles and userRoles. Here is the code for userRoles table. on this I'm getting error creating table (error code 1005), both userid and roleid are pkey (int, auto increment) CREATE TABLE IF NOT EXISTS `mydb`.`UserRole` ( `roleid` INT(10) UNSIGNED NOT NULL , `userid` INT(10) UNSIGNED NOT NULL , PRIMARY KEY (`roleid`, `userid`) , INDEX `fk_userid` (`userid` ASC) , INDEX `fk_roleid` (`roleid` ASC) , CONSTRAINT `fk_userid` FOREIGN KEY (`userid` ) REFERENCES `mydb`.`Users` (`userid` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid` ) REFERENCES `mydb`.`Roles` (`roleid` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci; -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ Peace is the Ultimate thing we want. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: error creating table
I created dummy tables for Roles and Users specifying the primary keys as 'serial' and then tried the below syntax. It failed. Then I redefined the primary keys in the parent tables to be the exact same type as the foreign keys in UserRole and it worked. So, check the datatype of all your keys and make sure they match. On Mon, Nov 30, 2009 at 11:50 AM, Sharique uddin Ahmed Farooqui saf...@gmail.com wrote: Hi, I'm developing a CMS, in which I have 3 tables user, roles and userRoles. Here is the code for userRoles table. on this I'm getting error creating table (error code 1005), both userid and roleid are pkey (int, auto increment) CREATE TABLE IF NOT EXISTS `mydb`.`UserRole` ( `roleid` INT(10) UNSIGNED NOT NULL , `userid` INT(10) UNSIGNED NOT NULL , PRIMARY KEY (`roleid`, `userid`) , INDEX `fk_userid` (`userid` ASC) , INDEX `fk_roleid` (`roleid` ASC) , CONSTRAINT `fk_userid` FOREIGN KEY (`userid` ) REFERENCES `mydb`.`Users` (`userid` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid` ) REFERENCES `mydb`.`Roles` (`roleid` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci; -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ Peace is the Ultimate thing we want. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
MySQL shutting down because of Operating system error 1784
Hi, We are getting InnoDB: Operating system error number 1784 error on MySQL and it just shuts down after getting the error. This happens once every 2 days or so. We are using MySQL 5.0.51b-community-nt. I was wondering if anyone had this problem before? Here's the full error output: InnoDB: Operating system error number 1784 in a file operation. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html InnoDB: File name D:\MySQLlog\ib_logfile0 InnoDB: File operation call: 'Windows aio'. InnoDB: Cannot continue operation. InnoDB: Log scan progressed past the checkpoint lsn 35 1443981126 Is it because of not being able to write log files for some reason? Is InnoDB logs required? Thanks! Cagdas
RE: MySQL shutting down because of Operating system error 1784
If you have a lot of InnoDB transactions, maybe your ib_logfile0 and ib_logfile1 are too small. Transactional data are written in these files in a circular fashion. You may have run out of space in these. If you want to make these files bigger, simply do the following: 1) Use the setting innodb_log_file_size=Number in my.ini 2) net stop mysql 3) del D:\MySQLlog\ib_logfile* 4) net start mysql (during startup of mysqld, ib_logfile0 and ib_logfile1 are recreated) As a rule of thumb, set innodb_log_file_size = (25% of innodb_buffer_pool_size) BTW the combined total of all ib_logfiles cannot exceed 4GB. Example: if innodb_buffer_pool_size=1G, then set innodb_log_file_size=256M Example: if innodb_buffer_pool_size=512M, then set innodb_log_file_size=128M Example: if innodb_buffer_pool_size=256M, then set innodb_log_file_size=64M Etc... Rolando A. Edwards MySQL DBA (SCMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -Original Message- From: Cagdas CUBUKCU [mailto:cagdascubu...@gmail.com] Sent: Monday, November 30, 2009 1:19 PM To: mysql@lists.mysql.com Subject: MySQL shutting down because of Operating system error 1784 Hi, We are getting InnoDB: Operating system error number 1784 error on MySQL and it just shuts down after getting the error. This happens once every 2 days or so. We are using MySQL 5.0.51b-community-nt. I was wondering if anyone had this problem before? Here's the full error output: InnoDB: Operating system error number 1784 in a file operation. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html InnoDB: File name D:\MySQLlog\ib_logfile0 InnoDB: File operation call: 'Windows aio'. InnoDB: Cannot continue operation. InnoDB: Log scan progressed past the checkpoint lsn 35 1443981126 Is it because of not being able to write log files for some reason? Is InnoDB logs required? Thanks! Cagdas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL shutting down because of Operating system error 1784
Cagdas CUBUKCU cagdascubukcu at gmail.com writes: Hi, We are getting InnoDB: Operating system error number 1784 error on MySQL and it just shuts down after getting the error. http://msdn.microsoft.com/en-us/library/cc500408.aspx # ERROR_INVALID_USER_BUFFER or ERROR_NOT_ENOUGH_MEMORY Each device driver maintains a fixed-size list (in a nonpaged pool) of outstanding I/O requests. If this list is full, the system can’t queue your request, ReadFile and WriteFile return FALSE, and GetLast-Error reports one of these two error codes (depending on the driver). Apart from increasing your log file size, can you check the number of i/o processes and if some other process is doing i/o as well. I think windows has some processonitor for this. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Innodb buffer pool size filling up
Machiel: We have a MySQL database where the INNODB_BUFFER_POOL_SIZE keeps on filling up. Are you getting any errors or just noticing the buffer pool is full? I saw some error messages about the buffer pool size becoming a problem if the fscync is slow. Do you see any more info in the logs? Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Innodb buffer pool size filling up
There are no errors in the logs at all. We have a script to calculate the percentages used and free in order to do daily,weekly and monthly reporting trend analyses and thus we notice the growth but no errors. -Original Message- From: Neil Aggarwal [mailto:n...@jammconsulting.com] Sent: 01 December 2009 08:55 AM To: mysql@lists.mysql.com Subject: RE: Innodb buffer pool size filling up Machiel: We have a MySQL database where the INNODB_BUFFER_POOL_SIZE keeps on filling up. Are you getting any errors or just noticing the buffer pool is full? I saw some error messages about the buffer pool size becoming a problem if the fscync is slow. Do you see any more info in the logs? Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=machiel.richa...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org