MYSQL :: How To Make Database Access Fast

How To Make Database Access Fast
In my linux server (LOCAL), *accessing data through the PHP scripts from MySQL (3.23.41)tables, it is taking more time. * Earlier it was very fast. * Now a days some reports it is taking more than five minuits. Earlier it use to come with in a minuit. *What may the problem and what I have to do spead up the process.

Opinion: What The Access More Fast? ODBC Or MYSQL
s

Could Not Connect To The Database, Please Recheck The Settings You Specified. Also Make Sure That A Database With The Name You Specified Already Exists On The Database Server. PhpAdsNew Will Not Create The Database For You, You Must Create It Manually
The error message I get above is the same everytime when trying to install phpAdsnew. I have tried everything. I am hosted through yahoo! and have actually succesfully installed scripts before even though I know nothing about it. Now that I have a "auto-install", it does not work. Yahoo! also offers php-nuke with the auto-install where you just click a few buttons, and I get a similar error stating that it can not conect to the database.

Please can anyone help me and tell me what I am doing wrong?

How To Make A Database?
i have installed the MySQL thing, but i wanna know how to make a database.

MySql Actually Make A Database?
I am trying to make the transition and I don't get how mySql works with files.

1. I've been able to make databases and edit them. Where is the database?
2. I'm on the latest version of Mac OS. I can't find the database name with spotlight.

How To Make A Database Multi-lingual?
Just wondering how I would be able to make the data stored into MySQL database to display in multi-languages?

Mysql Database Connection - How To Make Connectin?
i have two website . both hosted on diff. server

now what i need is to connect second website database from first website
***
detail
***
when user register on first website a insert query should also make on second website database.
can you tell me how can i write my conenction string:

server1:rs397.secureserver.com (database: abc) , website 1: www.example1.com
server2:rs455.secureserver.com (database: 3214), website 2: www.example2.com

waiting for any one urgent reply
vr4indian@yahoo.com is my email id or you can also reply on this message

How Can I Make A Query Like Microsoft Access, And A Query From A Query
I am new to MYSQL and am trying to understand how to make queries... I am moving from Microsoft Access where it is GUI driven and easy!

I can make a simple single query using MYSQL Query Browser, say:

qry1: SELECT ID, Area FROM data GROUP BY Area

How can I store this as a query inside MYSQL, rather than having to code it each time?

In Microsoft Access I could enter a variable ($VARIABLE) and then pass by code to the query:

qry2: SELECT ID, $VARIABLE FROM data GROUP BY $VARIABLE

How can I store this as a query and then pass the variable from code?

In Microsoft Access I could base a query on the results of another query, so following example above:

qry3: SELECT qry1.Area, data.ID FROM qry1 INNER JOIN data ON qry1.Area = data.Area;

How can I store this as a query in MYSQL.

Create Error: Access Denied For User: '@localhost' To Database 'database Name'
I have already installed the php4, apache and mySQL on windowsXP SP2.
when I wanted to create database through PHP code it showed me error like this "Create Error: Access denied for user: '@localhost' to database 'database name'" and I can't even create database using mySQL either.

How Fast Is A Lookup?
I have 100K records in a mysql db and wondered how long - approximately - it takes to look up a matching ip address.

My code looks something like this:

PHP

$ipaddress=$_SERVER['REMOTE_ADDR'];$offer=$_GET['offer'];$affiliate=$_GET['affiliate'];$db1=mysql_connect("mysite.com",'user','pw');mysql_select_db("mydb",$db1);$q=mysql_query("SELECT * FROM `offers` WHERE `offer`='$offer' AND `affiliate`='$affiliate'");if (mysql_num_rows($q)==1) $r=mysql_fetch_assoc($q) AND mysql_query("UPDATE visitor_log SET `sale` = Ƈ', `oid` = '{$r['offer']}', `comm`='{$r['comm']}' WHERE ipaddress='$ipaddress'");mysql_close($db1);

