Full text search not matching 2 letter word

| STORAGE  | 152 | +-++--++--+--+-+ Any ideas why this is not working? Thanks Andrew -- MySQL General Mailin

Re: Workbench MySQL Enterprise Backup Error

The beauty of running enterprise versions is that you have support from Oracle. I would gently point you in their direction if not to get what you paid for but also because most of us in this list are unequipped to help you because we don't use the software you have problems with. Good luck On 22

Re: server-side logging of query errors?

Further more, use logstash to collect the audit events and you can filter out anything that wasn't an error and move it to a query error log. On Wed, Jun 24, 2015 at 5:32 PM, Singer Wang wrote: > Yep, as shown below: > > root@audit-db.ec2:(none)> select fark from fark from fark fark fark from >

Re: checking for repetitive queries

pt-query-digest will help here. You can use a slow query log or tcpdump to track what the application is asking of the db. The report provided by the tool can be per db if you wish or the complete schema. It will provide a summary of the collection and you'll see how often yo On Mon, May 18, 2015

Re: checking for repetitive queries

cut short on the previous message but I'm sure you get the gist. A On Mon, May 18, 2015 at 11:25 PM, Andrew Moore wrote: > pt-query-digest will help here. You can use a slow query log or tcpdump to > track what the application is asking of the db. The report provided by the > t

Re: time stamp specific to columns

I think you'd have to do that with a trigger. On 4/8/15 6:36 AM, Martin Mueller wrote: I understand how a timestamp column automatically changes when there is a change in a data row. Is it possible to limit the update to changes in particular columns? I have a table where I care about changes i

Re: longtext fields in a row

I would think a better structure would be to have the data stored in a different table, keyed to a table containing the date and integer fields... On 4/1/15 10:35 AM, Andrew Mueller wrote: There is a max row size of 65,535 bytes. There is no real way to get around this limit other than placing t

Re: longtext fields in a row

There is a max row size of 65,535 bytes. There is no real way to get around this limit other than placing the HTML code somewhere else, perhaps in a different table. On Wednesday, April 1, 2015, Trianon 33 wrote: > Hello, > > I'm fiddling wit a table where I put in a date field (datetime, also

Re: questions about timestamps and DST

When you use a timezone with DST there is no such thing as 2.30am on the date of changeover. That hour doesn't exist. Look up the difference between timestamp and datetime data types. A On 31 Mar 2015 05:43, "Larry Martell" wrote: > I have a column that was a timestamp type. I was inserting row

Re: mysqldump with single-transaction option.

We will tend to use binary backups (Xtrabackup) for full consistent dataset restore (think slave provisioning and disaster recovery) and logical backups to perform single table restores in the event that a rollback may need to occur if someone drops a table or carries out an insane update. We will

Re: Replication problem

Whilst there are a few possibilities, check on the master that your binary logs are being written to. Another possible reason could be filtering. On 29 Aug 2014 21:36, "william drescher" wrote: > > Replication novice > > I have a master server at the office and a replication server at home. > Thi

Re: Big innodb tables, how can I work with them?

What kind of queries is this table serving? 8GB is not a huge amount of data at all and IMO it's not enough to warrant sharding. On Thu, May 15, 2014 at 1:26 PM, Antonio Fernández Pérez < antoniofernan...@fabergroup.es> wrote: > ​ > > ​ > ​Hi, > > I have in my server database some tables that ar

Re: Decode Json in MySQL query

May also be of interest; http://www.slideshare.net/blueskarlsson/using-json-with-mariadb-and-mysql On Fri, Mar 21, 2014 at 12:27 PM, Sukhjinder K. Narula wrote: > Many Thanks for the kind replies. > > I have decoded in my code but just wondering in case I missed any solution > to decode via q

Re: SHOW CREATE TABLE suddenly slow on InnoDB?

Hey Brad. What version are you using? My immediate thought is to check if innodb_stats_on_metadata is off. If it is on, switch off and check your timings again. Regards On 17 Mar 2014 04:40, "Brad Heller" wrote: > Hey all, > > I'm trying to figure out how InnoDB executes a SHOW CREATE TABLE quer

