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
See Related Forum Messages: Follow the Links Below to View Complete Thread
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?
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;
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 .
Enabling SSL Using MySQL Rpm
How do I enable MySQL to accept ssl connections using the rpm version of MySQL 4.1.10. I am using RHEL 3.0. Can some one point in the right direction?
Enabling Replication
If I add log-bin server-id=1 to my.ini and restart the server it starts creating the .bin logs - woo hoo ! Unfortunately I then cannot log into,or use mysql - I have tried at the cmd line with localhost in the connect string and also the actual IP address ..... no joy If I comment out the log-bin lines then all is ok again (phew!) - nothing is present in the error log either .... Any ideas what I am missing ?
Web-enabling The Database
After information has been added to the mysql database, how do you go about web-enabling the information to be searched by your visitors?
Enabling INNODB
in mysql 4.1 that came with xampp package, i saw that innodb table type is disabled..how may i enable it?
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.
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:
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.
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?
Cannot Alias Locked Tables / Join To Unlocked Tables ?
If you manually issue a table lock then query that table, aliasing the table generates an error. If you try to join the table to another table that is not locked, you will receive an error. What is the reason for this?
Multiple Smaller Tables V.s. Fewer Bigger Tables
What is the best way to store data in a database? Multiple smaller tables (which means many Inner/Left Joins when fetching the information) or fewer bigger tables (which means few or no Inner/Left Joins when fetching information).
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?
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?
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)
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..
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?
Tables On ISP
I am a newbie. I recently had the web developers for my company create a form online for one of my vendors that uses MySQL as the database. I have been unsuccessful at using the command line to connect to the tables. Do i need the mysql service on the computer that i am using to connect to my web server? What exactly do i need to connect to the tables?
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.
SQL Tables
I am working on my table structure and am alittle stuck on what to do. The user has the ability to reg himself, and if he doesnt then his details wont be saved but his transaction will. Now, when I store the transactions for regged and unregged users should I store them in different tables ? See the tables below: User Table UserID Name Contact Email Gender Registered username password moderator Event Table EventID EventName MaxNoTickets SingleTicketPrice Purchase Table PurchaseID UserID EventID NoOfTicketsPurchased TotalPrice As you can see, the following table would only work if the user was registered. But now the question is how I should store events for unregistered users. So far it looks like I will need to create a seperate table.
Many Tables In 1 DB Vs. Few Tables In Many DBs
How much of a performance hit will I have if I have 1 database with 300 tables, versus 30 databases with 10 tables each? (the single database would have about 30x the traffic of any single database). I don't expect the tables themselves to be very long at all, perhaps a couple hundred records max. Also, this will all run on the same server installation either way, so with 30 tables I don't get 30 MySQL servers. The traffic isn't going to be super heavy at all. So, the question is, is it really worth setting up 30 DBs or should I just drop everything into one and keep it simple?
Get Max() Value Between Two Tables
What is the best way to get the maximum value of a "like" field in two tables?(I.e. Table1 - Field1 - Values: 0002, 0003, 0005 Table2 - Field1 - Values: 0001, 0005 ) Result should be: 0005
Too Many Tables - Bad?
I have a database with 138 tables. Is having too many tables bad? Can it slow things down?
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.
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.
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.
Big Tables
I have a big inno table (about 20 GB). Is it posible to divide the table into several files?
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?
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?
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.
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?
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.
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.
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.
Two Tables
there are two kinds of users - ordinary users - special users Both kinds have the same fields like login,password,email etc. Special users have few more like name,surname,specialisation etc. Should I use one table ? user_profile: id login password email name - NULL surname - NULL
Big Tables
So i've got a table with 15 million rows.. id is the primary key SELECT COUNT(id) FROM listings WHERE id != 0; takes about a minute to load... which is insanely slow.. anyone know what could be causing this?
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.
Sql Tables
i cant seem to fix.I made the two sql tables and the php works but it is not working with my sql and this is what it says. Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /vhost/vhost3/o/n/e/oneeyedbeaver.co.uk/www/config.php on line 10 cannot connect to server .What am I doing wrong? I have php forms all set up and they are all ok.Any help would be very appreciated many thanks. Im also sorry about this if it is in the wrong section.
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.
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.
Two Tables
I have the following tables. (Please see png image) I want to keep my site members contacts (other members) in a different table and link them.So in the table contacts I will have two columns membersID and membersID (named contactID). Is this bad design since I cant think of any other way to store members contacts.
Two Tables
I want to get the records from table design AND from the table project. I tried : SELECT * FROM design,project WHERE design.headline = 'BOOKLET' AND project.headline = 'BOOKLET' but I only get the records from the table project and I get them 4 times
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 .
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
|
TRACKER
