Re: MS SQL to MySQL select
Hey, > In order for me to achive the goal of migrating a MS SQL based application > to web based php / mysql I need to understand a little bit MS SQL syntax and > MySQL counterpart expression. If is not too much to ask one of you guys > could "translate" this MS SQL select to MySQL? Here's the challenge: Yes, that is too much. This is a very basic query, if you cannot translate it yourself, I wish you good luck on your conversion project. Is there anything -specific- that you want to have translated here? Would it help if I said that this query prefixes each object with its owner (dbo) and for MySQL you should remove that? eg: create view equipos ... select ... OBJETOSPATRIMONIO.objpatCodigo ... from `01 LOCALIZACIONES OBJETOSPATRIM` INNER JOIN ... Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com > CREATE VIEW dbo.equipos > AS > SELECT TOP 100 PERCENT dbo.OBJETOSPATRIMONIO.objpatCodigo AS Expr1, > dbo.OBJETOSPATRIMONIO.objpatDenom AS Expr2, > dbo.OBJETOSPATRIMONIO.objpatEstadoTec AS Expr3, > dbo.ESTRUCTURAPATRIMONIO.clsnodopatID, > dbo.[01 LOCALIZACIONES OBJETOSPATRIM].Localizacion > FROM dbo.[01 LOCALIZACIONES OBJETOSPATRIM] INNER JOIN > dbo.OBJETOSPATRIMONIO ON dbo.[01 LOCALIZACIONES > OBJETOSPATRIM].objpatID = dbo.OBJETOSPATRIMONIO.objpatID INNER JOIN > dbo.OBJETOSPATRIMEQUIPOS ON > dbo.OBJETOSPATRIMONIO.objpatID = dbo.OBJETOSPATRIMEQUIPOS.equipID INNER JOIN > dbo.ESTRUCTURAPATRIMONIO ON > dbo.OBJETOSPATRIMONIO.objpatNodoEnlazID = > dbo.ESTRUCTURAPATRIMONIO.nodopatrimID > ORDER BY dbo.OBJETOSPATRIMONIO.objpatCodigo > > > Really appreciate your help! Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: enable and disable keys
try csplit to break the files into small chunks On Fri, Jun 13, 2008 at 12:21 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > How do i split file during ENABLE KEYS > > > On 6/13/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: >> >> increase bulk_insert_buffer_size and if possible split the bigger file >> into small chunks. It will help you. >> >> On Thu, Jun 12, 2008 at 1:51 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: >> >>> Hi All, >>> We are doing load data into a table using LOAD DATA INFILE process. Below >>> is >>> the method we are following. >>> >>> 1. create empty table with all the indexes. >>> 2. disable keys >>> 3. Load data using LOAD DATA INFILE, close to 99 Million records which >>> takes >>> around 3 hrs >>> 4 . Enable keys >>> >>> Table size is around 19.5 gb >>> >>> There is one primary key, 2 non unique indexes and one FULLTEXT INDEX. >>> >>> Enable kyes goes fine for couple of hrs with "REPAIR BY TMP", but then >>> switches to "REPAIR BY KEYCACHE" and writes a log in the error log >>> file "Warning: >>> Enabling keys got errno 28, retrying" >>> >>> What could be the problem. >>> >>> System has 8 cpu and 16GB RAM >>> >>> I have set myisam_max_sort_file_size=98GB >>> myisam_sort_buffer_size=750MB. >>> >>> /tmp folder has 16GB free space. >>> >>> please let me know, this problem is causing lot of dealy for other >>> process >>> to run. >>> >>> regards >>> anandkl >>> >> >> >> >> -- >> Krishna Chandra Prajapati >> MySQL DBA, >> Ed Ventures e-Learning Pvt.Ltd. >> 1-8-303/48/15, Sindhi Colony >> P.G.Road, Secunderabad. >> Pin Code: 53 >> Office Number: 040-66489771 >> Mob: 9912924044 >> URL: ed-ventures-online.com >> Email-id: [EMAIL PROTECTED] > > > -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
Re: Very slow inserts into InnoDB tables
hdparm -Tt /dev/sdX ? Ian Simpson wrote: That's pretty much what I've been doing to get that the drive is running at 100% bandwidth. What I'd like is something that just gives the bandwidth of the device in terms of Mb/s: you can probably work it out using that iostat command, seeing how much it wrote and what percentage of the bandwidth it's using, and then doing a calculation with those numbers to get the 100% value, but I don't know if that's valid, since there are generally a number of other operations going on at the same time. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Function Still Not Working
you not ADD Binary, you need to "remove" BINARY ... ;-) Sorry, I misunderstood. convert the string to latin1 or utf8 o.s.s. "LOWER() (and UPPER()) are ineffective when applied to binary strings (BINARY, VARBINARY, BLOB). To perform lettercase conversion, convert the string to a non-binary string" did you tried? Well, I thought I had tried this, but with all the other things that I'd tried, I guess I had everything mixed up. I started with a clean routine, used Convert(... using UTF8), and it works perfectly now. That's what it was. Thanks for the help! Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]