Re: New to MySQL

-mysql-server-on-centos If you have some error messages pending the completion of the steps please be complete with your problem and include the messages you receive. A On Wed, Mar 5, 2014 at 11:06 AM, Reindl Harald wrote: > > > Am 05.03.2014 12:03, schrieb Andrew Moore: > > Ne

Re: New to MySQL

Next action is to review the MySQL error log for the reason that it failed. A On Wed, Mar 5, 2014 at 10:55 AM, Asma rabe wrote: > Hi All, > > Thank you very much. > > I checked if mysql installed > rpm -qa | grep mysql > > and found it is installed, so no need for yum installation. when i trie

Re: New to MySQL

Percona, MariaDB and Oracle provide YUM repos now. Remove all traces of MySQL before starting install using ; rpm -e {package} --nodeps then grab your YUM packages. A On Tue, Mar 4, 2014 at 7:01 PM, Brian Van der Westhuizen [DATACOM] < brian.vanderwesthui...@datacom.co.nz> wrote: > Why don'

Re: Lost connection to MySQL server - need help.

Could be a crash related to innodb data dictionary being out of sync. Could be a bug. http://bugs.mysql.com/bug.php?id=55277 On 12 Oct 2013 11:21, "Jørn Dahl-Stamnes" wrote: > On Saturday 12 October 2013 12:01, nixofortune wrote: > > You might want to comment > > > > bind-address= 12

Re: binlog_format and pt-table-checksum?

Rafał, pt-table-checksum will set binlog_format to statement for it's own session. As for data drift, there are many causes for it but with statement based replication for your general replication configuration leaves you open to non-deterministic functions causing diffs throughout your data. HT

Re: restore problem

I would suggest making a physical backup. Shutdown MySQL on source, copy datadir and start on the the destination server. (observe configuration differences between the two machines) *Benefits;* consistent backup of non-transactional files. *Drawbacks;* downtime required. On Sun, Sep 8, 2013 at

Re: Performance Improvements with VIEW

I think you're reducing the amount of rows referenced throughout the proc using the view. This might be where you're seeing a performance difference. If you create an innodb table where the structure and row count match the view maybe you'll see another difference? I'll wait for Rick James' input b

Re: Audit Table storage for Primary Key(s)

Ah-ha, excuse my earlier response, I was under the impression you were trying to track schema changes etc. A On Fri, May 31, 2013 at 7:54 PM, Rick James wrote: > UUID PRIMARY KEY (or even secondary index) -- > Once the table gets big enough (bigger than RAM cache), each row INSERTed > (or SELE

Re: Audit Table storage for Primary Key(s)

There's been a thirst for this kind of thing for sometime but possibly you're looking for a cheaper option? Since 5.5 there's some incarnation of an audit plugin which can be extended for your own needs which should allow you to perform some persistence of the results with either a log file which c

Re: Bug in BETWEEN same DATETIME

Personally I don't share your view that it's a bug. Omitting the time results in midnight by default so this screws between because there's no time between 00:00:00 and 00:00:00. Are you having operational issues here or are you simply fishing for bugs? WHERE `transaction_date` = DATE(datetime)

Re: Bug in BETWEEN same DATETIME

Sorry, that was meant to be; WHERE (new column stored as date) = '2013-04-16' On Thu, May 23, 2013 at 10:16 PM, Andrew Moore wrote: > Personally I don't share your view that it's a bug. Omitting the time > results in midnight by default so this screws between because

RE: Chain Replication QUestion

ql.com/why-mysql/white-papers/mysql-replication-tutorial/ Andrew. > -Original Message- > From: Rick James [mailto:rja...@yahoo-inc.com] > Sent: 01 May 2013 16:29 > To: Richard Reina; Manuel Arostegui > Cc: mysql@lists.mysql.com > Subject: RE: Chain Replication QUestion > &

RE: MySQL Cluster or MySQL Cloud

about partitioning, failover etc. Regards, Andrew. > -Original Message- > From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] > Sent: 29 April 2013 14:50 > To: Andrew Morgan > Cc: [MySQL] > Subject: Re: MySQL Cluster or MySQL Cloud > > Hi Andrew, > > Thanks for