Does this sort of thing take under a second? Ten seconds? I've no idea.

What Is The Best Way To Get Fast Query?
I've uploaded big database with millions of rows (different places with geographical coordinates) to my server (MySQL). I wonder how can I get faster queries?

I have cheap server. It's Celeron 2.8 with 1 Gb of RAM. For example, this query takes 10 seconds:

Quote:

SELECT * FROM table WHERE latitude > ཬ.832633619561896' AND latitude < ཬ.90083790234088' AND longitude > ƈ.1649932861328125' AND longitude < ƈ.5014495849609375' ORDER BY 'population' DESC LIMIT 0, 20

I need to get fast queries, like 0.1-0.5 seconds instead of 10 seconds. What is the best way to get fast queries:

1. Better, more expensive server. Will this solve the problem? Or it's not worth of the money?

2. Optimizing queries. Still I don't think this will give me 0.1 seconds query instead of 10 seconds. Am I wrong?

3. Splitting database to 500-5000 tables by coordinates (splitting map virtually to small quares). Is this a good idea?

Fast Mysql Search
Is there anything for making the search fast in mysql? like indexing in MS Sql Server.
I want to make the search function fast.

Fast Data Retieval
I want your suggestion about how I can retrieve data very fast from a mysql table.The table size is 1.2 GB. Whenever I am trying to run a query which includes group by it is taking too much time.

Fast Keyword Search
I´m asked to "speed up" a keyword search based on MySQL.
The material i´m given to work with is a quite large MySQL table with
1.5 mio rows, defined something like:

CREATE TABLE datarecords (
id BIGINT(20) NOT NULL auto_increment,
[3-4 other INT type columns],
keywords TEXT NOT NULL,
updated TIMESTAMP(14) NOT NULL,
PRIMARY KEY (id)) TYPE=MyISAM;

The search requires the id-fields of the datarecords table to be
returned, based on keywords within the keywords-field, like so:

SELECT id FROM datarecords WHERE (
(keywords LIKE '%someword%' AND keywords LIKE '%otherword%')
AND
(keywords NOT LIKE '%notthisword%' AND keywords NOT LIKE
'%thisneither%')
)

The table has grown unexpectedly large and will keep growing, so a
different method for keyword searching appears to be required, since
search-speed has decreased significantly (now at about 12 secs,
depending an the number of searched keywords)

Using FULLTEXT indexing has brought no performance increase...

Question:
Does anybody have any suggestion on how to tackle this type of
problem, to get search-speed down to about 2-3 secs?

One way i´m looking at this is to create a seperate keyword-table
something like this:

CREATE TABLE testkwdlist (
keyword varchar(32) NOT NULL default '',
ids text NOT NULL,
PRIMARY KEY (keyword)
) TYPE=MyISAM;

and filling this table up with the keywords and listing the IDs in the
ids-field, doing seperate queries for the positive and negative
searches and compiling the actual resultset in code...

Does this sound it has potential for a performance boost or is it
competely insane?

How To Convert MS Access Database To Mysql Database??
now i have more than ten thousand data in MS Access database and now i heed change it in to mysql database!So do you know how to that?I think i not time to key in back this all data because it is imposible la,because more than 10 thousand data la!

Converting Ms Access Database To Mysql 5 Database
I've imported a ms access database into a table in a mysql database.
The access database contains a field that holds date/time values in
'general date' format. These all show up at 01/01/1970 in the mysql
database. I believe the field in mysql is wanting UTC and shows
numbers when looked at from the sql command line (i.e. March 13, 2006,
5:31 pm is shown as 1142289086). How do I get the access data into
that format so it will import properly?

Fast Input Of Binary Data
We are considering MySQL as an alternative to the Sybase databases that we have now. One thing we need to be able to do is insert tens of millions of rows of data quickly. Each row may have 10 to 20 columns. The source of these data are binary data files. Is there a way to do this quickly? Currently we are using Sybase's bulk copy utility bcp. Is there something comparable in MySQL?

