609 reputation
11024
bio website
location
age
visits member for 2 years, 6 months
seen Oct 22 at 14:41

Oct
20
comment Dealing with Mysql Replication and Functions
Thanks for your answer, I did the test and it worked nice, do you have any idea what is the maximum number of master in a multi master replication?
Jan
21
comment importing database backup to phpmyadmin return #1064
how are you exporting/importing? you tagged SQL Server and Mysql, any relation between them?
Dec
13
comment OEM 11g alerts and notifications arrive together
@Phil I thought that the Email Manager was separate of the database status, just like MsSQL, thanks for clarify this
Dec
13
comment OEM 11g alerts and notifications arrive together
@Munchi acctually I have everything installed in a local host making some test to move them to Production, are you saying that this won't work because they need to be separate?
Dec
3
comment How to change SESSION_CACHED_CURSORS for all sessions
THANKs, it worked with the scope option, but I added sid='*' because I needed it for all the instances
Oct
9
comment mysql is locked; can't kill query
what I think is in the first part you got that message because the DB was writing the information, in your example, when you make the show .... and then kill ... you are killing the query to show the processlist list, you are not killing any 'real' query.
Oct
8
comment Review my simple database tables
you need to specify more about your project to know if your DB design is O.K
Jul
16
comment How to Create Snapshot Backups in MySQL
@AaronBrown thanks a lot for your comment, I did this question just to learn and not because I've a issue. My environment is Mysql 5.2, localhost, MAC, Thanks
Jul
10
comment How to restore mysql from only myi files?
I don't think that it's possible only with myi files, because they are more the structure(index) of the table than the data, I'm going to try yo put this question en DBA.stackoverflow
Jul
10
comment How to restore mysql from only myi files?
The MYI is only for MyISAM tables, what about the InnoDB or other engines?, take a look to this post: stackoverflow.com/questions/879176/… good luck
Jul
5
comment Which mysql storage engine to choose?
that's up to you, depending for what will you use the table, and if you are using mysql V-5.6+ you can create text index in Innodb Engines
Jul
5
comment Which mysql storage engine to choose?
the Aria Engine is getting close to use Transaction, so why don't use Aria instead?
May
18
comment Does this cause overhead ? Select name from User where user_name LIKE '%alex%'
@AaronBertrand yeap that's what I mean, about the (2) thanks, I'm agree with you, but I'm going to put a question about what I think hope you can answer it.
May
18
comment Which is faster, InnoDB or MyISAM?
Thanks a lot, I'll take a look
May
17
comment is it possible to create a form in the intranet that can be stored in a database?
I cannot tell you too much about Access as programming languages, but for that kind of simpler stuff I preffer php, or ROR for development, that's my personal opinion, would be great if some DAP programmer share something with us.
May
17
comment Why shouldn't we allow NULLs?
@AaronBertrand haha thanks, I asked you because I wanted to be 100% about the nulls fields ;)
May
17
comment Why shouldn't we allow NULLs?
@AaronBertrand no, I'm asking you the other way. Use null values because they are faster to checking.
May
17
comment Why shouldn't we allow NULLs?
@AaronBertrand is it not faster a query against null than 0, or any other vaue?
May
17
comment How to select/count rows where the same value exists in a column but not in other column all at the same table
@RolandoMySQLDBA boooo, you did it faster than me! hehe good one +1
May
17
comment How to Create Snapshot Backups in MySQL
Did you see the new online method of Mysql 6 where you can make snapshots? is that better than this one I posted?