restoring backup, problem with BLOB?
Hello List, I am restoring a MySQL backup (about 40MB), and its taking well over 2 hours to restore. the area where its really hanging is when its importing the "BLOB" There are about 1200 records, totaling about 10mb in size for these blobs. I am running MyISAM, my current memory settings read: bulk_insert_buffer_size 805306368 innodb_additional_mem_pool_size 7340032 innodb_buffer_pool_awe_mem_mb 0 innodb_buffer_pool_size 318767104 innodb_log_buffer_size 4194304 join_buffer_size131072 key_buffer_size 164626432 myisam_sort_buffer_size 193986560 net_buffer_length 16384 read_buffer_size61440 read_rnd_buffer_size258048 sort_buffer_size262136 Any ideas whats going on here? its a 3 ghz P4, running 1024 ram.
MySQL Reference Manual source?
Hi all, Im sure the Online HTML mysql reference manual is something built by mysql specifly to handle the manual. (the one found at http://dev.mysql.com/doc/refman/5.0/en/index.html ) Does anyone know of any open source programs for creating your own online manuals like the MySQL Reference manual? is the MySQL one available somewhere?
Re: MyIsam Vs InnoDB
ransactions to run without a need to write the log to disk until the transaction commit. Thus, if you have big transactions, making the log buffer big will save disk I/O. innodb_log_buffer_size=1M #Specifies when log files are flushed to disk. innodb_flush_log_at_trx_commit=1 On 11/24/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > > Hello. > > > > Without seeing at least your configuration it is difficult to say > > what's going on. Please, provide your config file. > > > > > > Andrew stolarz <[EMAIL PROTECTED]> wrote: > > >When I do a bulk import into a MyIsam engine database, I can reach about > 2-3 > > >thousand records imported per second. > > > > > >However when I use the InnoDB engine, I am only importing about 30-50 > > >records per second? > > > > > >Am I missing something here? > > > > > >its a P4 3 Ghz machine with 1024mb ram. running MySQL 5.0 > > > > > >thanks > > > > > >Andrew > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > >
MyIsam Vs InnoDB
Hello List, When I do a bulk import into a MyIsam engine database, I can reach about 2-3 thousand records imported per second. However when I use the InnoDB engine, I am only importing about 30-50 records per second? Am I missing something here? its a P4 3 Ghz machine with 1024mb ram. running MySQL 5.0 thanks Andrew
MySQL Administrator on 10.3 Server -HELP
Hello List, I have installed the mysql database on the osx 10.3 server machine. along with the myodbc connector. I also installed the administrator module, by simply draging it over to the application folder like it says. When I go to launce the application, it does nothing. I tried restarting the machine, and am logging with the administrator account. Any Ideas?
max Mysql database size
Hello Everyone, Hopefully easy question, What is the Max size of a MySQL server database?
URGENT --- OSX 10.4 ODBC driver error
Hello All, I am downloading and installing the "Installer package (Mac OS X v10.3)" from the mysql site. I am installing on a OSX 10.4 machine, at the end of the install I get an error message saying "The application MYODBCConfig quit unexpedically after it was reopened, max OSX and other applications are not effected etc. etc." its version : 3.51.11-1 so this ODBC driver will not work on the 10.4 machine? as right next to the download it states OSX v10.3 (installing on 10.3 works no problem) many thanks Andrew
Re: MySQL 4.1 full throttled?
Hello, I did a complete new install on another machine but this time I selected the dedicated server option during the first setup, reran the same process and its going about 3 times faster then it did before.. so it looks like I am on the right track! the current sizes I have for the following are: whats the ideal setup for these? key_buffer_size = 37748736 myisam_max_sort_file_size = 48234496 bulk_insert_buffer_size = 8388608 any other sugestions where to look? many thanks everyone, Andrew On 8/18/05, Brent Baisley <[EMAIL PROTECTED]> wrote: > > MySQL is not limited in anyway if you don't have a license. The > default install is not optimal for the hardware you are running it > on. The default parameters are set pretty low so as not to monopolize > your system. If you are doing a big insert, you should adjust the > appropriate buffers (key_buffer_size, myisam_max_sort_file_size, > bulk_insert_buffer_size) . M$ SQL is kind of optimized out of the > box. MySQL allows you to really fine tune the database to fit your > needs, right down to using difference table types for your data. > Don't expect good performance by just installing and running. You > would actually want to set certain variables to one value for your > bulk insert and then change them for normal use. > > > > On Aug 18, 2005, at 3:29 PM, Andrew stolarz wrote: > > > Hi folks, > > I just downloaded MySQL 4.1 to see if its a go ahead with our > > application, > > I am doing a tranfser from our current datafile to MySQL, its > > taking about > > 45 min to do this process.. > > when I do the same process and transfer to a M$ SQL server, it > > takes about > > 2 min max. > > is the 4.1 of mySQL that I downloaded throttled somehow until I > > purchase > > the license for it? > > many thanks > > Andrew > > > > -- > Brent Baisley > Systems Architect > Landover Associates, Inc. > Search & Advisory Services for Advanced Technology Environments > p: 212.759.6400/800.759.0577 > > >
Re: MySQL 4.1 full throttled?
> > Hi Shawn, > I am using the MySQL ODBC driver to connect from our application to the > MySQL database, > The actual server setting are default stright from the origional install, > I am running all this from my laptop localy (both MySQL and MS SQL tests), > P4 2.8GHZ, and 512mb ram. > its doing about 10 records pre second for the transfer. which is dead > slow. > just want to knock off the option, MySQL is not limited anyway without a > license is it? > Thanks > Andrew Stolarz > > On 8/18/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > > > > > Andrew stolarz < [EMAIL PROTECTED]> wrote on 08/18/2005 03:29:39 PM: > > > > > Hi folks, > > > I just downloaded MySQL 4.1 to see if its a go ahead with our > > application, > > > I am doing a tranfser from our current datafile to MySQL, its taking > > about > > > 45 min to do this process.. > > > when I do the same process and transfer to a M$ SQL server, it takes > > about > > > 2 min max. > > > is the 4.1 of mySQL that I downloaded throttled somehow until I > > purchase > > > the license for it? > > > many thanks > > > Andrew > > > > How _exactly_ are you "doing a transfer from our current datafile to > > MySQL"? Not only can technique make a difference but some of your server's > > settings may also need tweaking (based on the capaciity of your hardware). > > How "beefy" is your server? How did you configure your server's settings? > > Are you transferring this over a network or is the source file local to the > > server? > > > > There are so many variables to consider > > > > Shawn Green > > Database Administrator > > Unimin Corporation - Spruce Pine > > >
MySQL 4.1 full throttled?
Hi folks, I just downloaded MySQL 4.1 to see if its a go ahead with our application, I am doing a tranfser from our current datafile to MySQL, its taking about 45 min to do this process.. when I do the same process and transfer to a M$ SQL server, it takes about 2 min max. is the 4.1 of mySQL that I downloaded throttled somehow until I purchase the license for it? many thanks Andrew