We also need to be able to extract large amounts of data from the database and put them into binary data files. Again we are currently doing this with Sybase's bcp utility. Can we do this in MySQL?

Looking For Fast MySQL Components For Delphi 6/7
I'm on a trek looking for fast reliable (bug free) MySQL 4.1 components for
Delphi 6/7 for accessing large MyISAM and Innodb tables. Can anyone make
any recommendations?

I've tried MySQLDAC from MicroOlap and unfortunately support is terrible.
(No reply to any of my e-mails in the past 2 weeks).

I'm also looking at Zeos (where are the support newsgroups?), SciBit, and
CoreLab.

Does anyone have any recommendations? Horror stories? Ones to avoid?

Fast MySQL Backup With Rsync
wouldn't it be possible to do a fast backup of the MySQL data in this
way:

1.) rsync the MySQL data (with running mysqld)
2.) Stop mysqld
3.) rsync the MySQL data again

Please answer. I have found a similiar post in the year 2001, but no
replies. I think, if this is possible, it would be very useful for a
whole bunch of tasks. (For example changing hard drives in servers:
You could rsync everything, including the mysql data. The only
downtime would be from the point of shutting down all daemons to get a
consistent snapshot to the point of rebooting the server.)

Searching Rows Containig A Substring Fast
I am creating a server indexing files in my local area network, in
order to provide a searching feature.

So i want to make it possible to searchsuch rows where the 'name'
(VARCHAR) column contains a substring submitted by user.

an i use a full-text index to make it faster? from my first sight i
noticed that this index can be used to search for words in a string. So

the example below would not go:

searching 'cool' in 'uncoolness'

Am i right? Are there any other solutions? Maby some other databases
provide this use case?

Fast SELECTs Versus Slow INSERTs With Indexes
I run a MySQL database using phpMyAdmin interfaced with an application written in C++, and most of my nine database tables have 500,000 - 2,000,000 records in them. These tables also have about five-to-six indexes each. This makes working with the C++ application extremely fast, which is nice. Any SELECT statements can be run in less than a second, and I'm very happy. The problem comes when I have to insert new records into the tables. Every morning, I am received a pipe-separated .txt file of the previous day's new records (about 500 - 1,000) that I have to insert into the tables using my C++ application. Well, this takes an excruciatingly long time (almost an hour, actually) and I need to find some way to make it run faster. I am thinking of several options here:

Simple Fast Way To Grab The Highest ID From A MySQL Table?
I have a MySQL table on my web server (external web host) that has an
auto-increment integer as it's primary key field.

Is there a quick PHP function that will get me the highest ID in the table,
that is, the ID that belongs to the last record added.

Note, I need it to work across and between connection session, not from
within the same connection session.

How To Allow Access Just To One Database?
I have several database setups on my hosting account using Cpanel.

I want to allow an individual access to just one of these databases using phpmyadmin.

However whenever I try to go to the direct link to the open database in phpmyadmin it asks me for a username and password and just won't accept the dbusername and dbpassword. It wants the hosting package uname and password!

Thus when you log in like that you can access all the databases under phpmyadmin.

Am i missing something really simple here?

Can't Access Database
I have just installed MySQL version 5.0.18 on a VMWare session running Suse 10. I was able to start the server, create a database, and create a user with permissions to said database.

I am able to connect to the database and run queries on it remotely from the host OS (keeping in mind that the database is on a virtual machine, so this is technically remote access). However, if I run the admin.php file for PHPNuke or the vb_test.php file from vBulletin, I'm unable to access the database. Do these forums not support the newer versions of MySQL?

Access Only To A Particular Database
How do I grant full access on a particular database (all tables) to a particular user. I issued the following command but when I log in as the user and do I "show database" I don't see the database:

grant all on mynewdb.* to 'gregh'@'%';

