Nathan Harmston schrieb:
Hi everyone,
I am currently working on an application where I have a very large
table called intervals ( atm its 80 000 000 records and growing ), and
a smaller table ( token ) which join with it.
interval is just an id, start, end, word
token is id,
Hi experts,
When I try to set the packet size to some other value, it is not getting
updated.
show variables;
set max_allowed_packet = 2097152;
set global max_allowed_packet = 2097152;
it resulting,
Query is ok, 0 rows afected (0.00 sec)
Can you suggest me how set this value to higher one. By
On Feb 20, 2010, at 11:22 AM, Vikram A wrote:
Hi experts,
When I try to set the packet size to some other value, it is not getting
updated.
show variables;
set max_allowed_packet = 2097152;
set global max_allowed_packet = 2097152;
it resulting,
Query is ok, 0 rows afected (0.00
Jesper Wisborg Krogh
Team Leader • Certified MySQL 5.0 Developer DBA
Noggin IT • Level 8, 28 Foveaux St, Surry Hills NSW Australia 2010
T: +61 2 9219 8800 • F: +61 2 9280 4669 • E: jes...@noggin.com.au
http://www.noggin.com.au
On 21/02/2010, at 4:46 AM, Paul DuBois wrote:
On Feb 20, 2010,
Is it possible to replicate only DML statements? I don't want an
operator error of drop table to replicate to the slave
I use 5.0.x
ps: please cc me on the reply
Regards,
Jeetu
There is no good, there is no bad, there's just what happened. Dance with it.
--
MySQL General Mailing List
For list
Hi, I'm interested in piping out the contents of a mysql table to
stdout in tab-separated value format, but:
- using 'select * into outfile' can't write to stdout.
- mysqldump --fields-... requires --tab, which requires an output file path.
- I also tried mkfifo /tmp/pipe and select * into
I have the following table:
CREATE TABLE `graph` (
`tableid1` varchar(20) NOT NULL,
`tupleid1` int(11) NOT NULL,
`tableid2` varchar(20) NOT NULL,
`tupleid2` int(11) NOT NULL,
`node1` int(11) NOT NULL,
`node2` int(11) NOT NULL,
`weight` int(10) NOT NULL,
PRIMARY KEY
I dont know if this can help, but if you are on unix/linux you can call
cat after the dump and easily you can get the output to the stdout
ie:
$ mysqldumptempfile.txt... cat tempfile.txt
Carlos
On 2/20/2010 9:03 PM, Yang Zhang wrote:
Hi, I'm interested in piping out the contents of a
On 21/02/2010, at 2:03 PM, Yang Zhang wrote:
Hi, I'm interested in piping out the contents of a mysql table to
stdout in tab-separated value format, but:
- using 'select * into outfile' can't write to stdout.
- mysqldump --fields-... requires --tab, which requires an output
file path.
- I