Tag Info

New answers tagged

0

The 16.04 seconds is a timer on the client that measures the amount of time that passed between the call and the execution of the query (if you want to be more specific than that, the wall clock time between calling start_timer() and mysql_end_timer(), something that can lead to hilarious results like this one I got). The reason that you think that it took ...


0

To complete the answers, Oracle's push for "replacing" the query cache functionality is the memcached integration.


0

In PostgreSQL you can do it using column aliasing: postgres=# CREATE TABLE product (product_id INTEGER, name TEXT); CREATE TABLE postgres=# INSERT INTO product (product_id, name) VALUES (1, 'product 1'), (2, 'product 2'); INSERT 0 2 postgres=# SELECT p.id FROM product p (id); id ---- 1 2 (2 rows) Don't know if it works the same way in MySQL, ...


1

Check out the correct answer to this question - and Bill Karwin's comment on that answer. I was quite surprised to learn that INTO was optional - but indeed it is, although according to the standard it shouldn't be. Amazingly enough, Oracle does require it - must be the only time that Oracle actually enforces one of the ANSI standards where (many*) others ...


0

Alter table blog change read-more read_more varchar(255) not null Reference: click


0

I am a big fan of dump, edit and insert. but you do not have to open the text file (dump file) to change it (this is especially usefull when it is several milion lines long). if you want to dump the database MYDATABASE. mysqldump MYDATABASE > mydump.sql then use sed to replace the old database name with new one like this sed -i ...


0

Given this table mysql> USE test Database changed mysql> DROP TABLE IF EXISTS biblio; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> CREATE TABLE biblio -> ( -> id INT NOT NULL AUTO_INCREMENT, -> name VARCHAR(20), -> PRIMARY KEY (id), -> KEY (name) -> ); Query OK, 0 rows affected (0.74 ...


1

When it comes to capacity, all your constraints start with Amazon RDS, not MySQL. Why ? I have posts about MySQL in Amazon RDS Aug 02, 2012 : Local database vs Amazon RDS Oct 12, 2012 : When should I think about upgrading our RDS MySQL instance based on memory usage? Feb 26, 2013 : MySQL optimization Your main bottlenecks for RDS are Transaction Log ...


1

The server core is similar (identical?) on the GA and Standard Edition (SE)/Entreprise Edition (EE). What you're getting with SE/EE is stuff like (from here) MySQL Partitioning MySQL Enterprise Backup MySQL Enterprise Monitor MySQL Enterprise HA MySQL Enterprise Scalability MySQL Enterprise Security MySQL Enterprise Audit You also get support and some ...



Top 50 recent answers are included