This way anyplace the user gregh logs in from, the user would have access to mynewdb. However, when gregh logs in from localhost, and does a "show databases", only the "test" database shows up. Am I doing something wrong?

Access Database On Web
I have a database on a webserver and now would like to write a small windows application to access this database, read and write to it. As I understand it correctly, I have to code in the username and password of the database. So, the question is, if I deploy this little application to other users, can they not get hold of my username/password by just decompiling the application? Is this not a big security risk? Or are there other ways to read and write to the database without me coding in my password?

Access Database
I am having trouble getting started. I have an Access database with multiple tables in it, and I want to post it on a website so that people can search it and edit it.
I dont konw really where to begin. I have a domain with MySQL capabilities, but I really dont know what to do next. I would really love some hand holding, and it wouldnt take that much time to teach me how to do it.
IM me at RND328 if you are willing or just respond to this post.

Access Database
A friend of mine mailed me a access database (.mdb), but I only use Linux
(RH 9.0) . Is there anyway that I can open the database in mysql?

How Do I Rewrite A Slow Subquery Into A Fast Join? (Prolly Real Easy For A Non-noob To Answer)
I used subquerys because they made more sense to me, until the table got "a lot" of data in it (not really... just 1000 entries) - then all querys including subquerys slowed down to 4-5 secs EACH!! :) This is insanely slow.

What I am doing here below is looking into what messages a user has already read in the subquery, so that none of the ones he already has read will EVER again show up for him.

So, how do I rewrite this subquery:

NOT IN (SELECT reffen FROM $readt WHERE sender = $nr)

From this entire SELECT:

SELECT halfref, brokensms, DATE_FORMAT(arrived, '%y'), DATE_FORMAT(arrived, '%m'), DATE_FORMAT(arrived, '%d'), DATE_FORMAT(arrived, '%H'), DATE_FORMAT(arrived, '%i'), priv FROM $halft WHERE sender = $nr and halfref NOT IN (SELECT reffen FROM $readt WHERE sender = $nr) order by id desc limit 1

Into a faster join of some sort?

I'd aprichiate if you told me what each part of the rewrite actually does, because I been reading about joins for a day now and still don't get them at all!

Access To Other Host Sql Database
I currently own a website with various different MySql databases. I use the mysql_connect ("localhost",""....) to connect. I would like to give another website access to this database. What would they have to enter in place of "localhost"?

Restrict Database Access
I have a complete application developed using MySQL as the data server and Microsoft Visual Fox as the GUI. My users all have privileges dependent upon their job functions BUT I can not find a way that I can stop other applications from accessing and changing the data as long as they do so with a valid userid and password.

The reason this is a BIG problem is many of the 'rules' governing table updates are part of the application and NOT part of the database. I can not use the IP validation as it is quite possible the unwanted access and changes could come from the same IP that a valid change would come from. This seems like it should be so easy to solve but I have spent many hours in the documentation with no results.

Database Access From Different Locations
My database is housed in a directory say "CHAMPION".Now, i copied this directory contents to a different location say "FORMULA1".

The formula1 directory does'nt have the database.

Is it possible to display the contents of this database from the formula1 directory????

(All the directories are in the server).

Or in other words, please clarify the following if I does'nt make any sense above.

In my server, there are 3 directories: "CHAMPION", "FORMULA1", "DRIVERS".

The above 3 directories are for three different webpages.I want to share one database to all these three.Where should i place my database???Right now, my database is placed in the "CHAMPION" directory and the champions webpage is working fine.I want "FORMULA1" and "DRIVERS" webpages also to access the same database.

Access A Database From Different Websites
Is it possible to access a MySQL database from a domain other than the domain that the database is phtsically on, and if so, how?

For example, if my database is located on www.site1.com, and I want to access it from a script on www.site2.com, how do I do it? For arguments sake, assume both websites are physically located on the same server, and they share an IP address of 123.123.123.001.

