Our database contains about 27,000 records only and it is very slow. Can someone please suggest any tips to increase the performance? We...

Young

02-21-2007 11:47 AM
Good Man

Hi there, i have a problem, and i tried to firuge out but i really need help. I have 2 txt files with these info: MOVIES.TXT***

paulgerardo@gmail.com

02-20-2007 08:02 PM
paulgerardo@gmail.com

hi i have a table like this: product id | product name | product price the product name and product price fields both contain...

mcyi2mr3@googlemail.com

02-17-2007 10:20 AM
shakahshakah@gmail.com

Hi I'm migrating from Access til MySQL. Works fine so far - but one thing is nearly killing me: I got the count of total records in a variabel -...

Otto

02-17-2007 12:28 AM
Vern99t

how to connect MySQL using C++ in redhat .... can any one tell a sample of code to creat ,connect and execute the statement in c++ code ... please...

yogesh

02-16-2007 12:17 AM
Otto

Hi, I have a very basic question but I havent found answer to it anywhere. I have a table that has following columns: date, answer1,...

LittleSam

02-11-2007 10:00 AM
LittleSam

In my.cnf i add these lines ####### log-bin log-slow-queries = /var/log/mysqld-slow.log long_query_time=1 #######

Pratchaya

02-11-2007 08:59 AM
Pratchaya

Hello, I want to import a csv file into my table. However, I need to empty the table before I do this. The problem is, I only see an option...

Toine

02-09-2007 05:56 AM
Carl Pearson

I am a newbie to MySQL. I'm confused as to the piping syntax of SERVER in the User DSN in ODBC for a client PC. If I use an ip it does not work,...

moti

02-05-2007 02:33 PM
moti

Scenario: Voting system where one chooses one item over another. My votes table has a winner_id and a loser_id. I need to determine what the...

brad

02-05-2007 12:10 PM
brad

Hey, I would like to syncronize my local database with my website database. Scenarios are 1. New rows / row updates in the local database to be...

D0c

02-04-2007 03:34 PM
D0c

Hello, I have 3 tables: T_component =TCO cmp_id | name 1 | door 2 | exhaust

elektrongyorsito via DBMonster.com

02-04-2007 08:55 AM
strawberry

Hi, I'm trying to create a stored procedure using the following syntax, but I'm getting an error. CREATE PROCEDURE `site`.`sp_ValidateInvite_SEL`...

Peter

02-01-2007 04:44 PM
Peter

Hi I was wondering if someone could reply with a command from the mysql client that I can issue which will import a flat file have 2 columns and a...

Jack

01-30-2007 07:30 AM
Carl Pearson

Hi, I would like to move my DBs in another directory. I know that I have to change in my.cnf the datadir path .... datadir=/var/lib/mysql ->...

pontarolo@warpstudio.ch

01-30-2007 07:24 AM
Carl Pearson

abracad_1999 (AT) yahoo (DOT) com wrote: There are a couple of problems. First, don't use quotes for your table & field names. Do this...

Carl Pearson

01-29-2007 03:22 PM
Carl Pearson

I have an SQL problem I have been struggling with. Given birthdates stored in a date format, I want to be able to pull out all those whose birthday...

Your Name

01-26-2007 08:07 PM
Carl Pearson

I have to run a full-text query something like this: SELECT id, title, url, comments, modified_date as modifieddate FROM clips WHERE IsActive = 1...

zb

01-25-2007 09:07 PM
zb

Hello, I'm looking for solution in case insensitive search in MySql. Table exemple. CREATE TABLE `pozycje` ( `id` int(11) NOT NULL...

iksando@gmail.com

01-25-2007 07:06 PM
Thomas Bartkus

hi all how do i make a command line connection to a remote mysql server? for local connections i know it is: mysql -u root dbname how do i connect...

mcyi2mr3@googlemail.com

01-24-2007 01:53 PM
Carl Pearson

Hi ... I have a data file and I need to retrieve just two values from the file. The positions of those values however remain the same in each time....

swethach

01-19-2007 05:59 PM
Jeff North

Output of "top" prior to initiation of mysql: load averages: 0.60, 0.97, 1.05 19:03:45 44 processes: 43 sleeping, 1 on cpu CPU states: 97.1%...

aaron

01-18-2007 09:53 PM
Michael Austin

Howdy, All, Was trying to modify all tables in a particular database starting with the same prefix, i.e., "tbl_". Decided I'd rather have them all...

Carl Pearson

01-18-2007 09:46 PM
Michael Austin

i am trying to put together a list of windows odbc drivers for mySQL so far i have found the following: (1) myODBC ...

timothy.woodward@gmail.com

01-16-2007 07:52 PM
timothy.woodward@gmail.com

I was wondering, are there any recommended ways to speed MySQL up a bit in low resource environments? See, I'm running a small webserver for kicks on...

antonioetayo@gmail.com

01-15-2007 12:33 PM
Michael Austin

I'm not finding what the maximum number of characters that a statement can be. Anyone know where I can find that spec?