RE: MySQL Cluster or MySQL Cloud

Hi Neil, I hate just sending people off to white papers but you might get some good insights by taking a look at the "MySQL Guide to High Availability Solutions" paper - http://www.mysql.com/why-mysql/white-papers/mysql-guide-to-high-availability-solutions/ Regards, Andrew. And

Re: mysql 5.6.10 won't start

Have you got permissions to start the daemon (sudo)? Is the destination for the pid file writable by the MySQL user? A On Mon, Apr 15, 2013 at 2:20 PM, Paul Nowosielski wrote: > Hi, > > I'm running mysql 5.6.10 on Fedora. > when I try and boot mysql I get this: > > # /etc/init.d/mysql start >

RE: Mysql Cluster Sync-UP

, Andrew. > -Original Message- > From: Kevin Peterson [mailto:qh.res...@gmail.com] > Sent: 09 April 2013 04:58 > To: mysql@lists.mysql.com > Subject: Mysql Cluster Sync-UP > > Hi, > > I am running My-SQL in cluster mode with two machine. Want to know if > mysql da

RE: Converting Mysql to mysql cluster

> -Original Message- > From: Kevin Peterson [mailto:qh.res...@gmail.com] > Sent: 27 March 2013 06:58 > To: mysql@lists.mysql.com > Subject: Converting Mysql to mysql cluster > > Hi, > > My site is using mysql and PHP, now for the scale purpose want to > introduce mysql-cluster. Few que

RE: Promoting MySQL 5.5 slave to master

> -Original Message- > From: Miguel Gonzalez [mailto:miguel_3_gonza...@yahoo.es] > Sent: 21 March 2013 08:29 > To: Manuel Arostegui > Cc: mysql@lists.mysql.com > Subject: Re: Promoting MySQL 5.5 slave to master > > > > > > - Mensaje original - > De: Manuel Arostegui > Para:

RE: mysql cluster and auto shard

> -Original Message- > From: Mike Franon [mailto:kongfra...@gmail.com] > Sent: 18 March 2013 13:34 > To: > Subject: mysql cluster and auto shard > > I am looking at the best way to scale writes. > > Either using sharding with our existing infrastructure, or moving to > mysql cluster.

RE: MySQL Cluster Solution

Hi Neil, MySQL Cluster *does* support stored procedures. There are some limitation that MySQL Cluster has; this white paper would be a good place to start... http://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/ Regards, Andrew. > -Original Message- >

Re: SELECT subquery problem

Try using a CASE construct in the select. Should work for this. A On Tue, Feb 5, 2013 at 3:25 PM, Stefan Kuhn wrote: > You cannot do this. A sql result alwas has the same number of columns in > each row. You could have null or "" in the column, though. This could be > done via the if(,,)-state

Re: log sequence number InnoDB: is in the future!?

So this isn't production - well just rebuild it from a backup? It's a pain in the rear to get the lsn aligned again through data creation/removal but if it's a system critical instance without possible downtime you've got some work to do... On Mon, Jan 28, 2013 at 2:21 PM, walter harms wrote: >

Re: log sequence number InnoDB: is in the future!?

Dump and reload or use some scripting to create and drop some fake data to increase the lsn towards the 'future' value. http://dba.stackexchange.com/questions/8011/any-better-way-out-of-mysql-innodb-log-in-the-future On Mon, Jan 28, 2013 at 12:01 PM, walter harms wrote: > hi list, > > i am usi

Re: MySQL Cluster alerts

Hi Bheemsen, looks like a few different things going on there; if you have a MySQL support contract/subscription then it would be worth raising SRs - it doesn't need to be a bug, it's fine tyo ask questions too. A couple of things that spring to mind in-line > I am frequently seeing the f

