Dear Suresh,
Thank you.
In MySQL Replication, as the slave itself takes the writes from master
but in how much time period does slave goes to master. is there any
parameter where I can set this. that after every 60 seconds slave
should write data from master to its own local database.
Hi,
I have created a query to read and update a stock item by using the FOR UPDATE
statement. According to the MySql documention only the rows that are selected
using the FOR UPDATE should be locked for other sessions, but somehow whole the
table is locked. This post gives some general
Hi Manasi,
Inside MySQL, there are no such parameters and the Slave delay depends on
different things like network between Master and Slave, load of the MySQLD
server etc...
To make the slave behind for a particular period of time, use mk-slave-delay
tool from the the maakit. It help your slave to
Hi Faizal, all!
F.A.I.Z.A.L wrote:
hi
anyone can help. its urgent. iam trying to start mysql server but it is not
starting.
Just read the output:
bash-2.03# ./mysqld_safe
[2] 3422
bash-2.03# Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid
hi thanks for your response..
this is solaris 8 machine. thanks a lot. i found the problem and resolved..
problem is: access problem in file system
'./mysql-bin.25' is created in root.root but it should be in
mysql.mysql (user.group). i changed this to mysql, then service started...
I have an install script that does some stuff with mysql (i.e. install,
start, etc). It installs
mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using readline 5.0
This was good when we just used CentOS 4.5. Now we are doing some later
CentOS versions and the mysql version may be
You *should* be using a package manager (perfectly fine RPMs available for
all your needs), but if you must do this, it's a reasonably safe bet to
right-align and zero-pad all your number to 4 digits, at which point you're
free to concatenate them and treat them as a single number.
14.12.5.0.19
I am using RPM. And for Centos 5 it was installing a lower version
of mysql than what was installed with the system. That is why I want
to check before doing the RPM. I guess the alternative is to use the
latest version all the time, but not sure whether that will work on
the 4.5 version.
The
On Thu, Jan 14, 2010 at 5:02 PM, tony.chamberl...@lemko.com wrote:
The other thing is, mysql appears to keep changing between
/etc/init.d/mysqld and /etc/init/mysql so I also have to do an
ls /etc/init.s/mysql* to figure out what to use to start which is also
kind of a pain.
Hmm... I'm no
its a linux server fedora with 2GB ram, insert mostly used through the
update, no load or on cpu during that time
mysql show status;
+++
| Variable_name | Value |
+++
| Aborted_clients
Hi Peter (and MySQL list),
On Wed, Jan 13, 2010 I (Ricardo Dias Marques) asked the following :
It would be convenient for me to get a list of those fields ordered by
field / column name.
... and on the same day, Peter Brawley peter.braw...@earthlink.net
kindly replied:
SELECT *
FROM
Hi,
The function is probably behaving as intended, but its confusing the
hell out of me. ;) Anyway, say I have two tables; orders and lineitems
Orders has two columns: orderid(primary key) and ordertotal
Lineitems has two columns: orderid and itemid
For every orderid in the orders table,
Dear MySQL users,
MySQL Server 5.5.1-m2, a new version of the popular Open Source
Database Management System, has been released.
The -m2 suffix tells this belongs to the second milestone according
to our milestone release model, also called Betony.
You can read more about the release model and
Dear MySQL users,
I made a very silly mistake:
My previous mail entitled DRAFT is really final and valid,
I forgot to change the subject after the internal review cycle.
I ask you all to apologize that mistake and and hope you will excuse any
confusion I may have created.
On behalf of the
Hello,
I need to convert a non-materialized MySQL view to
a MySQL table. Are there any tools to do that?
Thanks,
Jacek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
At 04:55 PM 1/14/2010, Jacek Becla wrote:
Hello,
I need to convert a non-materialized MySQL view to
a MySQL table. Are there any tools to do that?
Thanks,
Jacek
Jacek,
Can't you just do a:
create table mytable select * from myview;
???
Mike
--
MySQL General Mailing List
For list
John,
What's happening is that the tables do not have a one-to-one
relationship, so the JOIN duplicates rows from Orders to match the
rows in Lineitems. You need to ensure the aggregation is consistent
across the two datasets. Try this:
SELECT
Sum(a.ordertotal) as total,
Johan,
I don't see a valid need for using FOR UPDATE here. In fact, FOR
UPDATE is the cause of many grievances, and I would advise you to
avoid it by any means possible. Among other things, it will cause
serious performance problems when your server gets busy. And as you
can see, it's hard to
Hi guys i have a problem, 3 big tables: item_instance about 15KK rows,
character_inventory 15KK rows, guild_bank_item 2KK rows.
And i need i clean on item_instance how this query:
DELETE FROM `item_instance` WHERE guid NOT IN(SELECT item FROM
`character_inventory`) AND guid NOT IN(SELECT
For alternatives, have a look at The unbearable slowness of IN() at
http://www.artfulsoftware.com/queries.php.
PB
-
Junior Ortis wrote:
Hi guys i have a problem, 3 big tables: item_instance about 15KK rows,
character_inventory 15KK rows, guild_bank_item 2KK rows.
And i need i clean on
Hi Baron,
Thank you for your answer.
The problem is that multiple users can read and update the same field
simultaneously (worse case) which could lead to unpredictable problems.
According to the MySql online documentation
(http://dev.mysql.com/doc/refman/5.0/en/innodb-locking-reads.html)
21 matches
Mail list logo