Roy Epperson

01-15-2007 11:32 AM
Roy Epperson

I have the following scenario. A mysql database running 3 databases. It is version 5.0.27 on Windows XP Prof.. All innodb databases. The one...

daniel@mfaconsulting.com

01-12-2007 09:54 PM
Jerry Stuckle

Ok I know how to get the data I want from mysql but I need to actually do something with this data and then send it back to mySQL. Company heads...

roger.rigsby@gmail.com

01-12-2007 08:57 PM
Carl Pearson

Mysql is filling my /var partition because the log limit doesn't seem to be respected. I've tried many different settings in /etc/mysql/my.cnf but...

Chrom_

01-12-2007 04:33 AM
Chrom_

I have a mysql table, with a field called DATE, how do i get it to automatilly put the date on it every time a new recored it put on the table Date...

S.Dickson@shos.co.uk

01-09-2007 11:26 AM
Bill Karwin

I have a FULLTEXT index. when i query it for a specific item, i get different results in phpMyAdmin, vs a PHP search app I'm developing. In the...

starman7@hotmail.com

01-08-2007 08:38 PM
starman7@hotmail.com

I am refining the search within a small IT Jobs Website developed in C#. I am using FULLTEXT search on 3 columns (title, short_desc, long_desc), but...

mossy

01-08-2007 10:11 AM
mossy

How do I change the collation on existing tables in an existing database?

Martin

01-07-2007 05:54 PM
Martin

I am writing a C# program that uses MySQL as database and MySQL ODBC 3.51 driver. It works fine all the way except this scenario that needs to...

zb

01-07-2007 03:27 AM
zb

I have a form that has a combo box thats displays all the suppliers I then have subform that shows all the products that we buy from them and how...

S.Dickson@shos.co.uk

01-05-2007 07:40 PM
Michael Austin

Hi, I'm working on MySQL 5.0 on Windows XP. I've tested a request on MSAccess and it's working. But if I launch it under MySQL, the PC crashes and I...

max_mont

01-05-2007 07:37 PM
Michael Austin

We can help you find freelance programmers, Web Designers and Copywriters. Outsource projects to India, Romania, Ukraine or any other country.Find...

freelance.telecom.googlepages.com

01-05-2007 03:47 AM
freelance.telecom.googlepages.com

We currently use romancart for our online shopping cart, this has been fine for the first year of business but once an order is placed we have to...

S.Dickson@shos.co.uk

01-04-2007 07:30 PM
Carl Pearson

Hi, I'm trying to set up an ASP website that works in both Russian and English. The forms on the website should capture data, and write it off to...

nicko4972000@yahoo.com

01-02-2007 10:11 AM
nicko4972000@yahoo.com

I have a table that records targets and the time it appears on a display. What I would like to do is to report the time difference for each...

hik2sanity@hotmail.com

12-29-2006 11:10 AM
strawberry

Hello NG- I'm using mysql 5.0.22 as packaged (and updated) with Ubuntu Dapper. I would like to use Innodb, but "show innodb status" says "ERROR...

Jacob Marble

12-28-2006 03:57 PM
Jacob Marble

Hello Mr. Expert: - I have 3 tables in mysql in MyISAM table format, I am using mysql4.0 on freebsd5.3 - producttbl, productdetailentbl, pricetblN -...

Andrew S

12-26-2006 11:19 AM
shakahshakah@gmail.com

--LaRBCWFLTWUZJFPFbPQaCXaTTUWQBX You are not authorized to send mail to the ITA-L list from your mysql (AT) FREEBSD (DOT)...

LISTS.UFL.EDU LISTSERV Server

12-26-2006 07:55 AM
LISTS.UFL.EDU LISTSERV Server

Folks, In mySQL should any required non-clusterd indexes be built before or after a full-text index? Either on the same column or...

almurph@altavista.com

12-20-2006 07:24 PM
Michael Austin

Hi All, I've been racking my brain trying to figure out some sort of Sub-Select mySQL statement that will create a result with multiple rows...

chrisale@gmail.com

12-20-2006 10:03 AM
chrisale

How would I write a query to count the number of instances where a the PREP field is NULL and when it is not null. I know how to do it seperately,...

Jim

12-20-2006 02:03 AM
que

Please help me optimize this: I have a table with columns: headlineid, keyword. headlineid+keyword combination is unique. Relationship between...

rajeshkapadi@gmail.com

12-19-2006 09:06 AM
Captain Paralytic

Hi all, i am just lookin for a func or way about to retrieve the difference in minutes between 2 dates which are of DATETIME data type for induvidual...

Jag

12-18-2006 10:54 PM
Jag

Dear all I have a databse and php page...I would like retrieve a database to PHP page..but i don't want show the all text ...just want as like as...

Ace

12-18-2006 09:07 PM
Ace

I looking for help with Maxdb ... I'm looking for someone in the western states as close to Denver as possilbe. Project Hire. email...

dlschmitt@gmail.com

12-15-2006 04:44 PM
dlschmitt@gmail.com