Re: MySQL dying?

MySQL runs the internet. Go ahead kill it. I dare you. On Tue, Dec 4, 2012 at 11:18 PM, Karen Abgarian wrote: > MySQL, like all other products, can be peachy or bitchy. Good ones, they > also die.Wish I was kidding :-) > > > On Dec 4, 2012, at 2:37 PM, Andrés Tello wrote: > > > Are u kidd

Re: Update One of Three tables in a single query

What's your use case? I've not heard of a like this done at table/sql level. You could use stored procedures & dynamic SQL to achieve it though. On Thu, Nov 29, 2012 at 5:44 PM, Chris W <4rfv...@cox.net> wrote: > I have three tables, TableA, TableB, and TableC each has a unique ID > field, idA,

Re: innodb_lock_wait_timeout and replication

You are subscribed to the MySQL mailing list. You will need to unsubscribe yourself. On Fri, Oct 12, 2012 at 6:58 PM, Hubert de Donnea < hubertdedon...@hotmail.com> wrote: > I get all your mails for yearscould you not help me and suppress my > name from your contact thanks > > > To: mysql@li

Re: InnoDB corrupt after power failure

ng out of the new blocks assigned to the file are not atomic with respect to one another. Is the InnoDB recovery process OK with this scenario? Has anyone else seen corruption problems with data=writeback? -- Andrew [1] http://lxr.linux.no/linux+v3.5.2/Documentation/filesystems/ext3.txt --

Re: InnoDB corrupt after power failure

ely no data loss, but I'm worried we might have data loss or availability issues if this error crops up on our master server. Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

InnoDB corrupt after power failure

writeback mode. Is this a known bad config with InnoDB? Thanks for any help, Andrew --- MySQL server version: Server version: 5.5.27-1~ppa1~lucid-log (Ubuntu) (Running on Ubuntu 10.04.2 LTS) 120831 20:56:01 InnoDB: The InnoDB memory heap is disabled 120831 20:56:01 InnoDB: Mutexes and rw

Re: mysql is eating up lot of CPU and memory

e are no silver bullets here except using the blackhole storage engine for all tables (joke) . Andrew On 20 Sep 2012 18:15, "Simon K" wrote: > Hi All, > > I am using HP-UX box. > > I am having problem with mysqld daemon , it is eating too much of > processor and memo

Re: create roles/groups in MYSQL

There's nothing built in but if you want explore this it is an extension http://www.securich.com/ On 1 Aug 2012 21:56, "Aastha" wrote: > Hello, > > I have 10 different users and i have to give different accesses to > different tables. > Is it possible to create a groups with different set of a

Re: Disable DB without deleting data

Or rename the users themselves. This backs onto the revoke idea. If only the DBA knows the new names then the privileges stay intact and the old usernames could be restored with a reversal script when the db can be accessed again. Applications will simply get an access denied at connection time. No

Re: Disable DB without deleting data

Revoke all privileges to it. No access, no use. On Thu, Jul 19, 2012 at 11:47 PM, Kirk Hoganson wrote: > I need to find an easy way to make a database unavailable without deleting > the data, so that it could be easily and quickly restored if necessary, > without impacting the availability of the

Re: GA download reverted back to 5.5.24?

Charming, Noel. Are you Devops? :-D On Fri, Jul 6, 2012 at 3:09 AM, Noel Butler wrote: > ** > For those interested 5.5.25a has been released overnight, long after > oracle claimed it was there. > frankly., I think they ought to have use 5.5.26. > > To those who replied to me directly, a few fact

Re: GA download reverted back to 5.5.24?

Agreed - if you installed this version in production without fully testing then it's your problem, you'll need to downgrade. If you've tested thoroughly and hit the bug then you you're aware of the issue already and do not have it installed in production. If you tested thoroughly and didn't hit the

Re: New guy

Welcome Raymond, hope you enjoy your stay :) On Thu, Jun 21, 2012 at 8:47 PM, Raymond D'Anjou < radan...@osullivan-quebec.qc.ca> wrote: > I don't know if new members usually introduce themselves here... > ...but if not, why not? > > I was very active on the SQL Server news group a few years back

