Hi,
I have executed ANALYZE TABLE for myisam tables, but still myisam is showing
more scanning of rows as compared to innodb. What does ANALYZE TABLE command
exactly do for myisam storage engine.
Thanks
Krishna
On Wed, Apr 2, 2008 at 9:48 PM, Rob Wultsch [EMAIL PROTECTED] wrote:
On Wed, Apr
Hi All,
I have Master - Slave setup, with just one slave.
Can i set --log-slave-update on slave.
I have mysql running on debain with 8 cpu and 8 GB RAM.
Also in this link
http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-switch.html
Its says not to set --log-slave-update on slave,
Hi,
On myisam storage system
mysql explain select ui.user_id, ucp.user_id,ucp.payment_date from
user_info ui, user_course_payment ucp where ui.user_id=ucp.user_id;
On Thu, Apr 3, 2008 at 2:04 AM, Ben Roberts [EMAIL PROTECTED]
wrote:
Hello,
Does anybody have any info on cross-database joins?
i.e. doing a join across various tables that are located inside different
databases (albeit on the same database server).
Yes, Implemented and working fine
Just try mysqladmin ping that whether mysql is working or not
Krishna
On Thu, Apr 3, 2008 at 5:45 AM, Vidal Garza [EMAIL PROTECTED] wrote:
Hi...
I need test mysql connections but i have a problem...
freebsd# uname -a
FreeBSD freebsd.aduanet.net 6.3-RELEASE FreeBSD 6.3-RELEASE #0: Wed Jan
Hi,
There is nothing that, you can not enable log_slave_updates on slave.
Basically, it is useful in a situation when you have 1 master and 2 or more
slave in chain series. In this model 1st slave server should work as master
as well as slave. So, log_slave_update and binlog can be enabled to log
I need querylike this that make a row of numbers (in one execute)
SELECT a from (
SELECT -1 a UNION ALL
SELECT -2 UNION ALL
SELECT -3 UNION ALL
SELECT -4 UNION ALL
SELECT -5 UNION ALL
SELECT -6 UNION ALL
SELECT -7 UNION ALL
SELECT -8 UNION ALL
SELECT -9) t;
--
View this message in context:
Hi All,
i set the skip-innodb in my.cnf, but when i do the below, it still shows
some default values assigned to innodb parameters, can i avoid this as there
is some amount of memory allocated to innodb, and i dont what that. I want
all resource to allocated to only myisam. Please let me know how
But, it also says, that if slave1 is made master and if log-slave-update is
set on it, then
slave2 might receive data that it might have arleady got from the old
master, which might cause errors like duplicate keys etc.
On 4/3/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:
Hi,
There
Ananda Kumar schrieb:
Hi All,
i set the skip-innodb in my.cnf, but when i do the below, it still shows
some default values assigned to innodb parameters, can i avoid this as there
is some amount of memory allocated to innodb, and i dont what that. I want
all resource to allocated to only
you mean to day, i install mysql using source. But i have installed using
binary, is there any way i can do it .
regards
anandkl
On 4/3/08, Uwe Kiewel [EMAIL PROTECTED] wrote:
Ananda Kumar schrieb:
Hi All,
i set the skip-innodb in my.cnf, but when i do the below, it still
shows
some
On Wed, Apr 2, 2008 at 11:32 PM, Krishna Chandra Prajapati
[EMAIL PROTECTED] wrote:
Hi,
On myisam storage system
mysql explain select ui.user_id, ucp.user_id,ucp.payment_date from
user_info ui, user_course_payment ucp where ui.user_id=ucp.user_id;
Hi Vidal, all !
Vidal Garza wrote:
Hi...
I need test mysql connections but i have a problem...
freebsd# uname -a
FreeBSD freebsd.aduanet.net 6.3-RELEASE FreeBSD 6.3-RELEASE #0: Wed Jan
16 04:18:52 UTC 2008 [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]:/usr/obj/usr/src/sys/GENERIC i386
hi all, i have a question on insert ... select statement.
tbl_1(fld1,fld2,fld3, )
fld1 int primary key auto_increment not null
tbl_2(fld_a,fld_b,fld_c,...)
how do i construct my select statement so that fld1 is auto increment?
insert into tbl_1(fld1,fld2,fld3) select xxx, fld_b, NOW()
Hi Hiep,
you can put in either xxx = NULL
or you can skip it completely:
insert into tbl_1(fld2,fld3) select fld_b, NOW() from tbl_2;
Regards,
/Johan
Hiep Nguyen skrev:
hi all, i have a question on insert ... select statement.
tbl_1(fld1,fld2,fld3, )
fld1 int primary key
On Thu, 3 Apr 2008, Johan Höök wrote:
Hi Hiep,
you can put in either xxx = NULL
or you can skip it completely:
insert into tbl_1(fld2,fld3) select fld_b, NOW() from tbl_2;
Regards,
/Johan
Hiep Nguyen skrev:
hi all, i have a question on insert ... select statement.
Hi Hiep,
Hiep Nguyen skrev:
On Thu, 3 Apr 2008, Johan Höök wrote:
Hi Hiep,
you can put in either xxx = NULL
or you can skip it completely:
insert into tbl_1(fld2,fld3) select fld_b, NOW() from tbl_2;
Regards,
/Johan
Hiep Nguyen skrev:
hi all, i have a question on insert ... select
Please actually read my reply before asking the same question. As I
stated, InnoDB outputs *estimated* row counts in EXPLAIN, whereas MyISAM
outputs *accurate* row counts.
-jay
Krishna Chandra Prajapati wrote:
Hi,
On myisam storage system
mysql explain select ui.user_id,
I need to put a read-only copy of a single table on a database on another
server so remote customers can have read access to it. I built a new MySQL
server and placed in my DMZ. I can use SSH forwarding to access it from
outside. Now I need to get a copy of the table from my internal MySQL server
This is something I do with replication.
You can replicate a list of tables, see the 'replicate_do_table' config
option.
Then you can euse the 'read_only' option. Replication still works but
nothing else. But it would give you more options by using GRANT instead
of 'read-only':
CREATE
Description:
copying a table with a fulltext index via
insert into ft1 select * from ft2;
into a identical table sometimes leads to select error 1191
when concurrent select's are running.
this happens in an enviroment where the searched table is
I need to put a read-only copy of a single table on a database another
server so remote customers can have read access to it.
I use SQLYob Job Agent to synchronise two MySQL databases. See
http://www.webyog.com/en/ for more information.
I use SSH to so port forwarding from one box to the
Krishna Chandra Prajapati escribió:
Just try mysqladmin ping that whether mysql is working or not
Krishna
On Thu, Apr 3, 2008 at 5:45 AM, Vidal Garza [EMAIL PROTECTED] wrote:
Hi...
I need test mysql connections but i have a problem...
freebsd# uname -a
FreeBSD freebsd.aduanet.net
Hey folks,
I'm currently deciding whether to build a decent sized (around
300-500GB, although honestly, I've got little to base that on at the
moment) data warehouse in postgreSQL or MySQL. I've developed several
in MS SQL and postgreSQL, but the client is comfortable with MySQL, and
I'd
Hi,
Vidal Garza wrote:
[[...]]
I have a cuestion, where do you find the system header files error
number (61)?
I do that brute-force:
#! /bin/sh
#
# FGIN shell script to use fgrep on all
/usr/include/h files
#
# $1, $2, ... options and arguments given to fgrep
Hi
Up until version 5.0.44 (on linux) it appeared that you could do stuff
like deliberately insert a NULL into a NOT NULL varchar field and it
would be silently converted to an empty string. Similarly if you didn't
specify a value it appeared to use what is describe in the docs as the
I've built several datamarts using perl and MySQL. The largest ones
have been up to about 30GB, so I'm not quite on your scale.
for #1, I have an etl_id in the fact table so I can track back any
particular ETL job. I typically make it a dimension and include date,
time, software version, etc.
On Thu, Apr 3, 2008 at 2:28 PM, Dre [EMAIL PROTECTED] wrote:
1) Several sources seem to suggest MyISAM is a good choice for data
warehousing, but due to my lack of experience in a transaction-less world,
this makes me a little nervous.
MyISAM has the advantage of very fast loading. It's much
The beauty of this language is exactly as Johan says, you can skip the
obvious, Just insert all the other non-obvious columns. In the event that
you have numerous defaulted columns, though, it's best to supply a NULL so
the syntax is parallel (IMO), or alternatively to name the columns. But
either
29 matches
Mail list logo