On 3/29/2011 19:09, John G. Heim wrote:
I would like to use mysqldump to get a copy of the code for a stored
procedure in a format that is similar to the code I used to create it.
The problem is that I'm blind and I have to listen to the code to debug
it. I think I have a file containing the code
Hi John,
The lines you mention are comments , the comments in mysql sql files are
enclosed between two delimiters. The first is the sequence /* and the second
is the sequence */ , inside the comments you can have a marker constituted
by a ! and a number that represents a mysql version. These marke
I would like to use mysqldump to get a copy of the code for a stored
procedure in a format that is similar to the code I used to create it. The
problem is that I'm blind and I have to listen to the code to debug it. I
think I have a file containing the code that I used to create the stored
proc
Hi Gregory,
Are you sure you'd like to do this using MySQL? What would happen if you
start using sharding?
Maybe you could consider using a stack (stored in a tool like Redis?).
Whenever some user adds some item, you add primary key of the new item
to the "network updates" stack of each frie
> Why not optimize the IN ( ... ) to do the same type of thing?
If the argument to IN() is a list of values, it'll be OK. If it's a
SELECT, in 5.0 it will be slower than molasses (see "The unbearable
slowness of IN()" at http://www.artfulsoftware.com/queries.php.
> I always tried to avoid joi
Yes, this would be fine. But often, the list of friends is obtained from
a social network like facebook, and is not stored internally. Basically,
I obtain the friend list in a request to facebook, and then see which of
those users have created things. So would I have to create a temporary
table
> How can I quickly find all the articles written by this user's
friends, and not just random articles?
Taking the simplest possible case, with table friends(userID,friendID)
where each friendID refers to a userID in another row, the friends of
userID u are ...
select friendID from user wher
Hey there. My company writes a lot of social applications, and there is
one operation that is very common, but I don't know if MySQL supports it
in a good way. I thought I'd write to this list for two reasons:
1) Maybe MySQL has a good way to do this, and I just don't know
about it
2
Hi All
innodb_rollback_on_timeout=1
Specifies when there is transaction open by session and not committed, If such
session is inactive for long time, MySQL by default kicks out such session and
transaction perform by session would be rollback
innodb_lock_wait_timeout=600
Specify wait for loc
Hi Carlos and all:
Our architecture is a vm-ware virtual machine with debian lenny as S.O (64
bits), with 4 Gb of RAM . The virtual machine is a dedicated server with
MySQL 5.0. (INDB) Attached the my.cnf file. I've searched information about
this problem and to many persons the same have probl
Dear All,
I have the following two system variable set in my MySQL configuration file
under mysqld section. But I am not fully understand what the two variable
internally does.
innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600
Any help will be appreciated.
Thanks for Your Time
Mohan L
11 matches
Mail list logo