Re: i need advice on redundancy of mysql server.

Not forgetting Pythian , Baron ;) On Mon, Jun 11, 2012 at 8:12 PM, Baron Schwartz wrote: > Ultimately, if you intend to use MyISAM, you must keep in mind that it > eliminates some of your options. One problem is that MyISAM is very > slow to repair after a crash. Remember

Re: i need advice on redundancy of mysql server.

That's not a description of 'load balancing'; it is a high availability solution you're looking for. On Mon, Jun 11, 2012 at 4:43 PM, Joey L wrote: > I understand ..I am looking for load balancing - something that i do > not have to worry about if one server goes down - the other server > will b

Re: multi master auto syncing when servers back on line

; maintian a master master setup with ease ? > > > thanks > mjh > > On Tue, Jun 5, 2012 at 6:18 PM, Andrew Moore wrote: > > Joey, > > > > The master master replication topology comes with it's own potential > > pitfalls and trials. Be sure your use case

Re: multi master auto syncing when servers back on line

Joey, The master master replication topology comes with it's own potential pitfalls and trials. Be sure your use case needs master master and that you're not implementing it because you think it's 'nice to have'. pt-table-sync should assist you getting your data in sync but how have you arrived a

Re: I am trying to setup a multi master mysql setup.

Joey, please consult your mysql error log. Something has gone wrong on your server where innodb is not started. On Tue, Jun 5, 2012 at 3:53 PM, Joey L wrote: > I am following or trying to follow this document: > http://www.howtoforge.com/mysql5_master_master_replication_debian_etch > > I think i

Re: table cache value error in my.cnf file

Joey, you've over allocated the cache. MySQL is telling you that it has corrected the allocation. Check out the docs for the meaning behind the numbers. On Mon, Jun 4, 2012 at 2:01 PM, Reindl Harald wrote: > > > Am 04.06.2012 14:45, schrieb Joey L: > > Can you explain this further ? > > Sorry a

Re: Need help for performance tuning with Mysql

Yu, The upgrade to 5.5 that Jonny advises should NOT your first action. If MySQL is mis-configured on 5.0 it will likely be misconfigured on 5.1 and 5.5. Test your application thoroughly on the new version before heeding that advice. Read the change logs and known bugs. Running the upgrade might s

Re: Myisam won't support replication

Charles, How do you know your replication isn't working? On Thu, May 3, 2012 at 9:50 PM, Brown, Charles wrote: > I noticed that my replication stopped working after migrating to MySQL > cluster. My current engine is myisam. Does anyone have an idea why repl > won't work. Do I have to use the

Re: Postal code searching

If nothing else a great intro to the UK postcode. I find this very interesting/useful. Thanks Mark. On Wed, Apr 25, 2012 at 10:14 AM, Mark Goodge wrote: > On 24/04/2012 17:24, Tompkins Neil wrote: > >> How about if I want to only return postal codes that are like W1U 8JE >> not W13 0SU. >> >> B

Re: Instance tuning

Hey Bruce, Much of the output is inaccurate and the tool is rather dated. A On Wed, Apr 11, 2012 at 10:23 PM, Bruce Ferrell wrote: > I've long used mysqltuner.pl and have recently heard that it may not be > the best tool for the job. what are others using? What experiences have > you had with

Re: Licensing question about mysql_com.h

So what's the deal with Twitter's mysql code...how can it be BSD licensed? I'm a bit unsure about the intricacies of licensing. A On Tue, Apr 10, 2012 at 1:19 AM, Michael Dykman wrote: > Your code might not qualify for the linking excepetion, but users of > your code can use the inking exceptio

Re: two 5.1 servers, different behaviour

To rule out a version issue have you tried another host with the problematic version and same/similar config? On Feb 24, 2012 6:47 PM, "William Bulley" wrote: > According to Michael Dykman on Fri, 02/24/12 at 13:23: > > > > At this point, I would not know what else to do except fire up > > wires

