search for: ibdata

Hello, This forum has been very helpful to me in the past, and I've run out of ideas on how to solve my problem. I had been using R and MySQL (and Perl) together for quite some time successfully on my Windows XP machine. However, I recently had some problems with MySQL (the ibdata file had become 35GB on my hard drive, turns out it's a known bug with InnoDB), and ultimately the way I fixed my problem with MySQL was to upgrade it. It's working fine now, I can use MySQL however I'd like. I'm sticking to MyISAM tables for now, though. However, I had set up my...

Hi. I started mysqld.exe using Wine and it seems to work. But when I try to connect the server seems to answer somehow (connection is established, telnet works) but it seems that no communication takes place. mysql freezes and in telnet no response is shown. Any idea what this could mean? Running in Windows without an installer works so it has to be some problem with wine somehow. Using Ubuntu

...socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192 remote announce = 192.168.1.255 local master = yes os level = 128 domain master = yes preferred master = yes domain logons = yes name resolve order = host bcast dns proxy = no veto oplock files = /*.pst/ibdata*/ib_logfile*/ [NETLOGON] path = /etc/samba read only = yes [homes] comment = Home Directories browseable = no writable = yes case sensitive = yes force create mode = 0664 create mode = 0664 force directory mode = 0775 directory mode = 0775 [Common] com...

...distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Now I am getting log file it has error like this . [root at localhost ~]# cat /var/log/mysqld.log 090120 20:52:20 mysqld ended 090120 20:52:29 mysqld started InnoDB: Unable to lock ./ibdata1, error: 38 090120 20:52:29 InnoDB: Retrying to lock the first data file InnoDB: Unable to lock ./ibdata1, error: 38 InnoDB: Unable to lock ./ibdata1, error: 38 InnoDB: Unable to lock ./ibdata1, error: 38 InnoDB: Unable to lock ./ibdata1, error: 38 InnoDB: Unable to lock ./ibdata1, error: 38 InnoD...

So I got dashboard up and running on our production system on Thursday before I left. Within 48 hours it had completed filled the /var filesystem. The ibdata1 file is currently at 8GB in size. 1. What size should I expect for ~500 nodes reporting every 30 minutes? 2. Are there some database cleanup scripts which I have managed to overlook that need to be run? -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other r...