Grokbase Groups MySQL mysql May 2005

Search Discussions

359 discussions - 1,373 posts

  • We have a few of DBs which aren't using disk IO to optimum capacity. They're running at a load of 1.5 or so with a high workload of pending queries. When I do iostat I'm not noticing much IO : ...
    Kevin BurtonKevin Burton
    May 6, 2005 at 8:58 pm
    Jun 1, 2005 at 5:33 am
  • I'm on Mac OSX and Mysql is built-in, so is php. My php has built-in support for mysql. Both php and mysql are up and running. I have tested both. All this is running on this machine, so is Apache. I ...
    May 29, 2005 at 1:36 am
    May 30, 2005 at 7:15 am
  • Hi All, Is there a way by which I can tell the Mysql to ignore the rows that are locked by someone else and take the next available record. The problem is, I have a Query like this: Select * from ...
    Ramesh GRamesh G
    May 13, 2005 at 5:28 am
    May 14, 2005 at 8:19 am
  • Hello, I have data like this PK GRP_COL 1 A 2 A 3 A 4 B 5 B 6 B 7 C 8 C 9 C And I want to write a query to select data like this... PK FK GRP_COL 1 1 A 2 1 A 3 1 A 4 4 B 5 4 B 6 4 B 7 7 C 8 7 C 9 7 C ...
    Dan BolserDan Bolser
    May 24, 2005 at 10:08 am
    May 26, 2005 at 1:24 am
  • Why are columns included in the join between two tables ambigious? It seems that they should *not* be ambigious! Like this select pk from a inner join b using (pk); ERROR 1052 (23000): Column 'pk' in ...
    Dan BolserDan Bolser
    May 6, 2005 at 10:50 pm
    May 15, 2005 at 7:25 pm
  • Were kicking around using SATA drives in software RAID0 config. The price diff is significant. You can also get SATA drives in 10k RPM form now., Kevin -- Use Rojo (RSS/Atom aggregator)! - visit ...
    Kevin BurtonKevin Burton
    May 11, 2005 at 7:29 pm
    May 13, 2005 at 3:20 pm
  • is it okay to post a basic sql join question to this list? if not, please point me to a list for these types of questions. thanks. - philip
    Philip GeorgePhilip George
    May 29, 2005 at 4:36 am
    May 30, 2005 at 7:19 am
  • Hello, I posted last night but did not receive an answer. I am trying to create a fulltext index, but my table was created as an InnoDB type. There is quite a bit of data there (1000+ records) and I ...
    Scott PurcellScott Purcell
    May 25, 2005 at 12:54 pm
    May 27, 2005 at 5:41 pm
  • Dear All, I am using MySQL 4.0.15 on a Linux (RH9) for the past 18 months. All my tables are InnoDB and tend to be extremely large in nature (running in couple of millions, actually the ibdata files ...
    May 19, 2005 at 7:54 am
    May 19, 2005 at 8:36 am
  • Hi All, I did this below, mysql SET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka'); and then tried logging on, [root@localhost bluefish-1.0]# mysql -h localhost -u root -pwhatafraka ERROR ...
    Mark SargentMark Sargent
    May 2, 2005 at 5:20 am
    May 5, 2005 at 4:39 am
  • Hello. Is there a way to have MySQL give up on a query after a certain length of time? I use Debian Linux Sarge, MySQL 4.1 and Php 5. Sometimes I have queries that take forever although the same ...
    Jacob Friis LarsenJacob Friis Larsen
    May 20, 2005 at 9:50 am
    May 24, 2005 at 11:54 am
  • So... it sounds like a lot of people here (Dathan and Greg) have had problems deploying MySQL on Opteron in a production environment. I was wondering if we could start an Opteron HOWTO somewhere ...
    Kevin BurtonKevin Burton
    May 9, 2005 at 4:09 pm
    May 11, 2005 at 8:23 pm
  • I'm looking for a row numbering in a select statement. Something I can use to determine in whivh row values are returned in a query. I found this insanely old list post: ...
    May 9, 2005 at 10:08 pm
    May 10, 2005 at 6:15 pm
  • I have a db of about 300,000 records and when I try to find one random record like this: select * from table order by rand() limit 1; it can take several minutes. My Sherlock Holmes instincts tell me ...
    Brian DunningBrian Dunning
    May 13, 2005 at 4:54 pm
    May 16, 2005 at 5:12 pm
  • Can I select the maximum value across multiple columns? ie, I'd like to select the highest value of buyCost AND sellCost in a table...where buy and sell are two different columns in the same table. i ...
    Scott KlarenbachScott Klarenbach
    May 27, 2005 at 6:12 pm
    Jun 2, 2005 at 12:02 pm
  • I use Mysql to store call detail records from telephone calls. I have around 20 voice switches that send the call detail records in real time using INSERT statements. I am having a problem where I ...
    Matthew SimpsonMatthew Simpson
    May 20, 2005 at 6:22 pm
    Jun 6, 2005 at 3:12 pm
  • Scott, sorry, my mistake, SELECT price FROM fedex_zones z INNER JOIN fedex_rates r ON AND WHERE r.weight = 25; PB ---- Scott Haneda wrote:
    Peter BrawleyPeter Brawley
    May 11, 2005 at 7:27 am
    May 11, 2005 at 4:20 pm
  • Hello, I need to restore a mySQL dump file but cannot find the right syntax. I have root access and have used: mysql -u root -p account_databasename < backupname But I am getting: Access denied for ...
    Adrian CooperAdrian Cooper
    May 18, 2005 at 10:21 pm
    May 19, 2005 at 2:03 pm
  • Hello, I am working on a database that deals with network statistics. I have a program that generates web reports based on this data every ten minutes. The table layout looks something like this: ...
    Paul HallidayPaul Halliday
    May 10, 2005 at 6:49 pm
    May 11, 2005 at 10:56 am
  • Greetings all, We are migrating our web site from one server to another and are having some issues with transferring our MySQL database. Here's the process we're currently using: 1) run mysqldump for ...
    Brian EricksonBrian Erickson
    May 8, 2005 at 8:47 pm
    May 10, 2005 at 5:06 am
  • I have a pretty simple table with a list of payments, not much more than: paymentID | amount | paymentDate 1 | 123 | 2005-01-10 2 | 77 | 2005-01-13 3 | 45 | 2005-02-16 4 | 13 | 2005-02-17 I can get ...
    Russell HornRussell Horn
    May 25, 2005 at 12:02 pm
    Jul 10, 2006 at 8:26 am
  • I'm trying to replicate this PHP behavior in a MySQL stored procedure. The purpose is to pad every character of the string with a pad character. For example, if the pad character is 'x' and the ...
    Scott KlarenbachScott Klarenbach
    May 27, 2005 at 5:57 pm
    Jun 1, 2005 at 5:33 pm
  • Hi, here is the case: one student may have more than one address, and one student may have more than one phone number so the db would be: student ---------------- student_id name age address ...
    Koon Yue LamKoon Yue Lam
    May 24, 2005 at 5:34 pm
    May 24, 2005 at 7:34 pm
  • Hi, The following query produces the number of bookings per project grouped by week: SELECT WEEK(Booking_Start_Date) AS "WEEK", SUM(IF(B.Project_ID = "23", 1,0)) AS `Project A`, SUM(IF(B.Project_ID = ...
    Shaun thornburghShaun thornburgh
    May 23, 2005 at 2:18 pm
    May 24, 2005 at 1:40 pm
  • hi, here is table description report1 +-------------------------+------------------+------+-----+---------------------+----------------+ I WANT REPORT LIKE FOLLOWINGS date sender processed spam ...
    Seena BlaceSeena Blace
    May 15, 2005 at 5:31 pm
    May 18, 2005 at 5:00 pm
  • Hi All, mysql is running, but, there seems to be no /tmp/mysql.sock file. How is this file generated..? I can't connect, keep getting errors. What about via a port..? What is the argument for that..? ...
    Mark SargentMark Sargent
    May 5, 2005 at 10:57 am
    May 6, 2005 at 3:52 pm
  • I just learned a lot stuff at including sorting by number-to-text, text-to-number, names, specific values, etc. However, the document didn't ...
    Erik BukakisErik Bukakis
    May 9, 2005 at 7:10 pm
    Jul 11, 2005 at 3:00 pm
  • Hello, I have an InnoDB table running on MySQL 4.1.11 with multiple FK constraints. I'm accessing it via JDBC from Java. When an FK constraint fails with error 1216 I need to know which of the ...
    Frank SchröderFrank Schröder
    May 24, 2005 at 5:12 am
    Jun 2, 2005 at 10:45 pm
  • what's the sql syntax (in mysql) for exporting a table's structure and and data (the one that reiterates the original CREATE TABLE statement)? that i'll end up with something that can be put in ...
    Philip GeorgePhilip George
    May 29, 2005 at 1:20 am
    May 29, 2005 at 2:05 am
  • Hi I have not received anything from this list for a couple of days. I just tried to "re-register", and that did not help. If anyone reads this, please reply to ME so I can determine if the problem ...
    Tucker, GabrielTucker, Gabriel
    May 27, 2005 at 5:55 pm
    May 28, 2005 at 1:10 am
  • LOAD DATA and skip columns in text file... What i have found out is that this is not possible in any existing version of mysql, correct? I found a message from Sinisa Milivojevic @ MySQL AB dated ...
    Jessica SvenssonJessica Svensson
    May 24, 2005 at 11:06 pm
    May 26, 2005 at 1:42 am
  • hi All, I need to create a query using no subqueries as I use 4.0.23 which does not support subqueries. I cannot upgrade for some compellimg reasons (the product does not support anything later than ...
    Anoop kumar VAnoop kumar V
    May 23, 2005 at 3:27 pm
    May 24, 2005 at 9:46 pm
  • Hi, I just upgraded from 4.1.11 (which worked fine, and stil does if I downgrade) to 4.1.12 and the first query crashes the server. This query is executed via DBD::mysql, when run via the mysql ...
    Mark HughesMark Hughes
    May 18, 2005 at 10:12 am
    May 19, 2005 at 11:49 pm
  • Hi! What is the maximum number of user variables that I can have in MySQL ? (I need to transfer a application from one server to another and I need to rebuild the links between tables with new id's ...
    Neculai MacarieNeculai Macarie
    May 11, 2005 at 12:04 pm
    May 12, 2005 at 6:49 pm
  • I use mysql 4.0.23-nt on win XP. In order to shift some of my databases I followed the following steps as per a recent post: 1. I moved the folders containing the database files that I wanted to move ...
    Anoop kumar VAnoop kumar V
    May 4, 2005 at 1:25 am
    May 6, 2005 at 3:00 pm
  • Hi List, I was checking the list of collations for a character set "latin" that I have in my MySQL version 4.1.10-standard running on Mac OS X 10.4. The list that I have, bellow, does not include ...
    Andre MatosAndre Matos
    May 2, 2005 at 12:31 am
    May 3, 2005 at 11:21 am
  • Hello, Currently I have a large mysql table (36 million rows) and according to the mysql-admin the data length is 6.5GB and my index length is 8.8GB. I am new to mysql, but I would assume that my ...
    Michael GaleMichael Gale
    May 24, 2005 at 8:09 pm
    May 24, 2005 at 10:15 pm
  • Hi, can anyone explain how I would export a database created in Access to MySQL using PHPMyAdmin - I can't seem to import the data as csv or txt. Thanks Steven
    May 17, 2005 at 4:18 pm
    May 19, 2005 at 3:31 am
  • I need to change format from varchar(10) to decimal. When I alter the table the data is trimmed. What I'm doing wrrong? TH
    Jerry SwansonJerry Swanson
    May 17, 2005 at 11:30 pm
    May 18, 2005 at 6:32 pm
  • Hi, is it possible to alter fields in a column by removing the first three characters? i.e. change 100123456789 to 123456789 Thanks for your help
    Shaun thornburghShaun thornburgh
    May 11, 2005 at 11:29 am
    May 11, 2005 at 1:49 pm
  • Dear friends, how do you extract with a query only the first few lines from a blob field? For instance: you have an article stored in the field. You would like to visualise the first few lines before ...
    May 9, 2005 at 11:35 am
    May 9, 2005 at 5:55 pm
  • So here's my situation: we have a database that has a table of about 5 million rows. To put a new row into the table, I do an INSERT ... SELECT, pulling data from one row in the table to seed the ...
    Joseph CochranJoseph Cochran
    May 4, 2005 at 2:25 am
    May 5, 2005 at 10:35 am
  • Where could I find speciffication of how MySQL client and server communicate? It seems to me there are two ways of communicating - over UNIX socket and over TCP/IP connection. Lets say I want to ...
    Nikola SkoricNikola Skoric
    May 1, 2005 at 5:25 pm
    May 3, 2005 at 6:29 pm
  • I'm looking for a feature in mysql where it will email me if ther are any changes in a particular database or table.
    May 31, 2005 at 4:46 pm
    May 31, 2005 at 11:28 pm
  • Hi list, I have run into problems on a master table for our helpdesk. We have the following table: ticket_id (int) - autoincrement (indexed) master_id (int) (indexed) Master ID is used to distinguish ...
    May 28, 2005 at 4:52 am
    May 30, 2005 at 2:38 pm
  • I'm trying to rename some tables for archival, but the table renaming is failing when I use CONCAT() to form the table string name: mysql RENAME TABLE flows TO flows_tmp, flows_new TO flows, ...
    Jason DixonJason Dixon
    May 28, 2005 at 12:13 pm
    May 28, 2005 at 4:13 pm
  • Hi everyone, First time on the list, although I've been (quietly) a (not-so)long-time quiet observer. This isn't a FAQ and I can assure you I've tried every procedure out there (both on and off-list) ...
    Ricardo OliveiraRicardo Oliveira
    May 16, 2005 at 9:00 pm
    May 27, 2005 at 6:10 pm
  • Where can I find the installer for MYSQL DB 4.0.13 for solaris/linux. I couldn't find it on the site. Could you guide me please. Thanks, Mayuresh.
    Mayuresh KshirsagarMayuresh Kshirsagar
    May 25, 2005 at 6:01 am
    May 26, 2005 at 4:14 am
  • Hello, I created a table that uses a varchar(254) size field, and found out that the customers data is being truncated. It needs to be larger. Currently there are about 500 records (it is a ...
    Scott PurcellScott Purcell
    May 23, 2005 at 1:37 pm
    May 23, 2005 at 6:15 pm
  • I am have trouble connecting to the MySQL server 4.1 using the API, though I have no trouble connecting using the same parameters from the command line mysql.exe. I'm using server version 4.1.10 on ...
    Nicholas WatmoughNicholas Watmough
    May 5, 2005 at 5:49 am
    May 23, 2005 at 3:45 pm
Group Navigation
period‹ prev | May 2005 | next ›
Group Overview
groupmysql @

369 users for May 2005

Mfatene: 82 posts Gleb Paharenko: 80 posts Sgreen: 44 posts Kevin Burton: 29 posts Eric Bergen: 28 posts Jay Blanchard: 24 posts Mark Sargent: 20 posts Michael Stassen: 20 posts Philip George: 20 posts Dan Bolser: 18 posts Paul DuBois: 18 posts Martijn Tonies: 16 posts Rhino: 16 posts Seena Blace: 15 posts Dathan Pattishall: 14 posts Jeremiah Gowdy: 14 posts Peter Brawley: 14 posts Simon Garner: 13 posts Brent Baisley: 12 posts Harald Fuchs: 12 posts
show more