Re:Cant drop trigger.

Is there white space at the end of the trigger name? A On Feb 20, 2012 10:04 PM, "Brent Clark" wrote: > Hi Guys > > I wonder if someone could urgently help me > > Im trying to drop some triggers. But mysql says the trigger does not exist. > > I ran > > SELECT TRIGGER_SCHEMA, EVENT_OBJECT_TABLE,

Re: Date and Time

What's your problem/reason with how it is? Andy On Sun, Jan 8, 2012 at 8:21 PM, Donovan Brooke wrote: > Hello, I'm doing an insert into with date and time type fields. > > I was reading: > http://dev.mysql.com/doc/**refman/5.1/en/date-and-time-**literals.html

Re: Cleaning up old files

The binary log is useful for more then just replication and can be used to take incremental backups or to perform forensics on what your server has done. I would recommend learning how to use them to your advantage over turning binary logging off as some have recommended. Make sure you're monitorin

Re: add index to slave but not master

will differ from the original master and you might notice a performance difference as a result. Hth Andrew On Oct 31, 2011 7:47 AM, "Jeff Pang" wrote: > Hello, > > I have a question that, if I add the index to the table in slave, but > don't do it in master, will i

Re: Synchronize two mysql servers (single user, only one server (but not both) can be changed at any given time)

As Johan describes, replication is the way. If that's not an option due to connectivity between the hosts you could arrange for a logical dump to be copied and restored. I would certainly opt for replication in your situation. A On Tue, Oct 18, 2011 at 7:02 AM, Johan De Meersman wrote: >

Re: Beginner question

Hey, welcome to the lists, Be mindful that your query is using 2 tables and 'SELECT *'. On Tue, Oct 11, 2011 at 4:11 PM, Biz-comm wrote: > I am trying to write a query for a web page that shows a list of users in a > particular group. > > There are 3 tables: > pm1_users that uses UserID > pm1

Re:Socket not found

Hey Peter, 2 options; Check the socket key-value in the my.cnf file under the client section. Explicitly tell mysqladmin what one to use with the relevant cmd line option. See the documentation for syntax. Hth Andrew On 9 Oct 2011 09:21, "Peter Schrock" wrote: > I just loaded an

Re: 4 minute slow on select count(*) from table - myisam type

Glad you got to the bottom of it Joey. On 7 Oct 2011 01:23, "Joey L" wrote: > Guys - I wanted to thank you all very much for your help > I found the offending code on the website ! > thank you very very very much... > what did it for me was a combination of show processlist and show full >

Re: 4 minute slow on select count(*) from table - myisam type

is faster...i am not really doing any >> transaction stuff. >> thanks >> >> On Thu, Oct 6, 2011 at 12:16 PM, Andrew Moore >> wrote: >> > Sorry, hit send by accident there! *face palm* >> > Just had a quick scan of the report. You've got 2 1GB d

Re: 4 minute slow on select count(*) from table - myisam type

ugh), MyISAM doesn't like high concurrency mixed workloads such as yours, it will cause locking and maybe thats why your count has such a delay. Such activity may be better suited to InnoDB engine (you must configure and tune for this, not JUST change the engine). HTH Andy On Thu, Oct 6, 2011 at 5:

Re: 4 minute slow on select count(*) from table - myisam type

Joey, does your 'large' table get On Thu, Oct 6, 2011 at 3:22 PM, Joey L wrote: > here is mysqlreport --- > > root@rider:~/tmp# ./mysqlreport --user root --password barakobomb > Use of uninitialized value $is in multiplication (*) at ./mysqlreport

Re: A tidbit for those of us who want to play with InnoDB compression

Nice one Johan, thanks for the info. On Tue, Oct 4, 2011 at 2:17 PM, Johan De Meersman wrote: > As noted in the title, I'm messing about a bit with InnoDB compressed > tables. As such, I found a rather glaring hole in the Internet: how the hell > do you turn compression off again? :-D > > After m