Access To The Mysql Database
I've installed MySQL 4.0.20d-win on a Win2k server with
service pack 3. When I perform a "SHOW DATABASES;"
command I only see the "test" database. I understand
there is also a "mysql" database which contains the
priviledges table. I have logged in as root and the
mysql client reports I do not have access to this DB.

A couple of the reference books I've read, says I can
access this DB but it is referencing an older version
of MySQL server. My question is, "can I access the
'mysql' DB with my version of the MySQL server?"

Import Access Database
How do I import Access database into MySQL?

Microsoft Access Database
i need some advice as I'm sure there will be a way to do this i just don't know it.
I have an access database that i use, however i need to share this with my work college who is in another location. So i was wondering if there is some way i can make all the data online so it runs from something like an MySql database and we just use the software to execute it all.

Converting A Mysql Database To MS Access
I have to convert a mysql database to Access with all of its tables and data inside them.

Please suggest me some utility or some methode. I'm a ASP developer and I don't know anything in php so please guide me..

Using MS Access To Get Data In / Out Of A MySQL Database
I have no experience using MS Access to interface with MySQL. I have a tiny MySQL database that might need to have Access connect with it over the internet and grab data/update etc. Is this practical and what does it take to do it?

My project is not time sensitive but I'd like to see what methods I can use
to do remote queries with my database running on a *nix/Linux server.

Is Websphere Supports To Access Database
i want to know whether websphere supports mysql database.

Database Access Race Condition
I am working on a website with two applications on the server - both accessing the MySql database. PHP applications are reading and writing to the database and a Java servlet (running under Tomcat) is also accessing the database.

Currently the software in both applications is under development so there is very little in the way of actual database accesses, however, someone has suggested that we will have problems in the operational system because both Java and PHP applications will be attempting to access the same database.

Access Link To Mysql Database
I have set up two links in access to two different mysql databases. One allows me to add records and make changes. The other says that I cannot update the file and won't let me make changes of any kind.

I have no idea what is different, or what I did different in setting these links up.

Anyone know how I can make the database editable?

Access Mysql Database From Php Codes
I am using Apache2, Php 4.4.2, and mysql server 4.1 and have configured httpd.conf for apache and php.ini file for php. Now I am writing a small program to access my database on mysql server as follow:

<?php

$connection = mysql_connect ('localhost' , 'root' , 'aungmyinchin')
or die (mysql_error());

echo "$connection";

mysql_select_db("dms",$connection);

$query="SELECT * FROM FEATURE";

$result = mysql_query($query,$connection);

echo $result;
?>

But when I ran on browser (through an html link), I have the following error message as:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:Program FilesApache GroupApache2htdocsSku-Feature.php on line 3
Client does not support authentication protocol requested by server; consider upgrading MySQL client.

Doctors To Access/manipulate A Database
in something like a page to access/manipulate the content of the database?
user friendly wherby users is not required to know sql statement to insert in data?
like we wouldn't expect a doctor to know the sql statement to input data inside the database.

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.

Client To Access An SQL Database By Visual C++
I have several problems. I am trying to communicate with a
sql database(local) by Visual C++ 6.0 (MFC based aplication).
Well i think i am able now to connect to the local sql-server,
but i cannot send commands to the sql-server, as create table...
or things like that. I searched the Internet but only found source code
for C. Well, but i need some for C++ .

Converting Access Database To Mysql
Have for some years developed applications in Microsoft Access.
One of my clients now require the database to be usable nationwide. Cannot use replication as data changes must be immediately accessible to all users.
I gather, to use Access on the net is either difficult or expensive (using Terminal Server, which is I understand one way of doing it, requires the purchase of multiple user licences and also needs a professional engineer to set it up, etc).
Have no experience of mySQL.

How difficult is it to create/convert the sort of forms one uses in Access to mySQL?
Can one convert the data tables easily to mySQL?
How about queries, reports, etc?