#mysql
22 October 2007
Total 24 pages. You are browsing page 24/24.
First :: Prev :: [...] [20] [21] [22] [23] [24] :: Next :: Last
23:13 <****> enygma: anywhere with a coast?
23:13 <****> ;p
23:14 <****> enygma: no, that's a DECIMAL
23:14 <****> ahh
23:14 <****> k
23:15 <****> Good day all. Could the binlog position be stated as being called the position of the specified sql statement in the binlog?
23:17 <****> the reason I ask is because the slave database has a problem with a statement from the master db. I am wondering if I can increment the binlog position by 1 to bypass it
23:19 <****> dkr: I didn't find anything corresponding to that requirement; do you know there is such an option?
23:20 <****> Cope: --no-create-info --no-create-db
23:21 <****> ah, was looking for --inserts-only type of thing
23:22 <****> Cope: I don't know about views though
23:25 <****> hi. is it possible to have foreign key on 2 columns from different tables ?
23:25 <****> I am upgrading from 32-bit linux (and mysql) to 64-bit. Is it safe to use the same /var/lib/mysql, or must I dump and reload?
23:29 <****> is the binlog position in replication the same as the statement number? Meaning it I change the replication binlog position from 401 to 403 will it only skip one sql statement?
23:29 <****> hi
23:29 <****> I've used unicode characters (non ascii) to name the columns of the table...is that dangerous?
23:29 <****> or is it OK?
23:31 <****> one of my users has several databases accessible by his one mysql user
23:31 <****> abc_one, abc_two, abc_three etc..
23:32 <****> when logging into phpmyadmin, it asks if he wants to create abc?one
23:32 <****> if he clicks create database, it does it
23:32 <****> if the name is changed at all, it says access denied creating the database
23:32 <****> the user does not have create_priv, and pma user the phpmyadmin has has no priviliges at all
23:33 <****> is this some kind of temp db or something weird? the user shouldn't have access to do that, should they?
23:33 <****> the default mysql port is 3306, correct?
23:37 <****> Solifugus ye
23:41 <****> nm, figured it out.. need to use \_ in GRANT tables, not just _
23:43 <****> does anyone have any links to any sites that detail how to setup multiple mysql servers (physical machines) used for load balancing? (And also allow for atomic locking/transactions across the cluster)
23:44 <****> hi chadmaynard
23:44 <****> hello
23:48 <****> Is there a mechanism by which i can insert into a view and have the underlying table(s) updated?
23:48 <****> Im thinking yes since that sentence sounds familiar, whats that method called?
23:50 <****> BobSapp: I think it's called a materialized view
23:50 <****> But don't quote me on that.
23:50 <****> Quote chadmaynard
23:52 <****> does anyone have any links to any sites that detail how to setup multiple mysql servers (physical machines) used for load balancing? (And also allow for atomic locking/transactions across the cluster)
23:52 <****> hey guys
23:53 <****> what is default size of key_cache_size
23:56 <****> like 8MB i think
--- Log closed Tue Oct 23 00:00:11 2007
Total 24 pages. You are browsing page 24/24.
First :: Prev :: [...] [20] [21] [22] [23] [24] :: Next :: Last