Re: how to shrink ibdata1

File per table is required if you want to implement compression via the barracuda file format. On 3 Oct 2011 06:39, "Adarsh Sharma" wrote: > innnodb_file per table creates ibdata files for each table and What to > do if some tables data are deleted frequently. > I have a innodb table which was tru

Re: 4 minute slow on select count(*) from table - myisam type

33500 15m 6660 S0 0.2 0:19.39 >> /usr/sbin/asterisk -p -U asterisk >>1 root 20 0 2032 604 568 S0 0.0 0:01.14 init [2] >>2 root 20 0 000 S0 0.0 0:00.01 [kthreadd] >>3 root RT 0 000 S0

Re: 4 minute slow on select count(*) from table - myisam type

Is your table MyISAM or InnoDB? A On Sun, Oct 2, 2011 at 2:44 PM, Joey L wrote: > I have having issues with mysql db - I am doing a "select count(*) from > table" -- and it take 3 to 4 min. > My table has about 9,000,000 records in it. > I have noticed issues on my web pages so that is why i di

Re: mysql listed as "attach page" by google?

Yeah I noticed that today too... On Mon, Sep 26, 2011 at 7:30 PM, Michael Albert wrote: > I don't suppose I am the first to notice this, but most of > the pages on dev.mysql.com have been listed by google > as "attack pages", e.g http://dev.mysql.com/downloads/. > Has there been a problem, or is

Re: Query Optimization

reply Andy. Unfortunately the users will be selecting >>> varying date ranges and new data is constantly coming in, so I am not sure >>> how I could archive/cache the necessary data that would be any more >>> efficient than simply using the database directly. >>>

Re: Query Optimization

t; efficient than simply using the database directly. > > > > On 09/08/2011 02:16 PM, Andrew Moore wrote: > >> Thinking outside the query, is there any archiving that could happen to >> make >> your large tables kinder in the range scan? >> >> Andy >> &g

Re: Query Optimization

Thinking outside the query, is there any archiving that could happen to make your large tables kinder in the range scan? Andy On Thu, Sep 8, 2011 at 7:03 PM, Brandon Phelps wrote: > On 09/01/2011 01:32 PM, Brandon Phelps wrote: > >> On 09/01/2011 12:47 PM, Shawn Green (MySQL) wrote: >> >>> On 9

Re: trying to change wait_timeout

Check that you're looking at the variable in the GLOBAL scope not the SESSION scope. SHOW GLOBAL VARIABLE ... Andy On Thu, Sep 8, 2011 at 11:34 AM, Bruce Ferrell wrote: > On 09/08/2011 02:56 AM, Johan De Meersman wrote: > >> - Original Message - >> >>> From: "Bruce Ferrell" >>> To: mysq

Re: why does throughput increase with number of connections even if it exceeds number of processors?

Hong, What you are seeing is probably your server's ability to keep up with your benchmark with some comfort. I assume your benchmark isn't completing in a couple of seconds but would presume that you are not IO bound and all changes are happening in memory. Its hard to give you 'the' answer as yo

Re: Reg...My Hung MYSQL instance

It will only do what you let it. If your server ui consuming too much memory it because you've let it. On Aug 23, 2011 9:22 AM, "Shafi AHMED" wrote: > Dear, Today suddenly my database went into hung state due to Out of Memory > [ Killed process 1330 (mysqld) ]. > > Please advise me folks.This happ

Re: mysql

That's too bad. How did you configure things? What trouble shooting have you done so far? On Aug 23, 2011 9:18 AM, "madu...@gmail.com" wrote: > When I try to start my mysql DB I keep getting the following message: > "Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock

Re: about the config file

Hey! I asked this one a long time ago. They are interchangeable in most cases. I can recall there was one or two options (pid-file and log-error...I think?!) that were funky with the '_' but I can't be sure that's still an issue. Try them out and don't worry too much about the aesthetics of the f

Re: access from everywhere but localhost?

