Free Disk Space On DELETE
I'm building a huge DB. One particular table can contain as much as 125 million records. I need to DELETE records older than a year. That part works fine but it doesn't free any space on my hard drive (C:/). I tried OPTIMIZE TABLE and it still won't free hard disk space.
View Complete Forum Thread with Replies
Related Forum Messages:
Calculating Disk Space
I was wondering, is there a way to calculate the overhead in disk space for a table that contains column types that are only regular ints and floats. The table type is MyISAM, but I'd also like to know for other tables how to find this overhead. Basically I'm looking for a formula. If that's possible?
View Replies !
Can I Upload A MYSQL Database To My Free Web Hosting Space?
I have a domain with awardspace.com which has php and MYSQL enabled. I am a newbie and not quite sure how to set it all up or if it's even possible with the Database I've created on my desktop. When I go to the Database Manager in the administrator section it has a spot to create a database,and confirm a password. From there I take it you would use the PHPMyAdmin to alter the database. Can I just upload a database using an FTP manager like Dreamweaver, or do I need to start from scratch and create the database on this server. If so is there a way to eventually download it so I don't lose any of the information in it.
View Replies !
Release Disk Space By Drop Database ?
OS. linux 2.4.22 MYsql : 4.0.18-standard I created a database and populate 2 big InnoDB tables, the total size is > 3G. After all testing, I droped the database . But, the harddisk space is not release to the filesystem, Why, How could I recover that ?
View Replies !
Release Disk Space By Drop Database
OS. linux 2.4.22 MYsql : 4.0.18-standard I created a database and populate 2 big InnoDB tables, the total size is > 3G. After all testing, I droped the database . But, the harddisk space is not release to the filesystem, Why, How could I recover that.
View Replies !
How Do I Reclaim Disk Space In Data Folder
I have 5 databases: - mysql - test - product1 - product2 - product3 The hard disk on my server was near full, so I decided to delete databases product2 and product3 as I no longer need them. I dropped the databases product2 and I noticed the disk space was not freeed by MySQL after dropping this database. The tables in databases product2 and product3 are INNODB. What is the best method to reclaim my disk space when dropping entire databases?
View Replies !
Licence Free?
I am migrating a commercial application from DBISAM to MySQL (Delphi) I still dont understand: should I pay for every licence that I install or MySQL is free?
View Replies !
MySQL Free?
I have been using XAMPP as a server on my PC to test my PHP and MySQL code and it is free for those who have not heard of it. My dad was telling me his office was thinking about getting MySQL but it cost money. I went to there web site and it looks as if they have a certified server version (costs money) and a developer version (free). I was wondering if you have a site online running MySQL do you have to buy the certified version or can you use the developer version without any cost.
View Replies !
Free SE Submissions
I remember back in the glory days of the web long gone where I could run through 8-10 major search engines and submit for free. I recently tried to do that with my new site and realized that most are pay for inclusion. Is there a Secret Area to submit at or is it impossible to get into for the most part? Any other free ones besides dmoz and google? Or is it just impossible to get anywhere with hard work and no money now?
View Replies !
Commercial Or Free Reporting
I wondered if you could let me know which is the best report generating package for mysql.... I am looking into open source or commercial packages... I want the package to create me a link where I could add a button to so my user does not see the sql code... they just click the button and pops the charts... The Package must output plenty of charts... I searched through google, but I prefer to know by people that have used the packages
View Replies !
Is Mysql For Windows Free?
I saw in a site that says "mysql for windows is free for one month to continue using it you must get a license". I was planning to use mysql on windows for company database I thought mysql windows version is free. Am I have to use on the linux for free solution?
View Replies !
Free Or Inexpensive Version ?
I am an individual who would like to learn on their own how to use mysql. I am probably wrong, but I thought that being open source there would be a free, or inexpensive, version to "play" with on ones own PC. I cannot afford the Enterprise Version. Is there a basic, or watered down version, available ? (Perhaps, not directly thru mysql.com ?)
View Replies !
Free MySQL Or SQL Database
Is there someone who knows a webhosting provider who provides free SQL or MySQL(rather SQL than MySQL) database which is not limited by numeber of tables for free charge. I found one which is limited by one table, in which I cannot change the name table, cannot create new table etc. I need at least four tables. No matter space limits, may be under 5MB for example. But must be accessable from outside, I mean I want to connect it from Visual Foxpro via ODBC driver.
View Replies !
Free MySQL DB For A Web Portal
I'm running a web portal in simple HTML with static pages. But I want to setup my portal on PHP+MySQL. I know nothing abt MySQL but a little abt PHP. Can someone guide me setting up a PHP MySQL based web portal. ( including sample PHP pages & MySQL DB )
View Replies !
Form Free Text Field
I have a form free text field for which the user can enter any text. I do not do any scrubbing of this text, ie. checking for some text which could effect SQL statments. I look at my logs an I find alot of the error messages below. For free form text fields what should I "scrub" or run checks for. For example I guess is the users uses a . - or something of the like it can cuase this error. DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'exp communications-in a B2B environment.'
View Replies !
Using Free Version Of MySQL In My Company...
I am a student working part time for a company. I am just starting my final year dissertation and would like to use MySQL to hold a database that I will be making. I was just wondering if I would be breaking any rules by using the free version of MySQL?
View Replies !
Free LAMP-Image - Is It Legal?
I plan to make a vmware image, which contains a LAMP system, that means: Linux (in my case debian or a smaller one), apache, mysql and php5. My question: Is it legal? I want to provide this image for FREE!
View Replies !
Open-source/free DB Modeling Tool
I'm looking for a decent DB modeling/designing tool that is free and supports the following features: 1. Visual design of tables/relationships 2. Syncronization to database 3. Query mode 4. Ability to sync with different database types I've been using DBDesigner, but it has a few bugs that are really annoying.
View Replies !
Where I Can Get Free DEMO DATABASE And TABLES For My Practice?
I want to hone my skills on MYSQL but i want to have dummy database and tables, and specially the contents of the tables the datas. because i want to... practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, and practice.....
View Replies !
Can't Move Log To Another Disk
I want my 4.1.12-max-log mysql server to log to the other folder than data folder. I did many reconfigurations taken from documentation and nothing worked! Can anybody help mi giving "newbie style" step by step instruction? Or - better - to ask me questions like: "did you use this or that variable in my.cnf" or "did you read this part of documentation"
View Replies !
Hard Disk
When I sucessfully create a databse in the MySQL command line client, where exactly in the C drive does the database gets stored? I created a databse and than I used the windows search functionality to search for that databse. I am getting a result that says the database dosen't exist. But when I type in the show databases; command in the command line client, it shows that the databases exists, but I would like to know where.
View Replies !
MySQL: Spam Free (Send/Receive) Emails. HOW?
I would like to create a MySQL to protect my subscribers and clients from receiving a spam emails. I can create a new table for MySQL and write new script for PHP MySQL: mysql_query("CREATE TABLE members( members_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email_address VARCHAR(50)") or die(mysql_error()); mysql_query("CREATE TABLE spam_free( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), members_id (INT), fake_email VARCHAR(50)") or die(mysql_error()); ?> PHP: After my client / subscriber sign up as a member of my organization, php autmatically creates a new fake email address with my domain name i.e. doe @ mydomain DOT com in it. PROBLEM: I couldn't find a code or syntax that make mysql to redirect email to my subscriber from my client's email client and vice versa. Once our database matches sender's fake email address, MySQL would redirect sender's email to our member with a real email otherwise die. Is any one of you know the code that can get mysql to work and redirect email without go through php? (not use webmail).
View Replies !
Disk Quota In MySQL
Is there a way to assign a limit on the size of a specific database? For example database A can take up no more than 500 MB. One of my databases can potentially grow without any bounds and possibly stop other critical databases from operating. We are using MySQL 4.0.21 on Linux. We use innodb tables.
View Replies !
Showing Disk Usage
How can I see how much disk space is being occupied by an InnoDB table? Looking into /var/lib/mysql doesn't seem to work anymore for InnoDB tables. Please tell also if there is a way to see how much space is occupied by a particular row or column of a table.
View Replies !
Running MtSQL On A RAM Disk
I am trying to set up the same thing but have been stopped right from the get go as I can not get a larger than 2G RAM disk going (using a 64 bit Ubuntu installation). I am hoping someone who has gone through the basic set up might get me squared away to start. An offline conversation would be fine and perhaps save the rest of y'all wading through said basics.
View Replies !
Restore Database From Another Disk
I'm wanting to restore my old database by copying the contents of the old /var/lib/mysql folder to the new server, but this isn't working. Is there a documented procedure for doing this? I'm using InnoDB and MyISAM.
View Replies !
Disk Based Cluster
I want to know mysql support disk based cluster. Because i want to migrate on mysql cluster 5.0 and i have 30 GB database. If i mysql disk based cluster supports that much space than that would be great. Another question is that MyISAM storage engine in mysql supports table partioning ?
View Replies !
Copying Table To Disk During Execution
I seem to be having an issue with a query's results being paged out to disk during runtime. I notice in processlist it saying "Copying to tmp table on disk". select col1, col2, count(ip) as 'COUNT' from db.table group by 2 order by 1, 3; None of the columns are a primary/foreign or an index. This query returns 92K rows and has taken anywhere from 50 seconds to run to over 1.5 minutes. The table size on disk is around 33MB. After doing some research i found that i should be changing the tmp_table_size system variable. Originally it was set to the MySQL default, 33554432. I set the varaible to 90,000,000 and it still started paging out to the disk (this was the only query running at the time). I would think that 90MB in space would have been enough to handle the query since that would assume over 600K row size. I actually had some trouble setting the tmp_table_size for the global variable but was able to change it as a session variable. I have also tried altering the query_cache variable (which has only slowed the query down - currently it sits at a size of 50MB) and also the sort_buffer_size but neither have made a difference. What is the magic variable that i should be messing with?
View Replies !
Ibdata1 Is Close To Disk Size
I am running MySQL 4.0.13 with my-medium.cnf (attached) on a Solaris 8, 4x450 Mhz, 4gb RAM. All my tables are InnoDB. Currently my ibdata1 is 1.8 gb. I have about 1 gig space left on the same partition. Also it is excruciatingly slow now. How do prevent the ibdata1 from filling up the disk partition ? How do I increase the speed on my MySQL? [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K myisam_sort_buffer_size = 8M query_cache_size = 16M query_cache_limit = 8M log-bin server-id = 1 # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /usr/local/mysql/var/ #innodb_data_file_path = ibdata1:10M:autoextend #innodb_log_group_home_dir = /usr/local/mysql/var/ #innodb_log_arch_dir = /usr/local/mysql/var/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #innodb_buffer_pool_size = 16M #innodb_additional_mem_pool_size = 2M # Set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 5M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 ( I had to comment the innodb to stop crashing ) [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout
View Replies !
Flush A Heap Table To Disk
For example if I have data that I want to be inserted in to a heap table (for optimisation reasons) but I don't want to risk losing *all* the data if mysql crashes. Is it possible to perform something like a flush so that if mysql does crash some of the data is saved.
View Replies !
Flush A Heap Table To Disk?
As the subject says, is it possible to flush the contents of a heap table to disk? For example if I have data that I want to be inserted in to a heap table (for optimisation reasons) but I don't want to risk losing *all* the data if mysql crashes. Is it possible to perform something like a flush so that if mysql does crash some of the data is saved.
View Replies !
Data Location On Hard Disk
I have just installed MySQL 5.0 and finished the first test from a database application. I saw that the data is stored in c:program...MySQl... I am not happy with that. I want MySQL stores all data in a map of my own choice.
View Replies !
Moving Mysql To Another Hard Disk
I have a web based intranet application (php) that uses a mysql database. The server has just had a new drive added to it and am looking for a way to move the database from the current c drive to this new drive.I'm looking for a way to either: move the entire database to the new drive (in which case do i have to do anything within the code - the database name is still the same and i'll presume another drive is still localhost can) Can i just make Mysql save data into the new drive (and also move just the old data file to the new drive leaving everything else as it was).
View Replies !
Trouble Moving Data To Different Disk
Basically, what I've done is: 1) stopped mysqld. 2) made a place to put the files on the other disk. 3) copied the files to the other disk. 4) changed datadir and socket values in my.cnf. 5) created a symbolic link from the old data directory to the new. 6) chowned the new data directory and the old to mysql just in case. When I try to start mysqld, the service says it fails, but the log says that the service started just fine and it's ready for connections. Also, there are 2 processes running: /bin/sh /usr/bin/mysqld_safe (root) and /usr/libexec/mysqld (mysql). I can stop mysqld and it returns [OK].
View Replies !
MyISAM Table And Sort Order On The Disk
I ran the myisamchk tool with the options --sort-index --sort-records=1 against an MYI file. Is there something I can use to confirm what this command did? I would like to see what the sort order on the disk for each table in my database.
View Replies !
Random MYI MYD Files Generated Consuming Disk
named as follows: #sql_5d7e_0.MYI #sql_5d7e_9.MYI #sql_5d7e_6.MYI #sql_5d7e_2.MYI #sql_5d7e_5.MYI #sql_5d7e_5.MYI etc., etc. In my error log I saw the following: Incorrect key file for table '#sql_2684_1.MYI'; try to repair it (many of these for each "table")
View Replies !
How Big ( Disk Size ) Would This Database Be: 4.2 Billion Rows
I have a database in MySQL version 5.0.19 that I'm making. Its structure is: CREATE TABLE `big` ( `keyval` int(10) unsigned zerofill NOT NULL, `name` varchar(20) default NULL, `avail` enum('y','n') default NULL, PRIMARY KEY (`keyval`), KEY `keyval` (`keyval`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; The 'keyval' will be filled with every value from 00000000 to 4294967295 ( 4.3 billion rows ), and assume worse case of 20 characters in each 'name' element and 'y' or 'n' always set in the 'avail' colmn.
View Replies !
Running A Stand-alone MySQL DB Off A Flash Disk?
Is this possible? I'm creating a logbook for work in Access at the moment because it will be portable on flash disks provided the machine has Office installed. But what I'd really like is to create it as a webpage that links to a mySQL database on the flash disk. The "install" would be a folder containing the page(s) and a folder with all the DB stuff. Does anyone know if this is possible? I hope it is, especially after my Access experiences.
View Replies !
Disk Usage Increases After Dropping A Large Index?
I have a linux server which is hosting several very large (~20GB) databases. In order to save some disk space I dropped an index on one of the larger (InnoDB) tables because it is no longer needed. It took about 30 minutes for MySQL to drop the index, during which time I saw the free disk space decrease. I didn't think anything of it while the drop operation was running because I figured it was some kind of temp file being used by the drop (even though the temp directory for mysql is supposed to be on another partition). To my surprise, after the index was dropped, not only did I not have more free space as I expected, but in fact I had about 2 GB less than I did before I dropped the index. Huh? So now I'm down 1 index and 2 GB of space. How does dropping a db object actually increases the amount of disk used by mysql? Is there anyway I can reclaim this space? MySQL version is 4.0.15
View Replies !
|
TRACKER
