FAQ

Search Discussions

92 discussions - 364 posts

  • I'm using MySQL to manage data on my computer . The total data is 50 Gig in MyISAM folders. As I type, I already have the folder with the myd, frm, etc being copied offsite. As I understand it, if ...
    Mitchell MaltenfortMitchell Maltenfort
    Apr 19, 2010 at 7:15 pm
    Apr 21, 2010 at 5:27 pm
  • I have a 1.5G database which feeds a CMS web application (Drupal). Right now I am hosting it with a 1.5G RAM VPS and I feel it is too slow. IO and CPU are high. So I am planning to upgrade it to a ...
    ShamubroShamubro
    Apr 21, 2010 at 2:31 pm
    Apr 22, 2010 at 9:18 am
  • I'm going to be setting up a MySQL database for a project. My reading indicates that MyISAM (default) is going to be better than InnoDB for the project but I want to be sure I have the trade-offs ...
    Mitchell MaltenfortMitchell Maltenfort
    Apr 2, 2010 at 7:02 pm
    Apr 10, 2010 at 4:21 am
  • I have a table with over 8 million rows of lat / long data all currently in decimal(12,8) format (actually some in float(12,8)). First question - should I have these all in decimal or float? I can't ...
    DanDan
    Apr 30, 2010 at 9:54 pm
    May 3, 2010 at 3:55 pm
  • I have a InnoDB table which contains columns named 'cluster' and 'file' ('cluster' + 'file' is a primary key). I want to add a new column that tracks the revision number of a file for a given cluster ...
    Aveek MisraAveek Misra
    Apr 22, 2010 at 8:39 am
    Apr 23, 2010 at 8:34 am
  • Hi all, I am hiring a few new junior DBA's and I want to put them thru a simple db repair training. Does anyone know how I can deliberately corrupt a MyISAM and InnoDB database in different ways ...
    Nurudin JaveriNurudin Javeri
    Apr 18, 2010 at 4:25 pm
    Apr 22, 2010 at 8:49 am
  • Hello all, My organization has a dedicated MySQL server. The system has 32Gb of memory, and is running CentOS 5.3. The default engine will be InnoDB. Does anyone know how much space should be ...
    Joe HammermanJoe Hammerman
    Apr 13, 2010 at 10:50 pm
    Apr 19, 2010 at 8:40 am
  • I am experimenting with multiple tables, it is only a test that is my local machine only. This is the current code, which does not work , I have tried to concatonate the insert statements. I have ...
    GaryGary
    Apr 11, 2010 at 4:57 pm
    Apr 13, 2010 at 3:49 pm
  • I have the following statement: select chart_of_accounts.accountname as Account, concat('$',format(coalesce(sum(sales_journal_entries.debit),0),2)) as Debit, ...
    Keith ClarkKeith Clark
    Apr 27, 2010 at 9:53 pm
    Apr 28, 2010 at 2:04 pm
  • This maybe a newbie question. Consider the following concept, ~/index.php #1. Fetch data from an external webpage using PHP Curl; #2. Preg_match/Prepare Data to INSERT from local MySQL; - this may ...
    Antonio PHPAntonio PHP
    Apr 16, 2010 at 9:39 am
    Apr 19, 2010 at 2:13 pm
  • Hi, I am using MySQL version 4.1.12-log. All the databases on it are using MyISAM database engine. Every day, I delete almost 90000 rows on a table of 3 153 916 rows. To delete the rows, I use a ...
    David FlorellaDavid Florella
    Apr 14, 2010 at 1:08 pm
    Apr 15, 2010 at 8:02 am
  • Hi, I am using MySQL replication : - The version of the master is 4.1.12-log - The version of the slave is 5.0.41 When I use the query '' DELETE QUICK FROM [TABLE] WHERE [field] < 'xxxxxx' LIMIT ...
    David FlorellaDavid Florella
    Apr 28, 2010 at 9:07 am
    Apr 28, 2010 at 5:35 pm
  • I have 7 days worth of general log data totalling 4.4GB. I want to analyze this data to get: a) queries per second, minute, hour and day b) a count of the number of selects versus write statements ...
    Imran ChaudhryImran Chaudhry
    Apr 20, 2010 at 11:03 am
    Apr 20, 2010 at 5:00 pm
  • Hi, I would like to export my table structure from MYSQL from a particular db. Is there any tool for doing this? Please guide me. Thank you VIKRAM A
    Vikram AVikram A
    Apr 8, 2010 at 5:12 am
    Apr 19, 2010 at 3:32 am
  • I am working on Java-HTML-MS Access Backend database. Now office is removing all unlicensed softwares and they are removing microsoft applications also and hence the necessity to shift from MS Access ...
    VR Venugopal RaoVR Venugopal Rao
    Apr 28, 2010 at 10:00 am
    May 3, 2010 at 5:10 am
  • How can I remove old mysql-bin log file in log directory? A mysql full backup will clear the old mysql bin log file or not? Thanks, Arshu Paul
    Angelina PaulAngelina Paul
    Apr 19, 2010 at 3:59 am
    Apr 19, 2010 at 11:54 am
  • Hi all, I have some security issues. I would like to have your suggestions/solutions. I have winserver2003 with mysql 5.1.45. We have client serve application that allows multi-login system with ...
    Vikram AVikram A
    Apr 28, 2010 at 8:28 am
    Apr 28, 2010 at 5:20 pm
  • I've just installed MySQL on Windows 2000. I've opened the MS-DOS windows and I've written C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010 After the enter the prompt says Enter ...
    Alba\.albettiAlba\.albetti
    Apr 8, 2010 at 2:02 pm
    Apr 18, 2010 at 4:22 pm
  • hi all what is the difference between OPTIMIZE TABLE tablename; and ANALYZE TABLE tablename; thank you Cheers Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com
    F.A.I.Z.A.LF.A.I.Z.A.L
    Apr 13, 2010 at 8:52 am
    Apr 15, 2010 at 7:22 am
  • Hi guys, Is the information is true. http://planet.mysql.com/ http://tokutek.com/2010/04/tokutek-acquires-oracle/ Regards, Krishna
    Krishna Chandra PrajapatiKrishna Chandra Prajapati
    Apr 1, 2010 at 2:39 pm
    Apr 2, 2010 at 11:19 am
  • I cant seem to get this working. $query="SELECT im.image_id, im.caption, im.where_taken, im.description, im.image_file, im.submitted, kw.fox, kw.wolves, kw.wildlife, kw.american, kw.scenic, kw.birds, ...
    GaryGary
    Apr 26, 2010 at 11:36 pm
    Apr 27, 2010 at 12:21 pm
  • I need to load a dump from a 4.1.12 server to a 5.0.18 server. When I do that it fails with: ERROR 1064 (42000) at line 23: You have an error in your SQL syntax; check the manual that corresponds to ...
    Larry MartellLarry Martell
    Apr 22, 2010 at 8:43 pm
    Apr 23, 2010 at 2:59 pm
  • Hi, I have installed mysql 5.1.45 version on windows server 2003[standard edition] and windows xp. I am using WIN SERVER as MASTER and WIN XP as slave.And the default engine in both severs is INNODB. ...
    Vikram AVikram A
    Apr 21, 2010 at 1:19 pm
    Apr 22, 2010 at 10:07 am
  • Hi all. Now this one is strange. I just created a new table called "lines." I can use Open Office to read the records in it just fine. However, when I type this command at the cli, I get an error: ...
    Mike DiehlMike Diehl
    Apr 14, 2010 at 11:31 pm
    Apr 15, 2010 at 5:23 pm
  • hi all... i have a bit of a problem with this: table products: ---------------------- prod | category | ---------------------| boots | winter | boots | summer | boots | spring | shoes | spring | ...
    Kalin mKalin m
    Apr 7, 2010 at 3:37 pm
    Apr 12, 2010 at 1:42 pm
  • Good Afternoon All following the documentation available at http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html i wish to select a date using DD-MON-YY format but my format of ...
    Martin GaintyMartin Gainty
    Apr 9, 2010 at 3:04 pm
    Apr 9, 2010 at 5:49 pm
  • I downloaded a MySQL backup script today since I have 3 or 4 relatively small databases. The script can be found here: http://sourceforge.net/projects/automysqlbackup/ Now I was wondering if I can ...
    Carlos MennensCarlos Mennens
    Apr 28, 2010 at 4:58 pm
    May 16, 2010 at 1:41 pm
  • Hi all, posted this in the backup list, but that one seems to be pretty dead, so i'll try my luck again here: We're currently looking for a way to backup a pretty big mysql table to a csv file. ...
    Marijn VandevoordeMarijn Vandevoorde
    Apr 28, 2010 at 12:11 pm
    May 4, 2010 at 10:14 am
  • Hi We need to produce a query to return the total number of user visits between two date ranges that span over two year e.g from 2009-04-29 to 2010-04-29. My question is how can I compute the totals ...
    Tompkins NeilTompkins Neil
    Apr 29, 2010 at 12:12 pm
    Apr 29, 2010 at 1:05 pm
  • I was told I should ask this on this list. Any ideas? Thanks -Zardosht ---------- Forwarded message ---------- From: Zardosht Kasheff <zardosht@gmail.com Date: Fri, Apr 23, 2010 at 9:01 PM Subject: ...
    Zardosht KasheffZardosht Kasheff
    Apr 28, 2010 at 7:54 pm
    Apr 29, 2010 at 1:32 am
  • It seems that there is no direct support to limit 'select' to only the first N rows in a table. Could you let me know what the best way select rows from the first N rows in a table is? -- Regards, ...
    Peng YuPeng Yu
    Apr 27, 2010 at 10:39 am
    Apr 27, 2010 at 5:18 pm
  • hello ML, i'm new to MySQL, so i have a very basic question. I have to install a database server for about 15 persons. The server is intended for testing and evaluating. The users should be able to ...
    Lentes, BerndLentes, Bernd
    Apr 21, 2010 at 9:13 am
    Apr 21, 2010 at 1:04 pm
  • Dear All, I hit belown problem when i compile(make install) 5.5.4-M3 on centos 5.0. ...
    Yang WangYang Wang
    Apr 19, 2010 at 7:30 am
    Apr 20, 2010 at 1:20 am
  • Hi Just looking for some confirmation that under a single database - I assume it is perfectly normal to have both MyISAM and InnoDB engines for different tables ? Is there anything I need to be aware ...
    Tompkins NeilTompkins Neil
    Apr 8, 2010 at 10:21 am
    Apr 19, 2010 at 7:58 am
  • hi all, in MySQL 4.1.x i want to obtain the status of more tables with one only query. In 5.x i use "SHOW TABLE STATUS WHERE Name IN ('tab_1', tab_2, 'tab_3')" In 4.1.x i tried to use but it doesn't ...
    SpacemarcSpacemarc
    Apr 7, 2010 at 6:02 pm
    Apr 8, 2010 at 10:37 am
  • Hi there, I run simple statement like this: create table c select * from a union select * from b; where table a has 90,402,534 rows, and table b has 33,358,725 rows. Both tables have the same three ...
    Chen jiaChen jia
    Apr 5, 2010 at 6:06 pm
    Apr 5, 2010 at 6:18 pm
  • Hi, I run mysqltuner this morning and I got these warning: [!!] Key buffer size / total MyISAM indexes: 12.0G/23.2G [!!] Key buffer hit rate: 76.9% [!!] Query cache efficiency: 0.0% [!!] Temporary ...
    sangprabvsangprabv
    Apr 1, 2010 at 4:47 am
    Apr 4, 2010 at 12:19 am
  • In the ReadMe.pdf that came with the mysql that I downloaded from mysql.com, there is this comment: ------ You might want to add aliases to your shell's resource file to make it easier to access ...
    JamesadrianJamesadrian
    Apr 28, 2010 at 6:14 am
    Apr 28, 2010 at 2:47 pm
  • We have installed mysql-5.1.39 and having a database with following table. CREATE TABLE `EntMsgLog` ( `msgId` bigint(20) NOT NULL, `causeId` bigint(20) NOT NULL, `entityId` int(11) NOT NULL, ...
    Dheeraj KumarDheeraj Kumar
    Apr 26, 2010 at 9:59 am
    Apr 28, 2010 at 8:22 am
  • Hi All, I have a query I need to run but can't think how to get this working so I am hoping someone can advise. I have a table which logs start and end times of Scheduled jobs. It includes for ...
    John DaisleyJohn Daisley
    Apr 27, 2010 at 1:47 pm
    Apr 27, 2010 at 2:25 pm
  • I don't see there is a function to compute min or max of two numbers in a row. Essentially I want to select all the rows where the minimum of column1 and column2 are bigger than the maximum of col3 ...
    Peng YuPeng Yu
    Apr 26, 2010 at 11:08 pm
    Apr 27, 2010 at 1:52 am
  • Hi, I'm still stuck with my SQL query that is slow but really shouldn't be. The problem is that I cannot create a simple test case. I could only provide you a whole lot of pages of PHP code and SQL ...
    Yves GoergenYves Goergen
    Apr 25, 2010 at 4:12 pm
    Apr 26, 2010 at 2:59 pm
  • Dear MySQL users, MySQL Community Server 5.1.46, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.46 is recommended for use on production systems. For ...
    Karen LangfordKaren Langford
    Apr 23, 2010 at 5:05 pm
    Apr 23, 2010 at 8:05 pm
  • I have a very simple table. CREATE TABLE `hams`.`phoneticcallsign` ( `CallSign` char(6) NOT NULL, `PhoneticCallSign` char(6) NOT NULL, PRIMARY KEY (`CallSign`), KEY `PhoneticIdx` (`PhoneticCallSign`) ...
    Chris WChris W
    Apr 22, 2010 at 3:13 pm
    Apr 22, 2010 at 3:49 pm
  • I'm frankly not sure if this is a MySQL question or PHP, but I thought I would start here. I have a form that I have a (ever growing) list of checkboxes, Here is a sample of the code for it. <input ...
    GaryGary
    Apr 20, 2010 at 10:17 pm
    Apr 21, 2010 at 2:30 am
  • Hiya I tried getting the following command running from the following youtube clip. http://www.youtube.com/watch?v=Zofzid6xIZ4 Look at 19:25 I know I can use tcpdump, with maatkit (Im not always able ...
    Brent ClarkBrent Clark
    Apr 20, 2010 at 9:48 am
    Apr 20, 2010 at 2:01 pm
  • I want to change the mysql default storage engine from MyISAM to InnoDB. What are the steps involved .Is it edit my.cnf file and add a line default-storage-engine=innodb and restart the mysql server? ...
    Angelina PaulAngelina Paul
    Apr 19, 2010 at 3:32 am
    Apr 19, 2010 at 4:59 am
  • What's the deal with downloads of MySQL? I've been away from MySQL for a few years and have not really been keeping close tabs on things, although I have kept my mysql mailing list subscription and ...
    RhinoRhino
    Apr 16, 2010 at 6:54 pm
    Apr 16, 2010 at 7:05 pm
  • Hello, I have a row which is defined as double unsigned (MySQL 5.0.26-Max, OpenSuse). Values in this row can go from a single digit, like 1, to values like 0.0006872207 or 1.2513e-18. I want to store ...
    Sebastien MORETTISebastien MORETTI
    Apr 14, 2010 at 3:21 pm
    Apr 16, 2010 at 3:21 pm
  • Hi Guys i have a dedicated mysql-server and neeed tips and sugestion to optimize its to a better performance. 1-) Here i have results from mysqltunner Please enter your MySQL administrative login: ...
    Junior OrtisJunior Ortis
    Apr 10, 2010 at 7:10 am
    Apr 14, 2010 at 1:30 am
Group Navigation
period‹ prev | Apr 2010 | next ›
Group Overview
groupmysql @
categoriesmysql
discussions92
posts364
users129
websitemysql.com
irc#mysql

129 users for April 2010

Johan De Meersman: 33 posts Rob Wultsch: 17 posts Carsten Pedersen: 16 posts Martijn Tonies: 9 posts Gavin Towey: 8 posts Mos: 8 posts Shamubro: 8 posts Shawn Green: 8 posts Vikram A: 8 posts Mitchell Maltenfort: 7 posts Claudio Nanni: 6 posts Eric Bergen: 6 posts Prabhat Kumar: 6 posts Aveek Misra: 5 posts Chris W: 5 posts Dan Nelson: 5 posts David Florella: 5 posts Gary: 5 posts Kyong Kim: 5 posts Martin Gainty: 5 posts
show more
Archives