Enabling Federated Tables.
I am using mysql 5.0.27-community-nt on windows xp. Federated engine is inactive. How can I activate the federated engine?
View Complete Forum Thread with Replies
Related Forum Messages:
Federated Tables Slow? (like 4.5 Hrs For A Query)
I've got a problem with federated tables. I'm using MySQL 5.1 (with InnoDB as the default table type) on a Win2K server, on which I've got four federated tables pointing at four MyISAM tables on a MySQL 4.1.11 server. Of the four tables, three of them run just fine, and I can retrieve data quickly with no problems. The fourth is a sheer pig. While they have different columns, all four tables are roughly as complex as each other, all having the same features and developed by the same team. The most obvious difference, and what I suspect might be the problem, is that the first three tables have between 150 and 1,000 records, the fourth table has closer to 15,000. Still, there isn't that much lag when I'm pulling from the smaller tables, and the lag is really serious when I'm pulling from the larger one; I ran three queries last night to test, and I could pull data from the smaller tables in about 5 minutes, but the larger table took 4.5 hours- possibly because it was joined with two other tables, but the joins on the smaller tables didn't cause this kind of problem. The second obvious difference is the fact that I'm pulling from a MyISAM table into a federated table... from which I would like to store into an InnoDB table, but it ends up timing out quite a bit. Connecting to the database I've federated to isn't a problem. It responds to a PHP frontend lightning-fast. It's just my federated tables that suck so bad. I wouldn't even use federated tables, but I need to pull from the MyISAM database for storing historical records of inventory. What am I doing wrong, and what can I do to speed things up?
View Replies !
Federated
I have no idea about creating federation in MySQL, I am a student and I need to create a federated database using 2 machines. Obviously one remote database and one with the federated database on it. Unfortunately I have been trying to read and understand how to do this. But due to the lack of knowledge and understanding I have with MySQL I am finding it very difficult.
View Replies !
Federated Vs Replication
for one of the applications I'm working on, we're splitting users' tables over multiple independent clusters (each user has an own set of tables), but still need a way to keep overall statistics of all users in a single place. I can think of three options so far: 1) Replicate the stats table (multi-master replication should work, as table doesn't have an auto_increment field) and update stats using triggers; 2) On all secondary clusters, use federated stats table pointing to the appropriate table on the main cluster and update stats using triggers; 3) Modify the application to execute a query, which updates stats on main cluster, every time a row is inserted into/deleted from user's table;
View Replies !
Federated Stored Engine
My question, can i enable federated support without re-installing mysql server? if not, then how can i do it on windows and linux? Please explain briefly .
View Replies !
Starting MySQL Server With Federated Engine Support
I have MySQL service installed on my machine. I want to start the MySQL server with FEDERATED engine support. According to MySQL Federated Engine, I should start the server with --federated option. Where do I need to change this? I tried adding federated to the my.cnf file. Then Federated engine started working and InnoDB stopped working. After adding this line, I executed MySQL Code: SHOW ENGINES; There, I couldn't find InnoDB in list.
View Replies !
Enabling InnoDB
Actually am using mysql 5.0 version, default it using MyISAM engine, but i wnat ot use InnoDB engine. I tried to change the my.cnf file with entry "default_server_engnie=InnoDB".but there is no use.
View Replies !
Enabling SSL & Setting Up A Certificate
I have MySQL 5.0.27 on XP Pro. I have not been able to find the correct syntax for starting MySQL so that SSL is enabled.I've searched the forums and the Manual. ALso, can anyone point me to a location which provides clear guidance on setting up an SSL certificate? %.9.7.4 of the Reference Manual wasn't too helpful for me.
View Replies !
Enabling InnoDB Error
I've successfully enabled InnoDB for my database but I'm getting the following error when I try and set on delete cascade for a foreign key. Error SQL query: ALTER TABLE `editors` ADD CONSTRAINT `participants_editors` FOREIGN KEY ( `account_id` ) REFERENCES `participants` ( `id` ) ON DELETE CASCADE MySQL said: Documentation #1005 - Can't create table './isimodev_co_uk_main/#sql-7d1_4c69.frm' (errno: 150)
View Replies !
Enabling Binary Log In Mysql 5.0.45
I wrote log_bin=[filename] in my.inf and restarted ,eventhough if checked at commandprompt through show variables statement, its showing log_bin =off.I tried through mysql adminstrator stratup variables also. But no change at all.can anyone tell me how to enable binary logs and further process for replication.Awaiting for your valuble replies.
View Replies !
Enabling Multiple Statements
I'm trying to execute the following multiple statements using MySql w/ the ODBC connector. INSERT INTO Sites(Hostname) values('zzz'); INSERT INTO Hosts(SiteID, Hostname) values(last_insert_id(), 'zzz'); I get the following error: [1064] [1] [0] "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; INSERT INTO SiteHosts(SiteID, Hostname) VALUES(@@IDENTITY, 'zzz')' at line 2" Is there something I have to do to enable multiple statements?
View Replies !
Enabling Remote Connections
Can someone tell me how to set up the mysql server to accept remote connections? Im using mysql 4.1 on Linux Ubuntu 5.10 I have tried editing my.cnf and changing the bind-address from 127.0.0.1 to the server's IP address, but this just results in the server failing to restart with the following error: Starting MySQL database server: mysqld...failed. Please take a look at the syslog. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! What do I have to do to get it to accept local and remote connections? Code:
View Replies !
InnoDB Tables And MyISAM Tables In ONE Database?
My application demands some advantages from InnoDB and some from MyISAM. Is it attainable to have both InnoDB tables and MyISAM tables in ONE database? Or else, getting views from two databases, one from InnoDB and the other from MyISAM? If not possible, any other approaches will do the job?
View Replies !
Copying Tables And Associated Linking Tables
I am having much difficulty with a query, and am hoping to get some assistance. I have the three tables shown below. I need to copy all rows in Table1 for a existing Table1.FID back into the same table but with a new Table1.FID. Both the existing Table1.FID value and the new Table1.FID value are known integers. Now the tricky part! I need to copy all rows in Table2 which are associated with a copied record in Table1 as related by the cross-table Table3. I also need to copy all records in Table3 with the new Table1 and Table2 FID's so that the new records in tables Table1 and Table2 can be related. I can use PHP if necessary, but as a mater of principle and performance, Table1 ID (primary ID, auto increment) FID (foreign ID) Data1 Data2 Data3 Table2 ID (primary ID, auto increment) Data1 Data2 Tablex12 Table1_ID (Table 1's primary ID) Table2_ID (Table 2's primary ID)
View Replies !
Selecting From Multiple Tables (20 Tables)
I am running MySQL 4.1.20, but use a PHP front end mostly, so I'm not too familiar with the mysql command line options. I have a database with 20 tables, which are data stamped. I'd like to do a select or delete statement that uses multiple tables. I know I can do select * from t1, t2, t3 where field= 'value' But since the table names change, is there a way to do some kind of wildcard expression for table names? Something like.. select * from t* where field= 'value'
View Replies !
100 Databases, 4 Tables Each, Or 1 Database, 400 Tables
I was able to build, tweak and do whatever necessary to establish a rather different project but am worried that it may sooner or later crash due to idiotic programming / database usage. In essense I took 1 database with 4 tables and duplicate it 100 times BUT because I need to connect to the different tables within the php script and am not experienced enough to created nested database connections, I duplicate the 400 tables within the same database. What I want to know from a MySql perspective, would it make any difference if the script "play around" with 1 database connection and 400 tables or would 100 databases with 4 tables each be better? (Maximum database queries to only 17 tables at a time)
View Replies !
How To Get The SUM Value From Two Tables? Join Tables? Subquery?
Hi, I have two tables: table A Id. | id_result | value 1 | 1| 10 2 | 1| 11 3 | 2| 7 4 | 2| 13 table B Id. | id_result | value 1 | 1| 4 2 | 1| 1 3 | 2| 5 4 | 2| 6 How can I get sum of unique keys from table A and B (id_result) like this?: id_result | sum_table_A | sum_table_B 1 | 21| 5 2 | 20| 11 I can do it with UNION or 2 separate SQL statement, but how to make it in 1 query or using subquery?
View Replies !
Small Tables Or A Few Big Tables
My Web site is going to use a MySQL database extensively throughout the Web site. It is a content management system type Web site with lots of users and written articles and other things. With my database I'm trying to figure out if I should create big tables that have a lot of rows in them or if I should create a lot of tables that are very specific to its data and use a lot of table joins in my select statements. I'm mostly concerned about performance. I'm thinking that if I make a lot of tables, then select statements I do will be really fast because my tables won't contain very many rows. But I don't know if this is true or not or if it matters for performance reasons or not. In my Web site I have a lot of different kinds of data that could put in many different tables. But, without data redundancy and without using extra storage space, I can still make a few big tables, and make that work. I just don't know which way is best for performance -- speed, I want speed. Anybody know what I should do or know a book I should read or a Web site to go to?
View Replies !
More Tables, Or Huge Tables?
i'm opening a web-service where people can open their own sites. i have about 18 tables for a website to be put on the air. i wonder what's better for my users: one huge table with a lot of rows, or opening 18 new tables in a database in the format: 0_users 0_images 1_users 1_images 2_users 2_images what's better performance wise? for 1000 users? for 10000 users? 100k users? i assume that in about 20k users i'll have to get a standalone db server..
View Replies !
One Or Many Tables
What is a better method: creating one large table with a category field or several smaller table distinguished by the category? The tables have identical structures. The records are retrieved only form one category at the time.
View Replies !
Certain Tables
In my phpbb forums database, I have woken up to find out that several (7 I think) tables have disappeared mysteriously.They are phpbb_: config ; confirm ; disallow ; forums ; forums_prune ; posts, and I haven't found the other one for some reason, though I haven't checked them all thoroughly, as I have quite a few for various mods. Anyhow, I thought the tables crashed or there was some kind of a dodgy error with mysql, but I don't know how to find anything like that out. There's nothing to suggest that in the logs. I wish to rule out the possibility of hacking, at least for now, because the password for the database exists only in the config.php file of the script, and it is a long string of random charters. Same thing with the root password, but it's even more complex, and is only stored in my brain. Regardless, is there any possible explanation for this, and if so, is there any way to recover the tables?I've had a look in the directory where they are stored, and the tables which have disappeared are simply not there, which I find very worrying.
View Replies !
Tables
I just did an update to mysql 5 from 4. Now it seems a bunch of my tables are corrupt. In phpMyAdmin they are comming back as "in use". When I try to run a query I get this: #1017 - Can't find file: 'tablename' (errno: 2) it seems to only be affecting the really old websites/tables. Please help.
View Replies !
Set Up My Tables
I need to set up some tables for a bookmarking module that I am making for a CMS. The data contained will be: userID catID catNAME bmName bmURL This will all have to be grouped around the userID as that will vary depending on who is logged in at any given time and I will be running queries like select all where username = 1 and catID = 10 , etc, etc I will also need to be able to insert new categorys (catID) that will reamin unique to each user.Now I would like to know what the best way would be to set up the tables for this - I could do this by trial and error, but I would like to hear an experts advice/opinion.
View Replies !
MAX() From Two Tables
In the spirit of... SELECT MAX(id) FROM tableOne I'd like to find the MAX(id) of either tableOne or tableTwo, whichever is highest. For example, if tableOne's highest id was 6 and tableTwo's was 9 I'd like to retrieve nine, and vice-versa should tableOne's MAX(id) be greater than tableTwo's. Right now I have two queries followed by a conditional in PHP. It works, it's just not as classy. I've got the gutt feeling that MySQL can do it in one statement.
View Replies !
Two Tables
I have 2 tables that are maintained independently but contain several columns containing data with the same field names. How do I join one table on top of the other so that I can select from both, As if it were temporarily one table?
View Replies !
Changes To Tables
I'm working on an application that someone else wrote (using PHP and MySQL). There are LOTS of queries that make changes to different tables with joins and it's really hard to track down what's been done to the data after running the code. I've been trying to check some of the changes with mysql_affected_rows (for updates) and I've tried that function every way I can think of and I can't get that function to work. I resorted to using a counter and just counting the number of times that a while loop runs to sort of get an idea of how many records _might_ have been touched. That has (obviously) turned out to be unreliable. Does anyone know of a tool (or method) to show changes to a mysql DB after running a query? I looked at mysql diff, but it just looks at structure changes. I need to know how many records were touched when this code was run and I've been working on this for quite sometime and I'm not getting anywhere
View Replies !
1-many Tables
The code below is used to sum all product prices stored in an orderline table. A sale can have more than one orderline, which sums fine, but the delivery is not summing correctly (delivery is summed for every orderline, not every sale). Is there anyway to get around this problem? SELECT SUM(orderline.oln_prod_price) AS price , SUM(sales.prod_delivery) AS delivery
View Replies !
Tables From 5.0.27
I recently upgraded to 5.0.27, only to find that it is not nearly as stable as the previous version I was running, 4.1.14. I've had constant problems since upgrading, and would like to move back to 4.1.14. However, apparently tables created with 5 are unreadable by 4. Is there a way to convert the tables that were created under 5 to be compatible with 4?
View Replies !
Too Many Tables
I recently started on a project in which medical data is going to be stored in a MySQL DB. I had never really thought about it this way but because the data is so private and sensitive, the insurace/patients/doctors request that the information be stored seperatly for each user. Right now that would mean a seperate table for each user which could easily add up thousands of tables. I am not by any means a DB expert but when I googled it I found varying opinions. Some people say that 150 tables is alot and others say they have worked with DB's that have 15,000. I just want to know if there is any significant performance decrease as more tables are added.
View Replies !
Sum From 2 Tables
I cannot seem to get the query to work. I have 3 tables. A, B and C. A.id = B.id and A.id = C.id I want to get A.* , sum(B.value), sum(C.value) for all records in A. I am trying this but I can't seem to get it to work. Select A.id, A.name, sum(B.value), sum(C.value) from A, B, C where A.id = B.id and A.id = C.id group by A.id; When I run the query it just sits there. Is this query correct? How can I achieve this, if my syntax is wrong.
View Replies !
Trying To Get A Max From Two Tables
I have two tables: categories: id | category | level_id 1 | cat1 | 2 2 | cat2 | 3 levels: level_id | name | priority 1 | level a | 3 2 | level b | 2 3 | level c | 1 Query result should be: level b I need the level name of the highest priority level that corresponds to the categories table. I can't just grab the max priority number from the levels table, so I assume I need to do some kind of join. I have to have the priority column, so people can change the order of the levels, in case anyone asks why I am doing that.
View Replies !
How Many Tables
I am currently trying to speed up a database that is performing extremely slowly (1 hour or more for the average selection, which I would like to take a few seconds in an ideal world). The biggest table in the database currently has 50 million lines (around 30GiB for the whole database). Each line is made up of a source id (a number between 1 and 37) a datetime column, a user column, a port column (of which there can be up to 65535*2 ports per hour per user per source id). I'm currently using innodb and MySQL server 4.1.14. Now the source column obviously has a very low uniqueness, and importantly, no read request will EVER request more than one source id. I am planning to summarize the information older than 2 months into two other tables (daily data and monthly data when it gets old enough) and I am thinking of splitting up the information into separate tables for each source id - however, this is all in preparation for the database to grow roughly 30 times its current size (1000 source ids) - this would mean 3000 tables.... is that a bit extreme? Is there a better solution?
View Replies !
Sum For 2 Tables
Is that possible to total up from 2 different column sum ? example table A sum(c) and table B sum(d), and now i would like total up the sum(c) and sum(d). For you info, i'm using 'uinion all' to display 2 'select' results .
View Replies !
Tables Have An ID?
Do MySQL tables have an ID that is not affected by table renames? Microsoft SQL Server has SYS.TABLES.ID Oracle has ALL_OBJECTS.OBJECT_ID How can I get this in MySQL?
View Replies !
Tables That Contains Tables
My question is simple... I have a DB with a Table that contains Users, and another Table that contains Clubs. I just want to be able to add a ROW in my Users Table listing all the clubs he has a membership on. I can't seem to understand how to do this,
View Replies !
About Tables
I have some tables, but forgot to save the folder of these table. I want to know how i can open my tables and find the database name. i konw this is a silly question. but i really can't find the anwser.
View Replies !
Look Up Between Two Tables
I'm using mysqlcc and mysql server 4.1 I have two tables: tbl01 and tbl02 tbl01 needs to look up data from tbl02 and store it. Then when I change the data in tbl02 it will automatically update the data in tbl01. I have been trying to do a look up as in Access but can’t find how to.
View Replies !
Tables
I have done the SHOW TABLE STATUS FROM database; Now I just watnt to list the names of all tables, Data_length, and Data_Free. Is there away to do this?
View Replies !
Tables In Use
Everytime I try a repair with my Web Host Manager my whole site freezes up. I have one table that is "in use" a sessions table. I can use putty and get to the >Mysql prompt but I am lost from there... Is there a way to repair or fix this? I have tried using phpmyadmin and cpanel and neither work, they just time out.
View Replies !
Dba Tables ?
In Oracle database there are tables for administration purpuse like dba_users, dba_tables, etc. There are any tables like those in mysql? I want to see for example the structure of a table without using php admin or other graphical tool.
View Replies !
Two Tables At Once
I have two tables Contact ID = autonumber NameID = Id1 from Master_Roll tabel ContactDate = contact Date details = Deatails of this contact Master_Roll ID1 = Autonumber Surname = Surname First NAme = First Name DOB SEX PHONE ADDRESS EMAIL I want to query the contact Table and the Master_roll Details table, I also want to add and update both tables. Which is the best way to do this?
View Replies !
|
TRACKER
