Program To Optimise Mysql Queries
Basically im looking for a program that will take input (my query) and produce an output with a much nicer, more efficient query. I have seen sql programs that do this sort of thing, but nothing for mysql.
Just wonder if there is any programs that i have missed? Tryed Toad for mysql, but that wasnt what i wanted, i dont want a program to admin a mysql database, simply to produce a more efficient query.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Optimise A MYSQL DB
I have had some experience with PHP NUKE of the past few weeks, and I have found its DB Optimise feature excellent, when I run this feature it will gain back about 2k on some items But now, I have decided that I do not want to use php nuke, but I would still like to optimise my db, does anyone know how this can be done.
MYSQL In A Program
How would I access a database from a program? All I need to connect in the program is the IP address or the URL, though I do not know how to get those from a database. Also, I'm still having trouble with this: http://forums.mysql.com/read.php?10,141978,141978#msg-141978
Using MySQL To Input Into Another Program
I have been working on a workaround to see if I can figure out how to get DATA from MySQL into another program. The other program is built on MS SQL server. The problem is that it is so bloated that a remote and my computer at the plant cannot correspond back and forwards. It takes approximately 10 minutes to key an order in to the remote plant. I was working on a much smaller database through MySQL and using OpenOffice.org as the front end. I just wanted to go a step further and see if there was a way to use a triggering mechanism of some sort to input the data from OOo/MySQL to the actual program the company uses.
Linking C Program With Mysql API
I'm linking a simple C code with mysql. I compile the code with this command: linux> gcc -L/usr/lib/mysql -I/usr/include/mysql sqlTest.cpp -lmysqlclient -lsocket -lnsl But it complains that "-lsocket" cannot be found. So, I removed "-lsocket" and try again, then I got the messages like /tmp/ccIelMdT.o(.eh_frame+0x11): undefined reference to `__gxx_personality_v0' /usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x66): In function `my_uncompress': /usr/src/packages/BUILD/mysql-5.0.27/libmysql/my_compress.c:85: undefined reference to `uncompress' /usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x11c): Infunction `my_compress_alloc': /usr/src/packages/BUILD/mysql-5.0.27/libmysql/my_compress.c:58: undefined reference to `compress' My system is SUSE Linux 9.1, and I installed mysql by downloading the rpm files from this site, and use "rpm -i mysql-xxxx.rpm" to install them. The libraries are installed at /usr/lib/mysql, and include files are at /usr/include/mysql. Can anybody tell me how I can configure my system to make it work?
Program MySQL With Apache
I don't even know what this is called, but I'm looking for a free tool that allows me to code MySQL and will work with Apache and PHP.
Packaging A MySQL Database With A Program
In writing a visaul basic database program with Access as the database you simply copy the database file into the packager and it is installed with your program on the target machine. I am guessing that with mysql, since it is a 'server' program, it is not that easy. Am I wrong? And where would I find information on this. I have been working on a business accounting program and am a long way from finished, but I wanted something more robust than access as the database. I just need to know how to get the database to the target machine with my program.
How To Access MYSql From External Program
I have a Mysql database on a webserver and would like to access order information automatically from my home computer. I have the ecommerce software send me an email of the order and I wrote a VB program to extract the information from the email and populate an Access database. There must be a better way. Can I somehow have MS Access backup that database on my home computer?
Another Program To Access MySQL Database
I have a list of 8 rows by 11 columns that I exported from Excel into MySQL to populate my Database and that all made it through. I am now trying to create a label with a label making program that will connect to a database. I have installed the ODBC 3.51 driver and tested the link and it finds the file. When I try to open the database file from the label making program it says "Error Reading Record Fields", I click on details and it says "ODBC driver does not support dynasets." I have no idea what a dynaset is or why it is an error??? Is there a way around this? I can save the excel file as a DBaseIII .dbf file and it works but I wanted to be able to use a database for better tracking of information.
MySQL Admin Program/Script
I'm looking for an application, or php script that makes entering and retrieving information out of a database automated. The process would like so: I enter in the mysql un/pass etc. and create tables and rows. Also defining what type of input each row should have. Whether it be a checkbox, a dropdown menu, plain text input. Also defining what options for things like the checkboxes and dropdowns. After that, you would be able to go to a simple front end that had the inputs you defined. You could create your entries and retrive them. Sorting them how you see fit. Given the obvious use for such a thing, there must be plenty. I must not be wording my searches correctly though. I would prefer something free/open source.
Redirect Out Of Mysql Client Program To A File
I have mysql on MS Windows2000. I like to redirect the output/error messages of MySQL client programs to a file. For example, when I execute: "mysql --user=root --password=[wrongpaswd] --silent --database=mysql > errfile" The following error message is coming in the screen, not in 'errfile' "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)" I also need to capture the same for utility "mysqlimport". How capture the output of these client programs in a file?
Create A C++ Based Program Using Mysql Odbc.
I want my software to be independant of operation system and databases. That's why I want to use odbc, and don't want to use MFC. Here I have some questions to ask: 1. On unix (like sun solaris), does there exists any kind of midware like odbc? 2. I search on the internet, and find most of the examples are based on PHP. Is there any c++ examples? 3.Once I chose odbc, does that mean that whatever kind of database I would use later, I don't have to change my source code? 4. now I program on window xp platform. If I use odbc, when impliment my program to a unix platform, do i have to rewrite my code? I just started this project, and I'm a newbie. The problems may be a little bit of stupid. Can you guys give me some information about this topic?
Displaying MySQL TEXT Datatype In C Program
I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program. the line is as follows: while((row = mysql_fetch_row(result)) != NULL) { printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL")); } I have trued %c and %s in to print the Sensor name, however %s crashes the program and %c produces a smiley face.
Making Connection To Mysql From A C Program On Windows
can any one please tell me "how to make a conncetion to mysql database from a C program on windows " . Please help me by giving possible code for making a conncection,selecting data etc. i.e. what library files i need to include,what are the functions needed to be called.
Create My Own VB Backup Program For A Remote MySQL DB
I understand that the basic principles to create a TCP/IP backup program for a remote MySQL DB are: a) Query/retrieve the schema. b) Query/retrieve each table and create inserts for each row of data. The way I want to do it is even more basic, as I know what my schema is so I only need to reterieve and create the insert rows to put into my backup text file, which is basically a large DDL. The problems that I am experiencing are I want to keep the schema in an external text file so that I'm not storing it in the actual app and I thought I would also have another external file to store each 'select * from tablex' query. Is this a good way of doing it? How would I merge the results together to make a new (and 3rd) external text file backup?
Problem: Displaying MySQL TEXT Datatype In C Program
I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program. the line is as follows: while((row = mysql_fetch_row(result)) != NULL) { printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL")); } I have trued %c and %s in to print the Sensor name, however %s crashes the program and %c produces a smiley face.
Complex Queries Versus Multiple Simple Queries
I am constructing a database to contain information about stories posted on my site. Information included will be things like title, author(s), genre(s), story codes, synopsis, etc. I worked out that storing this information properly, so that it can all be searched on, could take as many as ten tables. My question is this: Is a single complex query really better (more efficient for the server) than multiple simple queries? In other words, I may need the information for as many as 25 or even 50 stories for a single page. Is it better to get all of the information out of a single, massive, complex query, or is it acceptable to get the information essentially one story at a time, which could mean 25 or 50 simple queries...?
Mysqlimport Program
I have been using load data in file command until recently on a windows machine - works fine. we are now using a Netware 6.5 box and are trying to use mysqlimport from the command line. I am using: mysqlimport --password=123456789 --fields-optionally-enclosed-by="" --fields-terminated-by="," 0608c sys:mysqlinstirling.txt to import a CSV text file into the database 0608c. the data looks like this "2007-06-28 16:07:00",0,13.58,15.77,-13.35,-12.69,-13.36,-6.61,-3.821,...... when the program executes it seems to give the desired results except the timedate is all zeros...
Extraction Program
I am looking for a simple extraction/load program to load data daily from a Progress 8.3B database via ODBC to a mysql 3.23.57 database. It does not necessarily need to do any data-type transforms. It need to run on Windows 2000 and be able to run it as a service, or as a cron task if running under Unix.
Setup Program
I'm writing a Java setup program for installing a JDBC app, which connects to a Mysql database.I want to create a script in order to provide final user setting privileges in that database and add it a table, without needing to write Mysql commands. How can I do it ?
DB Modelling Program
Is there a database (ERM) modelling program for Mac OS X that can handle MySQL? Maybe a freeware one?
Php Email Program
Does anyone know of a php or even cold fusion based script out there for accessing email that can be customized? Right now I use SquirrelMail which is great, however, you can't really customize it to tie in with your web site. Is there something out there that is very flexible that I could make fit right into my site which is pretty reliable in terms of web email?
Php Email Program
Does anyone know of a php or even cold fusion based script out there for accessing email that can be customized? Right now I use SquirrelMail which is great, however, you can't really customize it to tie in with your web site. Is there something out there that is very flexible that I could make fit right into my site which is pretty reliable in terms of web email
Many Smaller Queries Vs. Large Comlicated Queries
I am wondering if any one can help me. I have a page that will run around 85 smaller queries but if i combine the queries it will go down by almost half. This page is a high traffic page and I don't a complicated query taking up mysql resources while it created a temp table and such. My question is this: Is it better for mysql to run a lot of smaller queries (ex: simple selects with zero or one join, group by) or one larger complicated query with everything combined. The thing i have to keep in mind is that the mysql selects are comming off the localhost that the web server is also running on so they share the same resources.
C- Program To Write To Myi , Myd File
is it possible to create a myi, myd file for mysql using a C program. I am using Stata that is written in C API, and I want to write the data out to MYSQL database. Using ODBC and loading the data in MYSQL from STATA takes forever. Can anyone please tell me if I can create the myd files by using the data in memory thru C programming.
Can't Update A Field From VB Program
I've just setup MySQL on a Linux machine and I'm using Visual Basic in Windows to connect to it (using MySQL ODBC 3.51 driver). Everything works fine for browsing the database (used for stock control), but some parts of the VB program refuse to update the database. It was using an Access database (which worked ok) and I'm using the same SQL statement and table structure. Code:
Trigger To Run An External Program
Can I trigger an external program to run when a new record is added to the mysql table? The external program is in C and instead of scanning the table continuously for new insertions, it will be better if an external program could be triggered.
Can't Update A Field From VB Program
I've just setup MySQL on a Linux machine and I'm using Visual Basic in Windows to connect to it (using MySQL ODBC 3.51 driver). Everything works fine for browsing the database (used for stock control), but some parts of the VB program refuse to update the database. It was using an Access database (which worked ok) and I'm using the same SQL statement and table structure. Here's the SQL statement that VB runs: SELECT Stock.GJGStockCode, Stock.PartName, Stock.Discontinued, Stock.UnitsInStock, Stock.UnitsOnOrder, Stock.ReorderLevel, Stock.ReorderQty, StockSuppliers.SupplierID, StockSuppliers.OrderCode, StockSuppliers.PackQty, StockSuppliers.Price, Stock.PartsToOrder FROM Stock, StockSuppliers WHERE Stock.CurrentSupplier = StockSuppliers.Position AND Stock.GJGStockCode = StockSuppliers.GJGStockCode AND ((Stock.UnitsInStock + Stock.UnitsOnOrder <= Stock.ReorderLevel) OR (Stock.PartsToOrder > 0)) ORDER BY StockSuppliers.SupplierID, Stock.GJGStockCode ....which works ok for browsing the database. If I change the Stock.PartsToOrder field in the VB program, when VB trys to update it I get the error message "Insufficient key column information for updating or refreshing". The Stock table has a primary key (GJGStockCode), and the StockSuppliers table has a primary key (UniqueID) which is an auto_increment bigint. Does anybody know what I need to do to allow VB to update the database? Or is this a VB question!?? - Although the same SQL statement works with an Access database.
Program Refusing To DROP DB
I am getting this problem over phpmyadmin and also over a preprogrammed php script. When there are more than 30 or 40 selected DBs the programs refuse to carry out any command when I click on the drop button. They would just take as if there is no command issued at all..... Anyone know how to make it delete more DBs at one time? I looked at trhe my.cnf file but don't see any options to do this... It however runs on small batches but I need it to drop a lot more databases at one time.
PROGRAM TO UPDATE DATA TABLES
I need to be able to DELETE selected record & LOAD DATA from a text file or Foxpro table, from a program that can run continuously. I've tried Foxpro, but FoxPro views are too slow. I have also tried issuing these command from Foxpro with an ODBC connection established, but that does not work at all. The object is to remove all records for a member and replace these records with records from a new file. Each transaction will be up to 50,000 records. I need to execute 2 commands: DELETE FROM parts WHERE parts.member_id="xxx" and LOAD DATA INFILE 'd:/xxx.txt' INTO TABLE parts
Displaying TEXT Datatype With C Program
I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program. the line is as follows: while((row = mysql_fetch_row(result)) != NULL) { printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL")); } I have trued %c and %s in to print the Sensor name, however %s crashes the program and %c produces a smiley face.
Displaying TEXT Datatype With C Program
I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program. the line is as follows: while((row = mysql_fetch_row(result)) != NULL) { printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL")); } I have trued %c and %s in to print the Sensor name, however %s crashes the program and %c produces a smiley face.
Data On Separate Drive From Program Files
I have a server that I want to run MySQL on. The server has a 6.4gb hard drive for the OS and applications and a raid array for data that is shared via samba. What I want to do is install MySQL on the 6.4gb hard drive but have all the DATA saved to the raid array.
MySQL Queries
MySQL has no subqueries for version I'm using, some 4.x.y.z I've an employee table containing academics of many people. I need pull out second maximum percentage data from db records. Suppose 2 or more people have same marks distribution. So, how can I query MySQL?
Sub Queries In Mysql?
Is there a way to do something like subqueries in one query? I have a customer table (Klant) with contacts (KlantKontakt) and a address (Adres) table. The address table keeps a record of each different address for a customer including old addresses (to maintain history). If I want to retrieve a list of customers with their newest address, I have to do a max() to retreive the last address. I can do this in PHP in a seperate query but I like to do it in one query on the mysql prompt. Code:
Mysql Queries
I have a query that brings mysql box down... SELECT t1.emailaddr, t2.emailaddr FROM june t1, may_2007 t2 table june = 12229 rows table may_2007 = 4500 rows Is this a big DB that it would bring a whole mysql box down. My Local box has 512MB ram and the mail mysql server box has 5gigs of ram...
MySQL Queries
I am learning PHP & MySQL. I have a few questions regarding SQL queries. DEFAULT value What I'm trying to ask is, if you used the above definition, will that value be stored in any row, if a row is made in that column? Or..?
MySQL Queries
I have a very busy database with some tables having hundreds of thousands of records. I am running MySQL 5.0.16 on Windows. Some of the queries running on my database are not fined-tuned enough, and need improvement. However, the system is live in production and I am looking for a way to prevent MYSQL from committing Harakiri, i.e. from running very slow queries forever, taking the cpu to 50% and beyond for hours. My scripting language is PHP. I found that after a while the end user receives a timeout on the browser, but MySQL continues trying to run the query, sometimes for hours. My question is, is there a way to specify a timeout for MySQL so that it will abort any queries that it is running that have not returned a result by then. The end user is no longer around anyway, so I am looking for a way to protect the database resources (and in parallel I will start investigating how to optimize the slow queries)
Intersection Queries In MySQL
There is a feature in MS Access, that allows you to run intersection queries. What I mean. Consider the tables: modules ModuleID Name Main Main module Menu Menu navigation User User management groups: GroupID Name 1 Common 2 Administrators group_rights: ModuleID GroupID User 2 Menu 2 Access allows you to build a table as a result of the query, that looks like this: GroupID Main Menu User 1 NULL NULL NULL 2 NULL 1 1 Is it possible to build something like that in MySQL with 1 query?
2 Simple Mysql Queries
have problems with 2 simple queries and i dont know how to solve them. plz help me. first one looks like this: 1.What’s the average length of the movies released in 2006? And which movie comes closest to that average length? (search upwards) i wrote 2 separate queries: select avg(length) from film where release_year = 2006; and the second one: select title, length from film where release_year = 2006 order by length; i have to make this into one query. how do i do that? what should i write? the second query looks like this: One of the customers comes into the video store and he needs your help to find a children movie with 2 words to solve a word puzzle. In the puzzle the second word has 8 letters. He already knows that the 4th letter is “E” and the last 2 letters are “N” and “D”. Help him to find the movie i wrote: select title from film where title like ('% ___E__ND') and film_id in (select film_id from film_category where category_id in (select category_id from category where name = 'Children')); but the problem is that it doesnt return me a result. this query contains everything but the things are not in order. plz help me!
Logging Queries On MYSQL
I am running Red Hat and MySQL, I am needing to make it that mysql logs all queries done on the server, at the moment my /etc/my.cnf file looks like this. [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid What do I need to do to accompish this , I have looked on google and just cant find the answer at all to this.
ASP.NET And MySQL: PARAMTERISED QUERIES
I'm Trying teh following code I get teh above error any help would be appreciated Dim User1 as string User1 = Session("Username") Dim myConnection As MySqlConnection Dim myDataAdapter As MySqlDataAdapter Dim myDataset As DataSet Dim iCmd As new MySqlCommand Dim Query = "SELECT * FROM texts WHERE USERID = ?User" iCmd.CommandText = Query iCmd.Parameters.Add(New MySqlParameter("?User", User1)) myDataAdapter = New MySqlDataAdapter(iCmd.CommandText, strConnection) myDataAdapter.Fill(myDataset, "texts") I get the following error: MySql.Data.MySqlClient.MySqlException: Parameter '?User' must be defined Any ideas?
Does Mysql 3.23.51 Support Sub Queries?
the following: SELECT customerNo AS Count FROM Customers WHERE customerNo = (SELECT MAX(customerNo ) FROM Customers ); gives: ERROR 1064 : You have an error in your SQL syntax near '(SELECT MAX(customerNo ) FROM Customers )' at line 1 any ideas or alternatives to the above method? it works fine on mysql 5.0
Rhel4:mysql Queries
what are the differences between these packages? 1. mysql-server-4.1.7-4.RHEL4.1.i386.rpm 2. mysql-4.1.7-4.RHEL4.1.i386.rpm 3. mysql-bench-4.1.7-4.RHEL4.1.i386.rpm 4. mysql-devel-4.1.7-4.RHEL4.1.i386.rpm 5. mysqlclient10-3.23.58-4.RHEL4.1.i386.rpm i'm not subscribed to rhn, how do i upgrade mysql from 4.0 to 4.1, i've checked mysql site and look for guides how to upgrade. i came across some pages talking about things to do when upgrading. but it doesn't explicitely mention the steps to upgrade. like, uninstall current version, install the new version, etc. how do you upgrade mysql? what happens to current databases if i uninstall current version?
MySQL Database Queries
Is there a site that anyone knows of, that shows creating a MySQL database from input through output is concerned? I'd LOVE to see a tutorial that included the interface for input, the usable MySQL database and then the query potential (including query interface). I'm new to MySQL and haven't been able to find much on the internal workings of the database or query applications despite a pretty spendy book I purchased on the subject.
Parametrizing MySQL Queries In ASP.NET
I am trying to avoid the usual SQL injection attacks, how do you paramterize MySQl queries so that the strings used to create the query are variables. I am using a MySQLDataAdapter to fill a DataSet.
How Would I Connect These 2 MySQL Queries?
I'm trying to combine these 2 queries, having a hard time. I have two tables they are ezu_files and ezu_uploadinfos. Here's what the two tables look like: ezu_files --------- id upload name value ezu_uploadinfos --------------- id upload name type size * id and upload are the only two common fields between the two tables. Code:
|
TRACKER