Nope, for example you can assign access to db1.* to user1@192.168.% which doesn't include localhost or 127.0.0.1. On 20 Jun 2011 14:35, "Matthias Leopold" wrote: > does this mean that "access from everywhere but localhost" is impossible? > > matthias > > A

Re: access from everywhere but localhost?

Grant only to the hosts you want to have access to your data. Andy On 20 Jun 2011 14:20, "Willy Mularto" wrote: > Replace GRANT with REVOKE > > > > On Jun 20, 2011, at 8:08 PM, Matthias Leopold wrote: > >> hi, >> >> this surely is a beginners question: >> >> i already created a user and privilege

Re: How to copy file from an old server to reconstitute a database ?

Lee, You will need to take the datadir directory, typically found under /var/lib/mysql/ It would also be a good idea to grab your configuration file from /etc/mysql/my.cnf or /etc/my.cnf (ubuntu tends to be the former). Once transplanted into your new server remember to check that the permission

Re: need help with -- unknown variable

Check if this is in the [mysqldump] section of your my.cnf file(s). Of course it might not be a valid option in mysqldump...I haven't checked... On 13 Jun 2011 17:00, "Brown, Charles" wrote: > Hello All ~ I attempted to do a mysqldump when I got this message -- see below: > > mysqldump: unknown va

Re: MySQL loses password?

Try starting the server using --skip-grants-table and then resetting the password for the root account. http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_skip-grant-tables I've only seen/heard of the problems you're having with legacy system tables. Did you restore the data

Patching MySQL CLI to log information

Has anyone ever patched the MySQL or libmysql to log to some logfiles with information like the UNIX user, time, server connected to, port etc? I'm just trying to save myself a bit of C patching. Cheers, A -

Re: Not finding my.cnf file

Check the permissions in the datadir. On Wed, Jun 1, 2011 at 11:50 AM, Adarsh Sharma wrote: > Thanks, It works & a new error occurs as : > > 110601 16:16:16 mysqld_safe Starting mysqld daemon with databases from > /hdd2-1/myisam_data > /usr/sbin/mysqld: File '/hdd2-1/myisam_data/mysql-bin.index'

Re: Not finding my.cnf file

will require a MySQL restart before they will work. Best of luck Andrew On Wed, Jun 1, 2011 at 10:24 AM, Adarsh Sharma wrote: > Dear all, > > I install mysql in CentOS -5.4 through 2 commands : > > yum install mysql-server > yum install mysql-client > > And I can see di

Re: Renaming a database?

Could you try restoring the other db with another name and changing the connection string in the app? On 24 May 2011 16:20, "Jerry Schwartz" wrote: > It looks like there’s no way to rename a database. Is that true? > > > > I have two reasons for wanting to do this: > > > > - I want to get a curren

Re: Renaming a database?

Instead of renaming it, revoke permissions to it. If it's being used you should see some problems in the application due to access denied. Andy On Tue, May 24, 2011 at 4:19 PM, Jerry Schwartz wrote: > It looks like there’s no way to rename a database. Is that true? > > > > I have two reasons fo

Re: MySQL ignores foreign key constraints

Try show create table ... ; A On Fri, May 20, 2011 at 12:07 PM, Mimi Cafe wrote: > Hi > > An ideas why MySQL silently ignores any foreign key constraints I define > for > the following tables? > > > mysql> desc book; > > +--+---+--+-+

Re: URGENT: Change Default Location of where Database Files get written?

There absolutely is; there is a configuration file belonging to MySQL named `my.cnf`. It can exist in many places and there's a hierarchal order of precedense. The most common of which is /etc/my.cnf. Within this file you may specify the `datadir` option to identify location you wish your data to

Re: operation with dates

Rocio, there are specific date functions that you need to learn to allow you to complete this kind of query. Please check out the MySQL documentation for this. HTH Andy On Thu, May 12, 2011 at 4:05 PM, Rocio Gomez Escribano < r.go...@ingenia-soluciones.com> wrote: > Hello! I’m trying to subt

  1   2   3   4   5   6   7   8   9   10   >