mysql

Olá a todos.

Estou às voltas com um novo pequeno site, mas que necessita de vários módulos.
Por causa de reduções de budget, tive de optar por um shared hoster, que até costuma funcionar bem com outros sites drupal 7.

No entanto, após um dia, este novo site ficou demasiado lento, e administrar o site é um sufoco (45 sec a 2 min. para gravar uma página, outro tanto para abrir outra página).
O hoster diz-me que o problema não é meu, mas algum tempo depois informou-me que o site está constantemente a correr a seguinte query:

xin chào các pro!
tôi là 1 newbi. tôi đang gặp phải 1 vấn đề khi xây dựng web trên openSource mong sớm nhận được sự giúp đỡ của mọi người.

Vấn đề là tôi muốn bảo mật cái pass truy nhập vào CSDL khi mà đưa lên host, ví dụ như là mình mã hóa thành 1 chuỗi nào đó
vì thông thường như trong Drupal thì cái us và pas này đặt ở file settings, còn như trong Joomla thì nó lại đặt ở file config...
và tôi muốn là khi đưa lên rồi thì thông tin đó sẽ được private.

xin các pro có cách nào xin chi dẫn giúp.

weil wir es die letzten male gelegentlich von MySQL und alternativen hatten:

gerade habe ich auf der seite
http://drupal.org/requirements#database
von MariaDB gelesen ( http://mariadb.org/ ).

"MariaDB is a binary drop in replacement for MySQL. [...] This means that for most cases, you can just uninstall MySQL and install MariaDB and you are good to go. (No need to convert any datafiles if you use same main version, like 5.1)."
http://kb.askmonty.org/v/mariadb-versus-mysql

wurde in der diskussion noch nicht erwähnt, deshalb mal hier FYI.

Update: This has become a discussion about advertising guidelines on g.d.o/australia (perhaps generally as well).

Original Title: Expert Web Development Training in HTML, CSS, JavaScript, PHP, MySQL and Drupal

Hi, my name is Shaun Moss, and I provide 3 main services: Web Development, Consulting and Training. Today I want to tell you about my training services.

Web Development Training

I am running tuning-primer.sh and mysqltuner.pl

mysqltuner.pl says:
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Adjust your join queries to always utilize indexes
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
join_buffer_size (> 128.0K, or always use indexes with joins)
tmp_table_size (> 50M)
max_heap_table_size (> 50M)

Hi,

I'm an architect working on a project to rebuild our current consumer site, possibly using Drupal, and am new to Drupal and learning as much as I can as fast as I can. We currently serve all users to our site out of a single colocation (colo), but in the near future are planning to add additional colos in other geographic locations and serve the site concurrently from them all, with users being routed to the nearest colo.

Hej!
Har problem med att flytta över min databas till en lokal installation av Drupal.

Jag använder mig av MySQL Administrator 1.2.17 för både backup och inläsning. I samband med inläsningen av filen får jag följande felmeddelande:

Felmeddelandet fortsätter med en massa tecken och avslutas därefter med:

Recuerdo cuando no hace mucho tiempo, los teléfonos celulares eran una novedad y tener uno significaba andar para todos lados con un ladrillo.
El tiempo pasa, la tecnología avanza y cada día nos maravilla con nuevas hazañas.
En mi caso, hoy quede gratamente sorprendido cuando por pura curiosidad instalé un servidor web en mi nuevo chiche, un Nokia N97 mini que hasta el momento no tiene un día de uso.
La idea surgió ya que si mal no recuerdo leí un artículo sobre la posibilidad de instalar un servidor web en el cel, y ya teniendo el servidor, por que no intentar con Drupal?

Business Integration Technology has just released SQL ICE, the Internet Computing Environment for SQL Experts. Although SQL ICE can do a lot of things, one that may be of interest to Drupal Users is the ability to connect to your Drupal database and write MySQL queries to get reports that can be displayed, downloaded, and shared with other users.

All you need to do is add a Connection to the target database and write a query in SQL. The data is exposed as an XML document accessed by a REST Web service. For example, a simple query like:

Select

Hi Everyone.

I was reading on several forums that using MYSQL 5.5 will be a good option as it improves the performance compared to my current version 5.0.77.

I guess we are able to run things, only because we are using boost to completely cache the server.

I have listed some of the status variables from our website's drupal admin below. Some of them, made me think that something is wrong.

What should we do in order to correct the issues.